Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You have an enterprise data warehouse named DW1 in Azure Synapse Analytics 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?
A
On DW1, execute a query against the sys.database_files dynamic management view.
B
From Azure Monitor in the Azure portal, execute a query against the logs of DW1.
C
Execute a query against the logs of DW1 by using the Get-AzOperationalInsightsSearchResult PowerShell cmdlet.
D
On the master database, execute a query against the sys.dm_pdw_nodes_os_performance_counters dynamic management view.
