DP-300 Exam Question 121
Hotspot Question
You are building an Azure Stream Analytics job to retrieve game data.
You need to ensure that the job returns the highest scoring record for each five-minute time interval of each game.
How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You are building an Azure Stream Analytics job to retrieve game data.
You need to ensure that the job returns the highest scoring record for each five-minute time interval of each game.
How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 122
You have an Azure SQL database.
You discover that the plan cache is full of compiled plans that were used only once.
You run the select * from sys.database_scoped_configurations Transact-SQL command and receive the results shown in the following table.
You need relieve the memory pressure.
What should you configure?
You discover that the plan cache is full of compiled plans that were used only once.
You run the select * from sys.database_scoped_configurations Transact-SQL command and receive the results shown in the following table.
You need relieve the memory pressure.
What should you configure?
DP-300 Exam Question 123
Hotspot Question
You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1.
You need to recommend an authentication solution for Pool1. The solution must support multi- factor authentication (MFA) and database-level authentication.
Which authentication solution or solutions should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1.
You need to recommend an authentication solution for Pool1. The solution must support multi- factor authentication (MFA) and database-level authentication.
Which authentication solution or solutions should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 124
You have an Azure subscription.
You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements:
- Custom performance configuration, such as IOPS, capacity, and
throughout, must be supported.
- Costs must be minimized.
Which type of disk should you include in the solution?
You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements:
- Custom performance configuration, such as IOPS, capacity, and
throughout, must be supported.
- Costs must be minimized.
Which type of disk should you include in the solution?
DP-300 Exam Question 125
You have an Azure virtual machine based on a custom image named VM1.
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
- Automate the patching of SQL Server and Windows Server.
- Automate full database backups and transaction log backups of the
databases on VM1.
- Minimize administrative effort.
What should you do first?
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
- Automate the patching of SQL Server and Windows Server.
- Automate full database backups and transaction log backups of the
databases on VM1.
- Minimize administrative effort.
What should you do first?