DP-201

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

Question 16

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?

  1. Queue
  2. Files
  3. Blob
  4. Table

Question 17

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?

  1. Deploy an On-premises data gateway.
  2. Add a virtual network to the Azure SQL server that hosts the database.
  3. Add an application gateway to the virtual network that contains the Azure virtual machine.
  4. Add a virtual network gateway to the virtual network that contains the Azure virtual machine.

Question 18

You are designing an application that will store petabytes of medical imaging data When the data is first created, the data will be accessed frequently during the first week. After one month, the data must be accessible within 30 seconds, but files will be accessed infrequently. After one year, the data will be accessed infrequently but must be accessible within five minutes. You need to select a storage strategy for the data. The solution must minimize costs. Which storage tier should you use for each time frame? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

Question 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?

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

Question 20

You are designing a new application that uses Azure Cosmos DB. The application will support a variety of data patterns including log records and social media relationships. You need to recommend which Cosmos DB API to use for each data pattern. The solution must minimize resource utilization. Which API should you recommend for each data pattern? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: