Unique Azure Commands

Question 1

You have an Azure Synapse Analytics workspace.

You need to measure the performance of SQL queries running on the dedicated SQL pool.

Which two actions achieve the goal? Each correct answer presents a complete solution

• From the Monitor page of Azure Synapse Studio, review the SQL requests tab.
• Query the sys.dm_pdw_exec_request view.
• Add a Service endpoints
• Configure Network peering,

Answer 1

From the Monitor page of Azure Synapse Studio, review the SQL requests tab.
Query the sys.dm_pdw_exec_request view.

Question 2

You have an Azure Synapse Analytics workspace.

You need to monitor bottlenecks related to the SQL Server OS state on each node of the dedicated SQL pools.

Which view should you use?
-sys.dm_pdw_wait
-sys.dm_pdw_wait_stats
-sys.dm_pdw_nodes

Answer 2

sys.dm_pdw_wait_stats

Question 3

You have an Azure Synapse Analytics SQL pool.

You need to monitor currently-executing query executions in the SQL pool.

Which three dynamic management views should you use? Each correct answer presents part of the solution.
-sys.dm_pdw_exec_requests
-sys.dm_pdw_request_steps
-sys.dm_pdw_sql_requests
-sys.dm_exec_cached_plans

Answer 3

-sys.dm_pdw_exec_requests
-sys.dm_pdw_request_steps
-sys.dm_pdw_sql_requests

Question 4

You have an Azure Synapse Analytics workspace.
You need to identify running sessions in the workspace.
Which dynamics management view should you use?
- sys.dm_pdw_exec_sessions
- sys.dm_pdw_exec_requests
- sys.dm_exec_requests
- sys.dm_exec_sessions

Answer 4

sys.dm_pdw_exec_sessions
sys.dm_pdw_exec_sessions shows the status of the sessions, not the running requests.

Question 5

You have an Azure Synapse Analytics workspace that includes an Azure Synapse Analytics cluster named Cluster1.

You need to review the estimated execution plan for a query on a specific node of Cluster1. The query has a spid of 94 and a distribution ID of 5.

Which command should you run?
- SELECT * FROM sys.dm_exec_query_plan WHERE spid = 94 AND distribution_id = 5
- DBCC PDW_SHOWEXECUTIONPLAN (5, 94)

Answer 5

DBCC PDW_SHOWEXECUTIONPLAN (5, 94)
The execution plan for the specific distribution is available by busing the DBCC PDW_SHOWEXECUTIONPLAN command.

Question 6

You have an Azure Synapse Analytics workspace.

Users report that queries that have a label of ‘query1’ are slow to complete.

You need to identify all the queries that have a label of ‘query1’.

Which query should you run?

SELECT * FROM sys.dm_pdw_sql_requests WHERE label = ‘query1’
SELECT * FROM sys.dm_pdw_exec_requests WHERE label = ‘query1’

Answer 6

SELECT * FROM sys.dm_pdw_exec_requests WHERE label = ‘query1’
Labels for queries are available from sys.dm_pdw_exec_requests. Once the request IDs for the queries are identified, the request IDs can be used for the other dynamic management views.

Question 7

You have an Azure Synapse Analytics database named DB1.

You need to increase the concurrency available for DB1.

Which cmdlet should you run?
- Update-AzSynapseSqlDatabase
- Set-AzSqlDatabase

Answer 7

Increasing the concurrency on a database requires scaling the database up by using the Set-AzSqlDatabase cmdlet.