PrepAway - Latest Free Exam Questions & Answers

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

PrepAway - Latest Free Exam Questions & Answers

A.
CREATE EXTERNAL TABLE

B.
ALTER TABLE

C.
CREATE EXTERNAL TABLE AS SELECT

D.
ALTER EXTERNAL DATA SOURCE

E.
DROP EXTERNAL TABLE

2 Comments on “Which two statements should you execute?


Leave a Reply