Microsoft Exam DP-203 Topic 8 Question 59 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 59
Topic #: 8

You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a table named table1.

You load 5 TB of data intotable1.

You need to ensure that columnstore compression is maximized for table1.

Which statement should you execute?

AALTER INDEX ALL on table1 REORGANIZE

BALTER INDEX ALL on table1 REBUILD

CDBCC DBREINOEX (table1)

DDBCC INDEXDEFRAG (pool1,tablel)

Show Suggested Answer

Suggested Answer: C

by Nana at Aug 20, 2022, 12:34 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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