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?

Question

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?

Accepted Answer

D. Use the uniqueidentifier data type.

Answer

A. Use the timestamp data type.

Answer

B. Use the bigint data type.

Answer

C. Use the uniqueidentifier data type.

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…

Question

Options

How the community answered

Community Discussion