gs gs116 Monitoring and Auditing - SQL Audit - 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 error is returned for a query for all changes when a parameter that is used to define the query interval is not valid?
An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_partial_changes_
An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_
An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_net_changes_
None of the mentioned
Question 2: Point out the correct statement.
The function cdc.fn_cdc_get_all_changes_<capture_instance> returns all changes that occurred for the specified interval
The update mask that is returned from a query function is a compact representation that identifies few columns that changed in a row of change data
A typical application scenario for querying for change data is to periodically request change data by using a receiver window bounded by timestamp values
None of the mentioned
Question 3: The commit time of each transaction with an associated entry in a database change table is available in the table __________
cdc.log_time_mapping
cdc.lsn_time_mapping
cdc.lsn_time_audit
all of the mentioned
Question 4: Which of the code snippet collect the data every 5 minutes?
DECLARE @schedule_uid uniqueidentifier; SELECT @schedule_uid = ( SELECT schedule_uid from sysschedules_localserver_view @days_until_expiration = 5, WHERE name = N'CollectorSchedule_Every_5min') DECLARE @schedule_uid uniqueidentifier; SELECT @schedule_uid = ( SELECT schedule_uid from sysschedules_localserver_view @days_until_expiration = 30 WHERE name = N'CollectorSchedule_Every_5min') DECLARE @schedule_uid uniqueidentifier; SELECT @schedule_uid = ( SELECT schedule_uid from sysschedules_localserver_view WHERE name = N'CollectorSchedule_Every_5min')
All of the mentioned
Question 5: Point out the wrong statement.
cdc.lsn_time_mapping applies to SQL Server 2014
Datetime wrappers are owned by the user, and not are created in the default schema of the caller
Change data capture supports up to two capture instances for a single tracked source table
The name of the function to wrap the all changes query is fn_all_changes_ followed by the capture instance name.
Question 6: Which of the following query returns the average latency for the most recent sessions?
SELECT latency FROM sys.dm_cdc_log_audit_sessions WHERE session_id = 0
SELECT latency FROM sys.dm_cdc_log_scan_ WHERE session_id = 0
SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0
SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
Question 7: __________ gives DBAs an option to shut down the server in case of an audit log failure.
Shut down server on partial failure
Shut down server on audit log failure
Shut down server on complete failure
None of the mentioned
Question 8: Which of the following field in cdc.lsn_time_mapping has varbinary data type?
tran_begin_time
tran_id
start_lsn
all of the mentioned
Question 9: Which of the following query returns the average throughput for the most recent sessions?
SELECT command_count*duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sesss WHERE session_id = 0
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
