Microsoft Exam DP-203 Topic 3 Question 9 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 9
Topic #: 3

You are designing a fact table named FactPurchase in an Azure Synaps Analytics dedicated SQL pool. The table contains purchases from suppliers for a retail store. FactPurchase will contain the following columns.

FactPurchase will have 1 million rows of data added daily and will contain three years of data.

Transact-SQL queries similar to the following query will be executed daily.

Around-robin

Breplicated

Chash-distributed on DateKey

Dhash-distributed on PurchaseKey

Show Suggested Answer

Suggested Answer: A

by Solange at May 04, 2022, 06:26 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!