COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
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?
|
Change data capture
|
|
Statistics
|
|
A trigger
|
|
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.