Microsoft
70-451 · Question #141
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…
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
How the community answered
(54 responses)- A4% (2)
- B76% (41)
- C13% (7)
- D7% (4)
Community Discussion
No community discussion yet for this question.