MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 64 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
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. | |
| 52. |
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 | |
| 53. |
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 | |
| 54. |
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 | |
| 55. |
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 | |
| 56. |
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 | |
| 57. |
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 | |
| 58. |
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 | |
| 59. |
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 | |
| 60. |
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 | |
| 61. |
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 | |
| 62. |
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 | |
| 63. |
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); | |
| 64. |
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 | |