DP-203 Practice Test 10 — 10 Questions

Question 1

A company uses Azure Databricks for data processing. They want to monitor the performance of Spark jobs and set up alerts for job failures. Which Azure service should they use?

Accepted Answer

Azure Monitor. Azure Monitor is the central service for collecting metrics and logs from Azure Databricks, enabling performance monitoring and alerting on Spark jobs. Option A is incorrect because Azure Advisor provides recommendations but not real-time monitoring or alerts. Option B is incorrect because Azure Sentinel is a SIEM solution for security incidents, not for job performance monitoring. Option C is incorrect because Azure Log Analytics is a component of Azure Monitor used for log analysis, but the overarching service for monitoring and alerts is Azure Monitor.

Answer

Azure Advisor

Answer

Azure Sentinel

Answer

Azure Log Analytics

Question 2

Your Azure Data Factory pipeline uses a Copy activity to load data from an on-premises SQL Server to Azure Blob Storage. You notice that the pipeline is running slower than expected. You need to identify the bottleneck. Which Data Factory monitoring metric should you analyze first?

Accepted Answer

Data Integration Unit (DIU) consumption. Data Integration Unit (DIU) consumption indicates whether the Copy activity is resource-bound and helps identify performance bottlenecks. Option A is wrong because source queue length reflects integration runtime queue depth, not a direct metric for Copy activity throughput. Option B is wrong because pipeline duration is a result of performance issues, not a metric to pinpoint the bottleneck first. Option C is wrong because activity run count is unrelated to performance analysis.

Answer

Source queue length

Answer

Pipeline duration

Answer

Activity run count

Question 3

You are tasked with designing a data storage solution for a social media analytics company. They need to store user profile data (JSON) and social media posts (text and images). The data is used for machine learning models that require fast random access to individual user profiles and the ability to run analytical queries over posts. The solution must provide low-latency reads for user profiles (milliseconds) and support for large-scale analytics on posts. Which combination of Azure data services should you recommend?

Accepted Answer

Azure Cosmos DB for user profiles and Azure Data Lake Storage Gen2 for posts. Azure Cosmos DB provides low-latency (millisecond) reads for user profiles via its indexing and partitioning capabilities, ideal for fast random access. Azure Data Lake Storage Gen2 (ADLS Gen2) combines a hierarchical namespace with Blob Storage, enabling large-scale analytical queries on posts using tools like Azure Synapse Analytics or Spark, while efficiently storing text and images.

Answer

Azure Cosmos DB for both user profiles and posts

Answer

Azure SQL Database for both user profiles and posts

Answer

Azure Table Storage for user profiles and Azure Blob Storage for posts

Question 4

You are designing a data pipeline in Azure Synapse Analytics to ingest data from Azure Blob Storage into a dedicated SQL pool. The source files are CSV with varying row lengths, and you need to ensure optimal performance for reads. Which file format and compression should you recommend?

Accepted Answer

Parquet with Snappy compression. Parquet with Snappy compression is optimal for dedicated SQL pools in Azure Synapse Analytics because Parquet is a columnar format that enables efficient predicate pushdown and column pruning, reducing I/O. Snappy provides fast compression/decompression with minimal CPU overhead, which is critical for high-throughput reads in a distributed MPP environment.

Answer

Avro with Deflate compression

Answer

CSV with Gzip compression

Answer

ORC with Zlib compression

Question 5

Which TWO actions should you take to secure data in transit between an Azure Synapse Analytics serverless SQL pool and a client application?

Accepted Answer

Configure the serverless SQL pool to enforce TLS 1.2 connections.. The correct answers are B and C. Enforcing TLS 1.2 ensures encryption in transit using a modern, secure protocol (B). Using Azure Virtual Network service endpoints for the SQL pool keeps traffic within the Azure backbone network, adding a layer of network security (C). Option A (Azure RBAC) controls authentication and authorization, not encryption. Option D (disable SSL) would expose data in transit. Option E (ExpressRoute) provides private connectivity but does not inherently encrypt data; it's more for network isolation.

Answer

Use Azure RBAC to restrict access to the SQL pool.

Answer

Disable SSL encryption to reduce latency.

Answer

Use Azure ExpressRoute to connect to the SQL pool.

Question 6

