You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com uses a SQL Server 2005 database named Certkiller -DB01. Client information from the trading partners of Domain.com is imported into the CK_Clients table every night. You need to make certain that the client record is updated if it already exists in the CK_Clients table. However, if the record does not exist the information needs to be inserted into the CK_Clients table.
What should you do?
A.
You should create an INSTEAD OF trigger.
B.
You should create a DDL trigger.
C.
You should create a DML AFTER trigger.
D.
You should create an ALTER trigger
Explanation:
When you make use of an INSTEAD OF trigger you are able to write a job that inserts the records into the table and if the record already exists the INSTEAD of trigger will fire and execute an update of the record instead of an insert.