DP-203 Azure Data Engineer Associate Azure Synapse Analytics 2

Question 1

What is the primary purpose of Azure Synapse Link for Azure Cosmos DB?

Accepted Answer

Enabling near real-time analytics on operational Cosmos DB data without ETL pipelines

Answer

Migrating Cosmos DB data permanently to Azure SQL Database

Answer

Backing up Cosmos DB containers to Azure Blob Storage

Answer

Replicating Cosmos DB data across Azure regions for disaster recovery

Question 2

Which file format is NOT natively supported by Azure Synapse Analytics serverless SQL pools for querying data in Azure Data Lake Storage?

Accepted Answer

Avro

Answer

Parquet

Answer

CSV

Answer

JSON

Question 3

What is the primary use case for Apache Spark pools in Azure Synapse Analytics?

Accepted Answer

Running distributed data processing, transformation, and machine learning workloads

Answer

Running T-SQL queries against dedicated SQL pool tables

Answer

Providing serverless on-demand SQL queries for data exploration

Answer

Managing and scheduling Synapse pipeline activities

Question 4

What does the Delta Lake format primarily provide when used in Azure Synapse Analytics?

Accepted Answer

ACID transactions, schema enforcement, and time travel on data lake storage

Answer

Compressing Parquet files to reduce storage costs

Answer

Real-time streaming ingestion from Azure Event Hubs

Answer

Metadata storage for external table definitions

Question 5

What connector allows Apache Spark pools in Azure Synapse Analytics to efficiently read from and write to dedicated SQL pools?

Accepted Answer

Synapse Spark connector (azure-synapse-spark-connector)

Answer

Azure Data Factory mapping dataflow

Answer

PolyBase over JDBC

Answer

Azure Synapse Link

Question 6

Which approach best optimizes query performance in Azure Synapse Analytics serverless SQL pools?

Accepted Answer

Using Parquet format with folder partitioning and creating table statistics

Answer

Creating clustered columnstore indexes on external tables

Answer

Scaling up DWUs to increase compute nodes

Answer

Enabling result-set caching on the serverless endpoint

Question 7

Which Azure Synapse dedicated SQL pool feature stores query results so that subsequent identical queries return instantly without re-execution?

Accepted Answer

Result-set caching

Answer

Materialized views

Answer

Workload management queuing

Answer

Columnstore segment elimination