Microsoft Certified Azure Enterprise Data Analyst Associate · Free Practice Question Medium
Question 11
What steps should be included in the recommendation to reduce the query execution time while preserving the existing functionality for a Power BI dataset named Dataset1 that utilizes DirectQuery against an Azure SQL database named DB1?
- A Eliminate the associations from Dataset1.
- B Standardize the tables in DB1.
- C Generate computed columns in Dataset1.
- D Consolidate the tables in DB1.
Reveal correct answer
Correct answer: D
Explanation
To minimize the execution time of the query while maintaining the current functionality of the Power BI dataset that uses DirectQuery against the Azure SQL database, the recommended solution is to denormalize the tables in DB1. Denormalization involves combining tables and reducing the number of joins required in the query, which can significantly improve query performance. By denormalizing the tables, the query can access the required data more efficiently, resulting in faster execution times. Removing relationships from the dataset, normalizing the tables, or creating calculated columns would not directly address the goal of minimizing query execution time.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
