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

Question

TuteeHUB · Accepted Answer

SELECT * FROM sys.fn_get_audit(‘\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);

TuteeHUB · Answer

SELECT * FROM sys.fn_audit_file (‘\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);

TuteeHUB · Answer

SELECT * FROM sys.fn_get_audit_file (‘\serverName\Audit\HIPPA_AUDIT.sqlaudit’, default,default);

TuteeHUB · Answer

None of the mentioned

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);

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