Exam DP-500 topic 1 question 66 discussion

Actual exam question from Microsoft's DP-500

Question #: 66
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: D 🗳️

by cookiemonster42 at Jan. 19, 2023, 12:25 a.m.

Comments

Submit Cancel

SamuComqi

1 year, 10 months ago

I took the exam a few days ago (14/8/2023) and I passed the exam with a score of 915. My answer was: - Denormalize the tables in DB1

upvoted 1 times

...

Plb2

2 years ago

Selected Answer: D

D(enormalize)

upvoted 3 times

...

DarioReymago

2 years, 2 months ago

Selected Answer: D

I think D is correct

upvoted 2 times

...

cookiemonster42

2 years, 5 months ago

shouldn't it be B, because long tables are taking longer to process?

upvoted 1 times

stfglv

2 years, 5 months ago

no because "DB1 is a transactional database in the third normal form" --> the last part of the sentence means that it is already normalized.

upvoted 1 times

...

per_ing

2 years, 5 months ago

Denormalized tables are quicker to read than normalized, so I believe this is correct https://medium.com/@innerbit/when-and-how-you-should-denormalize-a-relational-database-75047344ebac

upvoted 4 times

...

salvalcaraz

1 year, 6 months ago

A query performs faster in a big denormalized table. Normalized databases requires more joins, which are expensive query processes.

upvoted 1 times

...