MENU
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?
Suggested Answer: B
Get Premium DP-420 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
41 comments · newest first
MI
Micaela
11 months ago
Huh, I didn't expect that! Why is IS_NUMBER on a string false?
HE
Helene
11 months ago
I think C should be true since it's a number in an object.
FA
Fannie
11 months ago
Totally agree with the output being A! Makes sense.
JA
Janessa
12 months ago
Wait, I thought IS_NUMBER would return true for strings that look like numbers?
WH
Whitley
12 months ago
A is false, B is true, C is false. That's the output!
LI
Lindsay
1 year ago
I’m leaning towards option C, but I’m not completely confident about how IS_NUMBER handles different data types in Cosmos DB.
UL
Ula
1 year ago
I practiced a similar question, and I feel like IS_NUMBER({prop: 1234}) would return false because it's an object, not a number.
SO
Solange
1 year ago
I think IS_NUMBER("1234") should return true since it's a numeric string, but I could be mixing it up with other functions.
ER
Ernestine
1 year ago
I remember that IS_NUMBER checks if the value is a number type, but I'm not sure about the string input.
WA
Walton
1 year ago
I think I've got it! The key is understanding how the IS_NUMBER function handles different input types. I'll work through each part of the query and select the correct answer.
WI
Willard
1 year ago
Okay, let me break this down step-by-step. The IS_NUMBER function checks if the input is a valid number, so I'll need to consider the different data types being passed in.
CR
Cristy
1 year ago
Hmm, this looks like a tricky one. I'll need to carefully read through the question and think about how the IS_NUMBER function works in Cosmos DB.
AN
Anika
1 year ago
I'm a bit confused by the third part of the query, where it's checking a property. I'll need to double-check how that works with the IS_NUMBER function.
AN
Annamae
1 year ago
This seems like a straightforward question. I'd go with option C - modifying the correlation schedule and sensitivity to reduce the false positives.
EM
Emogene
1 year ago
Is this the Azure Cosmos DB version of 'Is it a bird? Is it a plane? No, it's Superman!'? This is too easy, I was hoping for some real cosmic-level questions.
AR
Arlene
1 year ago
User3: C) [{\'A\': true, \'B\': true, \'C\': false}]
MI
Miles
1 year ago
User2: B) [{\'A\': true, \'B\': false, \'C\': true}]
HU
Hubert
1 year ago
User1: A) [{\'A\': false, \'B\': true, \'C\': false}]
TA
Talia
1 year ago
I can't believe they're asking us to check if something is a number. Next thing you know, they'll be asking us to check if the sky is blue. But hey, at least it's an easy point on the exam.
DO
Donette
2 years 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!
DA
Dana
1 year ago
User 3
CR
Cristy
1 year ago
User 2
CA
Catarina
1 year ago
User 1
AN
Anglea
2 years 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!
HA
Hannah
1 year ago
Looks like option C is the winner here.
NI
Nicolette
1 year ago
So, A is false, B is true, and C is false in this case.
MA
Margo
1 year ago
Yeah, the IS_NUMBER function should return true for the string and number, but false for the object.
GE
Gennie
1 year ago
I think you're right, option C seems to be the correct output.
FL
Floyd
2 years ago
No problem, happy to help.
TO
Tonja
2 years ago
That makes sense, thanks for explaining.
FL
Floyd
2 years ago
Because the IS_NUMBER function will return true for a number and false for a string, so option B makes sense.
JI
Jill
2 years ago
Wait, is the query supposed to check if the input is a number? That's too easy, I was expecting something more complex.
EV
Eveline
1 year ago
I agree, I was expecting a more complex query as well.
IN
In
1 year ago
It's a simple query to check if the input is a number.
RO
Rosamond
1 year ago
User 2: I agree, it seems pretty straightforward.
CO
Cornell
2 years ago
The output will be [{'A' false, 'B' true, 'C' false}]
VA
Valentin
2 years ago
Yes, the query is checking if the input is a number.
DA
Dalene
2 years ago
User 1: Yes, the query is checking if the input is a number.
TO
Tonja
2 years ago
Why do you think it's option B?
FL
Floyd
2 years ago
I disagree, I believe the correct answer is option B.
TO
Tonja
2 years ago
I think the output of the query is option A.