Database Auditing Interview Questions

Database Auditing interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

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 ?

A. An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_partial_changes_

B. An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_

C. An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_net_changes_

D. None of the mentioned

Correct Answer is : An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_

2. Point out the correct statement :

A. The function cdc.fn_cdc_get_all_changes_ returns all changes that occurred for the specified interval

B. 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

C. A typical application scenario for querying for change data is to periodically request change data by using a receiver window bounded by timestamp values

D. None of the mentioned

Correct Answer is : The function cdc.fn_cdc_get_all_changes_ returns all changes that occurred for the specified interval

3. The commit time of each transaction with an associated entry in a database change table is available in the table __________

A. cdc.log_time_mapping

B. cdc.lsn_time_mapping

C. cdc.lsn_time_audit

D. All of the mentioned

Correct Answer is : cdc.lsn_time_mapping

4. Point out the wrong statement :

A. cdc.lsn_time_mapping applies to SQL Server 2014

B. Datetime wrappers are owned by the user, and not are created in the default schema of the caller

C. Change data capture supports up to two capture instances for a single tracked source table

D. The name of the function to wrap the all changes query is fn_all_changes_ followed by the capture instance name.

Correct Answer is : cdc.lsn_time_mapping applies to SQL Server 2014

5. Which of the following query returns the average latency for the most recent sessions ?

A. SELECT latency FROM sys.dm_cdc_log_audit_sessions WHERE session_id = 0

B. SELECT latency FROM sys.dm_cdc_log_scan_ WHERE session_id = 0

C. SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0

D. SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

Correct Answer is : SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

Database Auditing interview questions