Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Floyd
19 hours ago
No problem, happy to help.
upvoted 0 times
...
Tonja
2 days ago
That makes sense, thanks for explaining.
upvoted 0 times
...
Floyd
3 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
4 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
5 days ago
Why do you think it's option B?
upvoted 0 times
...
Floyd
7 days ago
I disagree, I believe the correct answer is option B.
upvoted 0 times
...
Tonja
13 days ago
I think the output of the query is option A.
upvoted 0 times
...

Save Cancel