Exam 70-761 topic 1 question 87 discussion

Actual exam question from Microsoft's 70-761

Question #: 87
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 🗳️
COALESCE evaluates the arguments in order and returns the current value of the first expression that initially does not evaluate to NULL.
References:
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql

by Vanesa30 at March 21, 2020, 8:35 p.m.

Comments

Submit Cancel

Vanesa30

5 years, 2 months ago

yes, as well ISNULL as COALESCE function meet the same functionalities, but colaesce acepts, more than 2 parameteres and evaluate the first value then the second ,if the first one is NULL and so on.

upvoted 4 times

Michael93

4 years, 9 months ago

Yes, but in the exam I'd be sure to choose B because the column "UnitsOnOnrder" is not spelled correctly. Which leaves me very uncertain as to whether I should be ignoring such mistakes or giving them the benefit of the doubt

upvoted 1 times

...