Microsoft
70-451 · Question #95
You are designing a table to store date and time information for an application. The application will be used by users in Europe, Asia, and North America. You need to add a column that stores the…
The correct answer is D. a datetimeoffset data type. See the full explanation below for the reasoning.
Question
You are designing a table to store date and time information for an application. The application will be used by users in Europe, Asia, and North America. You need to add a column that stores the date and time information for all users. The column must contain information that can be used to identify the users' local time zone. What should you include in the design?
Options
- Aa sysdatetimeoffset function
- Ba getutcdate function
- Ca datetime2 data type
- Da datetimeoffset data type
How the community answered
(42 responses)- A5% (2)
- B7% (3)
- C14% (6)
- D74% (31)
Community Discussion
No community discussion yet for this question.