Databricks Certified-Data-Engineer-Professional valid exam dumps : Databricks Certified Data Engineer Professional

The following table consists of items found in user carts within an e-commerce website.

The following MERGE statement is used to update this table using an updates view, with schema evolution enabled on this table.

How would the following update be handled?

• A. The update is moved to separate ''restored'' column because it is missing a column expected in the target schema.
• B. The new nested field is added to the target schema, and files underlying existing records are updated to include NULL values for the new field.
• C. The update throws an error because changes to existing columns in the target schema are not supported.
• D. The new restored field is added to the target schema, and dynamically read as NULL for existing unmatched records.

A data engineering workspace was automatically enabled for Unity Catalog, creating a workspace catalog. New team members report they can create tables in the default schema but cannot access table in other schemas within the same workspace catalog. Why are the new team members unable to access tables in other schemas?

• A. Tables in other schemas require additional BROWSEprivileges that new users don't receive automatically
• B. New users only receive CREATE TABLE privileges on the default schema.
• C. Workspace catalog permissions are not subject to inheritance rules.
• D. Workspace users receive USE CATALOG and specific privileges on default schema only.

A data engineer wants to refactor the following DLT code, which includes multiple table definitions with very similar code.

In an attempt to programmatically create these tables using a parameterized table definition, the data engineer writes the following code.

The pipeline runs an update with this refactored code, but generates a different DAG showing incorrect configuration values for these tables.
How can the data engineer fix this?

• A. Wrap the loop inside another table definition, using generalized names and properties to replace with those from the inner table
• B. Load the configuration values for these tables from a separate file, located at a path provided by a pipeline parameter.
• C. Convert the list of configuration values to a dictionary of table settings, using table names as keys.
• D. Convert the list of configuration values to a dictionary of table settings, using different input the for loop.

A data engineer is working in an interactive notebook with many transformations before outputting the result from display(df.collect() ). The notebook includes wide transformations and a cross join.
The data engineer is getting the following error: "The spark driver has stopped unexpectedly and is restarting. Your notebook will be automatically reattached." Which action should the data engineer take?

• A. Run the notebook on a single node cluster to keep driver from falling.
• B. Check into the Spark UI to see how many jobs are assigned to each stage as they are employing fewer executors.
• C. Look at the compute metrics UI to see if the executors have higher than 90% memory utilization.
• D. Rewrite their code to avoid putting memory pressure on the driver node.

The data engineer team has been tasked with configured connections to an external database that does not have a supported native connector with Databricks. The external database already has data security configured by group membership. These groups map directly to user group already created in Databricks that represent various teams within the company. A new login credential has been created for each group in the external database. The Databricks Utilities Secrets module will be used to make these credentials available to Databricks users. Assuming that all the credentials are configured correctly on the external database and group membership is properly configured on Databricks, which statement describes how teams can be granted the minimum necessary access to using these credentials?

• A. "Manage" permission should be set on a secret scope containing only those credentials that will be used by a given team.
• B. "Read" permissions should be set on a secret scope containing only those credentials that will be used by a given team.
• C. "Read'' permissions should be set on a secret key mapped to those credentials that will be used by a given team.
• D. No additional configuration is necessary as long as all users are configured as administrators in the workspace where secrets have been added.