Databricks Certification Practice Test 04
Practice Test 04
Databricks Certification Practice Test 04
Practice Test 04
Insightful Saga — Modern Data Engineering Certification Preparation
Question 61
## Question 61 A retail company loads product data from multiple vendors. Different vendors use different column names for the same business field. For example: - vendor_product_id - product_code - item_id The analytics team wants a standardized dataset for reporting. In which Medallion layer should these column names typically be standardized?
Silver is responsible for data standardization and business rule implementation. Different source system structures are converted into a consistent format before moving to Gold. ---
Question 62
## Question 62 A financial services company stores customer transactions in a Delta table. Auditors require a complete record of every INSERT, UPDATE, and DELETE operation performed against the table. Which Delta component provides this capability?
The Delta Transaction Log records all committed operations against the table and enables features such as ACID transactions and table history. ---
Question 63
## Question 63 An insurance company runs a report that always filters by: - claim_year - claim_month What is the best partitioning strategy?
Partition columns should align with common query filters. This minimizes file scanning and improves performance. ---
Question 64
## Question 64 A newly hired Data Engineer notices that data is being copied multiple times between Bronze and Silver tables with no transformations being applied. What is the biggest concern?
Copying data without business value increases storage consumption and processing costs while providing little benefit. ---
Question 65
## Question 65 A company wants all development notebooks to be reviewed before being deployed to Production. Which Databricks feature best supports collaborative source control?
Databricks Repos integrates with Git repositories and supports version control, code reviews, and collaborative development. ---
Question 66
## Question 66 An airline company receives flight information as nested JSON documents. Before analysts can query the data efficiently, the nested structures must be flattened. Which layer should typically perform this activity?
Flattening, cleaning, and transforming semi-structured data are common Silver-layer responsibilities. ---
Question 67
## Question 67 A company stores historical sales data going back ten years. Most users query only the last three months. Which approach will likely reduce query cost?
Archiving cold data reduces storage and compute costs while keeping frequently accessed data readily available. ---
Question 68
## Question 68 A streaming pipeline receives duplicate events from an external system. The business wants each event processed only once. Which capability should the engineer investigate?
Deduplication logic helps ensure repeated events do not impact downstream analytics. ---
Question 69
## Question 69 A healthcare analytics team wants to share curated datasets with another business unit without physically copying the data. Which Databricks capability is designed for this use case?
Delta Sharing enables secure sharing of datasets without creating additional physical copies. ---
Question 70
## Question 70 An engineer notices that a job spends most of its time moving data between executors instead of processing records. What is the likely bottleneck?
Large shuffle activity is often one of the most expensive portions of Spark execution. ---
Question 71
## Question 71 A company needs a process that automatically runs notebook A, then notebook B, then notebook C every night. Which Databricks capability is most appropriate?
Databricks Workflows orchestrate and schedule dependent tasks and notebooks. ---
Question 72
## Question 72 A retail organization needs to prevent developers from creating oversized clusters that increase cloud costs. Which feature should be implemented?
Cluster Policies enforce rules regarding cluster size, configuration, and governance. ---
Question 73
## Question 73 A notebook fails midway through processing because one source file contains unexpected null values. What should be added to improve pipeline reliability?
Validation checks help detect and handle bad data before it impacts downstream systems. ---
Question 74
## Question 74 An engineering team wants a dataset refreshed every 15 minutes instead of waiting for a nightly batch. What business benefit is gained?
More frequent processing provides more current information for decision-making. ---
Question 75
## Question 75 A company wants to track notebook execution success and failures across hundreds of pipelines. Which capability should be used?
Workflow Monitoring provides visibility into job execution, failures, retries, and run history. ---
Question 76
## Question 76 An online marketplace receives customer reviews in multiple languages. The data engineering team stores the original text exactly as received before performing any translation. Why is this considered a good practice?
Raw data should be retained so transformations can be reapplied if business requirements change. ---
Question 77
## Question 77 A company wants to understand how a failed dashboard ultimately depends on a source ERP table. Which capability provides end-to-end visibility?
Lineage traces dependencies from source systems through transformations to reporting assets. ---
Question 78
## Question 78 A large e-commerce company notices that engineers repeatedly create tables with inconsistent naming conventions. What should be introduced to improve governance?
Standardized naming improves maintainability, discoverability, and governance. ---
Question 79
## Question 79 A data platform team wants every production pipeline failure to automatically notify support engineers. Which approach is most appropriate?
Automated alerts reduce downtime by enabling faster response to failures. ---
Question 80
## Question 80 A customer analytics dataset is used by Marketing, Finance, and Operations teams. The company wants a single trusted version of customer metrics. What principle is being implemented?
A Single Source of Truth ensures all teams use consistent business definitions and metrics. --- --- title: Databricks Certification Practice Test 05 description: Fill in the Blank Certification Questions ---