You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 contains an Azure SQL database named DB1. The schema and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database project.
You need to populate a new resource group named App1Test with the DB1 database and an Azure SQL Server named TestServer1. The resources in App1Test must have the same configurations as the resources in App1Dev.
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.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You create five Azure SQL Database instances on the same logical server.
In each database, you create a user for an Azure Active Directory (Azure AD) user named User1.
User1 attempts to connect to the logical server by using Azure Data Studio and receives a login error.
You need to ensure that when User1 connects to the logical server by using Azure Data Studio, User1 can see all the databases.
What should you do?

• A.Create User1 in the master database.
• B.Assign User1 the db_datareader role for the master database.
• C.Assign User1 the db_datareader role for the databases that Userl creates.
• D.Grant select on sys.databases to public in the master database.

Comment: *

Name: *

Email: *

Verification: *

You plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.
What should you use?

• A.two Azure SQL Databases in an elastic pool
• B.two databases hosted in SQL Server on an Azure virtual machine
• C.two databases in an Azure SQL Managed instance
• D.two single Azure SQL databases

Comment: *

Name: *

Email: *

Verification: *

You have 50 Azure SQL databases.
You need to notify the database owner when the database settings, such as the database size and pricing tier,
are modified in Azure.
What should you do?

• A.Create a diagnostic setting for the activity log that has the Security log enabled.
• B.For the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled.
• C.Create an alert rule that uses a Metric signal type.
• D.Create an alert rule that uses an Activity Log signal type.

Comment: *

Name: *

Email: *

Verification: *

D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

• A.Configure SalesSQLDb1 as writable.
• B.Update the connection strings of SalesSQLDb1App1.
• C.Update the firewall rules of SalesSQLDb1.
• D.Update the users in SalesSQLDb1.

Comment: *

Name: *

Email: *

Verification: *