Exam 98-364 topic 1 question 197 discussion

Actual exam question from Microsoft's 98-364

Question #: 197
Topic #: 1

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?

A. datetimeoffset
B. datetime
C. Use two different columns with one column of datetime, and the second column indicating the UTC offset.
D. datetime2

Show Suggested Answer

Suggested Answer: A 🗳️

by rogeriosolano at June 28, 2022, 3:55 p.m.

Comments

Submit Cancel

rogeriosolano

2 years, 11 months ago

Selected Answer: A

The datetimeoffset data type combines a date with a time of day that has time zone awareness. The time is based on a 24-hour clock but also includes a UTC offset. For the datetimeoffset data type, both the UTC and local datetime values will be validated during update, insert, convert, arithmetic, or assign operations. The recognition of any invalid UTC or local datetime value will result in an invalid value error. For example, the 9999-12-31 10:10:00 datetime value is valid in UTC, but it overflows in local time when the time zone offset is +13:50.

upvoted 1 times

...