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 :
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 ?
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 :
Correct Answer is :
4. Point out the wrong statement :
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 ?
Correct Answer is : SELECT * from sys.dm_cdc_log_scan_sessions where empty_scan_count 0
