DP-201 Free Questions – Designing an Azure Data Solution V10.02

1. You need to design a sharding strategy for the Planning Assistance database.

What should you recommend?

2. You need to recommend an Azure SQL Database pricing tier for Planning Assistance.

Which pricing tier should you recommend?

3. You need to design the solution for analyzing customer data.

What should you recommend?

4. You need to recommend a solution for storing customer data.

What should you recommend?

5. You need to recommend an Azure SQL Database service tier.

What should you recommend?

6. You need to recommend the appropriate storage and processing solution?

What should you recommend?

7. You need to recommend a solution that meets the data platform requirements of Health Interface. The solution must minimize redevelopment efforts for the application.

What should you include in the recommendation?

8. Which consistency level should you use for Health Interface?

9. You need to design the storage for the telemetry capture system.

What storage solution should you use in the design?

10. You need to design the solution for the government planning department.

Which services should you include in the design?

11. 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?

12. 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? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

13. 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? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

14. 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?

15. 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?

16. 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?

17. 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?

18. 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?

19. 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?

20. 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?