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

schedule

Answer

event

Answer

on-demand

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

Connect to Pool1 and run DBCC CHECKALLOC

Answer

Connect to the built-in pool and query sysdm_pdw_sys_info

Answer

Connect to the built-in pool and run DBCC CHECKALLOC

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

Session

Answer

Sliding

Answer

Tumbling

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

Azure Active Directory (Azure AD) identities

Answer

role assignments

Answer

account keys

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

The input data contains errors.

Answer

Events with an application timestamp that is more than five minutes earlier than their arrival time are received as inputs.

Answer

The late arrival policy causes events to be dropped

Question 6

You have a virtual network that protects your Azure Data Lake Storage Gen2 account, adls2.

In Azure Synapse, you're creating a SQL pool with adls2 as a source.

What method should you use to connect to adls2?

Accepted Answer

a managed identity

Answer

a shared key

Answer

a shared access signature (SAS)

Answer

an Azure Active Directory (Azure AD) user

Question 7

In Azure Synapse Analytics, you have a data warehouse.
You must ensure that c rests.
What do you want to enable?

Accepted Answer

Transparent Data Encryption (TDE)

Answer

Advanced Data Security for this database

Answer

Secure transfer required

Answer

Always Encrypted for all columns

Question 8

You have a subscription to Azure that includes the following resources:
* A SQL API account for Azure Cosmos DB
* An encryption key named key1 is stored in an Azure key vault named vault1.
By utilizing key1, you must verify that all content stored in Azure Cosmos DB is encrypted. What should you start with?

Accepted Answer

Create a managed identity

Answer

Create a new Azure Cosmos DB account

Answer

Disable soft delete on vault 1

Answer

Enable geo-redundancy for the Azure Cosmos DB account

Question 9

You're keeping an eye on an Azure Stream Analytics job.
For the last hour, the number of Backlogged Input Events has been 20.
The number of Backlogged Input Events must be reduced.
What are your options?

Accepted Answer

Increase the streaming units for the job

Answer

Stop the job

Answer

Drop late arriving events from the job

Answer

Add an Azure Storage account to the job