ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 2 question 46 discussion

Actual exam question from Microsoft's DP-203
Question #: 46
Topic #: 2
[All DP-203 Questions]

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:

Show Suggested Answer Hide Answer
Suggested 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
by alexleonvalencia at Dec. 10, 2021, 2:10 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
alexleonvalencia
Highly Voted 3 years, 6 months ago
1.- A database scoped credential 2.- an External data sorce 3.- a external file format
upvoted 216 times
Franz58
2 years, 11 months ago
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
upvoted 21 times
Dusica
1 year, 2 months ago
don't need encription ke
upvoted 1 times
...
DiscussoR
2 years, 3 months ago
File format is not related to a specific file
upvoted 1 times
...
auwia
2 years ago
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".
upvoted 5 times
...
...
Unessoo
6 months, 1 week ago
the correct order is: an asymmetric key a database scoped credential an external data source an external file format
upvoted 1 times
...
Bilal2
2 years, 5 months ago
agreed. https://www.sqlshack.com/sql-server-polybase-external-tables-with-azure-blob-storage/
upvoted 2 times
learnwell
1 year ago
Thank you for the link, explains it very well.
upvoted 1 times
...
...
DiscussoR
2 years, 3 months ago
Agree: https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-t-sql-objects?view=sql-server-ver16#create-external-tables-for-hadoop
upvoted 3 times
...
...
engrbrain
Highly Voted 3 years, 5 months ago
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
upvoted 56 times
vanrell
3 years, 3 months ago
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?
upvoted 4 times
sdokmak
3 years, 1 month ago
access key is for storage account so you still need a master/asymmetric key for the database.
upvoted 4 times
sdokmak
3 years, 1 month ago
*sorry, not asymmetric
upvoted 3 times
...
...
...
kamil_k
3 years, 3 months ago
Btw yes even in the description it says that the master key is a symmetric key, not an asymmetric one. It
upvoted 2 times
...
kamil_k
3 years, 3 months ago
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
upvoted 3 times
...
...
sachin_mt
Most Recent 3 months, 1 week ago
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
upvoted 1 times
...
aeab260
4 months, 2 weeks ago
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
upvoted 1 times
...
renan_ineu
9 months, 1 week ago
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
upvoted 3 times
...
evangelist
11 months, 3 weeks ago
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.
upvoted 2 times
...
evangelist
12 months ago
the correct order for the components is: A database scoped credential An external data source An external file format
upvoted 2 times
...
Azure_2023
1 year, 4 months ago
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.
upvoted 3 times
...
jongert
1 year, 6 months ago
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
upvoted 1 times
...
6d954df
1 year, 6 months ago
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
upvoted 1 times
lola_mary5
1 year, 4 months ago
This links also mentions a 4th step: create external file format, that doesn't fit in the number of asked answers.
upvoted 1 times
...
...
Momoanwar
1 year, 6 months ago
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.
upvoted 5 times
...
abhijeetbgmcanada
1 year, 7 months ago
Seems like answers are differing. Do we get partial points if answer is partially correct ?
upvoted 2 times
...
ellala
1 year, 8 months ago
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)
upvoted 2 times
...
oturbo
1 year, 9 months ago
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
upvoted 1 times
...
kkk5566
1 year, 9 months ago
1.- A database scoped credential 2.- an External data sorce 3.- a external file format
upvoted 2 times
...
[Removed]
1 year, 10 months ago
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
upvoted 2 times
...
mcwest002
1 year, 11 months ago
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
upvoted 2 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel