<< Prev Question Next Question >>

Question 15/72

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.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (72q)
Question 1: You have two Azure virtual machines named VM1 and VM2 that r...
Question 2: You have an Azure SQL database named db1. You need to retrie...
Question 3: Note: This question is part of a series of questions that pr...
Question 4: You need to apply 20 built-in Azure Policy definitions to al...
Question 5: You have a on-premises Microsoft SQL Server named SQL1 that ...
Question 6: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
Question 7: You have an Azure SQL managed instance. You need to enable S...
Question 8: You have a Microsoft SQL Server database named DB1 that cont...
Question 9: Note: This question is part of a series of questions that pr...
Question 10: You have an Azure SQL database named DB1. The automatic tuni...
Question 11: You have SQL Server on an Azure virtual machine named SQL1. ...
Question 12: You have a resource group named App1Dev that contains an Azu...
Question 13: Note: This question is part of a series of questions that pr...
Question 14: Note: This question is part of a series of questions that pr...
Question 15: You have an Azure subscription that contains an Azure SQL da...
Question 16: Note: This question is part of a series of questions that pr...
Question 17: You have a data warehouse in Azure Synapse Analytics. You ne...
Question 18: You have an Azure Synapse Analytics Apache Spark pool named ...
Question 19: You have an instance of SQL Server on Azure Virtual Machine ...
Question 20: You are building a database in an Azure Synapse Analytics se...
Question 21: You have an Azure SQL Database managed instance named SQLMI1...
Question 22: You have an Azure SQL managed instance named MI1. You need t...
Question 23: You have SQL Server on an Azure virtual machine that contain...
Question 24: From a website analytics system, you receive data extracts a...
Question 25: You have an Azure subscription that contains an Azure Data F...
Question 26: You have the following Transact-SQL query. (Exhibit) Which c...
Question 27: You have an Azure SQL database. You run the following PowerS...
Question 28: Note: This question is part of a series of questions that pr...
Question 29: Note: This question is part of a series of questions that pr...
Question 30: You are designing a star schema for a dataset that contains ...
Question 31: What should you implement to meet the disaster recovery requ...
Question 32: You have an on-premises app named App1 that stores data in a...
Question 33: You have a SQL Server on Azure Virtual Machines instance nam...
Question 34: Which windowing function should you use to perform the strea...
Question 35: You have a version-8.0 Azure Database for MySQL database. Yo...
Question 36: You have an Azure SQL database named DB1. DB1 contains a tab...
Question 37: You have an on-premises Microsoft SQL Server 2019 server tha...
Question 38: You have a database on a SQL Server on Azure Virtual Machine...
Question 39: You are developing an application that uses Azure Data Lake ...
Question 40: You have an Azure SQL database that contains a table named E...
Question 41: You are monitoring an Azure Stream Analytics job. You discov...
Question 42: Based on the PaaS prototype, which Azure SQL Database comput...
Question 43: You have an Azure virtual machine based on a custom image na...
Question 44: Note: This question is part of a series of questions that pr...
Question 45: You need to trigger an Azure Data Factory pipeline when a fi...
Question 46: You have SQL Server on an Azure virtual machine that contain...
Question 47: You have an Azure subscription that is linked to a hybrid Az...
Question 48: You have an on-premises Microsoft SQL server that uses the F...
Question 49: You are designing a security model for an Azure Synapse Anal...
Question 50: You have an Azure SQL Database instance named DatabaseA on a...
Question 51: You have an Azure Data Factory instance named ADF1 and two A...
Question 52: You have SQL Server on an Azure virtual machine that contain...
Question 53: You have an Azure data solution that contains an enterprise ...
Question 54: You manage an enterprise data warehouse in Azure Synapse Ana...
Question 55: You have an Azure SQL database. You are reviewing a slow per...
Question 56: You need to design a data retention solution for the Twitter...
Question 57: You have an Azure SQL database named db1 on a server named s...
Question 58: You have an instance of SQL Server on Azure Virtual Machine ...
Question 59: You have an Azure subscription. You need to deploy an Azure ...
Question 60: You plan to perform batch processing in Azure Databricks onc...
Question 61: You are designing an enterprise data warehouse in Azure Syna...
Question 62: Which counter should you monitor for real-time processing to...
Question 63: You need to recommend an availability strategy for an Azure ...
Question 64: You create five Azure SQL Database instances on the same log...
Question 65: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 66: You need to design an analytical storage solution for the tr...
Question 67: You are creating a new notebook in Azure Databricks that wil...
Question 68: You are designing a streaming data solution that will ingest...
Question 69: You have SQL Server on Azure virtual machines in an availabi...
Question 70: You have an Azure subscription. You plan to deploy an Azure ...
Question 71: You have an Azure SQL Database server named sqlsrv1 that hos...
Question 72: You plan to create a table in an Azure Synapse Analytics ded...