Explanation:When this job is executed it runs the system stored procedure sys.sp_MScdc_capture_job. 2. 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
Answer:A
Explanation:When this job is executed it runs the system stored procedure sys.sp_MScdc_capture_job. 2. 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