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

Chanel

2 months ago

If all else fails, we can always try the 'Undo' button. That's the secret to solving all data warehouse problems, right?

upvoted 0 times

Sharmaine

23 days ago

Yes, that's correct. Option B is the command you should run to add the ItemID column to the external table.

upvoted 0 times

...

Carman

28 days ago

B) Option B

upvoted 0 times

...

Billye

1 months ago

No, that won't work. Try another option.

upvoted 0 times

...

Adell

1 months ago

A) Option A

upvoted 0 times

...

Denny

2 months ago

Option A? Really? That's about as useful as a chocolate teapot. I'm going with Option B, no doubt about it.

upvoted 0 times

Rolf

13 days ago

Definitely not Option A, Option B is the better option.

upvoted 0 times

...

Carman

27 days ago

I agree, Option B seems like the best choice.

upvoted 0 times

...

Nguyet

1 months ago

I think Option B is the way to go.

upvoted 0 times

...

Bethanie

2 months 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

Virgilio

16 days ago

Thanks for the advice, I'll go with Option C then.

upvoted 0 times

...

Kallie

17 days ago

I agree, Option C is the most efficient solution.

upvoted 0 times

...

Margot

2 months ago

Option C is definitely the best choice here.

upvoted 0 times

...

Laticia

2 months ago

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

upvoted 0 times

Mari

23 days ago

User3: Option D it is then. Let's try that SQL magic trick.

upvoted 0 times

...

Nicolette

24 days ago

User2: Yeah, I agree. Let's go with Option D.

upvoted 0 times

...

Glenn

2 months ago

User1: I think Option D is the correct one.

upvoted 0 times

...

Angelyn

2 months ago

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

upvoted 0 times

...

Timmy

3 months ago

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

upvoted 0 times

...

Lorrie

3 months ago

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

upvoted 0 times

...

Audrie

3 months ago

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

upvoted 0 times

...