You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server named Server1. You need to verify whether the size of the transaction log file for each distribution of DW1 is…

The correct answer is A. On the master database, execute a query against the. The following query returns the transaction log size on each distribution. If one of the log files is reaching 160 GB, you should consider scaling up your instance or limiting your transaction size. --Transaction log size instance_name as distribution_db, cntr_value*1.0/1048576…

Submitted by satoshi_tk· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

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

Options

AOn the master database, execute a query against the
BFrom Azure Monitor in the Azure portal, execute a query against the logs of DW1.
COn DW1, execute a query against the sys.database_files dynamic management view.
DExecute a query against the logs of DW1 by using the Get-AzOperationalInsightSearchResult

How the community answered

(32 responses)

A
72% (23)
B
9% (3)
C
16% (5)
D
3% (1)

Explanation

The following query returns the transaction log size on each distribution. If one of the log files is reaching 160 GB, you should consider scaling up your instance or limiting your transaction size. --Transaction log size instance_name as distribution_db, cntr_value*1.0/1048576 as log_file_size_used_GB, FROM sys.dm_pdw_nodes_os_performance_counters instance_name like 'Distribution_%' AND counter_name = 'Log File(s) Used Size (KB)' https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-monitor

Topics

#Synapse Analytics#transaction log#DMV#distribution monitoring

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice