You deploy a database by using SQL Server 2016. The database contains a table namedTable1.You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize the amount of custom code required.What should you recommend?

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

A	Change data capture
B	Statistics
C	A trigger
D	Master Data Services

Explanation:

Detailed explanation-1: -Best practice rules for Sql Ensure that Azure SQL database servers are accessible via private endpoints only. Ensure there is a sufficient PITR backup retention period configured for Azure SQL databases. Ensure that no SQL databases allow unrestricted inbound access from 0.0.

Detailed explanation-2: -SQL> DROP DATABASE testDB; NOTE − Be careful before using this operation because by deleting an existing database would result in loss of complete information stored in the database.

Detailed explanation-3: -Members of the sysadmin fixed server role can perform any activity in the server. Members of the serveradmin fixed server role can change server-wide configuration options and shut down the server.

There is 1 question to complete.

MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL