Exam 70-762 topic 1 question 59 discussion

Actual exam question from Microsoft's 70-762

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

by Martiniis at Oct. 8, 2020, 4:40 a.m.

Comments

Submit Cancel

SoupDJ

Highly Voted 4 years, 7 months ago

For what it's worth - when a precision for seconds is not specified (as here), the default is 7 digits of nanoseconds; the question requires no fractional seconds - so the answer would be B for that reason as well.

upvoted 11 times

...

Martiniis

Most Recent 4 years, 8 months ago

This answer is B just because misspelled word? But 'datetimeoffset' is appropriate.

upvoted 1 times

kiri2020

4 years, 7 months ago

no, it has to be datetimeoffset(0)

upvoted 7 times

...