Exam 70-764 topic 1 question 226 discussion

Actual exam question from Microsoft's 70-764

Question #: 226
Topic #: 1

You work as a Database Administrator (DBA) for a company named ABC.com.
The company uses a Microsoft SQL Server 2012 infrastructure.
You have a database named CorpDB. CorpDB contains a table named SalesInfo.
You discover that some table has been deleted from the SalesInfo table.
You are unable to find out who deleted the information.
You need to implement a solution to monitor the deletion of any further information from the SalesInfo table. You want to minimize the development effort required for the solution.
What should you configure?

A. You should configure table permissions.
B. You should configure a user role.
C. You should configure change data capture.
D. You should configure a trigger.

Show Suggested Answer

Suggested Answer: C 🗳️

by New2me123 at Oct. 6, 2020, 7:01 p.m.

Comments

Submit Cancel

New2me123

4 years, 8 months ago

I think you can user Triggers, but it's a lot more work from an Administrative point of view.

upvoted 1 times

Cococo

4 years, 7 months ago

CDC keeps track of changes but it doesn't care about WHO's done them. Trigger has.

upvoted 1 times

RohitRaj2311

4 years, 7 months ago

CDC is about DML changes. deleting table is DDL.. so its trigger for sure.

upvoted 1 times

huzein

4 years, 7 months ago

No, CDC also tracks deletions. https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver15

upvoted 1 times

Cococo

4 years, 7 months ago

Yes, you're right, CDC is picking up any data changes but it doesn't care about who is making the changes, CDC is about the data, not the audit. Read this - https://dba.stackexchange.com/questions/34079/change-data-capture-how-to-know-who-made-the-change

upvoted 1 times

...