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

Explore topic-wise MCQs in SQL Server.

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

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