DP-203 Question #124: Real Exam Question with Answer & Explanation

Question

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.

Options

• AALTER EXTERNAL TABLE [Ext].[Items] ADD [ItemID] int;
• BDROP EXTERNAL FILE FORMAT parquetfile1; CREATE EXTERNAL FILE FORMAT parquetfile1 WITH ( FORMAT_TYPE = PARQUET, DATA_COMPRESSION = 'org.apache.hadoop.io.compress.SnappyCodec' );
• CDROP EXTERNAL TABLE [Ext].[Items] CREATE EXTERNAL TABLE [Ext].[Items] ([ItemID] [int] NULL, [ItemName] nvarchar(50) NULL, [ItemType] nvarchar(20) NULL, [ItemDescription] nvarchar(250)) WITH ( LOCATION= '/Items/', DATA_SOURCE = AzureDataLakeStore, FILE_FORMAT = PARQUET, REJECT_TYPE = VALUE, REJECT_VALUE = 0 );
• DALTER TABLE [Ext].[Items] ADD [ItemID] int;