Hotspot 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…

Question

Exhibit

Answer Area

• Location hostname partdfs
  blobdfstable
• Data source type optionTYPE = HADOOP
  PUSHDOWN = ONTYPE = BLOB_STORAGETYPE = HADOOP

Explanation

This question tests knowledge of creating an EXTERNAL DATA SOURCE in Azure Synapse Analytics dedicated SQL pool to reference Azure Data Lake Storage Gen2 for PolyBase or external table access. The correct T-SQL syntax requires specifying the correct TYPE and LOCATION parameters.

Approach. The correct T-SQL statement is: CREATE EXTERNAL DATA SOURCE [DataSourceName] WITH (TYPE = HADOOP, LOCATION = 'abfss://[email protected]', CREDENTIAL = [credential_name]). TYPE must be set to 'HADOOP' because Azure Synapse dedicated SQL pools use PolyBase which requires HADOOP as the data source type even for ADLS Gen2. The LOCATION must use the 'abfss://' (Azure Blob File System Secure) URI scheme for ADLS Gen2, formatted as 'abfss://<container>@<account>.dfs.core.windows.net'. Using 'wasbs://' is for older Azure Blob Storage, and 'https://' is used in serverless SQL pools, not dedicated pools. A CREDENTIAL referencing a database-scoped credential or managed identity may also be required for authentication.

Concept tested. Creating an EXTERNAL DATA SOURCE in Azure Synapse Analytics dedicated SQL pool using PolyBase syntax, including the correct TYPE (HADOOP) and LOCATION URI format (abfss://) for Azure Data Lake Storage Gen2 connectivity.

Reference. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop

No community discussion yet for this question.