DP-201 exam

DRAG DROP

You need to ensure that performance requirements for Backtrack reports are met.

What should you recommend? To answer, drag the appropriate technologies to the correct locations. Each technology 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.

View Answer

Answer:

Explanation:

Box 1: Cosmos DB indexes

The report for Backtrack must execute as quickly as possible.

You can override the default indexing policy on an Azure Cosmos container, this could be useful if you want to tune the indexing precision to improve the query performance or to reduce the consumed storage.

Box 2: Cosmos DB TTL

This solution reports on all data related to a specific vehicle license plate.

The report must use data from the SensorData collection. Users must be able to filter vehicle data in the following ways:

✑ vehicles on a specific road

✑ vehicles driving above the speed limit

Note: With Time to Live or TTL, Azure Cosmos DB provides the ability to delete items automatically from a container after a certain time period. By default, you can set time to live at the container level and override the value on a per-item basis. After you set the TTL at a container or at an item level, Azure Cosmos DB will automatically remove these items after the time period, since the time they were last modified.

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.

Which type of disk should you recommend?
A . Standard SSD Managed Disk
B . Premium SSD Managed Disk
C . Ultra SSD Managed Disk

View Answer

Answer: C

Explanation:

CONT_SQL3 requires an initial scale of 35000 IOPS. Ultra SSD Managed Disk Offerings

The following table provides a comparison of ultra solid-state-drives (SSD) (preview), premium SSD, standard SSD, and standard hard disk drives (HDD) for managed disks to help you decide what to use.

References: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/disks-types

You need to recommend a security solution that meets the requirements of Health Review.

What should you include in the recommendation?
A . dynamic data masking
B . Transport Layer Security (TLS)
C . Always Encrypted
D . row-level security

View Answer

Answer: C

Explanation:

Must ensure that sensitive health data is encrypted at rest and in transit.

Always Encrypted is a feature designed to protect sensitive data stored in Azure SQL Database or SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the database engine (SQL Database or SQL Server).

References:

https://docs.microsoft.com/en-us/azure/security/fundamentals/encryption-atrest

https://docs.microsoft.com/en-us/azure/security/fundamentals/database-security-overview

DRAG DROP

You need to design the system for notifying law enforcement officers about speeding vehicles.

How should you design the pipeline? To answer, drag the appropriate services to the correct locations. 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.

View Answer

Answer:

Explanation:

Scenario:

Information about vehicles that have been detected as going over the speed limit during the last 30 minutes must be available to law enforcement officers. Several law enforcement organizations may respond to speeding vehicles.

Telemetry Capture

The telemetry capture system records each time a vehicle passes in front of a sensor.

The sensors run on a custom embedded operating system and record the following telemetry data:

– Time

– Location in latitude and longitude

– Speed in kilometers per hour (kmph)

– Length of vehicle in meters

HOTSPOT

You need to design the Planning Assistance database.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: No

Data used for Planning Assistance must be stored in a sharded Azure SQL Database.

Box 2: Yes

Box 3: Yes

Planning Assistance database will include reports tracking the travel of a single vehicle

HOTSPOT

You need to design the SensorData collection.

What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: Eventual

Traffic data insertion rate must be maximized.

Sensor data must be stored in a Cosmos DB named treydata in a collection named SensorData

With Azure Cosmos DB, developers can choose from five well-defined consistency models on the consistency spectrum. From strongest to more relaxed, the models include strong, bounded staleness, session, consistent prefix, and eventual consistency.

Box 2: License plate

This solution reports on all data related to a specific vehicle license plate. The report must use data from the SensorData collection.

References: https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels

You plan to use an Azure SQL data warehouse to store the customer data. You need to recommend a disaster recovery solution for the data warehouse.

What should you include in the recommendation?
A . AzCopy
B . Read-only replicas
C . AdICopy
D . Geo-Redundant backups

View Answer

Answer: D

Explanation:

References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/backup-and-restore

What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?
A . a server-level virtual network rule
B . a database-level virtual network rule
C . a database-level firewall IP rule
D . a server-level firewall IP rule

View Answer

Answer: A

Explanation:

Virtual network rules are one firewall security feature that controls whether the database server for your single databases and elastic pool in Azure SQL Database or for your databases in SQL Data Warehouse accepts communications that are sent from particular subnets in virtual networks.

Server-level, not database-level: Each virtual network rule applies to your whole Azure SQL Database server, not just to one particular database on the server. In other words, virtual network rule applies at the server level, not at the database-level.

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vnet-service-endpoint-rule-overview

You are designing a statistical analysis solution that will use custom proprietary Python functions on near real-time data from Azure Event Hubs.

You need to recommend which Azure service to use to perform the statistical analysis. The solution must minimize latency.

What should you recommend?
A . Azure Synapse Analytics
B . Azure Stream Analytics
C . Azure Databricks
D . Azure SQL Database

View Answer

Answer: B

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/event-hubs/process-data-azure-stream-analytics

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?
A . Azure SQL Data Warehouse
B . Azure SQL Database
C . Azure Cosmos DB that uses the SQL API
D . Azure Cosmos DB that uses the Table API

View Answer

Answer: C

Explanation:

Scenario: ADatum identifies the following requirements for the Health Interface application:

– Reduce the amount of development effort to rewrite existing SQL queries.

– Upgrade to a data storage solution that will provide flexible schemas and increased throughput for writing data. Data must be regionally located close to each hospital, and reads must display be the most recent committed version of an item.

– Reduce the amount of time it takes to add data from new hospitals to Health Interface.

– Support a more scalable batch processing solution in Azure.