Data Engineering on Microsoft Azure — Question 47

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?

Answer options

• A. Use a native external table and authenticate by using a shared access signature (SAS).
• B. Use a native external table and authenticate by using a storage account key.
• C. Use an Apache Hadoop external table and authenticate by using a shared access signature (SAS).
• D. Use an Apache Hadoop external table and authenticate by using a service principal in Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra.

Correct answer: A

Explanation

The correct option is A because using a native external table with a shared access signature (SAS) provides a secure and performant way to access Azure Data Lake Storage Gen2 data. Option B is less secure compared to SAS, while options C and D involve Apache Hadoop external tables, which are not necessary in this context and may introduce additional complexity.