Question 236

You have a new Azure subscription.
You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.
You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
  • Question 237

    You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
    You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
    How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 238

    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.

    Question 239

    You have an Azure SQL managed instance named SQLMI1 that has Resource Governor enabled and is used by two apps named App1 and App2.
    You need to configure SQLMI1 to limit the CPU and memory resources that can be allocated to App1.
    Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    Question 240

    You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure
    SQL Database server.
    You need to ensure that each customer can only connect to and access their respective database.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.