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…

The correct answer is A. On DW1, execute a query against the sys.database_files dynamic management view. For information about the current log file size, its maximum size, and the autogrow option for the file, you can also use the size, max_size, and growth columns for that log file in sys.database_files…

Submitted by jordan8· 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 determine the size of the transaction log file for each distribution of DW1. What should you do?

Options

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
DOn the master database, execute a query against the

How the community answered

(27 responses)

A
74% (20)
B
7% (2)
C
15% (4)
D
4% (1)

Explanation

For information about the current log file size, its maximum size, and the autogrow option for the file, you can also use the size, max_size, and growth columns for that log file in sys.database_files. https://docs.microsoft.com/en-us/sql/relational-databases/logs/manage-the-size-of-the- transaction-log-file

Topics

#transaction log#dedicated SQL pool#sys.database_files#distribution monitoring

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice