Welcome to the Monitoring and Auditing MCQs Page

Dive deep into the fascinating world of Monitoring and Auditing with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Monitoring and Auditing, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of Monitoring and Auditing, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within SQL Server.

Check out the MCQs below to embark on an enriching journey through Monitoring and Auditing. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of SQL Server.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Monitoring and Auditing. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Monitoring and Auditing MCQs | Page 1 of 10

Explore more Topics under SQL Server

01

SQL Server Basics

02

Data Modification and Constraints

03

Beyond Relational

04

Data Definition Language

05

Development with SQL Server

06

Data Connectivity

07

Enterprise Data Management

08

Data Security

09

Performance Tuning and Optimization

10

Business Intelligence and Reporting Services

Q1.

Which of the following tool is used for purpose of data auditing for SQL Server only?

ApexSQL

SQL Ninja

SQL Audit

Idera

Discuss

Answer: (a).ApexSQL

Q2.

Point out the correct statement.

The CREATE SERVER AUDIT statement is in a transaction scope

An audit must exist before deleting a server audit specification for it

To insert a server audit, principles require the ALTER ANY SERVER AUDIT or the CONTROL SERVER permission

None of the mentioned

Discuss

Answer: (a).The CREATE SERVER AUDIT statement is in a transaction scope

Q3.

Which of the following object is only available for audit actions in Create Server Audit Specification?

Audit Action Type

Object Name

Audit Name

All of the mentioned

Discuss

Answer: (b).Object Name

Q4.

Selecting the _________ option can allow unaudited activity which could violate your security policies.

Fail

Shut down

Continue

Break

Discuss

Answer: (c).Continue

Q5.

Point out the wrong statement.

Users with the ALTER ROLE permission can create server audit specifications and bind them to any audit

SQL Server audit uses Extended Events to help create an audit

You can have multiple audits per SQL Server instance

You can create one server audit specification per audit

Discuss

Answer: (a).Users with the ALTER ROLE permission can create server audit specifications and bind them to any audit

Q6.

Which of the following code creates a server audit called “HIPPA_Audit” with a binary file as the target and no options?

CREATE SERVER AUDIT HIPAA_Audit
TO SUBJECT ( FILEPATH ='\\SQLPROD_1\Audit\' );

CREATE SERVER AUDIT HIPAA_Audit
TO FILE ( FILEPATH ='\\SQLPROD_1\Audit\' );

CREATE AUDIT HIPAA_Audit
TO FILE ( FILEPATH ='\\SQLPROD_1\Audit\' );

CREATE SERVER AUDIT HIPAA
TO FILE ( FILEPATH ='\\SQLPROD_1\Audit\' );

Discuss

Answer: (b).CREATE SERVER AUDIT HIPAA_Audit
TO FILE ( FILEPATH ='\\SQLPROD_1\Audit\' );

Q7.

Which of the following code Enables the audit ‘HIPAA_Audit’?

ALTER SERVER AUDIT HIPAA_Audit
WITH (STATE ==1);

ALTER SERVER AUDIT HIPAA_Audit
WITH (STATE = OFF);

ALTER SERVER AUDIT HIPAA_Audit
WITH (STATE = ON);

None of the mentioned

Discuss

Answer: (c).ALTER SERVER AUDIT HIPAA_Audit
WITH (STATE = ON);

Q8.

Which of the following code creates database audit specification?

CREATE AUDIT SPECIFICATION Audit_Pay_Tables
FOR SERVER AUDIT Payrole_Security_Audit
ADD (SELECT , INSERT
ON HumanResources.EmployeePayHistory BY dbo )
WITH (STATE = ON) ;

CREATE DATABASE AUDIT Audit_Pay_Tables
FOR SERVER AUDIT Payrole_Security_Audit
ADD (SELECT , INSERT
ON HumanResources.EmployeePayHistory BY dbo )
WITH (STATE = ON)

CREATE DATABASE AUDIT SPECIFICATION Audit_Pay_Tables
FOR SERVER AUDIT Payrole_Security_Audit
ADD (SELECT , INSERT
ON HumanResources.EmployeePayHistory BY dbo )
WITH (STATE = ON) ;

All of the mentioned

Discuss

Answer: (c).CREATE DATABASE AUDIT SPECIFICATION Audit_Pay_Tables
FOR SERVER AUDIT Payrole_Security_Audit
ADD (SELECT , INSERT
ON HumanResources.EmployeePayHistory BY dbo )
WITH (STATE = ON) ;

Q9.

Which of the following views log from a file that is named \\serverName\Audit\HIPPA_AUDIT.sqlaudit?

SELECT * FROM sys.fn_audit_file (‘\\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);

SELECT * FROM sys.fn_get_audit_file (‘\\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);

SELECT * FROM sys.fn_get_audit(‘\\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);

None of the mentioned

Discuss

Answer: (b).SELECT * FROM sys.fn_get_audit_file (‘\\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);

Q10.

Which of the following statement is used to enable auditing from SQL Server?

auditpol /set /subcategory:”application generated” /success:enable /failure:enable

polaudit /set /subcategory:”application generated” /success:enable /failure:enable

auditpolenable /set /subcategory:”application generated” /success:enable /failure:enable

auditenable /set /subcategory:”application generated” /success:enable /failure:enable

Discuss

Answer: (a).auditpol /set /subcategory:”application generated” /success:enable /failure:enable

Page 1 of 10

Welcome to the Monitoring and Auditing MCQs Page

Monitoring and Auditing MCQs | Page 1 of 10

Explore more Topics under SQL Server

SQL Server Basics

Data Modification and Constraints

Beyond Relational

Data Definition Language

Development with SQL Server

Data Connectivity

Enterprise Data Management

Data Security

Performance Tuning and Optimization

Business Intelligence and Reporting Services

Suggested Topics

Java Spring Framework

Cryptography and Network Security

CSS

R Programming

Hadoop

Artificial Intelligence

HTML

Data Science

Systems Analysis and Design Methods