Exam 70-762 topic 1 question 60 discussion

Actual exam question from Microsoft's 70-762

Question #: 60
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
Your company has employees in different regions around the world.
You need to create a database table that stores the following employee attendance information:
✑ Employee ID
✑ date and time employee checked in to work
✑ date and time employee checked out of work
Date and time information must be time zone aware and must not store fractional seconds.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
Datetime2 stores fractional seconds.
Datetime2 defines adate that is combined with a time of day that is based on 24-hour clock. datetime2 can be considered as an extension of the existing datetime type that has a larger date range, a larger default fractional precision, and optional user-specified precision.
References:
https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime2-transact-sql?view=sql-server-2017 https://msdn.microsoft.com/en-us/library/bb677335.aspx

by Barbedx at Jan. 12, 2021, 4:35 p.m.

Comments

Submit Cancel

Barbedx

4 years, 5 months ago

correct, datetime2 not contains timezone

upvoted 4 times

...