Databricks Certified-Data-Engineer-Professional Actual Tests : Databricks Certified Data Engineer Professional

The data architect has mandated that all tables in the Lakehouse should be configured as external Delta Lake tables.
Which approach will ensure that this requirement is met?

• A. Whenever a database is being created, make sure that the location keyword is used
• B. When the workspace is being configured, make sure that external cloud object storage has been mounted.
• C. When tables are created, make sure that the external keyword is used in the create table statement.
• D. Whenever a table is being created, make sure that the location keyword is used.
• E. When configuring an external data warehouse for all table storage. leverage Databricks for all ELT.

A data engineer has configured their Databricks Asset Bundle with multiple targets in databricks.yml and deployed it to the production workspace. Now, to validate the deployment, they need to invoke a job named my_project_job specifically within the prod target context.
Assuming the job is already deployed, they need to trigger its execution while ensuring the target- specific configuration is respected. Which command will trigger the job execution?

• A. databricks run my_project_job -t prod
• B. databricks execute my_project_job -e prod
• C. databricks bundle run my_project_job -t prod
• D. databricks job run my_project_job --env prod

Although the Databricks Utilities Secrets module provides tools to store sensitive credentials and avoid accidentally displaying them in plain text users should still be careful with which credentials are stored here and which users have access to using these secrets.
Which statement describes a limitation of Databricks Secrets?

• A. Secrets are stored in an administrators-only table within the Hive Metastore; database administrators have permission to query this table by default.
• B. The Databricks REST API can be used to list secrets in plain text if the personal access token has proper credentials.
• C. Account administrators can see all secrets in plain text by logging on to the Databricks Accounts console.
• D. Iterating through a stored secret and printing each character will display secret contents in plain text.
• E. Because the SHA256 hash is used to obfuscate stored secrets, reversing this hash will display the value in plain text.

The data science team has created and logged a production model using MLflow. The following code correctly imports and applies the production model to output the predictions as a new DataFrame named preds with the schema "customer_id LONG, predictions DOUBLE, date DATE".

The data science team would like predictions saved to a Delta Lake table with the ability to compare all predictions across time. Churn predictions will be made at most once per day.
Which code block accomplishes this task while minimizing potential compute costs?

• A.
  
• B.
  
• C. preds.write.mode("append").saveAsTable("churn_preds")
• D.
  
• E. preds.write.format("delta").save("/preds/churn_preds")

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. No additional configuration is necessary as long as all users are configured as administrators in the workspace where secrets have been added.
• D. "Read'' permissions should be set on a secret key mapped to those credentials that will be used by a given team.