Online Access Free 70-473 Practice Test
| Exam Code: | 70-473 |
| Exam Name: | Designing and Implementing Cloud Data Platform Solutions |
| Certification Provider: | Microsoft |
| Free Question Number: | 170 |
| Posted: | May 25, 2026 |
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.
Your company has an application that uses several Microsoft Azure SQL databases. New databases are added regularly as customers sign up for new services. Databases are removed regularly as customers cancel the services.
You create an auditing policy.
You plan to configure auditing for all of the databases.
You need to ensure that all of the databases are audited constantly.
Which cmdlet should you use?
Your company has a data center located in Europe. The company has a 10 Mbps connection to the Internet that is 80 percent saturated on average. You have an on-premises Microsoft SQL Server database that is 6 TB. You plan to migrate the database the database to Microsoft Azure.
You need to recommend a solution to migrate the database to Azure. The solution must meet the following requirements:
- Ensure that the database is hosted in the West US region.
- Minimize any changes to the current network infrastructure.
- Minimize the amount of time required to migrate the database.
What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
Select the BEST answer.
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.
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.
