Microsoft
70-776 · Question #11
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…
The correct answer is A. CREATE EXTERNAL TABLE E. DROP EXTERNAL TABLE. See the full explanation below for the reasoning.
Question
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.
Exhibit
Options
- ACREATE EXTERNAL TABLE
- BALTER TABLE
- CCREATE EXTERNAL TABLE AS SELECT
- DALTER EXTERNAL DATA SOURCE
- EDROP EXTERNAL TABLE
How the community answered
(42 responses)- A76% (32)
- B7% (3)
- C14% (6)
- D2% (1)
Community Discussion
No community discussion yet for this question.