Pass Implementing an Azure Data Solution DP-200 Exam With The Latest Study Guide

Pass Implementing an Azure Data Solution DP-200 Exam With The Latest Study Guide

Candidates who are familiar with Microsoft Certified: Azure Data Engineer Associate certification know that both DP-200 Implementing an Azure Data Solution and DP-201 Designing an Azure Data Solution are retiring on August 31, 2021. It is recommended to take and pass DP-203 exam to complete the certification. If you are planning to take and pass DP-200 exam, please choose the latest study guide from ITExamShop. The latest DP-200 study guide come with actual exam questions which cover the DP-200 exam objectives to test your skills. Also, the answers have been verified by the professional team. They have full confidence to ensure that you can pass Microsoft DP-200 Implementing an Azure Data Solution exam.

If still not trust, just come here to check DP-200 free questions before getting the latest DP-200 study guide.

Page 1 of 4

1. Topic 1, Proseware Inc



Background

Proseware, Inc, develops and manages a product named Poll Taker. The product is used for delivering public opinion polling and analysis.



Polling data comes from a variety of sources, including online surveys, house-to-house interviews, and booths at public events.



Polling data

Polling data is stored in one of the two locations:

- An on-premises Microsoft SQL Server 2019 database named PollingData

- Azure Data Lake Gen 2



Data in Data Lake is queried by using PolyBase



Poll metadata

Each poll has associated metadata with information about the poll including the date and number of respondents. The data is stored as JSON.



Phone-based polling

Security

- Phone-based poll data must only be uploaded by authorized users from authorized devices

- Contractors must not have access to any polling data other than their own

- Access to polling data must set on a per-active directory user basis



Data migration and loading

- All data migration processes must use Azure Data Factory

- All data migrations must run automatically during non-business hours

- Data migrations must be reliable and retry when needed



Performance

After six months, raw polling data should be moved to a storage account. The storage must be available in the event of a regional disaster. The solution must minimize costs.



Deployments

- All deployments must be performed by using Azure DevOps. Deployments must use templates used in multiple environments

- No credentials or secrets should be used during deployments



Reliability

All services and processes must be resilient to a regional Azure outage.



Monitoring

All Azure services must be monitored by using Azure Monitor. On-premises SQL Server performance must be monitored.



You need to ensure that phone-based poling data can be analyzed in the PollingData database.

How should you configure Azure Data Factory?

2. DRAG DROP

You need to provision the polling data storage account.

How should you configure the storage account? To answer, drag the appropriate Configuration Value to the correct Setting. Each Configuration Value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.



3. DRAG DROP

You need to ensure that phone-based polling data can be analyzed in the PollingData database.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer are and arrange them in the correct order.



4. HOTSPOT

You need to ensure phone-based polling data upload reliability requirements are met.

How should you configure monitoring? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.



5. HOTSPOT

You need to ensure that Azure Data Factory pipelines can be deployed.

How should you configure authentication and authorization for deployments? To answer, select the appropriate options in the answer choices. NOTE: Each correct selection is worth one point.



6. HOTSPOT

You need to ensure polling data security requirements are met.

Which security technologies should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.



7. Validate configuration results and deploy the solution

Does the solution meet the goal?

8. You need to set up Azure Data Factory pipelines to meet data movement requirements.

Which integration runtime should you use?

9. 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 questions sets might have more than one correct solution, while others might not have a correct solution.

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

You need setup monitoring for tiers 6 through 8.

What should you configure?

10. Validate configuration results and deploy the solution

Does the solution meet the goal?


 

Leave a Reply

Your email address will not be published.