Exam 70-461 topic 1 question 59 discussion

Actual exam question from Microsoft's 70-461

Question #: 59
Topic #: 1

You develop a Microsoft SQL Server database that contains a table named Customers. The Customers table has the following definition:

You need to create an audit record only when either the MobileNumber or HomeNumber column is updated.
Which Transact-SQL query should you use?

A. CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF COLUMNS_UPDATED (HomeNumber, MobileNumber) - - Create Audit Records
B. CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF EXISTS(SELECT HomeNumber from inserted) OR EXISTS (SELECT MobileNumber FROM inserted) - - Create Audit Records
C. CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF COLUMNS_CHANGED (HomeNumber, MobileNumber) - - Create Audit Records
D. CREATE TRIGGER TrgPhoneNumberChange ON Customers FOR UPDATE AS IF UPDATE (HomeNumber) OR UPDATE (MobileNumber) - - Create Audit Records

Show Suggested Answer

Suggested Answer: D 🗳️
Reference:
http://msdn.microsoft.com/en-us/library/bb510663.aspx
http://msdn.microsoft.com/en-us/library/ms186329.aspx

by designsfactory at April 4, 2025, 11:08 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!