Databricks Certification Practice Test 05
Practice Test 05
Databricks Certification Practice Test 05
Practice Test 05
Insightful Saga — Modern Data Engineering Certification Preparation
Question 81
## Question 81 A retail company stores raw files exactly as received from source systems. According to Medallion Architecture, these files should typically be stored in the **_____** layer. <Select> <option>Gold</option> <option>Silver</option> <option>Bronze</option> <option>Semantic</option> </Select>
The Bronze layer stores raw, unmodified source data before cleansing or business transformations occur. ---
Question 82
## Question 82 A Delta table is receiving thousands of small files every day. To improve query performance, the engineer should run **_____**. <Select> <option>MERGE</option> <option>OPTIMIZE</option> <option>DESCRIBE HISTORY</option> <option>CACHE</option> </Select>
OPTIMIZE compacts small files into larger files and improves read performance. ---
Question 83
## Question 83 A streaming pipeline fails unexpectedly. To resume processing from the last successful state, engineers should configure **_____**. <Select> <option>Photon</option> <option>Checkpointing</option> <option>Partitioning</option> <option>ZORDER</option> </Select>
Checkpointing stores offsets and state information so processing can resume after failures. ---
Question 84
## Question 84 A healthcare company wants to hide patient SSN values while allowing access to other columns. Unity Catalog feature **_____** should be implemented. <Select> <option>Column-Level Security</option> <option>Broadcast Join</option> <option>Delta Sharing</option> <option>AQE</option> </Select>
Column-Level Security restricts access to sensitive columns. ---
Question 85
## Question 85 A company needs historical tracking of customer address changes. The most appropriate design pattern is **_____**. <Select> <option>SCD Type 1</option> <option>SCD Type 2</option> <option>Overwrite Load</option> <option>Snapshot Delete</option> </Select>
SCD Type 2 preserves historical versions of records while maintaining current values. ---
Question 86
## Question 86 A Data Engineer wants to view all changes made to a Delta table over time. The command **_____** provides this information. <Select> <option>SHOW DATABASES</option> <option>DESCRIBE HISTORY</option> <option>CACHE TABLE</option> <option>CREATE VIEW</option> </Select>
DESCRIBE HISTORY displays operation type, timestamp, user and Delta table versions. ---
Question 87
## Question 87 A small reference table is joined with a multi-terabyte fact table. The most efficient join strategy is usually **_____**. <Select> <option>Broadcast Join</option> <option>Cross Join</option> <option>Cartesian Join</option> <option>Nested Join</option> </Select>
Broadcasting the small table avoids expensive data shuffling. ---
Question 88
## Question 88 A company wants centralized governance across multiple Databricks workspaces. The recommended Databricks service is **_____**. <Select> <option>MLflow</option> <option>Unity Catalog</option> <option>Photon</option> <option>Notebook Workflow</option> </Select>
Unity Catalog centralizes permissions, lineage and governance. ---
Question 89
## Question 89 The hierarchy in Unity Catalog is: Catalog → _____ → Table <Select> <option>Workspace</option> <option>Schema</option> <option>Cluster</option> <option>Photon</option> </Select>
Objects are organized as Catalog → Schema → Table/View. ---
Question 90
## Question 90 A logistics company continuously receives new files in cloud storage. Databricks feature **_____** automatically discovers and ingests new files. <Select> <option>Auto Loader</option> <option>Photon</option> <option>Vacuum</option> <option>Cluster Policy</option> </Select>
Auto Loader automatically detects and processes newly arriving files. --- --- title: Databricks Certification Practice Test 06 description: Intermediate and Advanced Fill in the Blank Questions ---