Design and Implement Data Modeling in Unity Catalog DP-750 Practice Questions (Page 2)

Questions 6–10

1. 6expert · hard

   A retail analytics team has a fact table of sales transactions. They need to support queries for daily sales by store and also monthly sales by product category. The raw transaction table is large. To optimize query performance and storage, what granularity should they use for the analytical tables?

   • AUse a single table at monthly granularity by store
   • BCreate two aggregate tables: daily by store and monthly by category
   • CUse a single table at transaction-level granularity
   • DUse a single table at daily granularity by store and category
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   When would you choose an unmanaged (external) table over a managed table?

   • AWhen you want Databricks to handle all data lifecycle management
   • BWhen you want to enforce strict access control
   • CWhen you need to keep the data files even after the table is dropped
   • DWhen you need automatic schema evolution
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A company needs to ingest data from a SaaS application (Salesforce) and an on-premises SQL Server database into Azure Databricks. The Salesforce data must be synced every 15 minutes, while the SQL Server data is loaded daily. The team has limited coding skills and prefers a managed solution. Which combination of ingestion tools should they use?

   • ANotebooks for both sources
   • BStructured Streaming for both sources
   • CLakeflow Connect for Salesforce and Azure Data Factory for SQL Server
   • DAzure Data Factory for both sources
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   In a slowly changing dimension (SCD) Type 2 implementation, what happens when a dimension attribute changes?

   • AThe old record is deleted and a new one is inserted
   • BA new record is inserted and the old record is marked as expired
   • CThe existing record is updated with the new value
   • DA separate table is created for each change
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A media company stores user interaction events in a Delta table. Queries frequently filter by user_id and event_date, and the table is updated with new events every few minutes. The data volume is growing rapidly, and the team wants to maintain query performance without manual tuning. Which strategy should they implement?

   • APartition the table by event_date and apply Z-ordering on user_id
   • BApply Z-ordering on event_date only
   • CPartition the table by user_id and event_date
   • DUse liquid clustering on user_id and event_date
   Reveal Solution Discussion Select an answer first