PrepAway - Latest Free Exam Questions & Answers

What is the best way to achieve this?

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply