Examice

Exam DP-203 All QuestionsBrowse all questions from this exam

Question 160

DRAG DROP -

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.

Select and Place:

Correct Answer:

Step 1: an asymmetric key -

A master key should be created only once in a database. The Database Master Key is a symmetric key used to protect the private keys of certificates and asymmetric keys in the database.

Step 2: a database scoped credential

Create a Database Scoped Credential. A Database Scoped Credential is a record that contains the authentication information required to connect an external resource. The master key needs to be created first before creating the database scoped credential.

Step 3: an external data source -

Create an External Data Source. External data sources are used to establish connectivity for data loading using Polybase.

Reference:

https://www.sqlservercentral.com/articles/access-external-data-from-azure-synapse-analytics-using-polybase

Discussion

alexleonvalencia

1.- A database scoped credential 2.- an External data sorce 3.- a external file format

Franz58

you need to connect to the DW, not to a specific file. Therefore : 1- Create a Database Encryption Key 2 - Create a Database Scoped Credential 3 - Create an External Data Source

DiscussoR

File format is not related to a specific file

auwia

It should be: "Create a Master Key" not 'DataBase Encryption Key' if you are trying to findout a predecessor step before "create a Database Scoped Credential".

Dusica

don't need encription ke

Bilal2

agreed. https://www.sqlshack.com/sql-server-polybase-external-tables-with-azure-blob-storage/

learnwell

Thank you for the link, explains it very well.

DiscussoR

Agree: https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-t-sql-objects?view=sql-server-ver16#create-external-tables-for-hadoop

engrbrain

According to the documentation, the first thing you are to create is CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'S0me!nfo'; I don't think this is means an asymmetric key. It is simply a database encryption key. So I think the answer is 1- Create a Database Encryption Key 2 - Create a Database Scoped Credential 3 - Create an External Data Source

kamil_k

also, the question only mentions storage account in general not a file or folder, so I believe we don't need to go as far as creating file format anyway

kamil_k

Btw yes even in the description it says that the master key is a symmetric key, not an asymmetric one. It

vanrell

Does the text not say you already have an access key? Should the correct answer not be 1.- A database scoped credential 2.- an External data sorce 3.- a external file format as alex mentions?

sdokmak

access key is for storage account so you still need a master/asymmetric key for the database.

sdokmak

*sorry, not asymmetric

Momoanwar

Chatgpt : To configure PolyBase to connect an Azure Synapse Analytics data warehouse to an Azure Data Lake Storage Gen2 account, you need to create: 1. **A database scoped credential**: This stores the necessary authentication to access the data lake, such as the storage account access key. 2. **An external data source**: This defines the location of the data in the storage account and uses the scoped credential for authentication. 3. **An external file format**: This specifies the format of the data files (e.g., CSV, Parquet) in the data lake so that PolyBase knows how to parse the data. These components should be created in the sequence listed above to ensure that PolyBase has the information it needs to authenticate, locate, and read the data from the storage account.

Azure_2023

Database Scoped Credential: This comes first as it holds the secure credentials needed for authentication. External Data Source: This relies on the credential to define the connection to the storage account. External File Format (Optional): This step further enhances performance and efficiency by informing PolyBase of the data format.

evangelist

the correct order for the components is: A database scoped credential An external data source An external file format

abhijeetbgmcanada

Seems like answers are differing. Do we get partial points if answer is partially correct ?

ellala

The database master key is a SYMMETRIC KEY (https://learn.microsoft.com/en-us/sql/t-sql/statements/create-master-key-transact-sql?view=sql-server-ver16#remarks) therefore the answer should be: 1- Create a Database Encryption Key (CREATE MASTER KEY ENCRYPTION BY PASSWORD) 2 - Create a Database Scoped Credential (CREATE DATABASE SCOPED CREDENTIAL) 3 - Create an External Data Source (CREATE EXTERNAL DATA SOURCE) (https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-t-sql-objects?view=sql-server-ver16#1-create-database-scoped-credential)

kkk5566

1.- A database scoped credential 2.- an External data sorce 3.- a external file format

Ram9198

1.A database scoped credential 2.an External data source 3 a external file format Create master key is an symmetric key https://learn.microsoft.com/en-us/sql/t-sql/statements/create-master-key-transact-sql?view=sql-server-ver16 DEK comes under the concept of azure SQL TDE and no way related to this question Hence proved

mcwest002

Create external tables for Azure Data Lake Store From <https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-t-sql-objects?view=sql-server-ver16#create-external-tables-for-azure-data-lake-store> 1. Create database scoped credential 2. Create external data source to reference Azure Data Lake Store (ADLS) 3. Create external file format

DipikaChavan

1.A database scoped credential 2.an External data source 3 a external file format

evangelist

A database scoped credential: This is needed to authenticate and access the storage account. An external data source: This defines the location of the data source using the database scoped credential. An external file format: This specifies the format of the data files (e.g., CSV, Parquet) in the data lake.

jongert

Given answer appears correct. This section specifies we need the master key (which is an asymmetric key), then create the scoped credential. The scoped credential can finally be used to create an external data source. https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-scoped-credential-transact-sql?view=sql-server-ver16#c-creating-a-database-scoped-credential-for-polybase-connectivity-to-azure-data-lake-store

6d954df

check this out, the answers provided are correct https://learn.microsoft.com/en-us/sql/analytics-platform-system/polybase-configure-azure-blob-storage?view=aps-pdw-2016-au7

lola_mary5

This links also mentions a 4th step: create external file format, that doesn't fit in the number of asked answers.

oturbo

CREATE MASTER KEY; -- SECRET: Provide your Azure storage account key. CREATE DATABASE SCOPED CREDENTIAL AzureStorageCredential WITH IDENTITY = 'user', SECRET = '<azure_storage_account_key>' ; CREATE EXTERNAL DATA SOURCE AzureStorage WITH ( TYPE = HADOOP, LOCATION = 'wasbs://<blob_container_name>@<azure_storage_account_name>.blob.core.windows.net', CREDENTIAL = AzureStorageCredential ); https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-load-from-azure-blob-storage-with-polybase

rocky48

1.- A database scoped credential 2.- an External data sorce 3.- a external file format

Rossana

Create an external data source (C) that specifies the location of the data in the storage account. Create an external file format (E) that describes the format of the data in the external data source. Create a database scoped credential (A) that contains the credentials needed to access the storage account. Note that asymmetric keys and database encryption keys are not required for configuring PolyBase with Azure Data Lake Storage Gen2.