nerdexam
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)
  • A
    81% (29)
  • B
    11% (4)
  • C
    3% (1)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice