DP-203 Azure Data Engineer Associate Azure Synapse Analytics

Question 1

How many distributions does an Azure Synapse Analytics dedicated SQL pool use to spread data across compute nodes?

Accepted Answer

60

Answer

30

Answer

90

Answer

120

Question 2

Which table distribution type in an Azure Synapse dedicated SQL pool is best for large fact tables that are frequently joined on a specific column?

Accepted Answer

HASH

Answer

ROUND_ROBIN

Answer

REPLICATE

Answer

PARTITION

Question 3

Which index type in Azure Synapse dedicated SQL pools provides the best compression and performance for large-scale analytical queries?

Accepted Answer

Clustered columnstore index

Answer

Rowstore clustered index

Answer

Heap

Answer

Nonclustered rowstore index

Question 4

What is the primary purpose of an Azure Synapse workspace?

Accepted Answer

Providing a unified collaboration environment integrating SQL, Spark, pipelines, and analytics

Answer

Storing raw data in Azure Data Lake Storage only

Answer

Running Apache Spark workloads exclusively

Answer

Managing Azure Data Factory pipelines only

Question 5

What is the main advantage of using REPLICATE table distribution in Azure Synapse dedicated SQL pools?

Accepted Answer

Copies the full table to each compute node, eliminating data movement during joins

Answer

Distributes rows evenly across all 60 distributions for balanced loading

Answer

Partitions data by date for faster time-range queries

Answer

Enables row-level security for sensitive dimension tables

Question 6

In Azure Synapse Analytics dedicated SQL pools, what does the service objective (e.g., DW1000c) control?

Accepted Answer

The number of Data Warehouse Units (DWUs) and compute power allocated

Answer

The number of storage accounts attached to the pool

Answer

The version of SQL Server engine used internally

Answer

The maximum number of concurrent users allowed

Question 7

Which feature in Azure Synapse Analytics allows SQL queries to access data stored in Azure Data Lake Storage Gen2 without loading it into a dedicated SQL pool?

Accepted Answer

External tables with PolyBase

Answer

Azure Synapse Link

Answer

Azure Data Factory Copy activity

Answer

Spark dataframe connector