ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-761 All Questions

View all questions & answers for the 70-761 exam
Go to Exam

Exam 70-761 topic 1 question 36 discussion

Actual exam question from Microsoft's 70-761
Question #: 36
Topic #: 1
[All 70-761 Questions]

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a table named Products that contains information about the products that your company sells. The table contains many columns that do not always contain values.
You need to implement an ANSI standard method to convert the NULL values in the query output to the phrase "Not Applicable".
What should you implement?

  • A. the COALESCE function
  • B. a view
  • C. a table-valued function
  • D. the TRY_PARSE function
  • E. a stored procedure
  • F. the ISNULL function
  • G. a scalar function
  • H. the TRY_CONVERT function
Show Suggested Answer Hide Answer
Suggested Answer: F 🗳️
The ISNULL function replaces NULL with the specified replacement value.
References:
https://msdn.microsoft.com/en-us/library/ms184325.aspx
by Minh at May 20, 2019, 7:24 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Karoljis
Highly Voted 5 years, 6 months ago
COALESCE is standard.
upvoted 28 times
...
Minh
Highly Voted 5 years, 6 months ago
but ISNULL is not a standard sql function
upvoted 16 times
...
Billybob0604
Most Recent 3 years, 11 months ago
This must be wrong. COALESCE is the ANSI standard
upvoted 1 times
...
Andy7622
4 years ago
ISNULL isn't ANSI. Must be COALESCE()
upvoted 2 times
...
TheDUdeu
4 years, 4 months ago
Coalesce is the correct answer ISNULL is T-SQL.
upvoted 2 times
...
julie2020
4 years, 4 months ago
Correct answer: A COALESCE evaluates the arguments in order and returns the current value of the first expression that initially doesn't evaluate to NULL. Incorrect Answer: F ISNULL is not a ANSI standard function. The COALESCE function is preferred.
upvoted 2 times
...
okus
4 years, 5 months ago
Yea its coalesce
upvoted 1 times
...
supermario
4 years, 9 months ago
COALESCE
upvoted 6 times
...
safiullah
5 years, 3 months ago
Option A as COALESCE is the ANSI standard function. https://docs.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql?view=sql-server-2017
upvoted 15 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago