DP-201

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

Question 21

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?

  1. Azure Synapse Analytics
  2. Azure Blob storage
  3. Azure Data Lake Storage Gen2
  4. Azure SQL Database

Question 22

Your company is an online retailer that can have more than 100 million orders during a 24-hour period, 95 percent of which are placed between 16:30 and 17:00. All the orders are in US dollars. The current product line contains the following three item categories: ✑ Games with 15,123 items ✑ Books with 35,312 items ✑ Pens with 6,234 items You are designing an Azure Cosmos DB data solution for a collection named Orders Collection. The following documents is a typical order in Orders Collection. Orders Collection is expected to have a balanced read/write-intensive workload. Which partition key provides the most efficient throughput?

  1. Item/Category
  2. OrderTime
  3. Item/Currency
  4. Item/id

Question 23

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

  1. Increase the Request Units (RUs).
  2. Turn off indexing.
  3. Add a write region.
  4. Create unique indexes.
  5. Create compound indexes.

Question 24

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?

  1. Azure Data Lake Storage Gen2
  2. Azure Cosmos DB
  3. Azure SQL Database
  4. Azure Blob storage

Question 25

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

  1. SQL
  2. Cassandra
  3. Gremlin
  4. Table