最新的Databricks Certified Data Engineer Professional - Certified-Data-Engineer-Professional免費考試真題
Which of the following technologies can be used to identify key areas of text when parsing Spark Driver log4j output?
正確答案: D
說明：（僅 Fast2test 成員可見）
Which approach demonstrates a modular and testable way to use DataFrame transform for ETL code in PySpark?
正確答案: C
說明：（僅 Fast2test 成員可見）
A Delta Lake table was created with the below query:
Consider the following query:
DROP TABLE prod.sales_by_store
If this statement is executed by a workspace admin, which result will occur?
Consider the following query:
DROP TABLE prod.sales_by_store
If this statement is executed by a workspace admin, which result will occur?
正確答案: C
說明：（僅 Fast2test 成員可見）
Review the following error traceback:
Which statement describes the error being raised?
Which statement describes the error being raised?
正確答案: D
說明：（僅 Fast2test 成員可見）
A team of data engineer are adding tables to a DLT pipeline that contain repetitive expectations for many of the same data quality checks.
One member of the team suggests reusing these data quality rules across all tables defined for this pipeline.
What approach would allow them to do this?
One member of the team suggests reusing these data quality rules across all tables defined for this pipeline.
What approach would allow them to do this?
正確答案: C
說明：（僅 Fast2test 成員可見）
A data engineering team needs to create a SQL Alert that monitors data quality across multiple columns in their customer table. They want to trigger an alert when both the percentage of customers with missing email addresses exceeds 15% AND the percentage of customers with invalid phone number formats exceeds 10%. Which SQL query pattern is appropriate for implementing this multi-column alert condition?
正確答案: B
說明：（僅 Fast2test 成員可見）
A data engineer needs to implement column masking for a sensitive column in a Unity Catalog- managed table. The masking logic must dynamically check if users belong to specific groups defined in a separate table (group_access) that maps groups to allowed departments. Which approach should the engineer use to efficiently enforce this requirement?
正確答案: C
說明：（僅 Fast2test 成員可見）
A Data engineer wants to run unit's tests using common Python testing frameworks on python functions defined across several Databricks notebooks currently used in production. How can the data engineer run unit tests against function that work with data in production?
正確答案: A
說明：（僅 Fast2test 成員可見）
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?
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?
正確答案: C
說明：（僅 Fast2test 成員可見）
The downstream consumers of a Delta Lake table have been complaining about data quality issues impacting performance in their applications. Specifically, they have complained that invalid latitude and longitude values in the activity_details table have been breaking their ability to use other geolocation processes.
A junior engineer has written the following code to add CHECK constraints to the Delta Lake table:
A senior engineer has confirmed the above logic is correct and the valid ranges for latitude and longitude are provided, but the code fails when executed.
Which statement explains the cause of this failure?
A junior engineer has written the following code to add CHECK constraints to the Delta Lake table:
A senior engineer has confirmed the above logic is correct and the valid ranges for latitude and longitude are provided, but the code fails when executed.
Which statement explains the cause of this failure?
正確答案: B
說明：（僅 Fast2test 成員可見）