Certification Exam Prep Questions For Microsoft Implementing an Azure Data Solution (DP-200)


QuickStart is now offering assessment questions for Microsoft Implementing an Azure Data Solution (DP-200). Whether you are deciding which exam to sign up for, or simply want to practice the materials necessary to complete certification for this course, we have provided a practice assessment to better aid in certification. 100% of the questions are real questions; from a recent version of the test you will take for Microsoft Implementing an Azure Data Solution (DP-200) .


Arrow
 

1

You are a data engineer for your company. Your company wants to build an e-commerce site that allows vendors to sell their products online. Each vendor's product can have an arbitrary number of attributes. For example, Vendor A has a product named Bicycle Z that contains attributes Price. Description, Brand, PartNumber, and Size. Vendor B has the same product named Bicycle Z that contains attributes Price, Description, Weight, and Model. You want to implement a solution that does not restrict the product attributes that are used by each vendor. Your solution must allow you to use .NET to query product data. You need to create the appropriate data store. Solution: You create a Cosmos DB account that uses the Table API. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
2

You are a data engineer for your company. Your company wants to build an e-commerce site that allows vendors to sell their products online. Each vendor's product can have an arbitrary number of attributes. For example, Vendor A has a product named Bicycle Z that contains attributes Price, Description. Brand, PartNumber, and Size. Vendor B has the same product named Bicycle Z that contains attributes Price, Description, Weight, and Model. You want to implement a solution that does not restrict the product attributes that are used by each vendor. Your solution must allow you to use .NET to query product data. You need to create the appropriate data store. Solution: You create an Azure SQL Database account that uses a managed instance. Does this solution meet the goal?

A. No
Correct!
B. Yes
Incorrect.
3

You are a data engineer for your company. Your company wants to build an e-commerce site that allows vendors to sell their products online. Each vendor's product can have an arbitrary number of attributes. For example, Vendor A has a product named Bicycle Z that contains attributes Price, Description, Brand, PartNumber, and Size. Vendor B has the same product named Bicycle Z that contains attributes Price, Description, Weight, and Model. You want to implement a solution that does not restrict the product attributes that are used by each vendor. Your solution must allow you to use .NET to query product data. You need to create the appropriate data store. Solution: You create a table storage account. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
4

You are a data engineer for your company. Your company wants to build an e-commerce site that allows vendors to sell their products online. Each vendor's product can have an arbitrary number of attributes. For example, Vendor A has a product named Bicycle Z that contains attributes Price, Description, Brand, PartNumber, and Size. Vendor B has the same product named Bicycle Z that contains attributes Price, Description, Weight, and Model. You want to implement a solution that does not restrict the product attributes that are used by each vendor. Your solution must allow you to use .NET to query product data. You need to create the appropriate data store. Solution: You create a Cosmos DB account that uses the SQL API. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
5

You are a data engineer. You are developing a data ingestion solution that ingests data from large pipe-delimited text files in an Azure Data Lake Gen 1 storage account to Azure Data Warehouse. You need to load the data. Solution: You do the following: • Create an external file format and external data source. • Create an external table that uses the external data source. • Load the data from the external table. Does this solution meet the goal?

A. Yes
Incorrect.
B. No
Correct!
6

You are a data engineer. You are developing a data ingestion solution that ingests data from large pipe-delimited text files in an Azure Data Lake Gen 1 storage account to Azure Data Warehouse. You need to load the data. Solution: You do the following: • Create an external file format and external data source. • Create an external table that uses the external data source. • Load the data from the external table. Does this solution meet the goal?

7

You are a data engineer. You are developing a data ingestion solution that ingests data from large pipe-delimited text files in an Azure Data Lake Gen 1 storage account to Azure Data Warehouse. You need to load the data. Solution: You do the following: • Create an external file format and external data source. • Create an external table that uses the external data source. • Load the data from the external table. Does this solution meet the goal?

A. Yes.
Incorrect.
B. No
Incorrect.
8

You are a data engineer. You are developing a data ingestion solution that ingests data from large pipe-delimited text files in an Azure Data Lake Gen 1 storage account to Azure Data Warehouse. You need to load the data. Solution: You do the following: • Create an Azure Databricks account and a linked server. • Create an external table that points to the Azure Databricks account. • Load the data by running the dbutils.fs.cp command. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
9

You are a data engineer for an autonomous vehicle manufacturer. Each vehicle contains a transmitter that submits sensor data over Advanced Message Queuing Protocol (AMQP). You want to retrieve the sensor data in real time so that you can extract relevant information, transform it. and then send it to Power BI. You need to implement the solution. Solution: You do the following: • Create an loT Hub instance. • Create a Stream Analytics job that uses a query to extract data. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
10

You are a data engineer for an autonomous vehicle manufacturer. Each vehicle contains a transmitter that submits sensor data over Advanced Message Queuing Protocol (AMQP). You want to retrieve the sensor data in real time so that you can extract relevant information, transform it. and then send it to Power BI. You need to implement the solution. Solution: You do the following: • Create an Azure Relay service. • Create an Azure Function app that extracts and queries data from Azure Relay. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
11

You need to have the test center web application send exam data to azure Which technology should you choose to receive the data?

A. Azure databricks
Incorrect.
B. Azure Relay
Incorrect.
C. Event Grid
Incorrect.
D. Event Hub
Correct!
12

You need to choose the technology to query the data, filter it, and send it to Power BI. Which technology should you choose?

A. HDlnsight
Incorrect.
B. WebJob
Incorrect.
C. Function app
Incorrect.
D. Stream Analytics
Correct!
13

You need to choose the windowing function that is most appropriate. Which windowing function should you use?

A. Sliding
Incorrect.
B. Tumbling
Incorrect.
C. Hopping
Incorrect.
D. Session
Correct!
14

You need to add test data for analysis in Azure. Which two data formats should you use? Each correct answer presents a complete solution.

A. XML
Incorrect.
B. YAML
Incorrect.
C. JSON
Correct!
D. CSV
Correct!
15

You are a data engineer for your company. You are creating an Azure Cosmos DB account to store an existing product catalog. The existing product catalog currently exists as a single Oracle database table. Approximately 20 percent of the columns in the table are empty. Each product type can have different attribute names and a different attribute count. You must be able to search the catalog by product id and category. You must be able to search for products in the Clothing category by size. You must be able to search for products in the Laptop category by CPU speed. You also must be able to query data by using the following syntax from a web application:

A. Gremlin API
Incorrect.
B. Core SQL API
Correct!
C. Table API
Incorrect.
D. MongoDB API
Incorrect.
16

You are a data engineer. You manage an HDlnsight cluster. You want to monitor the cluster's performance by using a web user interface. You need to choose the appropriate tool for monitoring. Which tool should you use?

A. Azure Log Analytics
Incorrect.
B. Apache Ambari
Correct!
C. Azure Stream Analytics
Incorrect.
D. Apache Spark
Incorrect.
17

Your company has an application for technical writers to share, review and publish exam questions. The application allows live reviews for questions and provides reports about question performance after the questions are published. All questions and reviews and stored in Azure SQL Database. Writers are able to report question metrics in an exam results table with millions of rows. Reports include the percentage of correct answers, average question rating and answer count per question. After a question is published, live reviews are disabled and previous reviews are archived in a separate database. Writers report the following performance issues with the application: • Some delays are occurring during the live reviews. • Reports are taking too long to be generated. You need to resolve the performance issues. Which two features should you use? Each correct answer presents a complete solution.

A. Partitioned view
Incorrect.
B. Columnstore index
Correct!
C. Memory-optimized table
Correct!
D. Heap table
Incorrect.
18

You are a data engineer. You use Azure Data Factory to copy and transform data from Azure blob storage to an on-premises server. You need to ensure that you can successfully copy data. Which two actions should you perform? Each correct answer presents part of the solution.

19

You are a data engineer. You create a table with the following query: CREATE TABLE License ( [ID] int, [Number] char(9) MASKED WITH (FUNCTION = 'partial(3, "xxxxx", 1)') NULL, [GivenName] varchar(20), [SurName] varchar(20) You insert data by using the following query: INSERT INTO License (ID, Number, GivenName. SurName) SELECT 1, '111222333', 'Sam'. 'Jack' You then run the following query to return data: SELECT Number FROM License where ID=1 You need to determine which value is returned from the query. Which value is returned?

A. xxx22233x
Incorrect.
B. 111xxxxx3
Correct!
C. 22233
Incorrect.
D. 1113
Incorrect.
20

You are a data engineer for your company. You have an HDlnsight cluster in Azure. You need to monitor the cluster for performance. What should you do?

21

You are a data engineer for your company. You create an Azure Databricks account by using the Azure portal. You plan to ingest data from blob storage into Databricks. You import a notebook from Github. You need to create the next resource so that you can run code to ingest the data. What should you create next?

A. Spark cluster
Correct!
B. Master key
Incorrect.
C. SQL Data Warehouse instance
Incorrect.
D. Cosmos DB account
Incorrect.
22

You are deploying a new e-commerce solution in the Microsoft Azure environment that uses Azure SQL Database as its relational data store. As a part of the business continuity plan, you enable active geo-replication of the primary database to the secondary database in another Azure region. The Marketing team wants you to update the price list in Azure SQL Database shortly after the announcement of the new product ranges. You need to ensure that the price changes made in the primary database are replicated synchronously to the secondary database. What should you do?

23

You are a data engineer for your company. You have an Azure Databricks account. You want to use Azure Monitor to monitor the Databricks account. You need to choose a solution for sending application metrics to Azure Monitor. Which library or tool should you use?

A. Azure CLI
Incorrect.
B. Log4j
Incorrect.
C. Powershell
Incorrect.
D. Dropwizard
Correct!
24

You have a Microsoft SQL Server 2019 database hosted on an Azure virtual machine (VM). The database is the data store for a web application. When customers visit the shopping cart page of the application, the page loads slowly. You need to determine the stored procedure that is being called when this page is accessed. What should you do?

25

You are a data engineer. You have an Azure Data Factory pipeline in the US East region. You realize that pipeline run-data is deleted after 45 days. You need to keep the run-data from the pipeline for longer than 45 days. What should you do?

26

Your company manages an ecommerce platform for a large retailer. The platform is composed of thousands of web servers running on Azure virtual machines (VMs). The platform generates approximately three gigabytes (GB) of log data in a day. The log files for each server are stored in Azure Data Lake Storage Gen2 inside a single folder. This data is processed and analyzed on an HDlnsight cluster. You need to provide some performance improvements while minimizing cost. Which two changes should you implement? Each correct answer presents a complete solution.

27

You are a data engineer. You have an Azure Databricks account with an imported notebook. You also create an Azure data factory. You need to ensure that Data Factory can access Databricks. What should you create?

PDP Url

Sample Question - Microsoft Implementing an Azure Data Solution(DP-200)


Self-Paced

Learning Style

Beginner

Difficulty

1 Hour

Course Duration

Certificate

See Sample

Buy Individually
About Individual Course:
  • Individual course plan gives you access to this course
$109.00
$109.00
/ Each

Outline

More Information

More Information
Lab Access No
Learning Style Self-Paced Learning
Difficulty Beginner
Course Duration 1 Hour
Language English

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here