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

Explore more Topics under SQL Server

Q61.
Which of the following is a change tracking function?

a.

WITH CHANGE_TRACK_CONTEXT

b.

CHANGE_TRACKING_MAX_VALID_VERSION()

c.

CHANGE_TRACKING_CURRENT_VERSION

d.

All of the mentioned

Discuss
Answer: (c).CHANGE_TRACKING_CURRENT_VERSION
Q62.
Point out the correct statement.

a.

A good example of one-way synchronization application is an occasionally connected application

b.

Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications

c.

After change tracking is configured for a table, any DDL statement that affects rows in the table will cause change tracking

d.

None of the mentioned

Discuss
Answer: (b).Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications
Q63.
Which of the following is the biggest disadvantage of change tracking?

a.

Schema changes are required in the server database

b.

Triggers are fired for each change that has been made to a row

c.

Logic for maintaining the correct row versions and deletions is easy

d.

All of the mentioned

Discuss
Answer: (b).Triggers are fired for each change that has been made to a row
Q64.
Which of the following query selects incremental inserts from the Sales.Customer table at the server?

a.

IF @sync_initialized == 0
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer LEFT OUTER JOIN
CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
ELSE
BEGIN
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
WHERE (CT.SYS_CHANGE = 'I' AND CT.SYS_CHANGE_CREATION_VERSION
<= @sync_new_received_anchor)
END

b.

IF @sync_initialized = 0
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer LEFT OUTER JOIN
CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
ELSE
BEGIN
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
WHERE (CT.SYS_CHANGE = 'I' AND CT.SYS_CHANGE_CREATION_VERSION
<= @sync_new_received_anchor)
END

c.

IF @sync_initialized =0
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer LEFT OUTER JOIN
CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
ELSE
BEGIN
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
WHERE (CT.SYS_CHANGE_OPERATION = 'I' AND CT.SYS_CHANGE_CREATION_VERSION
<= @sync_new_received_anchor)
END

d.

None of the mentioned

Discuss
Answer: (c).IF @sync_initialized =0
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer LEFT OUTER JOIN
CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
ELSE
BEGIN
SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType]
FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT
ON CT.[CustomerId] = Sales.Customer.[CustomerId]
WHERE (CT.SYS_CHANGE_OPERATION = 'I' AND CT.SYS_CHANGE_CREATION_VERSION
<= @sync_new_received_anchor)
END
Q65.
Point out the wrong statement.

a.

Change tracking is used for one way synchronization applications only

b.

Applications that have to synchronize data with an instance of the SQL Server Database Engine must be able to query for changes

c.

Two-way synchronization applications can also be built that use change tracking

d.

The two-way synchronization applications must be able to detect conflicts

Discuss
Answer: (a).Change tracking is used for one way synchronization applications only
Q66.
Which of the following code snippet returns a version integer that is associated with the last committed transaction that was tracked by change tracking?

a.

SELECT @sync_new_received_anchor = change_tracking_cur_version()

b.

SELECT @sync_new_received_anchor = change_tracking_current_ver()

c.

SELECT @sync_new_received_anchor = change_tracking_current_version()

d.

SELECT @sync_new_received_anchor = change_track_current_version()

Discuss
Answer: (c).SELECT @sync_new_received_anchor = change_tracking_current_version()
Q67.
Which of the following is a valid syntax for WITH CHANGE_TRACKING_CONTEXT?

a.

WITH CHANGE_TRACKING_CONTEXT (@sync_client_id_binary)
INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson,
CustomerType)
VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType)
SET @sync_row_count = @@rowcount

b.

WITH CHANGE_TRACKI_CONTEXT (@sync_client_id_binary)
INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson,
CustomerType)
VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType)
SET @sync_row_count = @@rowcount

c.

WITH CHANGE_TRACKING_CON (@sync_client_id_binary)
INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson,
CustomerType)
VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType)
SET @sync_row_count = @@rowcount

d.

All of the mentioned

Discuss
Answer: (a).WITH CHANGE_TRACKING_CONTEXT (@sync_client_id_binary)
INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson,
CustomerType)
VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType)
SET @sync_row_count = @@rowcount
Q68.
_____________ obtains tracking information for all changes to a table that have occurred since a specific version.

a.

CHANGETABLE_CONTEXT

b.

CHANGETABLE

c.

CHANGE_TRACKING_IS_COLUMN_IN_MASK

d.

All of the mentioned

Discuss
Answer: (b).CHANGETABLE
Q69.
Which of the following is a catalog view used for change tracking?

a.

sys.change_tracking_tables

b.

sys.change_tracking_views

c.

sys.change_tracking_columns

d.

none of the mentioned

Discuss
Answer: (a).sys.change_tracking_tables
Q70.
Which of the following feature distinguishes change data capture from change tracking?

a.

Historical data

b.

DML

c.

DML type

d.

Whether a column was changed

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

Wireless and Mobile Communications

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

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

Microprocessor

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

Operating System

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

Artificial Intelligence

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

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...