DP-203 Azure Data Engineer Associate Azure Synapse Analytics 3

Question 1

What is the purpose of workload management in Azure Synapse Analytics dedicated SQL pools?

Accepted Answer

Allocating and isolating compute resources for different user groups to enforce query SLAs

Answer

Scheduling Synapse pipeline trigger runs by time

Answer

Managing autoscaling of Apache Spark cluster nodes

Answer

Controlling data-level access permissions for external tables

Question 2

In Azure Synapse Analytics dedicated SQL pools, which T-SQL object must be created first to define the location and authentication for an external data source like Azure Data Lake Storage Gen2?

Accepted Answer

EXTERNAL DATA SOURCE

Answer

DATABASE SCOPED CREDENTIAL

Answer

EXTERNAL FILE FORMAT

Answer

EXTERNAL TABLE

Question 3

What feature of Azure Synapse Analytics dedicated SQL pools allows organizations to stop compute charges during periods of inactivity without losing data?

Accepted Answer

Pause and resume

Answer

Autoscale down to DW100c

Answer

Serverless fallback mode

Answer

Elastic pool consolidation

Question 4

What is Azure Synapse Studio?

Accepted Answer

A web-based unified IDE for SQL development, Spark notebooks, pipeline authoring, and monitoring

Answer

A command-line tool for deploying ARM templates to Synapse workspaces

Answer

A desktop application for managing Azure subscription costs

Answer

A dedicated tool for configuring Synapse network security and private endpoints

Question 5

Which Azure Synapse Analytics component enables federated queries that join data from Azure Data Lake Storage, Cosmos DB, and other sources without physically moving the data?

Accepted Answer

Serverless SQL pool with OPENROWSET or external tables

Answer

Dedicated SQL pool with external tables

Answer

Apache Spark pool with cross-source dataframes

Answer

Synapse Link multi-source federation

Question 6

What happens to data stored in an Azure Synapse Analytics dedicated SQL pool when the pool is paused?

Accepted Answer

Data remains intact in Azure Storage and is fully preserved

Answer

Data is archived to Azure Blob cold storage tier

Answer

Data is temporarily deleted and restored on resume

Answer

Data is compressed into a backup snapshot and held offline

Question 7

Which distribution strategy should you choose for a small lookup table under 2 GB that is frequently joined with large distributed fact tables in Azure Synapse dedicated SQL pools?

Accepted Answer

REPLICATE distribution to cache the table on every compute node

Answer

HASH distribution on the join key column

Answer

ROUND_ROBIN distribution for uniform load

Answer

PARTITION BY date to align with the fact table partition