Which two Transact-SQL functions can you use?

Posted by: Pdfprep Category: 70-761 Tags: , ,

You have a date related query that would benefit from an indexed view.

You need to create the indexed view.

Which two Transact-SQL functions can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.
A . DATEADD
B . AT TIME ZONE
C . GETUTCDATE
D . DATEDIFF

Answer: AD

Explanation:

An indexed view will accept only deterministic functions.

Incorrect Answers:

C: GETUTCDATE is not deterministic.

References: https://docs.microsoft.com/en-us/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql? view=sql-server-2017#DateandTimeFunctions

Leave a Reply

Your email address will not be published.