Implement Server-Side Programming in Azure Cosmos DB for NoSQL by Using JavaScript DP-420 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A banking application uses Azure Cosmos DB for NoSQL to store account documents. A stored procedure is used to transfer funds between two accounts that belong to the same customer. The stored procedure reads both account documents, adjusts the balances, and replaces both documents. What is the primary benefit of using a stored procedure for this operation?

   • AIt automatically retries the operation if it fails due to a conflict.
   • BIt ensures the operation is atomic and isolated within the same logical partition.
   • CIt reduces the number of network round trips by executing the logic on the server.
   • DIt allows the operation to span multiple containers and partitions.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A team is developing a .NET application that uses Azure Cosmos DB for NoSQL. They have written a stored procedure in a JavaScript file named `bulkUpdate.js`. They need to deploy this stored procedure to a container named `orders` in their development environment. Which code snippet correctly deploys the stored procedure?

   • A`await client.CreateStoredProcedureAsync("bulkUpdate", File.ReadAllText("bulkUpdate.js"));`
   • B`await container.Scripts.ReplaceStoredProcedureAsync(new StoredProcedureProperties { Id = "bulkUpdate", Body = File.ReadAllText("bulkUpdate.js") });`
   • C`await container.Scripts.CreateStoredProcedureAsync(new StoredProcedureProperties { Id = "bulkUpdate", Body = File.ReadAllText("bulkUpdate.js") });`
   • D`await container.Scripts.ExecuteStoredProcedureAsync("bulkUpdate", new PartitionKey("orders"));`
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A team is deploying a stored procedure to an Azure Cosmos DB for NoSQL container using the .NET SDK. The stored procedure already exists in the container, and the team wants to update its JavaScript code. Which method should they use?

   • A`await container.Scripts.UpsertStoredProcedureAsync(new StoredProcedureProperties { Id = "myProc", Body = newBody });`
   • B`await container.Scripts.CreateStoredProcedureAsync(new StoredProcedureProperties { Id = "myProc", Body = newBody });`
   • C`await container.Scripts.ReplaceStoredProcedureAsync(new StoredProcedureProperties { Id = "myProc", Body = newBody });`
   • D`await container.Scripts.ExecuteStoredProcedureAsync("myProc", new PartitionKey("pk"));`
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A team is designing a stored procedure for an Azure Cosmos DB for NoSQL container partitioned by `tenantId`. The stored procedure must update multiple documents that belong to the same tenant. The team is concerned about the 2-second execution time limit for stored procedures. Which approach should they take to ensure the stored procedure completes within the time limit?

   • AUse a user-defined function to perform the updates.
   • BIncrease the timeout setting on the client request to allow the stored procedure to run longer.
   • CUse a trigger instead of a stored procedure to perform the updates.
   • DUse continuation tokens within the stored procedure to process documents in batches and resume from where it left off.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is the primary purpose of a stored procedure in Azure Cosmos DB for NoSQL?

   • ATo execute server-side JavaScript logic that can perform operations on items within a single logical partition
   • BTo define a reusable query that can be used across multiple containers
   • CTo automatically transform data as it is written to the container
   • DTo manage the indexing policy of a container
   Reveal Solution Discussion Select an answer first