Question
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1.
You plan to access the files in Account1 by using an external table.
You need to create a data source in Pool1 that you can reference when you create the external table.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
```sql
CREATE EXTERNAL DATA SOURCE source1
WITH
( LOCATION = 'https://account1.[Dropdown 1].core.windows.net',
[Dropdown 2]
)
```
Explanation
Dropdown 1: dfs is the Data Lake Storage Gen2 endpoint, written as storage_account.dfs.core.windows.net in the location path. The blob endpoint belongs to the Azure Blob Storage entries, and table is a different storage service.
Dropdown 2: TYPE = HADOOP is the type accepted by a dedicated SQL pool for an external data source, and it uses PolyBase to read the files through an external table. TYPE = BLOB_STORAGE is for bulk operations in SQL Server rather than for external tables, and it is not in the dedicated SQL pool syntax. PUSHDOWN = ON is not part of that syntax either.
