Exam 70-761 All Questions

View all questions & answers for the 70-761 exam

Exam 70-761 topic 1 question 86 discussion

Actual exam question from Microsoft's 70-761

Question #: 86
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a table that was created by running the following Transact-SQL statement:

The Products table includes the data shown in the following table:

TotalUnitPrice is calculated by using the following formula:
TotalUnitPrice = UnitPrice * (UnitsInStock + UnitsOnOrder)
You need to ensure that the value returned for TotalUnitPrice for ProductB is equal to 600.00.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️
ISNULL ( check_expression , replacement_value )
Arguments:
check_expression
Is the expression to be checked for NULL. check_expression can be of any type. replacement_value
Is the expression to be returned if check_expression is NULL. replacement_value must be of a type that is implicitly convertible to the type of check_expresssion.
References:
https://docs.microsoft.com/en-us/sql/t-sql/functions/isnull-transact-sql

by anonimdom at Jan. 14, 2020, 10:28 a.m.

Comments

Submit Cancel

pabitrasharma

4 years, 6 months ago

The NULL value in the UnitsOnOrder field would cause a runtime error. Correct Answer Is B

upvoted 2 times

BabyBee

4 years, 5 months ago

I gave a thumb up when I meant to reply. Answer is correct A. ISNULL function is going to replace that NULL for a 0. ( some number + 0 = some number), so no error.

upvoted 1 times

...

CristianCruz

4 years, 9 months ago

You need to ensure that the value returned for TotalUnitPrice for ProductB is equal to 600.00 PRODUCTB IS EQUAL TO 600.00 Answer is A

upvoted 1 times

...

stm22

4 years, 10 months ago

that is no aggregation; it's just math

upvoted 3 times

...

Simmipeach

5 years, 1 month ago

Why is there no group by clause when there's an aggregation?

upvoted 3 times

...

anonimdom

5 years, 3 months ago

But here is no any comparison with 600. It calculates the totals but doesn't check if it is equal to 600.