You work in an International company named TAKEEEN. And you’re in charge of the database of your company.

You work in an International company named TAKEEEN. And you’re in charge of the database of your company. You intend to use SQL Server 2008 to create a database in a distributed enterprise environment.
There’re multiple servers in the enterprise environment.
All the servers have the same database which contains the table that has a surrogate key.
You must make sure that:
1. the surrogate key is unique across all servers;
1. because of INSERT operations, the index on the surrogate key is not fragmented.
So what should you do to achieve this?
A. The timestamp data type should be used.
B. In a default constraint, the IDENTITY property should be used.Uniqueidentifier data type should be used.
C. In the column definition, the IDENTITY property should be used.The bigint data type should be used.
D. In a default constraint, the NEWSEQUENTIALID() function should be used.The uniqueidentifier data type should be used.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.