Which two statements should you execute?

You have a Microsoft Azure SQL data warehouse. The following statements are used to define file formats in the data warehouse.

You have an external PolyBase table named file.factPowerMeasurement that uses the FileFormat_ORC file format You need to change file_ factPowerMeasurement to use the FileFormaLPARQUET file format.
Which two statements should you execute? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. CREATE EXTERNAL TABLE
B. ALTER TABLE
C. CREATE EXTERNAL TABLE AS SELECT
D. ALTER EXTERNAL DATA SOURCE
E. DROP EXTERNAL TABLE

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.