CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #63
CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #63: Real Exam Question with Answer & Explanation
Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #63. The question stem and answer options stay visible for context.
Question
A Databricks SQL dashboard has been configured to monitor the total number of records present in a collection of Delta Lake tables using the following query pattern: SELECT COUNT (*) FROM table Which of the following describes how results are generated each time the dashboard is updated?
Options
- AThe total count of rows is calculated by scanning all data files
- BThe total count of rows will be returned from cached results unless REFRESH is run
- CThe total count of records is calculated from the Delta transaction logs
- DThe total count of records is calculated from the parquet file metadata
- EThe total count of records is calculated from the Hive metastore
Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer
You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.