Microsoft DP-200 Exam Questions

Name: Microsoft DP-200 Exam
Brand: Pass4Success
SKU: DP-200
Price: 69.00 USD
Availability: InStock
Rating: 4.8 (51 reviews)

Status: RETIRED

Exam Name: Implementing an Azure Data Solution

Exam Code: DP-200

Related Certification(s): Microsoft Azure Data Engineer Associate Certification

Certification Provider: Microsoft

Actual Exam Duration: 120 Minutes

Number of DP-200 practice questions in our database: 243 (updated: 31-08-2021)

Expected DP-200 Exam Topics, as suggested by Microsoft :

Topic 1: Responsibility for data related tasks that include Ingesting/ Egressing/ and Transforming Data
Topic 2: Multiple Sources Using Various Services and Tools
Topic 3: Azure Data Engineer Collaborates With Business Stakeholders
Topic 4: Identify and Meet Data Requirements While Designing and Implementing the Management
Topic 5: Monitoring Security and Privacy of Data Using the Full Stack of Azure Services

Disscuss Microsoft DP-200 Topics, Questions or Ask Anything Related

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Free Microsoft DP-200 Exam Actual Questions

Note: Premium Questions for DP-200 were last updated On 31-08-2021 (see below)

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 plan to enable Azure Multi-Factor Authentication (MFA).

You need to ensure that User1-10543936@ExamUsers.com can manage any databases hosted on an Azure SQL server named SQL10543936 by signing in using his Azure Active Directory (Azure AD) user account.

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

AExplanation:
Provision an Azure Active Directory administrator for your managed instance
Each Azure SQL server (which hosts a SQL Database or SQL Data Warehouse) starts with a single server administrator account that is the administrator of the entire Azure SQL server. A second SQL Server administrator must be created, that is an Azure AD account. This principal is created as a contained database user in the master database.
1. In the Azure portal, in the upper-right corner, select your connection to drop down a list of possible Active Directories. Choose the correct Active Directory as the default Azure AD. This step links the subscription-associated Active Directory with Azure SQL server making sure that the same subscription is used for both Azure AD and SQL Server. (The Azure SQL server can be hosting either Azure SQL Database or Azure SQL Data Warehouse.)

2. Search for and select the SQL server SQL10543936

3. In SQL Server page, select Active Directory admin.
4. In the Active Directory admin page, select Set admin.

5. In the Add admin page, search for user User1-10543936@ExamUsers.com, select it, and then select Select. (The Active Directory admin page shows all members and groups of your Active Directory. Users or groups that are grayed out cannot be selected because they are not supported as Azure AD administrators.

6. At the top of the Active Directory admin page, select SAVE.

Reveal Solution

Correct Answer: A

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure?

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: 10543936

You need to ensure that only the resources on a virtual network named VNET1 can access an Azure Storage account named storage10543936.

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

AExplanation:
You can use Private Endpoints for your Azure Storage accounts to allow clients on a virtual network (VNet) to securely access data over a Private Link.
Create your Private Endpoint
1. On the upper-left side of the screen in the Azure portal, Storage > Storage account, and select your storage account storage10543936
2. Select Networking.
3. Select Add Private Endpoint.
4. In Create Private Endpoint, enter or select this information:
Virtual network: Select VNET1 from the resource group.
5. Select OK.
6. Select Review + create. You're taken to the Review + create page where Azure validates your configuration.

Reveal Solution

Correct Answer: A

https://docs.microsoft.com/en-us/azure/private-link/create-private-endpoint-storage-portal

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: 10543936

You need to replicate db1 to a new Azure SQL server named db1-copy10543936 in the US West region.

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

AExplanation:
1. In the Azure portal, browse to the database db1-copy10543936 that you want to set up for geo-replication.
2. On the SQL database page, select geo-replication, and then select the region to create the secondary database: US West region

3. Select or configure the server and pricing tier for the secondary database.

4. Click Create to add the secondary.
5. The secondary database is created and the seeding process begins.

6. When the seeding process is complete, the secondary database displays its status.

Reveal Solution

Correct Answer: A

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-active-geo-replication-portal

Question #4

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 ensure that you can recover any blob data from an Azure Storage account named storage10543936 up to 10 days after the data is deleted.

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

AExplanation:
Enable soft delete for blobs on your storage account by using Azure portal:
1. In the Azure portal, select your storage account.
2. Navigate to the Data Protection option under Blob Service.
3. Click Enabled under Blob soft delete

4. Enter the number of days you want to retain for under Retention policies. Here enter 10.
5. Choose the Save button to confirm your Data Protection settings
Note: Azure Storage now offers soft delete for blob objects so that you can more easily recover your data when it is erroneously modified or deleted by an application or other storage account user. Currently you can retain soft deleted data for between 1 and 365 days.

Reveal Solution

Correct Answer: A

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-soft-delete

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 increase the Request Units (RUs) for the database.

Does this meet the goal?

AYes

BNo

Reveal Solution

Correct Answer: A

To scale the provisioned throughput for your application, you can increase or decrease the number of RUs at any time.

Note: The cost of all database operations is normalized by Azure Cosmos DB and is expressed by Request Units (or RUs, for short). You can think of RUs per second as the currency for throughput. RUs per second is a rate-based currency. It abstracts the system resources such as CPU, IOPS, and memory that are required to perform the database operations supported by Azure Cosmos DB.

https://docs.microsoft.com/en-us/azure/cosmos-db/request-units

Unlock Premium DP-200 Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now