Does the solution meet the goal?

Load the data using the INSERT…SELECT statement

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

View Answer

Answer: B

Explanation:

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

You then 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