Microsoft Exam DP-203 Topic 11 Question 47 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 47
Topic #: 11

[All DP-203 Questions]

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.

Show Suggested Answer

Suggested Answer: A

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

by Dick at May 05, 2022, 07:24 PM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!