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!

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Internet of Things (IoT)

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

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Cloud Computing

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