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 a time data type. Configure the DEFAULT constraint to use the GETDATE() function.
B. Add a column to all the tables that have the identity property.
C. Add a column to all the tables that have a uniqueidentifier data type. Configure the DEFAULT constraint to use the NEWID() function.
D. Add a column to all the tables that have the hierarchyid data type.
