Question 152

You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server named Server1. You need to determine the size of the transaction log file for each distribution of DW1. What should you do?

• AOn DW1, execute a query against the sys.database_files dynamic management view.
• BFrom Azure Monitor in the Azure portal, execute a query against the logs of DW1.
• CExecute a query against the logs of DW1 by using the Get-AzOperationalInsightsSearchResult PowerShell cmdlet.
• DOn the master database, execute a query against the sys.dm_pdw_nodes_os_performance_counters dynamic management view.