Databricks Certification Practice Test 03
Practice Test 03
Databricks Certification Practice Test 03
Practice Test 03
Insightful Saga — Modern Data Engineering Certification Preparation
Question 41
## Question 41 A global retail company receives daily sales files from 500 stores. Each store uploads its data separately throughout the day. The data engineering team notices that some stores occasionally resend the same file due to network failures. The team wants to ensure duplicate records are not loaded into the reporting layer. What is the MOST appropriate solution?
The Silver layer is responsible for: - Data cleansing - Standardization - Deduplication - Quality improvements Bronze should preserve raw incoming data. ---
Question 42
## Question 42 An online banking company stores customer transaction history in a Delta table. A deployment issue accidentally updates thousands of account balances incorrectly. Management asks the engineering team to restore the table exactly as it existed six hours ago. Which solution requires the LEAST effort?
Delta Time Travel allows access to previous versions of a table using timestamps or version numbers. ---
Question 43
## Question 43 A healthcare company runs a nightly pipeline that joins a 10 TB patient records table with a 50 MB hospital reference table. The nightly job takes much longer than expected. Which optimization would MOST likely improve performance?
The hospital table is small enough to broadcast, eliminating expensive data shuffles during joins. ---
Question 44
## Question 44 A logistics company stores shipment data partitioned by shipment_date. Analysts usually query only the last 7 days of data. What advantage does this partitioning strategy provide?
Databricks scans only the required partitions instead of the entire dataset. ---
Question 45
## Question 45 A media company loads video viewing events every few seconds. Business users require dashboards to reflect data almost immediately. Which processing approach should be used?
Structured Streaming enables continuous ingestion and near real-time reporting. ---
Question 46
## Question 46 A company has many Databricks workspaces across development, testing and production environments. Security teams want a single location to manage permissions and governance. Which service should be implemented?
Unity Catalog centralizes: - Permissions - Governance - Auditing - Lineage across workspaces. ---
Question 47
## Question 47 A manufacturing company receives IoT sensor files every minute. Engineers do not want to manually identify new files landing in cloud storage. Which Databricks feature is best suited?
Auto Loader automatically discovers and processes newly arriving files. ---
Question 48
## Question 48 A customer dimension table stores customer status changes. Business users need to know both current and historical customer statuses. Which design approach should be implemented?
SCD Type 2 preserves historical versions while maintaining the current active record. ---
Question 49
## Question 49 A Delta table contains billions of records. Queries frequently filter by Country and City. Which optimization strategy would provide the greatest benefit?
Partitioning allows Databricks to read fewer files during query execution. ---
Question 50
## Question 50 A data engineer notices that one Spark task processes significantly more data than all other tasks. The job completes slowly because a single executor takes much longer than the rest. What issue is occurring?
Data skew occurs when data distribution is uneven across partitions. ---
Question 51
## Question 51 A retail company writes transaction data continuously throughout the day. Several analysts run queries against the same table simultaneously. Which Databricks feature ensures readers always see consistent results during writes?
Delta Lake ACID guarantees consistency even when multiple readers and writers access data concurrently. ---
Question 52
## Question 52 A technology company has a nightly ETL workflow that runs once and then sits idle for the rest of the day. Management wants to minimize cloud costs. Which compute option is most appropriate?
Job Clusters automatically start and terminate, reducing idle costs. ---
Question 53
## Question 53 A travel company stores booking information in a Delta table. A new data source begins providing a new column called loyalty_tier. The team wants the table to accept the new column automatically. Which Delta capability supports this requirement?
Schema Evolution allows compatible schema changes without recreating tables. ---
Question 54
## Question 54 A streaming pipeline suddenly fails because of a temporary infrastructure outage. When restarted, the engineers want processing to continue from the last committed event. Which feature is required?
Checkpointing stores processing state and offsets for recovery. ---
Question 55
## Question 55 A pharmaceutical company must identify who modified a regulated dataset and when the changes occurred. Which command provides this information?
DESCRIBE HISTORY displays operation type, user, timestamp and version details. ---
Question 56
## Question 56 A data engineering team notices thousands of tiny files being created every hour in a Delta table. Query performance gradually declines. What should the team do?
OPTIMIZE compacts numerous small files into larger files and improves read performance. ---
Question 57
## Question 57 An airline company has Bronze, Silver and Gold layers. Business analysts use a Power BI dashboard for monthly KPI reporting. Which layer should Power BI primarily consume?
Gold contains business-ready, aggregated and curated datasets. ---
Question 58
## Question 58 A global e-commerce platform frequently reruns the same expensive transformation multiple times within a notebook. Engineers want to reduce repeated processing. Which action should be considered?
Caching stores frequently reused datasets in memory. ---
Question 59
## Question 59 A security team wants to hide customer Social Security Numbers while still allowing analysts to query other customer attributes. Which capability should be implemented?
Column-level security protects sensitive fields while exposing other attributes. ---
Question 60
## Question 60 A new data engineer joins a company and needs to understand how a Gold KPI table is generated from source systems. Which Unity Catalog capability would help most?
Lineage shows: - Source datasets - Transformations - Downstream dependencies - End-to-end data flow This helps engineers quickly understand data movement across the platform. --- --- title: Databricks Certification Practice Test 04 description: Advanced Company Scenario Based Questions ---