DP-200 Test 1

Question 1

You have an Azure Data Factory pipeline that loads source data into an Azure Data Lake Storage Gen2 account incrementally.

The source table's LastUpdatedDate column identifies the data to be loaded.

Every four hours, you intend to run the pipeline.

You must make certain that the pipeline's execution fits the following criteria:

When a pipeline run fails owing to concurrency or throttling constraints, the execution is automatically retried.

Backfilling existing data in the table is supported.

What kind of trigger should you employ?

Accepted Answer

tumbling window

Answer

A tumbling window trigger is ideal for this scenario because it fires at a fixed time interval (every four hours) and creates non-overlapping, contiguous windows. This trigger type inherently supports automatic retries for failed executions and allows for easy backfilling of existing data by re-running specific past windows. These features ensure robust and manageable incremental data loading.

Question 2

Pool1 is an Azure Synapse Analytics dedicated SQL pool, and DB1 is a database. Table1 is a fact table found in DB1.

In Table1, you must determine the amount of the data skew.

In Synapse Studio, what should you do?

Accepted Answer

Connect to Pool! and query sys.dm_pdw_nodes_db_partition_stats

Answer

To determine data skew in an Azure Synapse Analytics dedicated SQL pool, you should connect to the dedicated SQL pool (Pool1) and query the `sys.dm_pdw_nodes_db_partition_stats` Dynamic Management View (DMV). This DMV provides detailed information about data distribution across the compute nodes, including row counts per partition, which is crucial for identifying uneven data distribution or skew. Data skew can significantly impact query performance in a distributed system like Synapse.

Question 3

Azure Stream Analytics is used to receive Twitter data from Azure Event Hubs and send it to an Azure Blob storage account.

Every minute, you must output the number of tweets from the previous five minutes.

Which windowing mode should you employ?

Accepted Answer

Hopping

Answer

A hopping window is the correct choice because it allows you to define a fixed-size window (five minutes) that moves forward by a specified 'hop' interval (every minute). This enables the system to calculate the number of tweets in the preceding five minutes, and then perform the same calculation one minute later, effectively providing a rolling five-minute count every minute. Tumbling windows are non-overlapping, and sliding windows output for every event, neither of which fits the requirement precisely.

Question 4

You're working on an Azure Data Lake Storage Gen 2 application.

You must propose a method for granting permissions to a certain application for a set length of time.

What should your advice include?

Accepted Answer

shared access signatures (SAS)

Answer

Shared Access Signatures (SAS) are the recommended method for granting time-limited and granular permissions to specific resources in Azure Data Lake Storage Gen2. A SAS token provides delegated access to storage resources for a specified period, with defined permissions and an optional IP address restriction. This ensures that the application only has the necessary access for a controlled duration, enhancing security.

Question 5

You're utilizing Azure metrics to keep track of an Azure Stream Analytics task.

You notice that the average watermark delay over the last 12 hours has consistently exceeded the configured late arrival tolerance.

What could be the source of this behavior?

Accepted Answer

The job's resources are insufficient to handle the volume of incoming data.

Answer

A consistently high average watermark delay exceeding the late arrival tolerance indicates that the Azure Stream Analytics job is struggling to process incoming data at the rate it's arriving. This usually points to insufficient resources allocated to the job. Increasing the job's streaming units (SUs) would provide more processing power, allowing it to catch up with the incoming event stream and reduce the watermark delay.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Test 1