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?
A.
On the master database, execute a query against the sys.dm_pdw_nodes_os_performance_counters dynamic management view.
B.
From Azure Monitor in the Azure portal, execute a query against the logs of DW1.
C.
On DW1, execute a query against the sys.database_files dynamic management view.
D.
Execute a query against the logs of DW1 by using the Get-AzOperationalInsightsSearchResult PowerShell cmdlet.
Suggested Answer:A🗳️
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
SELECT - instance_name as distribution_db, cntr_value*1.0/1048576 as log_file_size_used_GB, pdw_node_id FROM sys.dm_pdw_nodes_os_performance_counters
WHERE - instance_name like 'Distribution_%' AND counter_name = 'Log File(s) Used Size (KB)' Reference: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-monitor
A is correct
-- Transaction log size
SELECT
instance_name as distribution_db,
cntr_value*1.0/1048576 as log_file_size_used_GB,
pdw_node_id
FROM sys.dm_pdw_nodes_os_performance_counters
WHERE
instance_name like 'Distribution_%'
AND counter_name = 'Log File(s) Used Size (KB)'
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-monitor
hi to all,
it's A for sure.
the "master" stuff can put some confusion here but it's right.
please see https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/synapse-analytics/sql-data-warehouse/quickstart-scale-compute-tsql.md
regards
Answer should be C - Reference: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-files-transact-sql?view=sql-server-ver15
sys.database_files gives the log size
Not sure which answer is the correct one, as the selected answer include "master database". The dmv "dm_pdw_nodes_os_performance_counters" doesn't exist in the master database. The dmv "sys.database_files" only shows 1 log file (not for each distribution), hence my guess is that these answer are incorrectly formulated
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.DP-200 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Abhitm
Highly Voted 4 years, 11 months agodumpsm42
Most Recent 4 years, 5 months agosyu31svc
4 years, 5 months agoVJ8
4 years, 11 months agoMarvinS91
4 years, 12 months ago