[Free] 2019(Nov) EnsurePass Microsoft DP-200 Dumps with VCE and PDF 11-20

Get Full Version of the Exam
http://www.EnsurePass.com/DP-200.html

Question No.11

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

A company uses Azure Data Lake Gen 1 Storage to store big data related to consumer behavior. You need to implement logging.

Solution: Create an Azure Automation runbook to copy events. Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: B

Question No.12

HOTSPOT

You develop data engineering solutions for a company.

A project requires an in-memory batch data processing solution.

You need to provision an HDInsight cluster for batch processing of data on Microsoft Azure.

How should you complete the PowerShell segment? To answer, select the appropriate option in the answer area.

NOTE: Each correct selection is worth one point.

image

Correct Answer:

image

Question No.13

HOTSPOT

You are designing a new Lambda architecture on Microsoft Azure. The real-time processing layer must meet the following requirements: Ingestion:

image

Receive millions of events per second

image

image

Act as a fully managed Platform-as-a-Service (PaaS) solution Integrate with Azure Functions

Stream processing:

image

Process on a per-job basis

image

image

Provide seamless connectivity with Azure services Use a SQL-based query language

Analytical data store:

image

image

Act as a managed service Use a document store

image

Provide data encryption at rest

You need to identify the correct technologies to build the Lambda architecture using minimal effort. Which

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

image

Correct Answer:

image

Question No.14

You manage a Microsoft Azure SQL Data Warehouse Gen 2.

Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.

You need to monitor resource utilization to determine the source of the performance issues.

Which metric should you monitor?

  1. Cache used percentage

  2. Local tempdb percentage

  3. WU percentage

  4. CPU percentage

Correct Answer: B

Question No.15

DRAG DROP

Your company manages on-premises Microsoft SQL Server pipelines by using a custom solution.

The data engineering team must implement a process to pull data from SQL Server and migrate it to Azure Blob storage. The process must orchestrate and manage the data lifecycle.

You need to configure Azure Data Factory to connect to the on-premises SQL Server database.

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

image

Correct Answer:

image

Question No.16

DRAG DROP

You develop data engineering solutions for a company.

A project requires analysis of real-time Twitter feeds. Posts that contain specific keywords must be stored and processed on Microsoft Azure and then displayed by using Microsoft Power BI. You need to implement the solution.

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

image

Correct Answer:

image

Question No.17

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

You develop data engineering solutions for a company.

A project requires the deployment of resources to Microsoft Azure for batch data processing on Azure HDInsight. Batch processing will run daily and must:

image

Scale to minimize costs

image

Be monitored for cluster performance

You need to recommend a tool that will monitor clusters and provide information to suggest how to scale.

Solution: Download Azure HDInsight cluster logs by using Azure PowerShell. Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: B

Explanation:

Instead monitor clusters by using Azure Log Analytics and HDInsight cluster management solutions.

References:

https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-hadoop-oms-log-analytics-tutorial

Question No.18

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:

image

image

Data must be partitioned into multiple containers. Data containers must be configured separately.

image

image

Data must be accessible from applications hosted around the world. The solution must minimize latency.

You need to provision Azure Cosmos DB

  1. Configure account-level throughput.

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

  3. Configure table-level throughput

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

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

Correct Answer: A

Question No.19

A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database.

You must perform an assessment of databases to determine whether data will move without compatibility issues.

You need to perform the assessment.

Which tool should you use?

  1. Azure SQL Data Sync

  2. SQL Vulnerability Assessment (VA)

  3. SQL Server Migration Assistant (SSMA)

  4. Microsoft Assessment and Planning Toolkit

  5. Data Migration Assistant (DMA)

Correct Answer: E

Explanation:

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server.

References:

https://docs.microsoft.com/en-us/sql/dma/dma-overview

Question No.20

HOTSPOT

Your company uses Azure SQL Database and Azure Blob storage.

All data at rest must be encrypted by using the company#39;s own key. The solution must minimize administrative effort and the impact to applications which use the database.

You need to configure security.

What should you implement? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point.

image

Correct Answer:

image

Get Full Version of the Exam
DP-200 Dumps
DP-200 VCE and PDF

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>