gs gs116 Monitoring and Auditing - Change Tracking - 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 is a change tracking function?
WITH CHANGE_TRACK_CONTEXT
CHANGE_TRACKING_MAX_VALID_VERSION()
CHANGE_TRACKING_CURRENT_VERSION
All of the mentioned
Question 2: Point out the correct statement.
A good example of one-way synchronization application is an occasionally connected application
Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications
After change tracking is configured for a table, any DDL statement that affects rows in the table will cause change tracking
None of the mentioned
Question 3: Which of the following is the biggest disadvantage of change tracking?
Schema changes are required in the server database
Triggers are fired for each change that has been made to a row
Logic for maintaining the correct row versions and deletions is easy
All of the mentioned
Question 4: Which of the following query selects incremental inserts from the Sales.Customer table at the server?
IF @sync_initialized == 0 SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType] FROM Sales.Customer LEFT OUTER JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT ON CT.[CustomerId] = Sales.Customer.[CustomerId] ELSE BEGIN SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType] FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT ON CT.[CustomerId] = Sales.Customer.[CustomerId] WHERE (CT.SYS_CHANGE = 'I' AND CT.SYS_CHANGE_CREATION_VERSION <= @sync_new_received_anchor) END IF @sync_initialized = 0 SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType] FROM Sales.Customer LEFT OUTER JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT ON CT.[CustomerId] = Sales.Customer.[CustomerId] ELSE BEGIN SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType] FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT ON CT.[CustomerId] = Sales.Customer.[CustomerId] WHERE (CT.SYS_CHANGE = 'I' AND CT.SYS_CHANGE_CREATION_VERSION <= @sync_new_received_anchor) END IF @sync_initialized =0 SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType] FROM Sales.Customer LEFT OUTER JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT ON CT.[CustomerId] = Sales.Customer.[CustomerId] ELSE BEGIN SELECT Sales.Customer.[CustomerId], [CustomerName], [SalesPerson], [CustomerType] FROM Sales.Customer JOIN CHANGETABLE(CHANGES Sales.Customer, @sync_last_received_anchor) CT ON CT.[CustomerId] = Sales.Customer.[CustomerId] WHERE (CT.SYS_CHANGE_OPERATION = 'I' AND CT.SYS_CHANGE_CREATION_VERSION <= @sync_new_received_anchor) END
None of the mentioned
Question 5: Point out the wrong statement.
Change tracking is used for one way synchronization applications only
Applications that have to synchronize data with an instance of the SQL Server Database Engine must be able to query for changes
Two-way synchronization applications can also be built that use change tracking
The two-way synchronization applications must be able to detect conflicts
Question 6: Which of the following code snippet returns a version integer that is associated with the last committed transaction that was tracked by change tracking?
SELECT @sync_new_received_anchor = change_tracking_cur_version()
SELECT @sync_new_received_anchor = change_tracking_current_ver()
SELECT @sync_new_received_anchor = change_tracking_current_version()
SELECT @sync_new_received_anchor = change_track_current_version()
Question 7: Which of the following is a valid syntax for WITH CHANGE_TRACKING_CONTEXT?
WITH CHANGE_TRACKING_CONTEXT (@sync_client_id_binary) INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson, CustomerType) VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType) SET @sync_row_count = @@rowcount WITH CHANGE_TRACKI_CONTEXT (@sync_client_id_binary) INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson, CustomerType) VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType) SET @sync_row_count = @@rowcount WITH CHANGE_TRACKING_CON (@sync_client_id_binary) INSERT INTO Sales.Customer (CustomerId, CustomerName, SalesPerson, CustomerType) VALUES (@CustomerId, @CustomerName, @SalesPerson, @CustomerType) SET @sync_row_count = @@rowcount
All of the mentioned
Question 8: _____________ obtains tracking information for all changes to a table that have occurred since a specific version.
CHANGETABLE_CONTEXT
CHANGETABLE
CHANGE_TRACKING_IS_COLUMN_IN_MASK
All of the mentioned
Question 9: Which of the following is a catalog view used for change tracking?
sys.change_tracking_tables
sys.change_tracking_views
sys.change_tracking_columns
none of the mentioned
Question 10: Which of the following feature distinguishes change data capture from change tracking?
Historical data
DML
DML type
Whether a column was changed
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
