Free DP-420 sample questions
These free DP-420 sample questions show the correct answer and explain why it is right. They cover partition keys, indexing and the change feed in Cosmos DB for NoSQL. Use them to find gaps before you book the exam.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
A developer is using the Azure Cosmos DB for NoSQL .NET SDK. To optimize performance and resource utilization, they are implementing the recommended singleton pattern for the `CosmosClient` instance. Which of the following are key reasons why using a singleton `CosmosClient` is a critical best practice? (Select THREE)
You are migrating a large dataset from an on-premises SQL Server to an Azure Cosmos DB for NoSQL container. The migration must be completed as quickly as possible. The target container has been provisioned with 100,000 RU/s. You are using the .NET SDK's bulk support feature. After starting the migration, you observe that the write throughput is much lower than the provisioned 100,000 RU/s, and you are not receiving any throttling (429) responses. What is the most likely cause for the underutilization of provisioned throughput?
A developer is writing a JavaScript stored procedure for Azure Cosmos DB for NoSQL to create a new user document and a corresponding settings document within a single transaction. The stored procedure must ensure that either both documents are created or neither is. The partition key for the container is `/userId`. Which function from the context object (`__`) should the developer use to create the user document inside the stored procedure?
An architect is designing a solution that requires both a transactional store for a live application and an analytical store for business intelligence queries. They have enabled Azure Synapse Link on their Azure Cosmos DB for NoSQL container. A data scientist needs to query the analytical store using a serverless SQL pool in Azure Synapse Analytics. Which statement accurately describes the data synchronization process between the transactional and analytical stores? sequenceDiagram participant App as Application participant TS as Transactional Store participant AS as Analytical Store participant Synapse as Synapse Serverless SQL App->>+TS: Write/Update/Delete Operation TS-->>-App: Acknowledge loop Auto-Sync Process TS->>AS: Propagate changes end Note right of AS: Latency typically < 2 minutes Synapse->>+AS: T-SQL Query AS-->>-Synapse: Return Analytical Data
You are designing a cost-effective solution for storing user audit logs in Azure Cosmos DB for NoSQL. The logs must be retained for 90 days for compliance reasons and then automatically deleted. The volume of logs is highly unpredictable, ranging from very low to extremely high throughout the day. Queries on the logs are infrequent. Which combination of Azure Cosmos DB capacity mode and feature should you use to meet these requirements most cost-effectively?
You have an Azure Cosmos DB for NoSQL account with a container that is configured for multi-region writes. The conflict resolution policy is set to Last Writer Wins (LWW), using the default `_ts` timestamp property. An application instance in 'East US' and another in 'West Europe' simultaneously update the same document. The write from 'East US' has a timestamp of `1662402705`, and the write from 'West Europe' has a timestamp of `1662402703`. Which update will be persisted as the final version of the document?
A developer is querying a container that stores product information. Each document has a `tags` property which is an array of strings, for example: `"tags": ["electronics", "wearable", "smartwatch"]`. The developer needs to write a query that returns all documents where the `tags` array contains the string "wearable". Which built-in function is the most efficient for this purpose?
Case Study: Contoso Fitness Wearables **Company Background:** Contoso Fitness Wearables is a rapidly growing company that produces smart fitness devices. They are launching a new global cloud-native application to track user activities, store biometric data, and provide personalized health insights. The application is expected to serve millions of users across North America, Europe, and Southeast Asia. Low latency for both reads and writes is a critical success factor to ensure a responsive user experience. **Current Situation:** The development team has chosen Azure Cosmos DB for NoSQL as the primary database. They have designed a data model where each user has a document containing their profile and an embedded array of recent activities. The proposed partition key is `/userId`. The application will be deployed to Azure regions in Central US, West Europe, and Southeast Asia. **Requirements:** 1. **Global Low Latency:** Users in all three regions must experience fast read and write performance, ideally under 10ms. 2. **High Availability:** The application must be resilient to regional outages. An automatic failover mechanism is required. 3. **Data Consistency:** User profile updates (e.g., changing subscription tier) must be strongly consistent. However, activity tracking data can tolerate a few seconds of replication lag to prioritize write availability. 4. **Operational Efficiency:** The solution for handling different consistency requirements must be implemented within the application code using the SDK, without requiring separate containers for profile and activity data. **Problem:** You are the lead architect responsible for finalizing the Azure Cosmos DB configuration. You need to devise a strategy that meets all the specified requirements for latency, availability, and mixed consistency. Which configuration should you recommend?
You are analyzing query performance in your Azure Cosmos DB for NoSQL solution. You execute a query and retrieve the diagnostics, which include the query metrics. The metrics show a 'Retrieved Document Count' of 5,000 but an 'Output Document Count' of 10. What does this discrepancy indicate about the query's efficiency? flowchart LR A[Query Engine] --> B{Index Seek/Scan}; B --> C[Load 5,000 Documents]; C --> D{Apply Filter in Backend}; D --> E[Output 10 Documents]; subgraph Legend direction TB F(Retrieved Document Count = 5000) G(Output Document Count = 10) end
10 more free samples are waiting
Create a free account to unlock the whole DP-420 sample bank, or get full access to all 183 practice questions in the simulator.