Explore topic-wise MCQs in Testing Subject.

This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following format output events in an Event Tracing for Windows?

A. event_file
B. ring_buffer
C. histogram
D. etw_classic_sync_target
Answer» E.
Discussion
2.

Which of the following feature distinguishes change data capture from change tracking?

A. Historical data
B. DML
C. DML type
D. Whether a column was changed
Answer» B. DML
Discussion
3.

Which of the following is syntax for sp_add_collector_type procedure?

A. core.sp_add_collector [ @collector_type_uid = ] ‘collector_type_uid’
B. core.sp_add_collector_type [ @collector_type_uid = ].
C. core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’
D. none of the mentioned
Answer» D. none of the mentioned
Discussion
4.

Which of the following field in cdc.lsn_time_mapping has varbinary data type?

A. tran_begin_time
B. tran_id
C. start_lsn
D. all of the mentioned
Answer» C. start_lsn
Discussion
5.

Upper bound on expected throughput of the capture job is calculated using which of the following computation?

A. (maxtrans * maxscans) / number of seconds between scans
B. (maxtrans * maxscans) * number of seconds between scans
C. (maxtrans * maxscans) – number of seconds between scans
D. None of the mentioned
Answer» B. (maxtrans * maxscans) * number of seconds between scans
Discussion
6.

What does collector_type_id stands for in the following code snippet?

A. uniqueidentifier
B. membership role
C. directory
D. none of the mentioned
Answer» B. membership role
Discussion
7.

Which of the following is the best Practice and Caveat for Management Data Warehouse?

A. Use a centralized server for the MDW database
B. The XML parameters for a single T-SQL collection item can have multiple <Query> elements
C. Use a distributed server for the MDW database
D. All of the mentioned
Answer» B. The XML parameters for a single T-SQL collection item can have multiple <Query> elements
Discussion
8.

Which of the following catalog view is used for SQL Server Extended Events?

A. sys.server_sessions
B. sys.server_event_sess
C. sys.server_event_session_actions
D. all of the mentioned
Answer» D. all of the mentioned
Discussion
9.

Which of the following code creates database audit specification?

A. CREATE AUDIT SPECIFICATION Audit_Pay_Tables
B. CREATE DATABASE AUDIT Audit_Pay_Tables
C. CREATE DATABASE AUDIT SPECIFICATION Audit_Pay_Tables
D. All of the mentioned
Answer» D. All of the mentioned
Discussion
10.

Which of the following code Enables the audit ‘HIPAA_Audit’?

A. ALTER SERVER AUDIT HIPAA_Audit
B. ALTER SERVER AUDIT HIPAA_Audit
C. ALTER SERVER AUDIT HIPAA_Audit
D. None of the mentioned
Answer» B. ALTER SERVER AUDIT HIPAA_Audit
Discussion
11.

Which of the following object is only available for audit actions in Create Server Audit Specification?

A. Audit Action Type
B. Object Name
C. Audit Name
D. All of the mentioned
Answer» C. Audit Name
Discussion
12.

Which of the following statement is used to enable auditing from SQL Server?

A. auditpol /set /subcategory:”application generated” /success:enable /failure:enable
B. polaudit /set /subcategory:”application generated” /success:enable /failure:enable
C. auditpolenable /set /subcategory:”application generated” /success:enable /failure:enable
D. auditenable /set /subcategory:”application generated” /success:enable /failure:enable
Answer» B. polaudit /set /subcategory:”application generated” /success:enable /failure:enable
Discussion
13.

Which of the following views log from a file that is named \\serverName\Audit\HIPPA_AUDIT.sqlaudit?

A. SELECT * FROM sys.fn_audit_file (‘\\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);
B. SELECT * FROM sys.fn_get_audit_file (‘\\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);
C. SELECT * FROM sys.fn_get_audit(‘\\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);
D. None of the mentioned
Answer» C. SELECT * FROM sys.fn_get_audit(‘\\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);
Discussion
14.

Which of the following code creates a server audit called “HIPPA_Audit” with a binary file as the target and no options?

A. CREATE SERVER AUDIT HIPAA_Audit
B. CREATE SERVER AUDIT HIPAA_Audit
C. CREATE AUDIT HIPAA_Audit
D. CREATE SERVER AUDIT HIPAA
Answer» B. CREATE SERVER AUDIT HIPAA_Audit
Discussion