Exam DP-203 topic 2 question 46 discussion

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

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

It is Database Master key required and not Database Encryption Key and hence it is not aprt of answer even though we need Database Master key to be created before loding into Dedicated SQL pool

1.- A database scoped credential 2.- an External data sorce 3.- a external file format A database encryption key is required before a database can be encrypted by using transparent data encryption (TDE). See https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-encryption-key-transact-sql?view=sql-server-ver16 Asymmetric keys are not compatiable with dedicated SQL pools (formerly SQL DW). https://learn.microsoft.com/en-us/sql/t-sql/statements/create-asymmetric-key-transact-sql?view=sql-server-ver16

Answer: 1. DB scoped credential 2. External data source 3. External file format Docs: MASTER [symmetric] KEY w/ PASSWORD (seams optional: see link 2; is symmetric: see link 3) > DATABASE SCOPED CREDENTIAL w/ IDENTITY and SECRET key > EXTERNAL DATA SOURCE w/ TYPE, LOCATION, CREDENTIAL > EXTERNAL FILE w/ TYPE and OPTIONS > TERMINATOR > EXTERNAL TABLE w/ DATA_SOURCE and LOCATION https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-sql-server?view=sql-server-ver16#configure-a-sql-server-external-data-source https://learn.microsoft.com/en-us/sql/t-sql/statements/create-master-key-transact-sql?view=sql-server-ver16#remarks https://learn.microsoft.com/en-us/sql/t-sql/statements/open-master-key-transact-sql?view=sql-server-ver16#remarks

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.

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

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.

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

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

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.

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

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)

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

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

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

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