DP-201 exam

A company stores sensitive information about customers and employees in Azure SQL Database. You need to ensure that the sensitive data remains encrypted in transit and at rest. What should you recommend?A . Transparent Data EncryptionB . Always Encrypted with secure enclavesC . Azure Disk EncryptionD . SQL Server AlwaysOnView...

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...

HOTSPOT You need to design network access to the SQL Server data. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: 8080 1433 is the default port, but we must change it...

HOTSPOT You need to design the authentication and authorization methods for sensors. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Sensor data must be stored in a Cosmos DB named treydata in a...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

You need to design a sharding strategy for the Planning Assistance database. What should you recommend?A . a list mapping shard map on the binary representation of the License Plate columnB . a range mapping shard map on the binary representation of the speed columnC . a list mapping shard...

DRAG DROP You are designing an Azure SQL Data Warehouse for a financial services company. Azure Active Directory will be used to authenticate the users. You need to ensure that the following security requirements are met: - Department managers must be able to create new database. - The IT department...

You need to design the solution for analyzing customer data. What should you recommend?A . Azure DatabricksB . Azure Data Lake StorageC . Azure SQL Data WarehouseD . Azure Cognitive ServicesE . Azure BatchView AnswerAnswer: A Explanation: Customer data must be analyzed using managed Spark clusters. You create spark clusters...

You need to design the runtime environment for the Real Time Response system. What should you recommend?A . General Purpose nodes without the Enterprise Security packageB . Memory Optimized Nodes without the Enterprise Security packageC . Memory Optimized nodes with the Enterprise Security packageD . General Purpose nodes with the...

You need to design a backup solution for the processed customer data. What should you include in the design?A . AzCopyB . AdlCopyC . Geo-RedundancyD . Geo-ReplicationView AnswerAnswer: C Explanation: Scenario: All data must be backed up in case disaster recovery is required. Geo-redundant storage (GRS) is designed to provide...