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

Questions 6–10

1. 6application · medium

   A finance app uses a Cosmos DB container partitioned by accountId. The app frequently queries for transactions where the amount is above a certain threshold. The threshold varies per query. You need to implement a reusable function that compares the amount to a threshold and returns a boolean. What should you do?

   • ACreate a stored procedure that takes the threshold as a parameter and returns the matching transactions.
   • BUse the Cosmos DB SDK to filter the results in the client after retrieving all transactions.
   • CCreate a user-defined function that takes the amount and threshold as parameters and returns a boolean, and use it in the WHERE clause of queries.
   • DCreate a pre-trigger that adds a boolean field to each transaction document indicating if it exceeds a fixed threshold.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the purpose of a user-defined function (UDF) in Azure Cosmos DB for NoSQL?

   • ATo automatically execute logic before or after data operations
   • BTo perform transactional operations on multiple items
   • CTo encapsulate reusable JavaScript logic that can be used in SQL queries
   • DTo manage the indexing policy of a container
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which SDK method is used to create a user-defined function on a container?

   • Acontainer.userDefinedFunctions.add()
   • Bclient.uploadUserDefinedFunction()
   • Cdatabase.createUserDefinedFunction()
   • Dcontainer.scripts.createUserDefinedFunction()
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A gaming company uses a Cosmos DB container partitioned by playerId. When a player completes a level, the app must update the player's score and insert a completion record. Both operations must be atomic. The client application is written in Node.js. What should you implement?

   • AA stored procedure that updates the player document and inserts the completion record, invoked with the playerId as the partition key.
   • BA pre-trigger that updates the player document and inserts the completion record.
   • CA user-defined function that updates the player document and inserts the completion record.
   • DTwo separate client calls: one to update the player and one to insert the completion record.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which of the following is a characteristic of user-defined functions in Azure Cosmos DB?

   • AThey are executed automatically on every write operation
   • BThey can be used to create transactions across partitions
   • CThey can perform read and write operations on items
   • DThey are stateless and cannot access the container directly
   Reveal Solution Discussion Select an answer first