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

Questions 16–20

1. 16foundation · easy

   Which of the following is a key design consideration when writing a transactional stored procedure?

   • AThe stored procedure must use the SQL API for all operations
   • BThe stored procedure must be deployed to each partition individually
   • CAll items accessed must have the same partition key value
   • DThe stored procedure must be written in C#
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A healthcare app stores patient records in a Cosmos DB container partitioned by patientId. When a new patient document is created, a timestamp field must be automatically added. You need to implement this requirement without changing the client application. What should you do?

   • AUse a user-defined function to add the timestamp during the create operation.
   • BCreate a post-trigger that adds the timestamp field after the create operation, and register it with the create operation.
   • CCreate a stored procedure that adds the timestamp and inserts the document, and call it from the client.
   • DCreate a pre-trigger that adds the timestamp field to the document before the create operation, and register it with the create operation.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A logistics company uses Azure Cosmos DB for NoSQL to track shipment statuses. A stored procedure named `updateShipmentStatus` accepts a shipmentId and a new status, and it updates the shipment document within the same logical partition. The client application needs to invoke this stored procedure and receive the updated document as the return value. Which client code snippet correctly invokes the stored procedure and retrieves the result?

   • A`container.Scripts.ExecuteStoredProcedureAsync<string>("updateShipmentStatus", new PartitionKey(shipmentId), new[] { shipmentId, newStatus })`
   • B`container.Scripts.ExecuteStoredProcedureAsync<dynamic>("updateShipmentStatus", new PartitionKey("shipments"), new[] { shipmentId, newStatus })`
   • C`client.CreateStoredProcedureAsync("updateShipmentStatus", new[] { shipmentId, newStatus })`
   • D`container.Scripts.ExecuteStoredProcedureAsync("updateShipmentStatus", new[] { shipmentId, newStatus })`
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which JavaScript method is used to create a new item in a container from within a stored procedure?

   • Acollection.insertItem()
   • Bcollection.addDocument()
   • Ccollection.createDocument()
   • Dcollection.putDocument()
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   How are triggers invoked in Azure Cosmos DB?

   • AThey are manually invoked by calling a method on the client SDK
   • BThey are automatically executed by the database engine when the associated operation occurs
   • CThey are executed only when explicitly called in a stored procedure
   • DThey are executed on a schedule defined in the trigger
   Reveal Solution Discussion Select an answer first