Microsoft
70-433 · Question #205
70-433 Question #205: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #205. The question stem and answer options stay visible for context.
Question
You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB01 that hosts the Sales database. The Sales database has a table named Shipping that has two columns that stored date data. You need to alter the table to be able to store a customer's local time as well as specifying the difference between the customer's local and UTC time. How would you alter the table to store this data in one column?
Options
- ABy making use of the time data type.
- BBy making use of the date data type.
- CBy making use of the text data type.
- DBy making use of the datetimeoffset data type.
- EBy making use of the smalldatetime data type.
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.