SQL Server Practice Test 8

1. Point out the wrong statement.

None of the mentioned

Actions and predicates are bound to events on a per-session basis

Extended Event sessions have implied boundaries in that the configuration of one session does change the configuration of another session

The mapping between package objects and sessions is many to many

2. The contents of sys.dm_os_wait_stats can be reset by running which of the following command?

DBCC SQLP ('sys.dm_os_wait_stats', CLEAR);

DBCC PERF ('sys.dm_os_wait_stats', CLEAR);

None of the mentioned

DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);

3. Point out the correct statement.

SQL Server does not always waits for something, a disk io, a place in the processor queue, a lock

510: CXPACKET indicates parallelism

All of the mentioned

Few variations of PAGEIOLATCH waits usually indicate a problem with the disk subsystem

4. Which of the following query determine sessions that had an empty scan?

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count <> 0

SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0

5. _____________ wait type applies to SQL Server 2014 only.

HADR_WORK_POOL

HADR_XRF_STACK_ACCESS

LCK_M_U_ABORT_BLOCKERS

HADR_WORK_QUEUE

6. Which of the following is an extended event task?

create an Extended Events session

alter an Extended Events session

all of the mentioned

find out what events are available in the registered packages

7. Which of the following is valid syntax for SET STATISTICS XML?

All of the mentioned

SET STATISTICS XML { ON }

SET STATISTICS XML { OFF }

SET STATISTICS XML { ON | OFF }

8. Which of the following field in cdc.lsn_time_mapping has varbinary data type?

start_lsn

tran_id

all of the mentioned

tran_begin_time

9. Which of the DDL statement creates a session object that contains the metadata?

None of the mentioned

CREATE SESSION

CREATE EVENT SESSION

CREATE EVENT SESSION METADATA

10. The cleanup job is initiated by running the parameterless stored procedure is ___________

sp_MScdc_cleanup_job

none of the mentioned

sp_cdc_cleanup_change_job

sp_cdc_cleanup_change_tables