Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated

goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the re

view screen.

You have a Microsoft Azure SQL database that has Blob Auditing configured.

You need to review the audit logs.

Solution: You download the log files by using Microsoft Azure Storage Explorer, and then you open the files by using Microsoft SQL

Server Management Studio (SSMS).

Does this meet the goal?

A. Yes

B. No

There are several methods you can use to view blob auditing logs:

After downloading several files or a subfolder that contains log files, you can merge them locally by

using Merge Audit Files in SQL Server Management Studio.

Use the Azure portal.

Use the system function sys.fn_get_audit_file (T-SQL) to return the audit log data in tabular format.

References:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing