Microsoft DP-200 Exam Questions Instant Access

Question 1

You need to implement event processing by using Stream Analytics to produce consistent JSON documents.

Which three actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You need to ensure that the missing indexes for REPORTINGDB are added.

What should you use?

ASQL Database Advisor

Bextended events

CQuery Performance Insight

Dautomatic tuning

Answer : D

Automatic tuning options include create index, which identifies indexes that may improve performance of your workload, creates indexes, and automatically verifies that performance of queries has improved.

Scenario:

REPORTINGDB stores reporting data and contains server columnstore indexes.

Migrate SALESDB and REPORTINGDB to an Azure SQL database.

References:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning

Question 2

You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output the data to an Azure Blob storage account.

You need to output the count of tweets during the last five minutes every five minutes. Each tweet must only be counted once.

Which windowing function should you use?

Aa five-minute Session window

Ba five-minute Sliding window

Ca five-minute Tumbling window

Da five-minute Hopping window that has one-minute hop

Answer : C

Tumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap, and an event cannot belong to more than one tumbling window.

References:

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions

Question 3

Use the following login credentials as needed:

Azure Username: xxxxx

Azure Password: xxxxx

The following information is for technical support purposes only:

Lab Instance: 10277521

You plan to deploy an integration runtime named Runtime1 to an Azure virtual machine.

You need to create an Azure Data Factory V2, and then prepare the required Data Factory resources for App1.

To complete this task, sign in to the Azure portal.

AExplanation:
Step 1: Create an Azure Data Factory V2
1. Go to the Azure portal.
2. Select Create a resource on the left menu, select Analytics, and then select Data Factory.

4. On the New data factory page, enter a name.
5. For Subscription, select your Azure subscription in which you want to create the data factory.
6. For Resource Group, use one of the following steps:

7. For Version, select V2.
8. For Location, select the location for the data factory.
9. Select Create.
10. After the creation is complete, you see the Data Factory page.
Step 2: Setup of the Integration Runtime Runtime1
High-level steps for creating a linked self-hosted IR
1. In the self-hosted IR Runtime to be shared, click Connections and Grant permission to another Data Factory. .

2. Select the data factory you just created.

Note the resource ID of the self-hosted IR to be shared.

3. In the data factory to which the permissions were granted, create a new self-hosted IR (linked) and enter the resource ID.

References:
https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-portal
https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime#sharing-the-self-hosted-integration-runtime-ir-with-multiple-data-factories

Answer : A

Question 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.

You develop a data ingestion process that will import data to a Microsoft Azure SQL Data Warehouse.

The data to be ingested resides in parquet files stored in an Azure Data lake Gen 2 storage account.

You need to load the data from the Azure Data Lake Gen 2 storage account into the Azure SQL Data Warehouse.

Solution;

1. Create an external data source pointing to the Azure Data Lake Gen 2 storage account.

2. Create an external tile format and external table using the external data source.

3. Load the data using the CREATE TABLE AS SELECT statement.

Does the solution meet the goal?

AYes

BNo

Answer : A

You need to create an external file format and external table using the external data source.

You load the data using the CREATE TABLE AS SELECT statement.

References:

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lake-store

Question 5

A company manages several on-premises Microsoft SQL Server databases.

You need to migrate the databases to Microsoft Azure by using the backup process of Microsoft SQL Server.

Which data technology should you use?

AAzure SQL Database Managed Instance

BAzure SQL Data Warehouse

CAzure Cosmos DB

DAzure SQL Database single database

Answer : D

Question 6

Use the following login credentials as needed:

Azure Username: xxxxx

Azure Password: xxxxx

The following information is for technical support purposes only:

Lab Instance: 10277521

You need to increase the size of db2 to store up to 250 GB of data.

To complete this task, sign in to the Azure portal.

AExplanation:
1. In Azure Portal, navigate to the SQL databases page, select the db2 database , and choose Configure performance

2. Click on Standard and Adjust the Storage size to 250 GB

References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-single-databases-manage

Answer : A

Question 7

You have an Azure subscription that contains the resources shown in the following table.

All the resources have the default encryption settings.

AEnable Azure Storage encryption for storageaccount1.

BEnable Transparent Data Encryption (TDE) for synapsedb1.

CEnable encryption at rest for cosmosdb1.

DEnable Azure Storage encryption for storageaccount2.

Answer : D

Microsoft Implementing an Azure Data Solution DP-200 Exam Questions