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

Floyd

4 days ago

No problem, happy to help.

upvoted 0 times

...

Tonja

5 days ago

That makes sense, thanks for explaining.

upvoted 0 times

...

Floyd

6 days ago

Because the IS_NUMBER function will return true for a number and false for a string, so option B makes sense.

upvoted 0 times

...

Jill

7 days ago

Wait, is the query supposed to check if the input is a number? That's too easy, I was expecting something more complex.

upvoted 0 times

...

Tonja

8 days ago

Why do you think it's option B?

upvoted 0 times

...

Floyd

10 days ago

I disagree, I believe the correct answer is option B.

upvoted 0 times

...

Tonja

16 days ago

I think the output of the query is option A.

upvoted 0 times

...