A company uses Azure Synapse Analytics dedicated SQL pool. They notice that queries against a large fact table are slow. They have already created statistics on all columns used in WHERE clauses and JOIN predicates. What should they do next to improve query performance?

Accepted Answer

Partition the table on a frequently filtered column.. Partitioning on a frequently filtered column enables partition elimination, reducing the amount of data scanned and improving query performance. Option A (result-set caching) caches query results for repeated queries, but this question is about slow queries on a large fact table, not repeated queries. Option B (increasing DWU) might improve performance by providing more resources, but it is a more costly approach and not the best first step; partitioning is a better design optimization. Option C (creating additional statistics on all columns) is unnecessary because they already have statistics on columns used in WHERE and JOIN; statistics on all columns would waste resources and not help.

Answer

Enable result-set caching.

Answer

Increase the DWU setting for the dedicated SQL pool.

Answer

Create additional statistics on all columns.

Question 7

Refer to the exhibit. You run the Kusto query in Azure Monitor Logs to analyze Data Factory pipeline runs. What is the purpose of this query?

Accepted Answer

Identify pipelines with the most failed activity runs per hour. The query filters pipeline runs with a status of 'Failed', groups them by pipeline name and hourly time bins, then counts the number of failed activity runs per hour. The results are sorted descending by count, making it easy to identify which pipelines have the most failed activity runs per hour. Therefore, option B is correct. Option A is incorrect because the query only includes failed runs, not all runs. Option C is incorrect because the query counts runs, not calculates duration. Option D is incorrect because the query filters on pipeline runs, not trigger runs.

Answer

List all pipeline runs regardless of status

Answer

Calculate the average duration of failed pipeline runs

Answer

Show the number of failed trigger runs per hour

Question 8

You are designing a data ingestion pipeline for Azure Synapse Analytics. The pipeline will load sensitive financial data from an on-premises SQL Server to a dedicated SQL pool. The data must be encrypted at rest and in transit. Which combination of features should you use?

Accepted Answer

Use Azure Synapse Transparent Data Encryption (TDE) and enforce TLS 1.2 for connections.. Transparent Data Encryption (TDE) encrypts data at rest in the dedicated SQL pool, and enforcing TLS 1.2 ensures encryption in transit. Option A is wrong because Always Encrypted is for column-level encryption, not for the entire pipeline. Option B is wrong because Azure Disk Encryption is for IaaS VMs, not for Azure Synapse. Option C is wrong because client-side encryption is not built-in for Synapse ingestion.

Answer

Use Always Encrypted in SQL Server and Azure Key Vault for column encryption.

Answer

Enable Azure Disk Encryption on the source server and use a VPN gateway.

Answer

Implement client-side encryption using Azure Storage client library and store keys in Microsoft Purview.

Question 9

You have an Azure Data Lake Storage Gen2 account that stores log files. You need to implement a data retention policy so that logs older than 90 days are automatically deleted. What should you use?

Accepted Answer

Lifecycle management policy. A lifecycle management policy can automatically delete blobs based on age. Option A is wrong because Azure Policy enforces compliance but does not delete. Option C is wrong because Azure Blob Storage inventory provides reports but does not delete. Option D is wrong because Azure Purview scopes metadata and data discovery, not lifecycle management.

Answer

Azure Policy

Answer

Azure Blob Storage inventory

Answer

Microsoft Purview

Question 10

You have an Azure Databricks workspace with a cluster that uses a Standard_LRS managed disk. You need to ensure that data at rest is encrypted using a customer-managed key (CMK). What should you configure?

Accepted Answer

Enable double encryption with a customer-managed key in Azure Disk Encryption. Azure Databricks managed disks support double encryption with a customer-managed key (CMK) using Azure Disk Encryption. This provides two layers of encryption: server-side encryption with a platform-managed key and additional encryption with a customer-managed key. Option A (Azure Storage Service Encryption) applies to Azure Storage accounts, not to Azure Databricks managed disks. Option C (TDE) is for Azure SQL Database. Option D (Azure Purview) is a data governance service, not an encryption solution.

Answer

Configure Azure Storage Service Encryption with a customer-managed key

Answer

Enable Transparent Data Encryption (TDE) in Azure SQL Database

Answer

Use Azure Purview to classify and encrypt data