You have an Azure Stream Analytics job.
You need to ensure that the job has enough streaming units provisioned.
You configure monitoring of the SU % Utilization metric.
Which two additional metrics should you monitor? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.

You have an Azure SQL managed instance.
You need to gather the last execution of a query plan and its runtime statistics. The solution
must minimize the impact on currently running queries.
What should you do?

You have an Azure SQL database named db1 on a server named server1.
The Intelligent Insights diagnostics log identifies queries that cause performance issues
due to tempDB contention.
You need to resolve the performance issues.
What should you do?

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1.
You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs. What should you do first?

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1.You plan to access the files in Account1 by using an external table.
You need to create a data source in Pool1 that you can reference when you create the
external table.
How should you complete the Transact-SQL statement? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure SQL Database managed instance named sqldbmi1 that contains a
database name Sales
You need to initiate a backup of Sales.
How should you complete the Transact-SQL statement? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point

You have an Azure subscription that contains an Azure SQL database.
The database fails to respond to queries in a timely manner.
You need to identify whether the issue relates to resource_semaphore waits.
How should you complete the Transact-SQL query? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure SQL Database instance named DatabaseA on a server named
Server1.
You plan to add a new user named App1 to DatabaseA and grant App1 db_datacenter
permissions. App1 will use SQL Server Authentication.
You need to create App1. The solution must ensure that App1 can be given access to other
databases by using the same credentials.
Which three actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.