Exam 70-461 topic 1 question 161 discussion

Actual exam question from Microsoft's 70-461

Question #: 161
Topic #: 1

You need to build a table structure for a stored procedure to support data entry from a website form. The website form must meet the following requirements:
✑ Users must validate their age as 18 or older to use the website.
✑ Users who leave the date of birth field blank, or who enter an invalid date, must receive an error message.
Which two actions should you perform? Each correct answer presents part of the solution.

A. Add the CHECK constraint to the table structure.
B. Add the DATEPART function to the stored procedure.
C. Add the DEFAULT constraint to the table structure.
D. Add the SYSDATETIMEOFFSET function to the stored procedure.
E. Add the ISDATE function to the stored procedure.

Show Suggested Answer

Suggested Answer: DE 🗳️
SYSDATETIMEOFFSET returns a datetimeoffset(7) value that contains the date and time of the computer on which the instance of SQL Server is running.
ISDATE returns 1 if the expression is a valid date, time, or datetime value; otherwise, 0.
References:
https://msdn.microsoft.com/en-us/library/bb677334.aspx

by Dadi at April 14, 2020, 9:51 a.m.