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

Posted by: Pdfprep Category: DP-200 Tags: , ,

You have an Azure SQL data warehouse.

Using PolyBase, you create 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 . Option A
B . Option B
C . Option C
D . Option D

Answer: A

Explanation:

Incorrect Answers: B, 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

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql

Leave a Reply

Your email address will not be published.