DP-300 Exam Question 146
You have an Azure subscription that contains the resources shown in the following table.
You plan to use SQLDB11 as an elastic job database to run jobs on SQLDB11 and SQLDB22.
What is the minimum number of database scoped credentials required for the elastic jobs?
You plan to use SQLDB11 as an elastic job database to run jobs on SQLDB11 and SQLDB22.
What is the minimum number of database scoped credentials required for the elastic jobs?
DP-300 Exam Question 147
You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.
In the event of an Azure regional outage, you need to be able to restore the database backups.
The solution must minimize costs.
Which type of storage accounts should you use for the backups?
In the event of an Azure regional outage, you need to be able to restore the database backups.
The solution must minimize costs.
Which type of storage accounts should you use for the backups?
DP-300 Exam Question 148
You have an Azure SQL database named sqldb1.
You need to minimize the possibility of Query Store transitioning to a read-only state.
What should you do?
You need to minimize the possibility of Query Store transitioning to a read-only state.
What should you do?
DP-300 Exam Question 149
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1.
Does this meet the goal?
DP-300 Exam Question 150
You have an Azure subscription that contains the resources shown in the following table.
App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.
You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs.
What should you do?
App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.
You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs.
What should you do?