Exam 70-464 topic 1 question 74 discussion

Actual exam question from Microsoft's 70-464

Question #: 74
Topic #: 1

You have a table named Table1 that stores customer data.
Each customer has a credit limit that can only be discovered by querying multiple tables.
You need to ensure that the value of the credit limit is returned by executing a query on Table1.
What should you create?

A. A trigger that uses a ranking function
B. A trigger that uses a table-valued function
C. A calculated column that uses a table-valued function
D. A calculated column that uses a scalar function

Show Suggested Answer

Suggested Answer: C 🗳️

by mpierce at Dec. 24, 2019, 8:35 p.m.

Comments

Submit Cancel

Zikato

4 years, 4 months ago

IMHO computed column cannot use a table-valued function. So scalar should be correct (even though not recommended)

upvoted 2 times

...

Luzix

4 years, 6 months ago

#Table --> If created inside a stored procedure they are destroyed upon completion of the stored procedure. You can use the D but there will be DECLARE @TABLE_NAME TABLE

upvoted 1 times

...

mpierce

5 years, 4 months ago

Even though returns a scalar value, cannot read from other tables if a scalar value function...only table value functions can read from other tables

upvoted 1 times

...

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam

Exam 70-464 topic 1 question 74 discussion

Comments

Zikato

Luzix

mpierce

SY0-701