Databricks Certification Practice Test 02
Practice Test 02
Databricks Certification Practice Test 02
Practice Test 02
Insightful Saga — Modern Data Engineering Certification Preparation
Question 21
## Question 21 A data engineering team receives customer data from multiple source systems. The incoming files often contain additional columns that were not present previously. The team wants new columns to be added automatically without recreating the destination Delta table. Which feature should be enabled?
Schema Evolution allows Delta tables to automatically incorporate compatible schema changes, such as newly added columns. ---
Question 22
## Question 22 A data pipeline writes thousands of small files every hour. Users report increasing query latency. Which action should be performed FIRST?
Large numbers of small files negatively impact query performance. OPTIMIZE compacts these files into larger files. ---
Question 23
## Question 23 A company wants to restrict analysts from viewing salary information while allowing access to employee names and departments. Which Unity Catalog capability should be used?
Column-level security allows sensitive columns to remain hidden while exposing permitted columns. ---
Question 24
## Question 24 A streaming job fails unexpectedly. After restart, processing should continue from the last successfully processed record. Which feature makes this possible?
Checkpointing stores state and progress information that allows recovery after failures. ---
Question 25
## Question 25 A data engineer needs to investigate who modified a table and when modifications occurred. Which feature should be queried?
DESCRIBE HISTORY provides information regarding Delta table operations, users, timestamps and versions. ---
Question 26
## Question 26 A query joins a 5 TB fact table with a 5 MB dimension table. Which optimization is most appropriate?
Broadcast joins eliminate expensive shuffles by sending the small dimension table to each executor. ---
Question 27
## Question 27 An analyst accidentally deletes records from a Delta table. The team must restore the table to yesterday's state. Which feature supports this requirement?
Delta Time Travel provides access to previous table versions using timestamps or versions. ---
Question 28
## Question 28 Which architecture layer should contain business-level KPIs such as Monthly Revenue and Total Profit?
Gold Layer contains aggregated and business-ready datasets. ---
Question 29
## Question 29 A company wants compute resources to terminate automatically after ETL completion. Which compute type should be selected?
Job Clusters start automatically and terminate after workload completion. ---
Question 30
## Question 30 A table contains millions of records distributed unevenly across partitions. One partition contains significantly more data than others. What issue is occurring?
Data skew occurs when workload distribution is highly imbalanced across partitions. ---
Question 31
## Question 31 Which feature automatically adjusts query plans during execution?
Adaptive Query Execution dynamically optimizes query execution while jobs are running. ---
Question 32
## Question 32 A team requires centralized governance across multiple Databricks workspaces. Which service should be implemented?
Unity Catalog centralizes data governance, permissions, lineage and auditing across workspaces. ---
Question 33
## Question 33 An engineer wants to ingest cloud files incrementally as they arrive. Which Databricks feature is specifically designed for this use case?
Auto Loader efficiently discovers and processes newly arriving files. ---
Question 34
## Question 34 A Delta table is partitioned by Region. A query filters only Region = 'India'. What optimization occurs?
Only relevant partitions are scanned, reducing read cost and improving performance. ---
Question 35
## Question 35 Which Unity Catalog object directly contains tables?
Hierarchy: Catalog → Schema → Table ---
Question 36
## Question 36 A pipeline requires historical tracking of customer address changes. Which design pattern is most suitable?
SCD Type 2 stores historical versions and tracks record changes over time. ---
Question 37
## Question 37 Which command provides metadata about Delta table columns and data types?
DESCRIBE TABLE returns schema-related information. ---
Question 38
## Question 38 A dimension table is frequently reused in multiple transformations. What should be considered to reduce repeated computation?
Caching stores data in memory for faster reuse. ---
Question 39
## Question 39 A company wants to understand upstream and downstream dependencies of a dataset. Which Unity Catalog capability provides this information?
Lineage provides visibility into data flow and dependencies. ---
Question 40
## Question 40 An engineer wants the highest query performance available for SQL workloads in Databricks. Which feature should be enabled?
Photon is Databricks' high-performance native execution engine optimized for analytics workloads. --- --- title: Databricks Certification Practice Test 03 description: Real Company Scenario Based Questions ---