gs gs116 Monitoring and Auditing - Change Data Capture - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Monitoring and Auditing. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following script will enable CDC on HumanResources.Shift table?
USE AdventureWorks GO EXEC sys.sp_cdc_enable @source_schema = N'HumanResources', @source_name = N'Shift', @role_name = NULL GO USE AdventureWorks GO EXEC sys.sp_cdc_disable_table @source_schema = N'HumanResources', @source_name = N'Shift', @role_name = NULL GO USE AdventureWorks GO EXEC sys.sp_cdc_enable_table @source_schema = N'HumanResources', @source_name = N'Shift', @role_name = NULL GO
All of the mentioned
Question 2: Point out the correct statement.
To determine if a database is already enabled, query the is_cdc_enabled column in the sys.database catalog view
Change data capture requires exclusive use of the cdc schema and cdc user
If a change data capture enabled database is dropped, change data capture jobs are not removed
All of the mentioned
Question 3: Which of the following disable database for Change Data Capture?
EXEC sys.sp_cdc_ensable_db
EXEC sys.sp_disable_db
EXEC sys.sp_cdc_disable_db
All of the mentioned
Question 4: If you do not want to use a gating role, explicitly set the @role_name parameter to ______________
0
NULL
1
None of the mentioned
Question 5: Point out the wrong statement.
By default, all of the columns in the source table are not identified as captured columns
By default, the change table is located in the default filegroup of the database
The purpose of the named role is to control access to the change data
None of the mentioned
Question 6: 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
Question 7: Which of the following script enable a table Without Using a Gating Role?
USE MyDB GO EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'MyTable', @role_name = 1, @supports_net_changes = 1 GOUSE MyDB GO EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'MyTable', @role_name = 0, @supports_net_changes = 1 GOUSE MyDB GO EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'MyTable', @role_name = NULL, @supports_net_changes = 1 GO
None of the mentioned
Question 8: Which of the following script enable a Table for all and Net Changes Queries?
\USE MyDB GO EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'MyTable', @role_name = N'MyRole', @supports_net_changes = 1 GO \USE MyDB GO EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'MyTable', @role_name = N'MyRole', @supports_net_changes = 0 GO \USE MyDB GO EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'MyTable', @role_name = N'MyRole', @supports_net_changes = NULL GO
All of the mentioned
Question 9: Upper bound on expected throughput of the capture job is calculated using which of the following computation?
(maxtrans * maxscans) / number of seconds between scans
(maxtrans * maxscans) * number of seconds between scans
(maxtrans * maxscans) – number of seconds between scans
None of the mentioned
Question 10: The cleanup job is initiated by running the parameterless stored procedure is ___________
sp_MScdc_cleanup_job
sp_cdc_cleanup_change_job
sp_cdc_cleanup_change_tables
none of the mentioned
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
