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

質問 1：
An upstream source writes Parquet data as hourly batches to directories named with the current date. A nightly batch job runs the following code to ingest all data from the previous day as indicated by thedatevariable:

Assume that the fieldscustomer_idandorder_idserve as a composite key to uniquely identify each order.
If the upstream system is known to occasionally produce duplicate entries for a single order hours apart, which statement is correct?
A. Each write to the orders table will run deduplication over the union of new and existing records, ensuring no duplicate records are present.
B. Each write to the orders table will only contain unique records; if existing records with the same key are present in the target table, these records will be overwritten.
C. Each write to the orders table will only contain unique records, and only those records without duplicates in the target table will be written.
D. Each write to the orders table will only contain unique records, but newly written records may have duplicates already present in the target table.
E. Each write to the orders table will only contain unique records; if existing records with the same key are present in the target table, the operation will tail.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
An external object storage container has been mounted to the location/mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:

After the database was successfully created and permissions configured, a member of the finance team runs the following code:

If all users on the finance team are members of thefinancegroup, which statement describes how thetx_sales table will be created?
A. A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.
B. An external table will be created in the storage container mounted to /mnt/finance eda bucket.
C. An managed table will be created in the storage container mounted to /mnt/finance eda bucket.
D. A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.
E. A managed table will be created in the DBFS root storage container.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which REST API call can be used to review the notebooks configured to run as tasks in a multi-task job?
A. /jobs/get
B. /jobs/runs/get
C. /jobs/runs/list
D. /jobs/runs/get-output
E. /jobs/list
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A table named user_ltv is being used to create a view that will be used by data analysis on various teams.
Users in the workspace are configured into groups, which are used for setting up data access using ACLs.
The user_ltv table has the following schema:

An analyze who is not a member of the auditing group executing the following query:

Which result will be returned by this query?
A. All age values less than 18 will be returned as null values all other columns will be returned with the values in user_ltv.
B. All columns will be displayed normally for those records that have an age greater than 18; records not meeting this condition will be omitted.
C. All records from all columns will be displayed with the values in user_ltv.
D. All columns will be displayed normally for those records that have an age greater than 17; records not meeting this condition will be omitted.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
In order to facilitate near real-time workloads, a data engineer is creating a helper function to leverage the schema detection and evolution functionality of Databricks Auto Loader. The desired function will automatically detect the schema of the source directly, incrementally process JSON files as they arrive in a source directory, and automatically evolve the schema of the table when new fields are detected.
The function is displayed below with a blank:

Which response correctly fills in the blank to meet the specified requirements?

A. Option E
B. Option A
C. Option C
D. Option D
E. Option B
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Assuming that the Databricks CLI has been installed and configured correctly, which Databricks CLI command can be used to upload a custom Python Wheel to object storage mounted with the DBFS for use with a production job?
A. libraries
B. configure
C. workspace
D. fs
E. jobs
正解：A
解説: (Topexam メンバーにのみ表示されます)