Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Hotspot Solution:
DimCustomer: Dual FactSales: DirectQuery FactMarketingEmail: Import FactSales requires DirectQuery since the data changes once per minute and must be available within five minutes — importing wouldn't reliably meet that freshness requirement at this volume. FactMarketingEmail, updated only once daily, should use Import to minimize query response time, since cached in-memory data queries fastest. DimCustomer needs Dual mode because it's related to both an Import table (FactMarketingEmail) and a DirectQuery table (FactSales): Dual allows the engine to use the cached copy when joined with Import tables and switch to DirectQuery when joined with the DirectQuery fact table, optimizing performance across both relationships without requiring you to duplicate the dimension.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
DimCustomer: Dual FactSales: DirectQuery FactMarketingEmail: Import
DimCustomer: Dual FactSales: DirectQuery FactMarketingEmail: Import FactSales requires DirectQuery since the data changes once per minute and must be available within five minutes — importing wouldn't reliably meet that freshness requirement at this volume. FactMarketingEmail, updated only once daily, should use Import to minimize query response time, since cached in-memory data queries fastest. DimCustomer needs Dual mode because it's related to both an Import table (FactMarketingEmail) and a DirectQuery table (FactSales): Dual allows the engine to use the cached copy when joined with Import tables and switch to DirectQuery when joined with the DirectQuery fact table, optimizing performance across both relationships without requiring you to duplicate the dimension.