Microsoft Exam DP-203 Topic 1 Question 68 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 68
Topic #: 1

You have an enterprise data warehouse in Azure Synapse Analytics.

Using PolyBase, you create an external table named [Ext].[Items] to query Parquet files stored in Azure Data Lake Storage Gen2 without importing the data to the data warehouse.

The external table has three columns.

You discover that the Parquet files have a fourth column named ItemID.

Which command should you run to add the ItemID column to the external table?

AOption A

BOption B

COption C

DOption D

Show Suggested Answer

Suggested Answer: B

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-restore-active-paused-dw

by Sylvie at Feb 27, 2023, 01:29 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Bethanie

23 hours ago

As a data warehouse expert, I can tell you that Option C is the way to go. It's the most elegant solution, like a graceful swan.

upvoted 0 times

...

Laticia

3 days ago

I'm not sure, but Option D looks tempting. Maybe it's some kind of fancy SQL magic trick?

upvoted 0 times

...

Angelyn

5 days ago

Option B seems like the right choice. We need to alter the external table to add the missing column.

upvoted 0 times

...

Timmy

20 days ago

I'm not sure. Maybe we should also consider Option B or Option C before making a decision.

upvoted 0 times

...

Lorrie

22 days ago

I agree with Audrie. Option A seems like the correct choice to modify the external table.

upvoted 0 times

...

Audrie

24 days ago

I think we should run the ALTER EXTERNAL TABLE statement to add the ItemID column.

upvoted 0 times

...