Microsoft
98-364 · Question #35
You manage a database named Exams accessed via a website. The website is regularly accessed by users in different countries. You are redesigning a table named History that records when users have…
The correct answer is A. datetimeoffset. See the full explanation below for the reasoning.
Question
You manage a database named Exams accessed via a website. The website is regularly accessed by users in different countries. You are redesigning a table named History that records when users have purchased and taken online exams. You need one of the columns in the History table to record what time of day that a user has taken an exam. Additionally, you need this column to have time zone awareness. What data type should you use?
Options
- Adatetimeoffset
- Bdatetime
- CUse two different columns with one column of datetime, and the second column indicating the
- Ddatetime2
How the community answered
(36 responses)- A81% (29)
- B11% (4)
- C3% (1)
- D6% (2)
Community Discussion
No community discussion yet for this question.