Databricks-Certified-Data-Engineer-Associate 試験問題を無料オンラインアクセス

In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?

• A.When the source table can be deleted
• B.When the source is not a Delta table
• C.When the location of the data needs to be changed
• D.When the target table cannot contain duplicate records
• E.When the target table is an external table

In which of the following file formats is data from Delta Lake tables primarily stored?

• A.CSV
• B.A proprietary, optimized format specific to Databricks
• C.JSON
• D.Delta
• E.Parquet

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?

• A.Databricks Repos provides the ability to comment on specific changes
• B.Databricks Repos supports the use of multiple branches
• C.Databricks Repos is wholly housed within the Databricks Lakehouse Platform
• D.Databricks Repos allows users to revert to previous versions of a notebook
• E.Databricks Repos automatically saves development progress

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?

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

A data engineer needs to audit who made changes to a Delta table during the last seven days.
Which SQL statement returns the record of past operations, including timestamps, users, and operation types?

• A.DESCRIBE DETAIL my_table
• B.DESCRIBE HISTORY my_table
• C.SHOW TBLPROPERTIES my_table
• D.SELECT * FROM delta.\my_table/_delta_log/``