Microsoft Exam DP-500 Topic 11 Question 10 Discussion

Actual exam question for Microsoft's DP-500 exam

Question #: 10
Topic #: 11

You have a Power Bl 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?

ACreate calculated columns in Dataset1.

BRemove the relationships from Dataset1.

CNormalize the tables in DB1.

DDenormalize the tables in DB1.

Show Suggested Answer

Suggested Answer: C

by Albina at Aug 22, 2022, 07:47 PM

Limited Time Offer

25%

Off

Get Premium DP-500 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

brendan daly

2 years ago

it is already normalized in 3rd normal form, you denormalize it.

upvoted 1 times

...