Exam 98-364 topic 1 question 143 discussion

Actual exam question from Microsoft's 98-364

Question #: 143
Topic #: 1

You work as a database developer for www.company.com.com.
The company has a database named www.company.com that is hosted on a SQL Server 2008 server. The database includes a table named Employees, which contains the details of the employees.
You want to ensure that anytime any data in the Employees table is modified with an UPDATE statement, they are recorded in a table named EmployeeChanges.
The EmployeeChanges table includes columns to record what the change was, who made the change, and when they made the change.
What should you create to meet this need?

A. A DDL trigger that queries the updated table
B. A DML trigger that queries the inserted table
C. A DDL trigger that queries the inserted table
D. A DML trigger that queries the updated table

Show Suggested Answer

Suggested Answer: B 🗳️

by textes at Aug. 11, 2021, 2:35 a.m.

Comments

Submit Cancel

textes

Highly Voted 3 years, 9 months ago

I think D, because youre monitoring for updates on the source table.

upvoted 5 times

Jeebs

3 years ago

There is 2 special tables, inserted and deleted which is managed by sql server for trigger purposes. This question should be referring to those 2 tables. Thus answer should be B.

upvoted 1 times

...

JamesBond

Most Recent 3 years ago

Answer is D, coz when table is modified with an UPDATE, means when the data is UPDATED not the table structure is modified or the data is INSERTED. DML statements include SELECT, INSERT, UPDATE, and DELETE only

upvoted 1 times

...