Free Microsoft 070-473 Exam Dumps Questions & Answers

Your environment contains several Microsoft Azure SQL databases.
You need to prevent inbound connections from the Internet to the databases when CPU utilization exceeds 90 percent.
Which two tasks should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Create an Azure alert based on an event.
• B.Create an Azure metric alert.
• C.Create an Azure Data Factory pipeline.
• D.Deploy an Azure logic app.
• E.Create a SQL Server Agent job.

You have a Microsoft Azure SQL database named DB1 on a logical server named Serverl48923034.database.windows.net. You need to restore DB1 to another database named DB2 on the same server.
Which Azure PowerShell command should you run first? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

You need to deploy a new Microsoft Azure SQL database that must meet the following requirements:
* Will be available it a single Azure region becomes unavailable
* Will be able to fail over to another Azure region automatically
Which two configuration tasks should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Configure the database connection string to point to the endpoint of the primary replica.
• B.Add the database to a database pool.
• C.Add the database to a failover group.
• D.Configure the database connection string to point to the endpoint of the read-write listener.
• E.Add the database to an AlwaysOn availability group that uses synchronous replication.

You have an on-premises database hosted on a Microsoft SQL Server instance.
You plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
Which three 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:

Explanation

Your organization contains several Microsoft Azure SQL databases.
You need to ensure that an administrator is notified when SQL injection is detected on one of the databases.
Which two features should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Auditing
• B.Management Data Warehouse
• C.Query Performance Insight
• D.Threat detection
• E.Azure Resource Health