What data type should you use?

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

How To Pass 98-364 Exam?

FULL Printable PDF and Software. VALID exam to help you PASS.

microsoft-exams

0 thoughts on “What data type should you use?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.