You work as a Database Administrator (DBA) for a company named ABC.com. The company has
a Windows Azure subscription. The company uses a cloud-based SQL Server environment
hosted on SQL Azure.
You have a database named ABC-DB1. The database contains a table named Entries and a table
named Updates. The Updates table is used for auditing purposes.
You want the Updates table to be automatically updated every time a new row is added to the
Entries table.
What is the best way to achieve this?
A.
By configuring a NOT NULL constraint.
B.
By configuring a CHECK constraint.
C.
By configuring a Data Manipulation Language (DML) trigger
D.
By configuring a Data Definition Language (DDL) trigger
Explanation: