You are designing a new database. The tables of the database will be replicated to multiple
offices. You need to design the tables to meet the following requirements: • A row identifier
must be set when a row is created • The row identifier must be unique across the entire
organization What should you recommend?

A.
Add a column to all the tables that have the hierarchyid data type.

B.
Add a column to all the tables that have a time data type. Configure the DEFAULT
constraint to use the GETDATE () function.

C.
Add a column to all the tables that have the identity property.

D.
Add a column to all the tables that have a uniqueidentifier data type. Configure the
DEFAULT constraint to use the NEWIDQ function.