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

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

Question No.1

DRAG DROP

You are developing the data platform for a global retail company. The company operates during normal working hours in each region. The analytical database is used once a week for building sales projections.

Each region maintains its own private virtual network.

Building the sales projections is very resource intensive are generates upwards of 20 terabytes (TB) of data.

Microsoft Azure SQL Databases must be provisioned.

image

Database provisioning must maximize performance and minimize cost

image

image

The daily sales for each region must be stored in an Azure SQL Database instance Once a day, the data for all regions must be loaded in an analytical Azure SQL Database

instance

You need to provision Azure SQL database instances.

How should you provision the database instances? To answer, drag the appropriate Azure SQL products to the correct databases. Each Azure SQL product 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.

image

Correct Answer:

image

Question No.2

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: Configure Azure Data Late Storage diagnostics to store logs and metrics in a storage account.

Does the solution meet the goal?

  1. Yes

  2. No

Correct Answer: A

Question No.3

DRAG DROP

You develop data engineering solutions for a company.

You need to deploy a Microsoft Azure Stream Analytics job for an IoT solution. The solution must:

Which four 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.4

DRAG DROP

Your company plans to create an event processing engine to handle streaming data from Twitter. The data engineering team uses Azure Event Hubs to ingest the streaming data.

You need to implement a solution that uses Azure Databricks to receive the streaming data from the Azure Event Hubs.

Which three actions should you recommend be performed 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.5

You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data. The analytical data store performs poorly.

You must implement a solution that meets the following requirements:

image

Provide data warehousing

image

Reduce ongoing management activities

image

Deliver SQL query responses in less than one second

You need to create an HDInsight cluster to meet the requirements.

Which type of cluster should you create?

  1. Interactive Query

  2. Apache Hadoop

  3. Apache HBase

  4. Apache Spark

Correct Answer: D

Explanation:

Lambda Architecture with Azure:

Azure offers you a combination of following technologies to accelerate real-time big data analytics:

image

Azure Cosmos DB, a globally distributed and multi-model database service.

image

Apache Spark for Azure HDInsight, a processing framework that runs large-scale data analytics applications.

image

Azure Cosmos DB change feed, which streams new data to the batch layer for HDInsight to process.

image

The Spark to Azure Cosmos DB Connector

image

Note:

Lambda architecture is a data-processing architecture designed to handle massive quantities of data by taking advantage of both batch processing and stream processing methods, and minimizing the latency involved in querying big data.

References:

https://sqlwithmanoj.com/2018/02/16/what-is-lambda-architecture-and-what-azure-offers-with-its- new-cosmos-db/

Question No.6

DRAG DROP

A company builds an application to allow developers to share and compare code. The conversations, code snippets, and links shared by people in the application are stored in a Microsoft Azure SQL Database instance. The application allows for searches of historical

conversations and code snippets.

When users share code snippets, the code snippet is compared against previously share code snippets by using a combination of Transact-SQL functions including SUBSTRING, FIRST_VALUE, and SQRT. If a match is found, a link to the match is added to the conversation.

Customers report the following issues:

image

Delays occur during live conversations

image

A delay occurs before matching links appear after code snippets are added to conversations You need to resolve the performance issues.

Which technologies should you use? To answer, drag the appropriate technologies to the correct issues. Each technology 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.

image

Correct Answer:

image

Question No.7

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?

  1. Yes

  2. No

Correct Answer: A

Question No.8

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.

  1. Create a new action group to email alerts@contoso.com.

  2. Use alerts@contoso.com as an alert email address.

  3. Use all security operations as a condition.

  4. Use all Azure SQL Database servers as a resource.

  5. Query audit log entries as a condition.

Correct Answer: ACE

Question No.9

A company uses Azure SQL Database to store sales transaction data. Field sales employees need an offline copy of the database that includes last year#39;s sales on their laptops when there is no internet connection available.

You need to create the offline export copy.

Which three options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  1. Export to a BACPAC file by using Azure Cloud Shell, and save the file to an Azure storage account

  2. Export to a BACPAC file by using SQL Server Management Studio. Save the file to an Azure storage account

  3. Export to a BACPAC file by using the Azure portal

  4. Export to a BACPAC file by using Azure PowerShell and save the file locally

  5. Export to a BACPAC file by using the SqlPackage utility

Correct Answer: BCE

Question No.10

HOTSPOT

You develop data engineering solutions for a company. An application creates a database on Microsoft Azure.

You have the following code:

Which database and authorization types are used? 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.