Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 15 discussion

Actual exam question from Microsoft's DP-203

Question #: 15
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?
A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: C
Incorrect Answers:
A, D: Only these Data Definition Language (DDL) statements are allowed on external tables:
✑ CREATE TABLE and DROP TABLE
✑ CREATE STATISTICS and DROP STATISTICS
✑ CREATE VIEW and DROP VIEW
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql

by Chien_Nguyen_Van at Sept. 1, 2021, 3:20 p.m.

Comments

Submit Cancel

Chien_Nguyen_Van

Highly Voted 3 years, 4 months ago

C is correct https://www.examtopics.com/discussions/microsoft/view/19469-exam-dp-200-topic-1-question-27-discussion/

upvoted 58 times

...

baiy

Highly Voted 1 year, 10 months ago

C is correct, since "altering the schema or format of an external SQL table is not supported". https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/external-sql-tables

upvoted 16 times

...

ELJORDAN23

Most Recent 11 months, 2 weeks ago

Got this question on my exam on january 17, C is correct

upvoted 6 times

...

hassexat

1 year, 3 months ago

C is correct since you need to drop first and create again the external table

upvoted 2 times

...

vigilante89

2 years ago

Answer is C. Drop the external table and recreate it. Because the column which needs to be added is the ItemID which seems like a primary key. So we have to drop the table and recreate it. Had it been any other column, we could have used ALTER syntax to add a column like shown below: ALTER EXTERNAL TABLE name action [, ... ] where action is one of: ADD [COLUMN] column_name type DROP [COLUMN] column ALTER [COLUMN] column TYPE type [USING expression] OWNER TO new_owner

upvoted 5 times

...

OldSchool

2 years, 1 month ago

C is Correct

upvoted 1 times

...

Selma97

2 years, 1 month ago

I still can't understand why it's not D.

upvoted 1 times

anto69

2 years ago

ALTER statement is not supported on external table, you need to DROP it and CREATE it again

upvoted 10 times

...

Deeksha1234

2 years, 4 months ago

correct

upvoted 2 times

...

dsp17

2 years, 5 months ago

C is correct. Even if you are confuse with other options. The clue here is keyword Location while creating external table, LOCATION = 'folder_or_filepath' : Specifies the folder or the file path and file name for the actual data.

upvoted 2 times

...

Ozren

2 years, 9 months ago

Good thing the details are shown here: "The external table has three columns." And the solution yet reveals the column details. This doesn't make any sense to me. If C is the correct answer (only one that seems acceptable), then the question itself is flawed.

upvoted 2 times

dduque10

2 years, 1 month ago

The external table has 3 columns, but the files it references has 4 columns, so the external table has to be altered

upvoted 2 times

...

PallaviPatel

2 years, 11 months ago

c is correct.

upvoted 1 times

...

hugoborda

3 years, 3 months ago

Answer is correct

upvoted 2 times

...