Microsoft
70-433 · Question #205
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…
The correct answer is D. By making use of the datetimeoffset data type. See the full explanation below for the reasoning.
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.
How the community answered
(28 responses)- B4% (1)
- C4% (1)
- D79% (22)
- E14% (4)
Community Discussion
No community discussion yet for this question.