Exam DP-203 topic 1 question 44 discussion

1) create database scoped credentials 2) create external source 3) create file format 4) create external table (it not supports CTAS)

Because it's saying "You have data stored in thousands of CSV files in Azure Data Lake Storage Gen2" and "You are implementing a pattern that batch loads the files daily into a dedicated SQL pool in Azure Synapse Analytics by using PolyBase" assumption is that we already have database credentials, so the answer is: 1) create external source 2) create file format 3) create external table

1) create database scoped credentials 2) create external source 3) create file format

The provided answer is correct. 1) source 2) file format 3) CETAS - this is dedicated SQL Pool. So, it is preferred. While external table is the only option for SERVERLESS SQL Pool... https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=azure-sqldw-latest&tabs=powershell#examples

The correct answer are : 1) create database scoped credentials 2) create external source 3) create file format Why ? : Focus on this below statement in question. Before building the loading pattern, you need to prepare the required database objects in Azure Synapse Analytics. Explanation: You just need to specify about prerequisite database object ( Not Loading pattern which is about Creating External Table )

I think the answer (A, B, D) is very clearly explained on this page: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables

I believe the only reason why "create database scoped credential" is not a right answer is because it should be a managed identity instead of a service principal. Service principals are used for applications outside of the Azure Environment (such as SQL Server, as some comments here refer to SQL Server documentation). But since we are using Synapse Analytics environment, we use managed identities. Check the link: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=azure-sqldw-latest&preserve-view=true&tabs=powershell#g-use-create-external-table-as-select-with-a-view-as-the-source And if you want to compare to SQL Server documentation, where indeed they use Service principal keys (which is not the situation we are given in this question): 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

The provided Answer is correct check yourself, goto F section in the following link https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=azure-sqldw-latest&tabs=powershell#examples

Before building the loading pattern, you need to prepare the required database objects in Azure Synapse Analytics - Loading pattern is CETAS, so answer DSC DS EFF

source ,format ,external

The answer is correct, - Create database scoped credential: "This step is required only for Kerberos-secured Hadoop clusters." In this case, the previous step does not apply.

1. Create database scoped credential 2. Create external data source 3. Create external file format https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-t-sql-objects?view=sql-server-ver16#create-external-tables-for-azure-blob-storage

the given answer is correct imo; "'PolyBase loads can be run using CTAS or INSERT INTO. CTAS will minimize transaction logging and is the fastest way to load your data. "' https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool#use-polybase-to-load-and-export-data-quickly

When using serverless SQL pool, CETAS is used to create an external table and export query results to Azure Storage Blob or Azure Data Lake Storage Gen2 and we need to implement a pattern that batch loads the files daily into a dedicated SQL pool in Azure Synapse Analytics, so: 1) create database scoped credentials 2) create external source 3) create file format

In this question clearly stating that, "Before building the loading pattern, you need to prepare the required database objects" So Database objects list 1) Data Source 2) Data File Format 3) Table ( need to set up skip the header row) My Answer is 1) Create external source; 2) Create File Format ; 3) Create External Table

CTAS for external table is to write the result of the query (select) in a destination folder. So the good answer for this question is : ) create database scoped credentials 2) create external source 3) create file format

Should be - 1) create database scoped credentials 2) create external source 3) create file format As per https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-t-sql-objects?view=sql-server-ver16 - Check under : Create external tables for Azure Blob Storage - CTAS is not an option