Microsoft Exam DP-203 Topic 2 Question 92 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 92
Topic #: 2

You are designing a sales transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will contains approximately 60 million rows per month and will be partitioned by month. The table will use a clustered column store index and round-robin distribution.

Approximately how many rows will there be for each combination of distribution and partition?

A1 million

B5 million

C20 million

D60 million

Show Suggested Answer

Suggested Answer: A

by Lauran at Jun 21, 2024, 02:12 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jutta

3 days ago

Ah, the old round-robin distribution trick. I'm going with option C - 20 million rows per combo. Gotta love those evenly distributed partitions!

upvoted 0 times

...

Lenora

8 days ago

I agree with Patrick, C) 20 million makes sense with the partitioning and distribution in mind.

upvoted 0 times

...

Jin

10 days ago

Hmm, 60 million rows per month? That's a lot of data to crunch! I'm betting on 20 million rows per combination - just enough to keep the database busy but not too overwhelming, right?

upvoted 0 times

...

Patrick

11 days ago

I disagree, I believe the answer is C) 20 million because of the partitioning by month.

upvoted 0 times

...

Jeannetta

15 days ago

I think the answer is A) 1 million.

upvoted 0 times

...