DP-203 Question #177: Real Exam Question with Answer & Explanation

Question

Drag and Drop Question You are responsible for providing access to an Azure Data Lake Storage Gen2 account. Your user account has contributor access to the storage account, and you have the application ID and access key. You plan to use PolyBase to load data into an enterprise data warehouse in Azure Synapse Analytics. You need to configure PolyBase to connect the data warehouse to storage account. Which three components should you create in sequence? To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order. Answer:

Explanation

To configure PolyBase to connect Azure Synapse Analytics to an Azure Data Lake Storage Gen2 account, you must first create a database scoped credential to securely store the storage account credentials (application ID and access key or managed identity). Next, you create an external data source that references the credential and points to the ADLS Gen2 location. Finally, you create an external file format to define the structure and format (e.g., Parquet, CSV, ORC) of the files to be loaded - this sequence is mandatory as each object depends on the prior one.

No community discussion yet for this question.