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

Corrie

8 days ago

Wow, 60 million rows a month? That's enough to make the Azure Synapse team do a little dance! I'm feeling lucky with option D - 60 million rows per combo. Let's see if I can win the data center jackpot!

upvoted 0 times

...

Jutta

10 days ago

Hold on, 60 million rows per month? That's enough to make even the most seasoned data analyst sweat! I'm guessing 5 million rows per combination just to be on the safe side.

upvoted 0 times

...

Jutta

16 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

Caren

8 hours ago

I agree with you, option C seems like the most logical choice.

upvoted 0 times

...

Lenora

21 days ago

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

upvoted 0 times

...

Jin

23 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

Denae

7 days ago

I think it's 20 million rows per combination too.

upvoted 0 times

...

Patrick

25 days ago

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

upvoted 0 times

...

Jeannetta

28 days ago

I think the answer is A) 1 million.

upvoted 0 times

...