adplus-dvertising

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.

frame-decoration

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

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

a.

ApexSQL

b.

SQL Ninja

c.

SQL Audit

d.

Idera

Discuss
Answer: (a).ApexSQL
Q2.
Point out the correct statement.

a.

The CREATE SERVER AUDIT statement is in a transaction scope

b.

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

c.

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

d.

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?

a.

Audit Action Type

b.

Object Name

c.

Audit Name

d.

All of the mentioned

Discuss
Answer: (b).Object Name
Q4.
Selecting the _________ option can allow unaudited activity which could violate your security policies.

a.

Fail

b.

Shut down

c.

Continue

d.

Break

Discuss
Answer: (c).Continue
Q5.
Point out the wrong statement.

a.

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

b.

SQL Server audit uses Extended Events to help create an audit

c.

You can have multiple audits per SQL Server instance

d.

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?

a.

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

b.

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

c.

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

d.

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’?

a.

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

b.

ALTER SERVER AUDIT HIPAA_Audit
WITH (STATE = OFF);

c.

ALTER SERVER AUDIT HIPAA_Audit
WITH (STATE = ON);

d.

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?

a.

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

b.

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

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) ;

d.

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?

a.

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

b.

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

c.

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

d.

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?

a.

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

b.

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

c.

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

d.

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

Suggested Topics

Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...