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?

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!
PDP Url

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
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 AccessNo
Learning TypePractice Exam
DifficultyBeginner
LanguageEnglish

Reviews

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

This Subscription Includes:

Information
Virtual instructor Led

Virtual Classroom Courses

Our virtual instructor-led courses give you access to live instructors training you with other live students in a virtual classroom environment.

200+ Virtual Classroom Courses
Information
Self-Paced

Online Self-Paced Courses

Take self-paced online courses at your convenience and own pace, with unlimited access to courses in various emerging technologies.

700+ Self-Paced Courses
Information
College

E-books blogs, case studies, ariticles

As part of informal learning, our platform will recommend E-books, whitepapers, case studies, articles, and videos. This is AI curated content closely aligned with your learning objectives.

E-books blogs, case studies,...
Information
College

College Accredited Courses

QuickStart courses are accredited by several top schools and universities, including Texas A&M and University of Phoenix. You can print out certificates and also apply them towards your degree plan with them.

College Accredited
Information
Dashboard

Full Learning Dashboard & Analytics

Access all your enrolled, completed, course statistics, and community discussions from one centralized and intuitive learning dashboard with built in analytics, course tracking, time spent, and more.

Analytics/Reporting
Information
Social

QuickStart Discussions

Engage with other learners where you can directly chat, ask questions, and socialize with other learners experts and instructors on a course subject.

Community Access Community Access
Information
Labs

Virtual Labs

Videos and lectures only go so far. Get real world, hands-on practice with virtual labs (not available for all courses).

Virtual Labs Virtual Labs
Information
Live Instructor Support

Live Instructor Mentoring & Support

Get your IT problems solved through a community of mentors, experts and peers. Get live help from experts to answer questions on course material or guidance on a project.

Mentoring & Discussions Mentoring & Discussions
Information
Dashboard

Career Paths

Start a learning pathway towards understanding and mastering your career. With QuickStart career paths, you can fully understanding and being the best in your field.

Learning Paths Learning Paths
Information
Dashboard

Informal Learning

Access to AI curated content from various content publishers which can help in self-directed learning.

Informal Learning Informal Learning
click here