Which Azure Cosmos DB SQL function can be used to retrieve a nested property value when the property name is dynamic or contains special characters?

Bracket notation, e.g., c['property name']

In Azure Cosmos DB SQL, how can you construct a query that adapts to variable input values?

By using string concatenation to build the query

By using parameters in the query

A reporting app has a stored procedure that builds a SQL query string dynamically based on user-selected filters. The filters include a 'category' (string or null) and a 'minPrice' (number or null). The team needs to ensure the query is safe from SQL injection and handles null filters correctly. What should they do?

Concatenate the filter values directly into the query string.

Use JavaScript functions in the stored procedure to escape the input.

Use a separate query for each possible filter combination.

Use parameterized queries with @category and @minPrice, and use IS_NULL checks in the WHERE clause.

Microsoft Certified:Azure Cosmos DB Developer Specialty

Domain 1Objective 5

Implement Data Access by Using the SQL Language for Azure Cosmos DB for NoSQL DP-420 Practice Questions (Page 4)

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 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

11concepts

Questions 16–20

16foundation · easy
Which Azure Cosmos DB SQL function can be used to retrieve a nested property value when the property name is dynamic or contains special characters?
Select an answer first
17foundation · easy
In Azure Cosmos DB for NoSQL, which SQL keyword is used to iterate over the elements of an array within a document and return one result per element?
Select an answer first
18foundation · easy
In Azure Cosmos DB SQL, how can you construct a query that adapts to variable input values?
Select an answer first
19expert · hard
A reporting app has a stored procedure that builds a SQL query string dynamically based on user-selected filters. The filters include a 'category' (string or null) and a 'minPrice' (number or null). The team needs to ensure the query is safe from SQL injection and handles null filters correctly. What should they do?
Select an answer first
20foundation · easy
Which Azure Cosmos DB SQL clause is used to sort query results in ascending or descending order?
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 Data Access by Using the SQL Language for Azure Cosmos DB for NoSQL DP-420 Practice Questions (Page 4)

Questions 16–20

Which Azure Cosmos DB SQL function can be used to retrieve a nested property value when the property name is dynamic or contains special characters?

In Azure Cosmos DB for NoSQL, which SQL keyword is used to iterate over the elements of an array within a document and return one result per element?

In Azure Cosmos DB SQL, how can you construct a query that adapts to variable input values?

Which Azure Cosmos DB SQL clause is used to sort query results in ascending or descending order?

Keep studying — Design and implement data models