Online Access Free 070-473 Practice Test
| Exam Code: | 070-473 |
| Exam Name: | Designing and Implementing Cloud Data Platform Solutions |
| Certification Provider: | Microsoft |
| Free Question Number: | 170 |
| Posted: | Aug 29, 2026 |
You need to recommend a database strategy to support the planned new customers. The solution must minimize costs.
What should you recommend?
You need to create a Microsoft Azure Resource manager template.
Which file format should you use?
You need to prepare the Azure environment for the planned migration of DB1. The solution must meet the requirements of the finance department.
Which two tasks should you perform in Azure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the Add-AzureRmSqlDatabase cmdlet from PowerShell.
Does this meet the goal?
Your company has several Microsoft SQL Server databases that are hosted on Microsoft Azure virtual machines. You plan to protect the data in the databases. The company employs several developers who implement changes to the databases. An application named App1 accesses the databases. App1 uses the Entity Framework and does not use any stored procedures.
An application named App2 accesses the databases. App2 uses the SQL Server 2008 R2 driver. App2 only accesses the names of customers that are stored in the databases.
You need to configure the databases to meet the following security requirements:
Prevent the developers from viewing the customer's names
Prevent unauthorized users from restoring a backup of any database
Prevent system administrators from viewing the customers' credit card numbers that are stored in the databases.
What should you implement to meet each security requirement? To answer, drag the appropriate technologies to the correct security requirements. Each technology may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
