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 are a data architect for a grocery delivery company. The development team is building an app that allows grocery stores to delivery groceries. Individual grocery stores sell different types of grocery products. You want to implement a solution that does not restrict the product attributes that are used by each grocery store. You want to access product information by using OData queries. You need to create the appropriate data store. Solution: You create an Azure table. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
2

You are a data architect for a grocery delivery company. The development team is building an app that allows grocery stores to delivery groceries. Individual grocery stores sell different types of grocery products. You want to implement a solution that does not restrict the product attributes that are used by each grocery store. You want to access product information by using OData queries. You need to create the appropriate data store. Solution: You create an Azure Cosmos DB account with the Table API. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
3

You are a data architect for a grocery delivery company. The development team is building an app that allows grocery stores to delivery groceries. Individual grocery stores sell different types of grocery products. You want to implement a solution that does not restrict the product attributes that are used by each grocery store. You want to access product information by using OData queries. You need to create the appropriate data store. Solution: You create an Azure Cosmos DB account with the Table API. Does this solution meet the goal?

A. No
Correct!
B. Yes
Incorrect.
4

You are a data architect for a grocery delivery company. The development team is building an app that allows grocery stores to delivery groceries. Individual grocery stores sell different types of grocery products. You want to implement a solution that does not restrict the product attributes that are used by each grocery store. You want to access product information by using OData queries. You need to create the appropriate data store. Solution: You create an Azure SQL Database. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
5

You need to choose the service for copying product files from the FTP server to Azure. Which service should you use?

6

You need to choose the data store that serves as the destination when copying product files from the FTP server. Which data source should you choose?

7

You need to choose the data source for the final product data. Which data source should you choose?

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

You need to design the partition distribution scheme for the Product table. Which scheme should you use?

9

You need to design the partition distribution scheme for the Vendor table. Which scheme should you use?

10

You need to recommend a solution to implement the components that transform data from merchant-specific formats. What should you use?

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

You are a data architect for your company. Your company manages data from customers all over the world. Each customer supplies your company with data in a variety of formats. Your company must transform the data after it receives it. The total size of all customer data is under one pebibyte (PiB). You need to recommend a data storage solution for customer data. Solution: You recommend Azure Table storage. Does this solution meet the goal?

A. Yes
Incorrect.
B. No
Correct!
12

You are a data architect for your company. Your company manages data from customers all over the world. Each customer supplies your company with data in a variety of formats. Your company must transform the data after it receives it. The total size of all customer data is under one pebibyte (PiB). You need to recommend a data storage solution for customer data. Solution: You recommend Azure Blob storage. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
13

You are a data architect for your company. Your company manages data from customers all over the world. Each customer supplies your company with data in a variety of formats. Your company must transform the data after it receives it. The total size of all customer data is under one pebibyte (PiB). You need to recommend a data storage solution for customer data. Solution: You recommend Azure Data Lake. Does this solution meet the goal?

A. No
Incorrect.
B. Yes
Correct!
14

You are designing an HDlnsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. The application design specifies the following requirements: • Azure Active Directory (Azure AD) multi-factor authentication (MFA) • Access control through POSIX permissions • Support for auditing through diagnostics logging • Automatic data encryption before persistent storage You need to configure your solution to optimize storage performance. Solution: You batch process files into file sizes of at least 256 MB before writing to Data Lake Storage Gent. Does this solution meet the goal?

A. Yes
Correct!
B. No
Incorrect.
15

You are designing an HDInsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. The application design specifies the following requirements: • Azure Active Directory (Azure AD) multi-factor authentication (MFA) • Access control through POSIX permissions • Support for auditing through diagnostics logging • Automatic data encryption before persistent storage You need to configure your solution to optimize storage performance. Solution: You preprocess files to ensure that they are smaller than 256 MB before writing to Data Lake Storage Gent. Does this solution meet the goal?

A. Yes
Incorrect.
B. No
Correct!
16

You are designing an HDlnsight application with a clustered Apache Hadoop file system that uses Azure Data Lake Gerd storage. The application design specifies the following requirements: • Azure Active Directory (Azure AD) multi-factor authentication (MFA) • Access control through POSIX permissions • Support for auditing through diagnostics logging • Automatic data encryption before persistent storage You need to configure your solution to optimize storage performance. Solution: You implement compaction jobs to combine smaller files into files that are 2 GB in size or larger. Does this solution meet the goal?

A. Yes
Incorrect.
B. No
Correct!
17

You are a data architect for your company. You plan to import data into Azure SQL Data Warehouse. You want to import a dimension table named Manufacturer that has about 200 rows. The size of the table is about 100 kilobytes (KB). 90 percent of the manufacturers are located in the same postal code. This table will be used in joins for most queries. You need to recommend the partitioning strategy for the table. Solution: You use a replicated table. Does this solution meet the goal?

A. No
Incorrect.
B. Yes
Correct!
18

You are a data architect for your company. You plan to import data into Azure SQL Data Warehouse. You want to import a dimension table named Manufacturer that has about 200 rows. The size of the table is about 100 kilobytes (KB). 90 percent of the manufacturers are located in the same postal code. This table will be used in joins for most queries. You need to recommend the partitioning strategy for the table. Solution: You use a hash-distributed table with the column that represents the postal code. Does this solution meet the goal?

A. No
Correct!
B. Yes
Incorrect.
19

You are a data architect for your company. You plan to import data into Azure SQL Data Warehouse. You want to import a dimension table named Manufacturer that has about 200 rows. The size of the table is about 100 kilobytes (KB). 90 percent of the manufacturers are located in the same postal code. This table will be used in joins for most queries. You need to recommend the partitioning strategy for the table. Solution: You use round-robin distribution. Does this solution meet the goal?

A. Yes
Incorrect.
B. No
Correct!
20

You need to select a data store option best suited to general vehicle data for buses and transit trains. What should you choose?

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

You need to choose an Azure Table storage redundancy option that meets Companyl's requirements.

22

You need to ensure that rider data is structured to meet file size and processing requirements. What should you use?

23

You need to ensure that retention requirements are met for the rider data. Management effort to implement the solution should be minimized. What should you recommend?

24

You need to design a solution for storing the initial inventory data. Which resource should you use?

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

You need to design a solution for analyzing the inventory data when it arrives.

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

You need to design a solution for storing the data long-term. Which resource should you use?

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

You need to design a solution to allow data engineers to visualize the data. What should you use?

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

You need to design a solution to allow business stakeholders to visualize the data. What should you use?

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

You are designing a real-time processing solution using Azure Stream Analytics. You need to ingest data from loT sensors installed in driverless vehicles. You also need to support a 200 MB reference data input to correlate related static values. Solution: You use Azure Event Hubs for stream data input and Azure SQL Database for reference input. Does this solution meet the goal?

A. No
Incorrect.
B. Yes
Correct!
30

You are designing a real-time processing solution using Azure Stream Analytics. You need to ingest data from loT sensors installed in driverless vehicles. You also need to support a 200 MB reference data input to correlate related static values. Solution: You use Azure Event Hubs for stream data input and Azure Blob Storage for reference input.

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