Practice Microsoft DP-201 Exam Questions

You need to design the vehicle images storage solution. What should you recommend?

You need to design a sharding strategy for the Planning Assistance database. What should you recommend?

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

You need to recommend an Azure SQL Database pricing tier for Planning Assistance. Which pricing tier should you recommend?

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