Which action should you perform?
A. Add a new index to the ID column of the Person table.
B. Add a new index to the EndDate column of the History table.
C. Create a materialized view that is based on joining data from the ActiveEmployee and History tables.
D. Create a computed column that concatenates the GivenName and SurName columns.
Answer:A
Which action should you perform?
A. Add a new index to the ID column of the Person table. B. Add a new index to the EndDate column of the History table. C. Create a materialized view that is based on joining data from the ActiveEmployee and History tables. D. Create a computed column that concatenates the GivenName and SurName columns.