MicrosoftMicrosoft
DP-500 · Question #21
DP-500 Question #21: Real Exam Question with Answer & Explanation
Sign in or unlock DP-500 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.
Implement and manage data models
Question
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?
Options
- ACreate calculated columns in Dataset1.
- BRemove the relationships from Dataset1.
- CNormalize the tables in DB1.
- DDenormalize the tables in DB1.
Unlock DP-500 to see the answer
You've previewed enough free DP-500 questions. Unlock DP-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#DirectQuery optimization#Database design for analytics#Denormalization#Performance tuning