DP-300 Exam Question 196

You have 10 Azure virtual machines that have SQL Server installed.
You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups.
What should you include in the backup strategy?
  • DP-300 Exam Question 197

    You have an Azure SQL database named DB1 in the General Purpose service tier.
    You need to monitor D81 by using SQL insights.
    What should you include in the solution? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 198

    You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.
    What should you recommend? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 199

    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 200

    You have SQL Server on an Azure virtual machine that contains a database named Db1.
    You need to enable automatic tuning for Db1.
    How should you complete the statements? To answer, select the appropriate answer in the answer area.
    NOTE: Each correct selection is worth one point.