DP-200 Practice Test

DP-200 Practice Test practice questions, page 4 of 15, with answer review and explanations.

Question 16

You are developing a solution to visualize multiple terabytes of geospatial data. The solution has the following requirements: ✑ Data must be encrypted. ✑ Data must be accessible by multiple resources on Microsoft Azure. You need to provision storage for the solution. Which four actions should you perform in sequence? To answer, move the appropriate action from the list of actions to the answer area and arrange them in the correct order. Select and Place:

Question 17

You are developing a data engineering solution for a company. The solution will store a large set of key-value pair data by using Microsoft Azure Cosmos DB. The solution has the following requirements: ✑ Data must be partitioned into multiple containers. ✑ Data containers must be configured separately. ✑ Data must be accessible from applications hosted around the world. ✑ The solution must minimize latency. You need to provision Azure Cosmos DB. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  1. Configure account-level throughput.
  2. Provision an Azure Cosmos DB account with the Azure Table API. Enable geo-redundancy.
  3. Configure table-level throughput.
  4. Replicate the data globally by manually adding regions to the Azure Cosmos DB account.
  5. Provision an Azure Cosmos DB account with the Azure Table API. Enable multi-region writes.

Question 18

A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution will have a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year. Which two factors affect your costs when sizing the Azure SQL Database elastic pools? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  1. maximum data size
  2. number of databases
  3. eDTUs consumption
  4. number of read operations
  5. number of transactions

Question 19

You are developing a solution using a Lambda architecture on Microsoft Azure. The data at rest layer must meet the following requirements: Data storage: ✑ Serve as a repository for high volumes of large files in various formats. ✑ Implement optimized storage for big data analytics workloads. ✑ Ensure that data can be organized using a hierarchical structure. Batch processing: ✑ Use a managed solution for in-memory computation processing. ✑ Natively support Scala, Python, and R programming languages. ✑ Provide the ability to resize and terminate the cluster automatically. Analytical data store: ✑ Support parallel processing. ✑ Use columnar storage. ✑ Support SQL-based languages. You need to identify the correct technologies to build the Lambda architecture. Which technologies should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

Question 20

Your company has an on-premises Microsoft SQL Server instance. The data engineering team plans to implement a process that copies data from the SQL Server instance to Azure Blob storage once a day. The process must orchestrate and manage the data lifecycle. You need to create Azure Data Factory to connect to the SQL Server instance. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place: