Note: This question is part of a series of questions that present the same scenario. Each question in this 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
I agree. datetime2 is not time-zone aware and by default the above syntax will use datetime2(7) which means 7 positions for fractional seconds