Microsoft Exam DP-420 Topic 15 Question 43 Discussion

Actual exam question for Microsoft's DP-420 exam

Question #: 43
Topic #: 15

[All DP-420 Questions]

You have an Azure Cosmos DB Core (SQL) API account.

You run the following query against a container in the account.

SELECT

IS_NUMBER("1234") AS A,

IS_NUMBER(1234) AS B,

IS_NUMBER({prop: 1234}) AS C

What is the output of the query?

A[{'A': false, 'B': true, 'C': false}]

B[{'A': true, 'B': false, 'C': true}]

C[{'A': true, 'B': true, 'C': false}]

D[{'A': true, 'B': true, 'C': true}]

Show Suggested Answer

Suggested Answer: B

by Daron at Jul 06, 2024, 08:31 AM

Limited Time Offer

25%

Off

Get Premium DP-420 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Donette

3 days ago

Hmm, this question is really testing our understanding of JSON and data types. I'm gonna go with option D just to see what happens. Who knows, maybe the Azure Cosmos DB API has some surprises up its sleeve!

upvoted 0 times

...

Anglea

9 days ago

Aha! I know this one. The IS_NUMBER function returns true if the input is a valid number, and false otherwise. Let's see, the first one is a string, the second one is a number, and the third one is an object with a numeric property. Gotta be option C!

upvoted 0 times

...