Databricks Databricks-Certified-Professional-Data-Engineer 問題集

質問 1：
The data engineering team maintains the following code:

Assuming that this code produces logically correct results and the data in the source table has been de-duplicated and validated, which statement describes what will occur when this code is executed?
A. An incremental job will detect if new rows have been written to the silver_customer_sales table; if new rows are detected, all aggregates will be recalculated and used to overwrite the gold_customer_lifetime_sales_summary table.
B. A batch job will update the gold_customer_lifetime_sales_summary table, replacing only those rows that have different values than the current version of the table, using customer_id as the primary key.
C. The silver_customer_sales table will be overwritten by aggregated values calculated from all records in the gold_customer_lifetime_sales_summary table as a batch job.
D. The gold_customer_lifetime_sales_summary table will be overwritten by aggregated values calculated from all records in the silver_customer_sales table as a batch job.
E. An incremental job will leverage running information in the state store to update aggregate values in the gold_customer_lifetime_sales_summary table.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A data engineer wants to reflector the following DLT code, which includes multiple definition with very similar code:

In an attempt to programmatically create these tables using a parameterized table definition, the data engineer writes the following code.

The pipeline runs an update with this refactored code, but generates a different DAG showing incorrect configuration values for tables.
How can the data engineer fix this?
A. Load the configuration values for these tables from a separate file, located at a path provided by a pipeline parameter.
B. Convert the list of configuration values to a dictionary of table settings, using table names as keys.
C. Convert the list of configuration values to a dictionary of table settings, using different input the for loop.
D. Wrap the loop inside another table definition, using generalized names and properties to replace with those from the inner table
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A Delta table of weather records is partitioned by date and has the below schema:
date DATE, device_id INT, temp FLOAT, latitude FLOAT, longitude FLOAT
To find all the records from within the Arctic Circle, you execute a query with the below filter:
latitude > 66.3
Which statement describes how the Delta engine identifies which files to load?
A. All records are cached to an operational database and then the filter is applied
B. The Hive metastore is scanned for min and max statistics for the latitude column
C. The Parquet file footers are scanned for min and max statistics for the latitude column
D. The Delta log is scanned for min and max statistics for the latitude column
E. All records are cached to attached storage and then the filter is applied
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which is a key benefit of an end-to-end test?
A. It pinpoint errors in the building blocks of your application.
B. It provides testing coverage for all code paths and branches.
C. It makes it easier to automate your test suite
D. It closely simulates real world usage of your application.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
A Delta Lake table was created with the below query:

Realizing that the original query had a typographical error, the below code was executed:
ALTER TABLE prod.sales_by_stor RENAME TO prod.sales_by_store
Which result will occur after running the second command?
A. All related files and metadata are dropped and recreated in a single ACID transaction.
B. The table reference in the metastore is updated and no data is changed.
C. The table name change is recorded in the Delta transaction log.
D. The table reference in the metastore is updated and all data files are moved.
E. A new Delta transaction log Is created for the renamed table.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Incorporating unit tests into a PySpark application requires upfront attention to the design of your jobs, or a potentially significant refactoring of existing code.
Which statement describes a main benefit that offset this additional effort?
A. Yields faster deployment and execution times
B. Troubleshooting is easier since all steps are isolated and tested individually
C. Improves the quality of your data
D. Ensures that all steps interact correctly to achieve the desired end result
E. Validates a complete use case of your application
正解：B