Free Microsoft Certified: Azure Cosmos DB Developer SpecialtyPractice Test

You are designing a data model for an e-commerce application using Azure Cosmos DB for NoSQL. Each order contains customer information, multiple line items, and shipping details. Orders are always queried and displayed together with all their details. What data modeling approach should you implement?

Your application stores IoT sensor data in Azure Cosmos DB with a partition key of /deviceId. You notice that device 'sensor-001' generates 10x more data than other devices, causing hot partition issues. What is the BEST solution to resolve this?

You need to implement optimistic concurrency control for updating documents in Azure Cosmos DB. Which approach should you use?

Your company needs to migrate data from an on-premises MongoDB database to Azure Cosmos DB for MongoDB. The database is 500 GB with minimal downtime requirements. Which migration approach should you recommend?

You are querying Azure Cosmos DB and notice high RU consumption. The query filters on multiple properties but only one property is indexed. What should you do to optimize query performance?

You have a multi-region Azure Cosmos DB account configured with Strong consistency. Users in remote regions report slow write performance. The application requires that reads always return the most recently committed write. What should you do to improve performance while meeting the requirement?

Your application uses the Azure Cosmos DB SDK to perform bulk operations. You need to maximize throughput for inserting 1 million documents. Which SDK feature should you enable?

You need to implement a change feed processor to react to changes in an Azure Cosmos DB container. The processor should track progress and support multiple consumers for parallel processing. What components are required?

Your Azure Cosmos DB container uses a hierarchical partition key with /tenantId as the first level and /userId as the second level. A query filters by tenantId only. What is the expected behavior?

You are implementing a solution where users can query data by either email or username. Your Cosmos DB container has a partition key of /userId. What is the BEST approach to enable efficient lookups by both fields?

Your application experiences variable workload patterns with traffic spikes during business hours. Which throughput provisioning model should you implement to optimize costs?

You need to execute a complex transaction that updates multiple documents within the same logical partition in Azure Cosmos DB for NoSQL. What approach should you use?

Your Azure Cosmos DB account is configured with multi-region writes. Two users simultaneously update the same document in different regions with Eventual consistency. What conflict resolution occurs by default?

You are implementing Azure Functions that trigger on Cosmos DB change feed. The function occasionally fails due to transient errors. What should you implement to ensure no changes are lost?

Your application queries frequently use ORDER BY on a property that is not the partition key. Query costs are high. What indexing optimization should you implement?

You need to design a data model for a social media application where users have posts, and posts have comments. Posts are frequently viewed with their comments, but users' post lists are also queried. Comments can number in the thousands per post. What is the BEST data modeling approach?

Your multi-region Cosmos DB account has four regions. You need to ensure that the application can tolerate a complete region failure for writes while minimizing write latency. What configuration should you use?

You are implementing a query that needs to return aggregated results across multiple partitions. The query uses GROUP BY with COUNT. How can you optimize this query?

You need to integrate Azure Cosmos DB with Azure Synapse Analytics for analytical queries without impacting operational workload performance. What feature should you enable?

Your application reads a document, performs a calculation based on its current value, and writes the updated document. Under high concurrency, some updates are lost. You need to ensure all updates are applied. What pattern should you implement?