Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 102

You have a Power BI dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1.
DB1 is a transactional database in the third normal form.
You need to recommend a solution to minimize how long it takes to execute the query. The solution must maintain the current functionality.
What should you include in the recommendation?

Answer options

• A. Remove the relationships from Dataset1.
• B. Normalize the tables in DB1.
• C. Create calculated columns in Dataset1.
• D. Denormalize the tables in DB1.

Correct answer: D

Explanation

Denormalizing the tables in DB1 can reduce the complexity of joins and improve query performance, which is crucial when using DirectQuery. Removing relationships or normalizing the tables would likely increase the time taken to execute queries, and creating calculated columns in Dataset1 might not be effective in addressing the underlying performance issues.