A reporting application queries a Cosmos DB container partitioned by region. The query needs to calculate a discounted price for each product based on a discount percentage stored in the product document. The calculation is used in multiple queries across the application. You need to implement this calculation in a reusable way. What should you do?

Create a stored procedure that calculates the discounted price and returns the results to the client.

Create a pre-trigger that calculates the discounted price and stores it in the document.

Use the Cosmos DB SDK to calculate the discounted price in the client application after retrieving the documents.

Create a user-defined function that calculates the discounted price and use it in the SELECT clause of queries.

Which of the following best describes the structure of a stored procedure in Azure Cosmos DB for NoSQL?

A JavaScript function that is registered on a container and can accept parameters

A server-side script that runs automatically before every read operation

A SQL query stored in the database that can be executed by name

A JSON document that contains a list of operations to be applied to a container

How is a user-defined function referenced in a SQL query?

Using the udf. prefix followed by the function name

Using the fn. prefix followed by the function name

Using the sp. prefix followed by the function name

Using the function name without any prefix

Which Azure Cosmos DB SDK method is used to create a stored procedure on a container?

database.createStoredProcedure()

container.scripts.createStoredProcedure()

container.storedProcedures.add()

Microsoft Certified:Azure Cosmos DB Developer Specialty

Domain 1Objective 7

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

Part of the Design and implement data models domain, which makes up ~45% of our current practice bank. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~18–29 in this domain), expect 3–4 from this objective — we provide 24 practice questions to prepare you well beyond it. (estimate)

24questions here

5free pages

9concepts

Questions 1–5

1application · medium
A reporting application queries a Cosmos DB container partitioned by region. The query needs to calculate a discounted price for each product based on a discount percentage stored in the product document. The calculation is used in multiple queries across the application. You need to implement this calculation in a reusable way. What should you do?
Select an answer first
2foundation · easy
Which of the following best describes the structure of a stored procedure in Azure Cosmos DB for NoSQL?
Select an answer first
3foundation · easy
When deploying a stored procedure to Azure Cosmos DB, where is the stored procedure registered?
Select an answer first
4foundation · easy
How is a user-defined function referenced in a SQL query?
Select an answer first
5foundation · easy
Which Azure Cosmos DB SDK method is used to create a stored procedure on a container?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-420

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-420” is a trademark of its owner, used for identification only.

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

Questions 1–5

Which of the following best describes the structure of a stored procedure in Azure Cosmos DB for NoSQL?

When deploying a stored procedure to Azure Cosmos DB, where is the stored procedure registered?

How is a user-defined function referenced in a SQL query?

Which Azure Cosmos DB SDK method is used to create a stored procedure on a container?

Keep studying — Design and implement data models