Databricks-Certified-Data-Engineer-Associate Exam Question 1
A data engineer is writing a script that is meant to ingest new data from cloud storage. In the event of the Schema change, the ingestion should fail. It should fail until the changes downstream source can be found and verified as intended changes.
Which command will meet the requirements?
Which command will meet the requirements?
Databricks-Certified-Data-Engineer-Associate Exam Question 2
Which SQL keyword can be used to convert a table from a long format to a wide format?
Databricks-Certified-Data-Engineer-Associate Exam Question 3
A Delta Live Table pipeline includes two datasets defined using STREAMING LIVE TABLE. Three datasets are defined against Delta Lake table sources using LIVE TABLE.
The table is configured to run in Development mode using the Continuous Pipeline Mode.
Assuming previously unprocessed data exists and all definitions are valid, what is the expected outcome after clicking Start to update the pipeline?
The table is configured to run in Development mode using the Continuous Pipeline Mode.
Assuming previously unprocessed data exists and all definitions are valid, what is the expected outcome after clicking Start to update the pipeline?
Databricks-Certified-Data-Engineer-Associate Exam Question 4
A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
Databricks-Certified-Data-Engineer-Associate Exam Question 5
An organization is looking for an optimized storage layer that supports ACID transactions and schema enforcement. Which technology should the organization use?