Databricks Certified Data Engineer Associate - Databricks-Certified-Data-Engineer-Associate Exam Practice Test
A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?
Which of the following relational objects should the data engineer create?
Correct Answer: E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A data engineer uploads a CSV file using the Create or modify a table using file upload option in Databricks. To avoid incorrect schema inference, the engineer disables Automatically detect column types before creating a Unity Catalog-managed table.
What is the outcome?
What is the outcome?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A data engineering team runs multiple daily batch jobs. The team needs to run the jobs on a fixed overnight schedule with consistent performance and controlled resource usage. The team wants to minimize operational overhead and reduce idle cluster costs.
Which compute option should the team use?
Which compute option should the team use?
Correct Answer: A
Vote an answer
A data engineering team needs to ingest historical CSV files from a cloud-storage location that already contains 50,000 existing files. The team also expects new files to arrive continuously. The team wants to use Auto Loader to incrementally process both the existing files and new arrivals efficiently.
Which Auto Loader mode should the team configure for this use case?
Which Auto Loader mode should the team configure for this use case?
Correct Answer: D
Vote an answer
An organization is looking for an optimized storage layer that supports ACID transactions and schema enforcement. Which technology should the organization use?
Correct Answer: A
Vote an answer
A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query that returns the number of input records containing unexpected NULL values. The data engineer wants their entire team to be notified via a messaging webhook whenever this value reaches 100.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which query is performing a streaming hop from raw data to a Bronze table?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A governance team is evaluating whether to use Unity Catalog attribute-based access control policies or manually applied row filters and column masks to protect sensitive data across its catalog.
Why should the team use attribute-based access control policies instead of manually applied row filters and column masks?
Why should the team use attribute-based access control policies instead of manually applied row filters and column masks?
Correct Answer: D
Vote an answer
A data engineer is working with two tables. Each of these tables is displayed below in its entirety.
The data engineer runs the following query to join these tables together:
Which of the following will be returned by the above query?
The data engineer runs the following query to join these tables together:
Which of the following will be returned by the above query?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project's release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project's release.
Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project's release?
Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project's release?
Correct Answer: E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A data engineer has finished developing a new Declarative Automation Bundle, formerly known as a Databricks Asset Bundle, for a streaming pipeline. The engineer must verify that the configuration is syntactically correct, deploy the code to the workspace, and finally trigger the pipeline to confirm that it runs as expected.
Which sequence of Databricks CLI commands performs these steps in the correct order?
Which sequence of Databricks CLI commands performs these steps in the correct order?
Correct Answer: A
Vote an answer
A company is collaborating with a partner that does not use Databricks but needs access to a large historical dataset stored in Delta format. The data engineer needs to ensure that the partner can access the data securely, without the need for them to set up an account, and with read-only access.
How should the data be shared?
How should the data be shared?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A data engineer needs access to a table new_table, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is.
Which of the following approaches can be used to identify the owner of new_table?
Which of the following approaches can be used to identify the owner of new_table?
Correct Answer: E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A departing platform owner currently holds ownership of multiple catalogs and controls storage credentials and external locations. The data engineer wants to ensure continuity: transfer catalog ownership to the platform team group, delegate ongoing privilege management, and retain the ability to receive and share data via Delta Sharing.
Which role must be in place to perform these actions across the metastore?
Which role must be in place to perform these actions across the metastore?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).