Databricks-Certified-Data-Engineer-Associate Exam Question 16

Which of the following describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delta Live Tables (DLT) tables using SQL?
  • Databricks-Certified-Data-Engineer-Associate Exam Question 17

    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?
  • Databricks-Certified-Data-Engineer-Associate Exam Question 18

    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?
  • Databricks-Certified-Data-Engineer-Associate Exam Question 19

    A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.
    Which of the following commands could the data engineering team use to access sales in PySpark?
  • Databricks-Certified-Data-Engineer-Associate Exam Question 20

    A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos.
    Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?