DP-203 · Question #308
You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named account1 and an Azure Synapse Analytics workspace named workspace1. You need to create an external table in…
The correct answer is A. Use a native external table and authenticate by using a shared access signature (SAS). Serverless SQL Pools cannot use Hadoop, Only Native. Access Key Auth is never best practice therefore leaving only A as a viable answer. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external- tables?tabs=hadoop
Question
You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named account1 and an Azure Synapse Analytics workspace named workspace1. You need to create an external table in a serverless SQL pool in workspace1. The external table will reference CSV files stored in account1. The solution must maximize performance. How should you configure the external table?
Options
- AUse a native external table and authenticate by using a shared access signature (SAS).
- BUse a native external table and authenticate by using a storage account key.
- CUse an Apache Hadoop external table and authenticate by using a shared access signature
- DUse an Apache Hadoop external table and authenticate by using a service principal in Microsoft
How the community answered
(35 responses)- A77% (27)
- B6% (2)
- C3% (1)
- D14% (5)
Explanation
Serverless SQL Pools cannot use Hadoop, Only Native. Access Key Auth is never best practice therefore leaving only A as a viable answer. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external- tables?tabs=hadoop
Topics
Community Discussion
No community discussion yet for this question.