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
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Asked Gpt. For very large fact tables with refresh memory issues and performance requirements, the preferred solution is Incremental Refresh with a Hybrid (Import + DirectQuery) table.
Summarization (Option C) is simpler and maintains peak performance.
* Answer: D. Change the invoice table to a composite table that contains historical data as a DirectQuery table and hot data as an import table, and then partition the table. * Explanation: - The error indicates memory limits are exceeded during refresh because the Invoice table has 12 million rows. - A composite model with Import for hot data (recent months) and DirectQuery for historical data reduces memory usage while keeping recent data fast for end users. - Partitioning ensures efficient refresh and query performance. * Why not the others: - A. Merge Sales person and Invoice: Increases table size and complexity, worsening memory issues. - B. Change Invoice to DirectQuery only: Reduces memory but can hurt performance for all queries. - C. Summarize Invoice: Loses detail needed for granular analysis.