DP-300 Exam Question 241
You have an Azure subscription.
You need to deploy an Azure SQL database. The solution must meet the following requirements:
- Dynamically scale CPU resources.
- Ensure that the database can be paused to reduce costs.
What should you use?
You need to deploy an Azure SQL database. The solution must meet the following requirements:
- Dynamically scale CPU resources.
- Ensure that the database can be paused to reduce costs.
What should you use?
DP-300 Exam Question 242
Hotspot Question
You have an Azure subscription that contains an Azure SQL database named DB1.
Users report that DB1 has query performance issues.
You need to ensure that you can move specific tables in DB1 to In-Memory OLTP.
How should you complete the T-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 named DB1.
Users report that DB1 has query performance issues.
You need to ensure that you can move specific tables in DB1 to In-Memory OLTP.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 243
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.
You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements:
- The service that hosts the migrated databases must be able to
communicate with SQL2 by using linked server connections.
- Administrative effort must be minimized.
What should you use to host the databases?
You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements:
- The service that hosts the migrated databases must be able to
communicate with SQL2 by using linked server connections.
- Administrative effort must be minimized.
What should you use to host the databases?
DP-300 Exam Question 244
Drag and Drop Question
You have an Azure subscription that contains a SQL Server on Azure virtual Machines instance named SQLVM1.
You need to ensure that SQL Server Agent jobs on SQLVM1 can run operating system commands.
Which four T-SQL statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
You have an Azure subscription that contains a SQL Server on Azure virtual Machines instance named SQLVM1.
You need to ensure that SQL Server Agent jobs on SQLVM1 can run operating system commands.
Which four T-SQL statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
