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 9 of 10

Explore more Topics under SQL Server

Q81.
Which of the following error is returned for a query for all changes when a parameter that is used to define the query interval is not valid?

a.

An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_partial_changes_

b.

An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_

c.

An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_net_changes_

d.

None of the mentioned

Discuss
Answer: (b).An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_
Q82.
Point out the correct statement.

a.

The function cdc.fn_cdc_get_all_changes_<capture_instance> returns all changes that occurred for the specified interval

b.

The update mask that is returned from a query function is a compact representation that identifies few columns that changed in a row of change data

c.

A typical application scenario for querying for change data is to periodically request change data by using a receiver window bounded by timestamp values

d.

None of the mentioned

Discuss
Answer: (a).The function cdc.fn_cdc_get_all_changes_<capture_instance> returns all changes that occurred for the specified interval
Q83.
The commit time of each transaction with an associated entry in a database change table is available in the table __________

a.

cdc.log_time_mapping

b.

cdc.lsn_time_mapping

c.

cdc.lsn_time_audit

d.

all of the mentioned

Discuss
Answer: (b).cdc.lsn_time_mapping
Q84.
Which of the code snippet collect the data every 5 minutes?

a.

DECLARE @schedule_uid uniqueidentifier;
SELECT @schedule_uid = (
SELECT schedule_uid FROM sysschedules_localserver_view
@days_until_expiration = 5,
WHERE name = N'CollectorSchedule_Every_5min')

b.

DECLARE @schedule_uid uniqueidentifier;
SELECT @schedule_uid = (
SELECT schedule_uid FROM sysschedules_localserver_view
@days_until_expiration = 30
WHERE name = N'CollectorSchedule_Every_5min')

c.

DECLARE @schedule_uid uniqueidentifier;
SELECT @schedule_uid = (
SELECT schedule_uid FROM sysschedules_localserver_view
WHERE name = N'CollectorSchedule_Every_5min')

d.

All of the mentioned

Discuss
Answer: (c).DECLARE @schedule_uid uniqueidentifier;
SELECT @schedule_uid = (
SELECT schedule_uid FROM sysschedules_localserver_view
WHERE name = N'CollectorSchedule_Every_5min')
Q85.
Point out the wrong statement.

a.

cdc.lsn_time_mapping applies to SQL Server 2014

b.

Datetime wrappers are owned by the user, and not are created in the default schema of the caller

c.

Change data capture supports up to two capture instances for a single tracked source table

d.

The name of the function to wrap the all changes query is fn_all_changes_ followed by the capture instance name.

Discuss
Answer: (a).cdc.lsn_time_mapping applies to SQL Server 2014
Q86.
Which of the following query returns the average latency for the most recent sessions?

a.

SELECT latency FROM sys.dm_cdc_log_audit_sessions WHERE session_id = 0

b.

SELECT latency FROM sys.dm_cdc_log_scan_ WHERE session_id = 0

c.

SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0

d.

SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

Discuss
Answer: (d).SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
Q87.
__________ gives DBAs an option to shut down the server in case of an audit log failure.

a.

Shut down server on partial failure

b.

Shut down server on audit log failure

c.

Shut down server on complete failure

d.

None of the mentioned

Discuss
Answer: (b).Shut down server on audit log failure
Q88.
Which of the following field in cdc.lsn_time_mapping has varbinary data type?

a.

tran_begin_time

b.

tran_id

c.

start_lsn

d.

all of the mentioned

Discuss
Answer: (b).tran_id
Q89.
Which of the following query returns the average throughput for the most recent sessions?

a.

SELECT command_count*duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

b.

SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

c.

SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sesss WHERE session_id = 0

d.

None of the mentioned

Discuss
Answer: (b).SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
Q90.
sys.fn_cdc_map_time_to_lsn returns ________ value from the start_lsn column in the cdc.lsn_time_mapping system table for the specified time.

a.

LSN

b.

LNS

c.

SLN

d.

None of the mentioned

Discuss
Answer: (a).LSN
Page 9 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!

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Operating System

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

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...