Which of the following requires VIEW SERVER STATE permission on the server?(a) sys.dm_os_states(b) sys.dm_os_wait_stats(c) sys.dm_os_wait_states(d) none of the mentionedThis question was addressed to me at a job interview.I would like to ask this question from Wait States in section Monitoring and Auditing of SQL Server

Which of the following requires VIEW SERVER STATE permission on the se

1.	Which of the following requires VIEW SERVER STATE permission on the server?(a) sys.dm_os_states(b) sys.dm_os_wait_stats(c) sys.dm_os_wait_states(d) none of the mentionedThis question was addressed to me at a job interview.I would like to ask this question from Wait States in section Monitoring and Auditing of SQL Server
Answer» The CORRECT option is (b) sys.dm_os_wait_stats For explanation I would say: sys.dm_os_wait_stats RETURNS INFORMATION about all the waits encountered by threads that EXECUTED.

Discussion

No Comment Found

Related InterviewSolutions

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 mentionedThis question was posed to me in a national level competition.I'm obligated to ask this question of Management Data Warehouse in division Monitoring and Auditing of SQL Server
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 mentionedThis question was posed to me in unit test.My question is taken from Management Data Warehouse in chapter Monitoring and Auditing of SQL Server
____________ 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_itemsI had been asked this question in an online interview.My doubt stems from Management Data Warehouse in chapter Monitoring and Auditing of SQL Server
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 elements(c) Use a distributed server for the MDW database(d) All of the mentionedThis question was posed to me in quiz.I'd like to ask this question from Management Data Warehouse topic in section Monitoring and Auditing of SQL Server
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 shouldchange 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 mentionedI have been asked this question by my college professor while I was bunking the class.I want to ask this question from Management Data Warehouse in chapter Monitoring and Auditing of SQL Server
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 mentionedThis question was posed to me in an interview for job.Question is taken from Management Data Warehouse in section Monitoring and Auditing of SQL Server
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 mentionedI got this question in my homework.This intriguing question comes from Management Data Warehouse in portion Monitoring and Auditing of SQL Server
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 mentionedThe question was posed to me in an interview for job.My doubt stems from Management Data Warehouse in portion Monitoring and Auditing of SQL Server
_________ 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 2014This question was posed to me in an international level competition.This intriguing question originated from Management Data Warehouse in chapter Monitoring and Auditing of SQL Server
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 mentionedI had been asked this question during an interview.This intriguing question comes from SQL Audit in portion Monitoring and Auditing of SQL Server

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment