DP-201

DP-201 practice questions, page 7 of 9, with answer review and explanations.

Question 31

You have a data model that you plan to implement in a data warehouse in Azure Synapse Analytics as shown in the following exhibit. All the dimension tables will be less than 2 GB after compression, and the fact table will be approximately 6 TB. Which type of table should you use for each table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

Question 32

You are designing a data storage solution for a database that is expected to grow to 50 TB. The usage pattern is singleton inserts, singleton updates, and reporting. Which storage solution should you use?

  1. Azure SQL Database elastic pools
  2. Azure Synapse Analytics
  3. Azure Cosmos DB that uses the Gremlin API
  4. Azure SQL Database Hyperscale

Question 33

You are designing a solution that will use Azure Table storage. The solution will log records in the following entity. You are evaluating which partition key to use based on the following two scenarios: ✑ Scenario1: Minimize hotspots under heavy write workloads. ✑ Scenario2: Ensure that date lookups are as efficient as possible for read workloads. Which partition key should you use for each scenario? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

Question 34

You have data on the 75,000 employees of your company. The data contains the properties shown in the following table. You need to store the employee data in an Azure Cosmos DB container. Most queries on the data will filter by the Current Department and the Employee Surname properties. Which partition key and item ID should you use for the container? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Select and Place:

Question 35

You need to design a data architecture to bring together all your data at any scale and provide insights into all your users through the use of analytical dashboards, operational reports, and advanced analytics. How should you complete the architecture? To answer, drag the appropriate Azure services to the correct locations in the architecture. Each service may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place: