Download Implementing an Azure Data Solution.prepaway.DP-200.2021-01-13.4e.150q.vcex

Download Exam

File Info

Exam Implementing an Azure Data Solution
Number DP-200
File Name Implementing an Azure Data Solution.prepaway.DP-200.2021-01-13.4e.150q.vcex
Size 15.79 Mb
Posted January 13, 2021
Downloads 4

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Coupon: EXAM_HUB

Discount: 20%


Demo Questions

Question 1
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:
Provide data warehousing 
Reduce ongoing management activities 
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?

  • A: Interactive Query
  • B: Apache Hadoop
  • C: Apache HBase
  • D: Apache Spark

Question 2
You develop data engineering solutions for a company. You must migrate data from Microsoft Azure Blob storage to an Azure SQL Data Warehouse for further transformation. You need to implement the solution. 
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. 

Question 3
You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations. 
The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. The solution must avoid single points of failure during connection and transfer to the cloud. The solution must also minimize latency. 
You need to secure the transfer of data between on-premises databases and Microsoft Azure. 
What should you do?

  • A: Install a standalone on-premises Azure data gateway at each location
  • B: Install an on-premises data gateway in personal mode at each location
  • C: Install an Azure on-premises data gateway at the primary location
  • D: Install an Azure on-premises data gateway as a cluster at each location

Question 4
An application will use Microsoft Azure Cosmos DB as its data solution. The application will use the Cassandra API to support a column-based database type that uses containers to store items. 
You need to provision Azure Cosmos DB. Which container name and item name should you use?  Each correct answer presents part of the solutions. 
NOTE: Each correct answer selection is worth one point.

  • A: collection
  • B: rows
  • C: graph
  • D: entities
  • E: table

Question 5
A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year. 
You need to implement the Azure SQL Database elastic pool to minimize cost. 
Which option or options should you configure?

  • A: Number of transactions only
  • B: eDTUs per database only
  • C: Number of databases only
  • D: CPU usage only
  • E: eDTUs and max data size

Question 6
You are a data engineer. You are designing a Hadoop Distributed File System (HDFS) architecture. You plan to use Microsoft Azure Data Lake as a data storage repository. 
You must provision the repository with a resilient data schema. You need to ensure the resiliency of the Azure Data Lake Storage. What should you use? To answer, select the appropriate options in the answer area. 
NOTE: Each correct selection is worth one point.

Question 7
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. 
Database provisioning must maximize performance and minimize cost 
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.

Question 8
A company manages several on-premises Microsoft SQL Server databases. 
You need to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. 
Which data technology should you use?

  • A: Azure SQL Database single database
  • B: Azure SQL Data Warehouse
  • C: Azure Cosmos DB
  • D: Azure SQL Database Managed Instance

Question 9
The data engineering team manages Azure HDInsight clusters. The team spends a large amount of time creating and destroying clusters daily because most of the data pipeline process runs in minutes. 
You need to implement a solution that deploys multiple HDInsight clusters with minimal effort. 
What should you implement?

  • A: Azure Databricks
  • B: Azure Traffic Manager
  • C: Azure Resource Manager templates
  • D: Ambari web user interface

Question 10
You are the data engineer for your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. 
Developers need to access data in the database using an API. 
You need to determine which API to use for the database model and type. 
Which two APIs should you use? Each correct answer presents a complete solution. 
NOTE: Each correct selection is worth one point.

  • A: Table API
  • B: MongoDB API
  • C: Gremlin API
  • D: SQL API
  • E: Cassandra API



You can buy ProfExam with a 20% discount..

Get Now!


Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen


Use VCE Exam Simulator to open VCE files