You are a database developer for a retail application. You create a database by using SQL
Server 2008 in a distributed enterprise environment that has multiple servers. The same
database is implemented on all the servers. The database contains a table that has a
surrogate key. You need to ensure that the following requirements are met: ·The surrogate
key is unique across all servers. ·The index on the surrogate key is not fragmented because
of INSERT operations. What should you do?
A.
Use the bigint data type. Use the IDENTITY property in the column definition.
B.
Use the uniqueidentifier data type. Use the NEWID() function in a default constraint.
C.
Use the timestamp data type.
D.
Use the uniqueidentifier data type. Use the NEWSEQUENTIALID() function in a default
constraint.