Exam 70-762 topic 1 question 61 discussion

Actual exam question from Microsoft's 70-762

Question #: 61
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: A 🗳️
Datetimeoffset defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock.
Syntaxis: datetimeoffset [ (fractional seconds precision) ]
Forthe use "datetimeoffset(0)", the Fractional seconds precision is 0, which is required here.
References:
https://msdn.microsoft.com/en-us/library/bb630289.aspx

by JohnFan at March 8, 2020, 6:24 a.m.

Comments

Submit Cancel

Anette

Highly Voted 5 years ago

Correct. datetimeoffset [ (fractional seconds precision) ] fractional seconds precision = 0

upvoted 11 times

...

julie2020

Most Recent 4 years, 10 months ago

So, Answer is Yes or No?

upvoted 2 times

ArmouredxAngels

4 years, 10 months ago

The answer is definitely Yes

upvoted 5 times

Andy7622

4 years, 8 months ago

but how about that dateoffset is not aware of the time zone?

upvoted 1 times

Andy7622

4 years, 8 months ago

Sorry , It was wrong statement. Please don't consider

upvoted 2 times

...

JohnFan

5 years, 3 months ago

datetimeoffset Same as datetime2, plus includes an offset for time zone offset (does not deal with daylight saving time) (8 to 10 bytes). You should be aware that SQL Server 2016 does not support the following data types in memory-optimized tables: datetimeoffset, geography, geometry, hierarchyid, rowversion, xml, sql_variant, and user-defined types.

upvoted 1 times

...