PrepAway - Latest Free Exam Questions & Answers

Which option should you include?

You plan to create a new table that has the following requirements:
Uses a GUID data type as the primary key.
Uses a clustered index as the primary key.
Minimizes fragmentation.
You need to recommend which option to include in the CREATE statement.
Which option should you include?
More than one answer choice may achieve the goal. Select the BEST answer.

PrepAway - Latest Free Exam Questions & Answers

A.
NEWID

B.
@@IDENTITY

C.
NEWSEQUENTIALID

D.
IDENTITY

Explanation:
The NEWSEQUENTIALID function creates a GUID that is greater than any GUID previously generated by this
function on a specified computer since Windows was started. After restarting Windows, the GUID can startagain from a lower range, but is still globally unique. When a GUID column is used as a row identifier, using
NEWSEQUENTIALID can be faster than using the NEWID function. This is because the NEWID function
causes random activity and uses fewer cached data pages. Using NEWSEQUENTIALID also helps to
completely fill the data and index pages.
https://docs.microsoft.com/en-us/sql/t-sql/functions/newsequentialid-transact-sql

One Comment on “Which option should you include?


Leave a Reply