gs gs116 Monitoring and Auditing - SQL Server Schema Audit - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Monitoring and Auditing. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 2: Point out the correct statement.
You can use Source control to audit schema changes
The SQL Server Audit feature enables you to audit column level groups of events and individual events
Audit level actions encompass data manipulation languages (DML) and data definition language (DDL) operations
None of the mentioned
Question 3: Which of the following event is not intrinsically audited?
ALTER DATABASE AUDIT SPECIFICATION
CREATE SERVER AUDIT SPECIFICATION
DROP SERVER AUDIT SPECIFICATION
All of the mentioned
Question 4: Which of the following is server-level audit action group?
BACK_RESTORE_GROUP
BACKUP_RESTORE_GROUP
DB_LOGOUT_GROUP
None of the mentioned
Question 5: Point out the wrong statement.
When the query processor parameterize the query, the parameter can appear in the audit event log instead of the column values of the query
To access the triggering event we can use the EventData function in our DDL trigger
AUDIT_DATABASE_CHANGE_GROUP event is raised whenever CREATE DATABASE AUDIT is issued
None of the mentioned
Question 6: AUDIT_CHANGE_GROUP event is raised whenever any audit is _____________
Created
Modified
Delete
All of the mentioned
Question 7: __________ could potentially lead to large audit records.
DATABASE_OBJECT_ACCESS_GROUP
DATABASE_MIRRORING_LOGIN_GROUP
DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP
DATABASE_OBJECT_PERMISSION_CHANGE_GROUP
Question 8: You can use the handy event name of __________ to make sure your trigger covers all DDL events.
DDL_DATABASE_EVENTS
DDL_DATABASE_LEVEL_EVENTS
DDL_DATABASE_LEVEL
All of the mentioned
Question 9: DDL Trigger can capture the information about the EVENT that fired it by using __________ function.
EVENTDATA()
EVENT()
EVENTS()
None of the mentioned
Question 10: Which of the following database level event si raised whenever a REFERENCES permission is checked.
EXECUTE
REFERENCES
UPDATE
SELECT
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
