gs gs116 Monitoring and Auditing - Management Data Warehouse - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Monitoring and Auditing. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: _________ introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting.
SQL Server 2005
SQL Server 2008
SQL Server 2012
SQL Server 2014
Question 2: Point out the correct statement.
MDW consist of three components
SQL Server Express instances can be targets
Setting up the MDW is a one-step process
All of the mentioned
Question 3: Which of the following mode allows for the collection and uploading of data to occur on demand?
Non-cached mode
Cached mode
Mixed mode
All of the mentioned
Question 4: Which of the following scenario favours cached mode?
Continuous collection of data
Less frequent uploads
Data collection and uploading of jobs on different schedules
All of the mentioned
Question 5: Point out the wrong statement.
The Data Collection is performed primarily through SSIS packages that control the collection frequency on the target
You should change the database name after creation
Do not change any of the job specifications for the data collection and upload jobs
None of the mentioned
Question 6: Which of the following is the best Practice and Caveat for Management Data Warehouse?
Use a centralized server for the MDW database
The XML parameters for a single T-SQL collection item can have multiple <Query> elements
Use a distributed server for the MDW database
All of the mentioned
Question 7: ____________ stores information about how the management data warehouse reports should group and aggregate performance counters.
core.snapshots_internal
core.supported_collector_types_internal
core.wait_categories
core.performance_counter_report_group_items
Question 8: Which of the following table is used in the management data warehouse schema that is required for the Server Activity?
snapshots.query_stat
snapshots.os_latch_stats
snapshots.active_sessions
all of the mentioned
Question 9: Which of the following is syntax for sp_add_collector_type procedure?
core.sp_add_collector [ @collector_type_uid = ] ‘collector_type_uid’
core.sp_add_collector_type [ @collector_type_uid = ].
core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’
none of the mentioned
Question 10: What does collector_type_id stands for in the following code snippet?
core.sp_remove_collector_type [ @collector_type_uid = ] ‘collector_type_uid’
core.sp_remove_collector_type [ @collector_type_uid = ] ‘collector_type_uid’
uniqueidentifier
membership role
directory
none of the mentioned
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
