Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-203 Topic 1 Question 68 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 68
Topic #: 1
[All DP-203 Questions]

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?

Show Suggested Answer Hide Answer

Contribute your Thoughts:

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
...

Save Cancel