ExamHelpDesk

Complete list of current Q & A>>

Designing Azure Data Solution. Associate (DP-201) – Quiz

1 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You plan to store 100 GB of data used by a line-of-business (LOB) app.
You need to recommend a data storage solution for the data. The solution must meet the following requirements:
✑ Minimize storage costs.
✑ Natively support relational queries.
✑ Provide a recovery time objective (RTO) of less than one minute.
What should you include in the recommendation?

2 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are designing a big data storage solution. The solution must meet the following requirements:
✑ Provide unlimited account sizes.
✑ Support a hierarchical file system.
✑ Be optimized for parallel analytics workloads.
Which storage solution should you use?

3 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are designing an Azure Cosmos DB database that will support vertices and edges.
Which Cosmos DB API should you include in the design?

4 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You need to recommend a storage solution for a sales system that will receive thousands of small files per minute. The files will be in JSON, text, and CSV formats. The files will be processed and transformed before they are loaded into a data warehouse in Azure Synapse Analytics. The files must be stored and secured in folders.
Which storage solution should you recommend?

5 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You have a MongoDB database that you plan to migrate to an Azure Cosmos DB account that uses the MongoDB API.
During testing, you discover that the migration takes longer than expected.
You need to recommend a solution that will reduce the amount of time it takes to migrate the data.
What are two possible recommendations to achieve this goal?

6 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You need to recommend a storage solution to store flat files and columnar optimized files. The solution must meet the following requirements:
✑ Store standardized data that data scientists will explore in a curated folder.
✑ Ensure that applications cannot access the curated folder.
✑ Store staged data for import to applications in a raw folder.
✑ Provide data scientists with access to specific folders in the raw folder and all the content the curated folder.
Which storage solution should you recommend?

7 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are designing a data store that will store organizational information for a company. The data will be used to identify the relationships between users. The data will be stored in an Azure Cosmos DB database and will contain several million objects.
You need to recommend which API to use for the database. The API must minimize the complexity to query the user relationships. The solution must support fast traversals.
Which API should you recommend?

8 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are designing an application that will have an Azure virtual machine. The virtual machine will access an Azure SQL database. The database will not be accessible from the Internet.
You need to recommend a solution to provide the required level of access to the database.
What should you include in the recommendation?

9 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are designing an application. You plan to use Azure SQL Database to support the application.
The application will extract data from the Azure SQL Database and create text documents. The text documents will be placed into a cloud-based storage solution.
The text storage solution must be accessible from an SMB network share.
You need to recommend a data storage solution for the text documents.
Which Azure data storage type should you recommend?

10 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

A company stores data in multiple types of cloud-based databases.
You need to design a solution to consolidate data into a single relational database. Ingestion of data will occur at set times each day.
What should you recommend?

11 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are designing a solution for a company. The solution will use model training for objective classification.
You need to design the solution.
What should you recommend?

12 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are designing an Azure Databricks interactive cluster.
You need to ensure that the cluster meets the following requirements:
✑ Enable auto-termination
✑ Retain cluster configuration indefinitely after cluster termination.
What should you recommend?

13 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

A company manufactures automobile parts. The company installs IoT sensors on manufacturing machinery.
You must design a solution that analyzes data from the sensors.
You need to recommend a solution that meets the following requirements:
✑ Data must be analyzed in real-time.
✑ Data queries must be deployed using continuous integration.
✑ Data must be visualized by using charts and graphs.
✑ Data must be available for ETL operations in the future.
✑ The solution must support high-volume data ingestion.
Which three actions should you recommend?

14 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are designing a data processing solution that will implement the lambda architecture pattern. The solution will use Spark running on HDInsight for data processing.
You need to recommend a data storage technology for the solution.
Which two technologies should you recommend?

15 / 15

Category: Designing Azure Data Solution. Associate (DP-201)

You are evaluating data storage solutions to support a new application.
You need to recommend a data storage solution that represents data by using nodes and relationships in graph structures.
Which data storage solution should you recommend?

Your score is

0%

Scroll to Top