Data Modelling Questions
Practice questions for Data Modelling topic in Databricks Certified Data Engineer Professional. 12 questions covering this domain.
In the medallion architecture, what is the primary purpose of the silver layer?
A data engineer needs to implement a Slowly Changing Dimension Type 2 (SCD Type 2) for a customer dimension table. Which statement correctly describes...
In the context of the Databricks Lakehouse medallion architecture, which layer is most appropriate for storing raw, unmodified data exactly as receive...
A data engineer is implementing a Type 2 Slowly Changing Dimension for a `products` table using Delta Lake. After successfully implementing the daily ...
A data engineer is designing a Delta table for a high-volume orders fact table that receives approximately 1 million new rows per day. Analysts run qu...
A bronze-layer design must preserve raw source fidelity and tolerate unexpected schema drift. Which approach aligns with the medallion guidance?
Which description best fits the gold layer in the medallion architecture?
A team wants to build a robust silver layer from cloud-ingested data. Which practice matches the medallion guidance?
A bronze-layer table is intended to preserve raw source fidelity and tolerate schema drift from upstream JSON files. Which design choice matches Datab...
A team proposes writing directly from cloud-file ingestion into silver tables to reduce pipeline hops. What does the Databricks medallion guidance rec...
Which description best fits the gold layer in the Databricks medallion architecture?
A modeling review proposes relying on primary keys and foreign keys in Delta tables to reject invalid inserts automatically. What is correct about tho...
Sign in to see all 12 questions
Create a free account to browse all questions — completely free during our launch phase.