Microsoft Exam DP-203 Topic 2 Question 92 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 92
Topic #: 2

[All DP-203 Questions]

You have an Azure Synapse Analytics dedicated SQL pool.

You plan to create a fact table named Table1 that will contain a clustered columnstore index.

You need to optimize data compression and query performance for Table1.

What is the minimum number of rows that Table1 should contain before you create partitions?

A100.000

B600,000

C1 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

Zachary

7 months ago

I agree with Jacqueline, creating partitions with fewer rows can definitely improve query performance.

upvoted 0 times

...

Jacqueline

7 months ago

But wouldn't creating partitions with 1 million rows be more efficient for query performance?

upvoted 0 times

...

Jamika

7 months ago

I'm just hoping the right answer isn't 'all of the above' - that would be a real head-scratcher!

upvoted 0 times

...

Emilio

7 months ago

A) 100,000? That's just way too low. You'll never get the full benefits of a columnstore index with that few rows.

upvoted 0 times

...

Margarett

7 months ago

I disagree, I believe the answer is D) 60 million.

upvoted 0 times

...

Aron

7 months ago

B) 600,000 seems like a good middle ground to me. Partitioning can get tricky, so I'd try to avoid it if possible.

upvoted 0 times

Staci

7 months ago

B) 600,000

upvoted 0 times

...

Tawna

7 months ago

A) 100,000

upvoted 0 times

...

Twila

8 months ago

D) 60 million? Wow, that's a lot of rows! I guess if you have a really massive dataset, partitioning might be the way to go.

upvoted 0 times

...

Son

8 months ago

C) 1 million? I heard that's the sweet spot for columnstore indexes in Azure Synapse. Anything less and the compression won't be as good.

upvoted 0 times

Ronnie

7 months ago

C) 1 million? I heard that's the sweet spot for columnstore indexes in Azure Synapse. Anything less and the compression won't be as good.

upvoted 0 times

...

Delsie

7 months ago

A) 100,000

upvoted 0 times

...

Jacqueline

8 months ago

I think the answer is C) 1 million.

upvoted 0 times

...