Posted by: Pdfprep
Post Date: November 11, 2020
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