nerdexam
Microsoft

70-451 · Question #141

70-451 Question #141: Real Exam Question with Answer & Explanation

The correct answer is B. datetime2. See the full explanation below for the reasoning.

Question

You are designing a data storage solution for a transactional application. You need to ensure that each row in a table records the date and the time that the row was written. The time must be as precise as possible. Which data type should you use?

Options

  • ADatetime
  • Bdatetime2
  • Csmalldatetime
  • DTimestamp

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice