Certification Exam Prep Questions For Microsoft Designing an Azure Data solution (DP-201)


QuickStart is now offering assessment questions for Microsoft Designing an Azure Data solution (DP-201). 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 Designing an Azure Data solution (DP-201)


Arrow
 

1

You work for a company, that delivers groceries, as a data architect. An application is being built by the development team to allow grocery stores to delivery groceries. There are different grocery stores selling different types of grocery products. You are required to provide a solution that does allows various product attributes used by each grocery store, without restricting any. You decide to use OData queries to access product information and create an appropriate data store. Solution: Creating an Azure Cosmos DB account with the Table API Do you think this is the right solution?

A. Yes
Correct!
B. No
Incorrect.
2

You work for a company, that delivers groceries, as a data architect. An application is being built by the development team to allow grocery stores to delivery groceries. There are different grocery stores selling different types of grocery products. You are required to provide a solution that does allows various product attributes used by each grocery store, without restricting any. You decide to use OData queries to access product information and create an appropriate data store. Solution: Creating an Azure SQL Database Do you think this is the right solution?

A. Yes
Correct!
B. No
Incorrect.
3

You are required to copy product files from the FTP server to Azure. Identify the suitable service you would use.

4

You work for a company, that delivers groceries, as a data architect. An application is being built by the development team to allow grocery stores to delivery groceries. There are different grocery stores selling different types of grocery products. You are required to provide a solution that does allows various product attributes used by each grocery store, without restricting any. You decide to use OData queries to access product information and create an appropriate data store. Solution: Creating an Azure table. Do you think this is the right solution?

A. Yes
Correct!
B. No
Incorrect.
5

You are required to copy product files from the FTP server. When copying the files, which of the following data stores serves as the destination?

A. Azure SQL Database
Incorrect.
B. Azure Data Warehouse
Incorrect.
C. Azure Data Lake
Correct!
D. Azure Databricks
Incorrect.
6

Which of the following data sources would you choose for the final product data?

A. Azure Cosmos DB
Incorrect.
B. Azure SQL Data Warehouse
Correct!
C. Azure Table
Incorrect.
D. Azure Databricks
Incorrect.
7

Can you identify from the following options which is the appropriate scheme to use if you are to design the partition distribution scheme for the Product table?

8

Can you identify from the following options which is the appropriate scheme to use if you are to design the partition distribution scheme for the Vendor table?

9

You are required provide a solution to transform data from merchant-specific formats by implementing components. Which of the following would you choose?

A. SQL Server Integration Services (SSIS)
Incorrect.
B. Powershell
Incorrect.
C. Polybase
Correct!
D. Azure CLI
Incorrect.
10

You work for an organization as a data architect. There is customer data from across the world you’re your organization manages. There are variety of data formats supplied by each customer which must be transformed by the organization. The total size of all customer data is under one pebibyte (PiB). You are required to come up with a data storage solution for customer data. Solution: You recommend Azure Table storage. Do you think this is the right solution?

A. Yes
Incorrect.
B. No
Correct!
11

You work for an organization as a data architect. There is customer data from across the world you’re your organization manages. There are variety of data formats supplied by each customer which must be transformed by the organization. The total size of all customer data is under one pebibyte (PiB). You are required to come up with a data storage solution for customer data. Solution: You recommend Azure Blob storage Do you think this is the right solution?

A. Yes
Correct!
B. No
Incorrect.
12

You work for an organization as a data architect. There is customer data from across the world you’re your organization manages. There are variety of data formats supplied by each customer which must be transformed by the organization. The total size of all customer data is under one pebibyte (PiB). You are required to come up with a data storage solution for customer data. Solution: You recommend Azure Data Lake Do you think this is the right solution?

A. No
Incorrect.
B. Yes
Correct!
13

Your organization tasks you to design an HDlnsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. Following are the requirements specified by the application design: - Automatic data encryption before persistent storage -Access control through POSIX permissions -Azure Active Directory (Azure AD) multi-factor authentication (MFA) -Support for auditing through diagnostics logging You are required optimize storage performance and configure your solution for that. Solution: Before writing to Data Lake Storage Gent., you batch process files into file sizes of at least 256 MB Do you think this is the right solution?

A. Yes
Correct!
B. No
Incorrect.
14

Your organization tasks you to design an HDlnsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. Following are the requirements specified by the application design: - Automatic data encryption before persistent storage -Access control through POSIX permissions -Azure Active Directory (Azure AD) multi-factor authentication (MFA) -Support for auditing through diagnostics logging You are required optimize storage performance and configure your solution for that. Solution: Before writing to Data Lake Storage Gent, you preprocess files to make sure they are smaller than 256 MB Do you think this is the right solution?

A. Yes
Incorrect.
B. No
Correct!
15

