Change Data Capture Interview Questions

Change Data Capture interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Point out the correct statement :

A. To determine if a database is already enabled, query the is_cdc_enabled column in the sys.database catalog view.

B. Change data capture requires exclusive use of the cdc schema and cdc user

C. If a change data capture enabled database is dropped, change data capture jobs are not removed

D. All of the mentioned

Correct Answer is : Change data capture requires exclusive use of the cdc schema and cdc user

2. Which of the following disable database for Change Data Capture ?

A. EXEC sys.sp_cdc_ensable_db

B. EXEC sys.sp_disable_db

C. EXEC sys.sp_cdc_disable_db

D. All of the mentioned

Correct Answer is : EXEC sys.sp_cdc_disable_db

3. If you do not want to use a gating role, explicitly set the @role_name parameter to :

A. 0

C. 1

D. None of the mentioned

Correct Answer is :

4. Point out the wrong statement :

A. By default, all of the columns in the source table are not identified as captured columns

B. By default, the change table is located in the default filegroup of the database

C. The purpose of the named role is to control access to the change data

D. None of the mentioned

Correct Answer is : By default, all of the columns in the source table are not identified as captured columns

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

A. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count 0

B. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count = 0

C. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count < 0

D. SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count > 0

Correct Answer is : SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count 0

Change Data Capture interview questions