Microsoft DP-200 Exam Practice Test Instant Access

Question 1

Use the following login credentials as needed:

Azure Username: xxxxx

Azure Password: xxxxx

The following information is for technical support purposes only:

Lab Instance: 10543936

You need to create an Azure Storage account named account10543936. The solution must meet the following requirements:

Minimize storage costs.

Ensure that account10543936 can store many image files.

Ensure that account10543936 can quickly retrieve stored image files.

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

AExplanation:
Create a general-purpose v2 storage account, which provides access to all of the Azure Storage services: blobs, files, queues, tables, and disks.
1. On the Azure portal menu, select All services. In the list of resources, type Storage Accounts. As you begin typing, the list filters based on your input. Select Storage Accounts.
2. On the Storage Accounts window that appears, choose Add.
3. Select the subscription in which to create the storage account.
4. Under the Resource group field, select Create new. Enter the name for your new resource group, as shown in the following image.

5. Next, enter the name account10543936 for your storage account.
6. Select a location for your storage account, or use the default location.
7. Leave these fields set to their default values:
Deployment model: Resource Manager
Performance: Standard
Account kind: StorageV2 (general-purpose v2)
Replication: Read-access geo-redundant storage (RA-GRS)
Access tier: Hot
8. Select Review + Create to review your storage account settings and create the account.
9. Select Create.

Answer : A

https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create

Question 2

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 create multiple pipelines in a new Azure Data Factory V2.

You need to create the data factory, and then create a scheduled trigger for the planned pipelines. The trigger must execute every two hours starting at 24:00:00.

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

AExplanation:
Step 1: Create a new 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: Create a schedule trigger for the Data Factory
1. Select the Data Factory you created, and switch to the Edit tab.

2. Click Trigger on the menu, and click New/Edit.

3. In the Add Triggers page, click Choose trigger..., and click New.

4. In the New Trigger page, do the following steps:
a. Confirm that Schedule is selected for Type.
b. Specify the start datetime of the trigger for Start Date (UTC) to: 24:00:00
c. Specify Recurrence for the trigger. Select Every Hour, and enter 2 in the text box.

5. In the New Trigger window, check the Activated option, and click Next.
6. In the New Trigger page, review the warning message, and click Finish.
7. Click Publish to publish changes to Data Factory. Until you publish changes to Data Factory, the trigger does not start triggering the pipeline runs.

References:
https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-portal
https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-schedule-trigger

Answer : A

Question 3

Contoso, Ltd. plans to configure existing applications to use Azure SQL Database. When security-related operations occur, the security team must be informed. You need to configure Azure Monitor while minimizing administrative efforts

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

NOTE: Each correct selection is worth one point.

ACreate a new action group to email alerts@contoso.com.

BUse alerts@contoso.com as an alert email address.

CUse all security operations as a condition.

DUse all Azure SQL Database servers as a resource.

EQuery audit log entries as a condition.
References:
https://docs.microsoft.com/en-us/azure/azure-monitor/platform/alerts-action-rules

Answer : A, C, D

Question 4

What should you implement to optimize SQL Database for Race Central to meet the technical requirements?

Athe sp_update stored procedure

Bautomatic tuning

CQuery Store

Dthe dbcc checkdb command

Answer : A

Scenario: The query performance of Race Central must be stable, and the administrative time it takes to

perform optimizations must be minimized.

sp_update updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently than the default updates.

Incorrect Answers:

D: dbcc checkdchecks the logical and physical integrity of all the objects in the specified database

Question 5

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a container named Sales in an Azure Cosmos DB database. Sales has 120 GB of dat

a. Each entry in Sales has the following structure.

The partition key is set to the OrderId attribute.

Users report that when they perform queries that retrieve data by ProductName, the queries take longer than expected to complete.

You need to reduce the amount of time it takes to execute the problematic queries.

Solution: You create a lookup collection that uses ProductName as a partition key.

Does this meet the goal?

AYes

BNo

Answer : B

One option is to have a lookup collection ''ProductName'' for the mapping of ''ProductName'' to ''OrderId''.

References:

https://azure.microsoft.com/sv-se/blog/azure-cosmos-db-partitioning-design-patterns-part-1/

Question 6

You are developing a data engineering solution for a company. The solution will store a large set of key-value pair data by using Microsoft Azure Cosmos DB

The solution has the following requirements:

* Data must be partitioned into multiple containers.

* Data containers must be configured separately.

* Data must be accessible from applications hosted around the world.

* The solution must minimize latency.

You need to provision Azure Cosmos DB

AConfigure account-level throughput.

BProvision an Azure Cosmos DB account with the Azure Table API Enable geo-redundancy.

CConfigure table-level throughput

DReplicate the data globally by manually adding regions lo the Azure Cosmos DB account.

EProvision an Azure Cosmos DB account with the Azure Table API. Enable multi-region writes.

Answer : E

Scale read and write throughput globally. You can enable every region to be writable and elastically scale reads and writes all around the world. The throughput that your application configures on an Azure Cosmos database or a container is guaranteed to be delivered across all regions associated with your Azure Cosmos account. The provisioned throughput is guaranteed up by financially backed SLAs.

References:

https://docs.microsoft.com/en-us/azure/cosmos-db/distribute-data-globally

Question 7

You need to configure a disaster recovery solution for SALESDB to meet the technical requirements.

What should you configure in the backup policy?

Aweekly long-term retention backups that are retained for three weeks

Bfailover groups

Ca point-in-time restore

Dgeo-replication

Answer : C

Scenario: SALESDB must be restorable to any given minute within the past three weeks.

The Azure SQL Database service protects all databases with an automated backup system. These backups are retained for 7 days for Basic, 35 days for Standard and 35 days for Premium. Point-in-time restore is a self-service capability, allowing customers to restore a Basic, Standard or Premium database from these backups to any point within the retention period.

References:

https://azure.microsoft.com/en-us/blog/azure-sql-database-point-in-time-restore/

Microsoft DP-200 Implementing an Azure Data Solution Exam Practice Test