Your organization tasks you to design an HDlnsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. Following are the requirements specified by the application design: - Automatic data encryption before persistent storage -Access control through POSIX permissions -Azure Active Directory (Azure AD) multi-factor authentication (MFA) -Support for auditing through diagnostics logging You are required optimize storage performance and configure your solution for that. Solution: You implement compaction jobs to combine smaller files into files that are 2 GB in size or larger. Do you think this is the right solution?

A. Yes
Incorrect.
B. No
Correct!
16

You are working for an organization as a data architect. You have an Azure SQL Data Warehouse where you decide to import data. There is a dimension table with around 200 rows named as Manufacturer. You want to import that table. 100 kilobytes (KB) is the size of the table. Same postal code is shared by 90 percent of the manufacturers. This table will be used in joins for most queries. You are required to come up with a partitioning strategy for the table. Solution: You use a replicated table. Do you think this is the right solution?

A. No
Incorrect.
B. Yes
Correct!
17

You are working for an organization as a data architect. You have an Azure SQL Data Warehouse where you decide to import data. There is a dimension table with around 200 rows named as Manufacturer. You want to import that table. 100 kilobytes (KB) is the size of the table. Same postal code is shared by 90 percent of the manufacturers. This table will be used in joins for most queries. You are required to come up with a partitioning strategy for the table. Solution: You use a hash-distributed table with the column that represents the postal code. Do you think this is the right solution?

A. No
Correct!
B. Yes
Incorrect.
18

You are working for an organization as a data architect. You have an Azure SQL Data Warehouse where you decide to import data. There is a dimension table with around 200 rows named as Manufacturer. You want to import that table. 100 kilobytes (KB) is the size of the table. Same postal code is shared by 90 percent of the manufacturers. This table will be used in joins for most queries. You are required to come up with a partitioning strategy for the table. Solution: You use round-robin distribution. Do you think this is the right solution?

A. Yes
Incorrect.
B. No
Correct!
19

Which of the following data store option is most suitable to general vehicle data for buses and transit trains?

A. Azure Storage blobs
Incorrect.
B. Cosmos DB
Incorrect.
C. HBase in HDlnsight
Correct!
D. Azure SQL Database
Incorrect.
20

You are required to make sure that rider data is structured in a way that is meets file size and processing requirements. Identify which of the following would you use?

21

You are required to make sure rider data meets the retention requirements. There must be minimum effort in implementation of the solution. What would be your recommendation?

22

You want to store initial inventory data for which you need to design a solution. Identify the resource you would use.

A. Event Hub
Incorrect.
B. Azure SQL Data Warehouse
Incorrect.
C. Azure Data Lake
Correct!
D. Power BI
Incorrect.
23

In order to analyze the inventory data on its arrival, you are required to design a solution. What solution would that be?

A. Azure Databricks
Correct!
B. IOT Hub
Incorrect.
C. Azure Data Lake Analytics
Incorrect.
D. Power BI
Incorrect.
24

You want to store data for long-term. Which of the following resources would you use?

A. Azure Data Lake
Incorrect.
B. Azure Data Lake
Incorrect.
C. Azure SQL Database
Incorrect.
D. Azure SQL Data Warehouse
Correct!
25

Which of the following would help you design a solution that might help data engineers to visualize the data?

A. Stream Analytics
Incorrect.
B. Power BI
Incorrect.
C. Azure Data Lake
Incorrect.
D. Azure Databricks
Correct!
26

Which of the following would you use if you want a solution that will allow business stakeholders to visualize the data?

A. Azure Data Lake
Incorrect.
B. Stream Analytics
Incorrect.
C. Azure Databricks
Incorrect.
D. Power BI
Correct!
27

You use Azure Stream Analytics to design a real-time processing solution. There are IoT sensors installed in the driverless vehicles and you are tasked to ingest data from those sensors. You also need to support a 200 MB reference data input to correlate related static values. Solution: For stream data input you use Azure Event Hubs and for reference input you use Azure SQL Database. Do you think this is the right solution?

A. No
Incorrect.
B. Yes
Correct!
28

You use Azure Stream Analytics to design a real-time processing solution. There are IoT sensors installed in the driverless vehicles and you are tasked to ingest data from those sensors. You also need to support a 200 MB reference data input to correlate related static values. Solution: For stream data input you use Azure Event Hubs and for reference input you use Azure Blob Storage. Do you think this is the right solution?

A. No
Incorrect.
B. Yes
Correct!
Product Image

Sample Question - Microsoft Designing an Azure Data solution (DP-201)

Practice Exam

Learning Style

Beginner

Difficulty

Course Info

Download PDF

Certificate

See Sample

Buy Individually Timezone
tab
Courses Offered In This Certification

You have already taken demo for this course.

If you want to get access to demo again, feel free to contact our support at (855) 800-8240

Outline

More Information

More Information
Lab Access No
Learning Type Practice Exam
Difficulty Beginner
Language English

Reviews

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

click here