Question 96

You have an Azure SQL database named DB1.
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails.
The solution must minimize costs.
Which deployment option and pricing tier should you configure?
  • Question 97

    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.

    Question 98

    You have an Azure subscription.
    You plan to deploy an Azure SQL database by using an Azure Resource Manager template.
    How should you complete the template? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 99

    You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.
    What should you include in the migration plan? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 100

    You have an Azure subscription that is linked to an Azure AD tenant named contoso.com. The subscription contains an Azure SQL database named SQL 1 and an Azure web named app1. App1 has the managed identity feature enabled.
    You need to create a new database user for app1.
    How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.