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

Explore more Topics under SQL Server

Q91.
_________ introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting.

a.

SQL Server 2005

b.

SQL Server 2008

c.

SQL Server 2012

d.

SQL Server 2014

Discuss
Answer: (b).SQL Server 2008
Q92.
Point out the correct statement.

a.

MDW consist of three components

b.

SQL Server Express instances can be targets

c.

Setting up the MDW is a one-step process

d.

All of the mentioned

Discuss
Answer: (a).MDW consist of three components
Q93.
Which of the following mode allows for the collection and uploading of data to occur on demand?

a.

Non-cached mode

b.

Cached mode

c.

Mixed mode

d.

All of the mentioned

Discuss
Answer: (a).Non-cached mode
Q94.
Which of the following scenario favours cached mode?

a.

Continuous collection of data

b.

Less frequent uploads

c.

Data collection and uploading of jobs on different schedules

d.

All of the mentioned

Discuss
Answer: (d).All of the mentioned
Q95.
Point out the wrong statement.

a.

The Data Collection is performed primarily through SSIS packages that control the collection frequency on the target

b.

You should change the database name after creation

c.

Do not change any of the job specifications for the data collection and upload jobs

d.

None of the mentioned

Discuss
Answer: (b).You should change the database name after creation
Q96.
Which of the following is the best Practice and Caveat for Management Data Warehouse?

a.

Use a centralized server for the MDW database

b.

The XML parameters for a single T-SQL collection item can have multiple <Query> elements

c.

Use a distributed server for the MDW database

d.

All of the mentioned

Discuss
Answer: (a).Use a centralized server for the MDW database
Q97.
____________ stores information about how the management data warehouse reports should group and aggregate performance counters.

a.

core.snapshots_internal

b.

core.supported_collector_types_internal

c.

core.wait_categories

d.

core.performance_counter_report_group_items

Discuss
Answer: (d).core.performance_counter_report_group_items
Q98.
Which of the following table is used in the management data warehouse schema that is required for the Server Activity?

a.

snapshots.query_stat

b.

snapshots.os_latch_stats

c.

snapshots.active_sessions

d.

all of the mentioned

Discuss
Answer: (b).snapshots.os_latch_stats
Q99.
Which of the following is syntax for sp_add_collector_type procedure?

a.

core.sp_add_collector [ @collector_type_uid = ] ‘collector_type_uid’

b.

core.sp_add_collector_type [ @collector_type_uid = ].

c.

core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’

d.

none of the mentioned

Discuss
Answer: (c).core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’
Q100.
What does collector_type_id stands for in the following code snippet? 
core.sp_remove_collector_type [ @collector_type_uid = ] ‘collector_type_uid’

a.

uniqueidentifier

b.

membership role

c.

directory

d.

none of the mentioned

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

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Cloud Computing

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

Artificial Intelligence

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

Microprocessor

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

MATLAB

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

Hadoop

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

Python

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

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

MongoDB

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