Does the solution meet the goal?

Load the data using the CREATE TABLE AS SELECT statement

Does the solution meet the goal?
A . Yes
B . No

View Answer

Answer: A

Explanation:

It is not necessary to convert the parquet files to CSV files.

You need to create an external file format and external table using the external data source.

You load the data using the CREATE TABLE AS SELECT statement.

References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lake-store