Databricks Databricks-Certified-Data-Engineer-Associate Databricks Certified Data Engineer Associate Exam Exam Practice Test Questions

• Question 1

  A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice that some data is being dropped due to quality concerns at some point in the DLT pipeline. They would like to determine at which table in their pipeline the data is being dropped.Which of the following approaches can the data engineer take to identify the table that is dropping the records?

  • They can set up separate expectations for each table when developing their DLT pipeline.
  • They cannot determine which table is dropping the records.
  • They can set up DLT to notify them via email when records are dropped.
  • They can navigate to the DLT pipeline page, click on each table, and view the data quality statistics.
  • They can navigate to the DLT pipeline page, click on the “Error” button, and review the present errors.

  Show Answer Answer: E Next

• Question 2

  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?

  • They can set up an Alert with a custom template.
  • They can set up an Alert with a new email alert destination.
  • They can set up an Alert with a new webhook alert destination.
  • They can set up an Alert with one-time notifications.
  • They can set up an Alert without notifications.

  Show Answer Answer: C Next

• Question 3

  Which of the following data lakehouse features results in improved data quality over a traditional data lake?

  • A data lakehouse provides storage solutions for structured and unstructured data.
  • A data lakehouse supports ACID-compliant transactions.
  • A data lakehouse allows the use of SQL queries to examine data.
  • A data lakehouse stores data in open formats.
  • A data lakehouse enables machine learning and artificial Intelligence workloads.

  Show Answer Answer: C Next

• Question 4

  Which of the following describes the relationship between Gold tables and Silver tables?

  • Gold tables are more likely to contain aggregations than Silver tables.
  • Gold tables are more likely to contain valuable data than Silver tables.
  • Gold tables are more likely to contain a less refined view of data than Silver tables.
  • Gold tables are more likely to contain more data than Silver tables.
  • Gold tables are more likely to contain truthful data than Silver tables.

  Show Answer Answer: C Next

• Question 5

  Which of the following describes a scenario in which a data team will want to utilize cluster pools?

  • An automated report needs to be refreshed as quickly as possible.
  • An automated report needs to be made reproducible.
  • An automated report needs to be tested to identify errors.
  • An automated report needs to be version-controlled across multiple collaborators.
  • An automated report needs to be runnable by all stakeholders.

  Show Answer Answer: E Next