Microsoft Exam DP-203 Topic 4 Question 80 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 80
Topic #: 4

[All DP-203 Questions]

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

You load 5 TB of data into table1.

You need to ensure that column store compression is maximized for table1.

Which statement should you execute?

AALTER INDEX ALL on table REBUILD

BDBCC DBREINOEX (table)

CDBCC IIDEXDEFRAG (pool1, table1)

DALTER INDEX ALL on table REORGANIZE

Show Suggested Answer

Suggested Answer: A, B

the two types of activities that you can use to execute SP1 areStored ProcedureandLookup.

A Stored Procedure activity executes a stored procedure on an Azure SQL Database or Azure Synapse Analytics or SQL Server1.You can specify the stored procedure name and parameters in the activity settings1.

A Lookup activity retrieves a dataset from any data source that returns a single row of data with four columns2.You can use a query to execute a stored procedure as the source of the Lookup activity2.You can then store the values in the columns as pipeline variables by using expressions2.

https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-stored-procedure

by Paris at Dec 08, 2023, 11:13 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Anissa

3 days ago

Hmm, I'm not sure about that. Wouldn't DBCC DBREINOEX be better since it's designed for compressing column store indexes?

upvoted 0 times

...

Elmira

8 days ago

I think option A is the correct answer. Rebuilding the index should maximize the column store compression for table1.

upvoted 0 times

...

Nickie

11 days ago

I see your point, but I still think A) ALTER INDEX ALL on table REBUILD is the best option for maximizing column store compression.

upvoted 0 times

...

Dahlia

17 days ago

I disagree, I believe the answer is D) ALTER INDEX ALL on table REORGANIZE.

upvoted 0 times

...

Nickie

18 days ago

I think the correct statement to execute is A) ALTER INDEX ALL on table REBUILD.

upvoted 0 times

...