ExamQuestions.com

Register
Login
Data Engineering on Microsoft Azure (DP-203) Exam Questions

Microsoft

Data Engineering on Microsoft Azure (DP-203)

57 / 240

Question 57:

Auditing for<a href="https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is">Azure Synapse Analytics</a> and Azure SQL Database first tracks database events and then writes these events to an audit log under your Log Analytics workspace, Azure storage account, or Event Hubs. Which of the following statements are true about Auditing and Audit logs? (Select two options)

Answer options:

A.Audit logs are written to Append Blobs in Blob storage on your Azure subscription
B.While using Azure AD Authentication, even the failed logins records appear in the SQL audit log. 
C.The format for Audit logs is .xml.
D.You can use SQL Server Management Studio (SSMS) to open the audit logs.
E.If you want auditing on read-only replicas, you need to manually configure it.