Online Access Free 70-473 Practice Test

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

You are planning the consolidation of the databases from Host1.
You need to identify which methods to use to back up the data after the consolidation completes. What are two possible methods that achieve this goal? Each correct answer presents a complete solution.

• A.BACKUP TO URL
• B.AlwaysOn failover clustering
• C.a maintenance plan
• D.AlwaysOn Availability Groups

You have a Microsoft Azure virtual machine named SQL1 that has Microsoft SQL Server 2016 installed.
SQL1 has a critical database that contains online transaction data. The database is 700 GB.
You regularly perform full database backups.
On a separate Azure virtual machine, you run a test restore procedure of the database and discover that restoring the database takes longer than expected.
You need to reduce the amount of time required to restore the database.
What should you do?

• A.Create multiple filegroups in the database, and then modify the backup solution to use filegroup backups.
• B.Partition the tables in the database, and then modify the backup solution to use incremental backups.
• C.Modify the backup solution to use differential database backups.
• D.Modify the backup solution to use transaction log backups.

You have four Microsoft Azure SQL databases located on the same database server.
You need to configure the databases to be in an elastic database pool.
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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Correct Answer:

Explanation

References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-elastic-pool-create-portal/

Your company's data center contains three Microsoft SQL Server databases named DB1, DB2, and DB3.
You plan to migrate the databases to Microsoft Azure.
You need to provision the recourses in Azure to meet the following requirements.
* DB1 must be able to execute CLR assemblies.
* DB2 must be able to run SQL Server Agent jobs.
Which database solution should you use for each database? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation