Exam 70-761 topic 1 question 113 discussion

Actual exam question from Microsoft's 70-761

Question #: 113
Topic #: 1

You need to create a table named Sales that meets the following requirements:

Which Transact-SQL statement should you run?

A.

B.

C.

D.

E.

Show Suggested Answer

Suggested Answer: D
datetime2 Defines a date 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.
Incorrect Answers:
B, C, E: NEWQSEQUENTIALID creates a GUID that is greater than any GUID previously generated by this function on a specified computer since Windows was started. A GUID uses more space then IDENTITY value.
References:
https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime2-transact-sql https://docs.microsoft.com/en-us/sql/t-sql/functions/newsequentialid-transact-sql

by Bartek at Sept. 18, 2019, 8:42 p.m.

Comments

Submit Cancel

MML

Highly Voted 5 years, 1 month ago

Correct is D

upvoted 5 times

Anette

5 years ago

correct, its int for 4 bytes (least amount of storage) and it has the primary key doing the identifying uniquely the row data.

upvoted 2 times

...

eduardogtc

Most Recent 4 years, 9 months ago

The correct is D. Besides the fact Datetime2 is standard, you have to set primary key to ensure uniqueness: Text from (https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-ver15): Uniqueness of the value - Uniqueness must be enforced by using a PRIMARY KEY or UNIQUE constraint or UNIQUE index

upvoted 3 times

...