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.