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