| Exam Code/Number: | 070-473Join the discussion |
| Exam Name: | Designing and Implementing Cloud Data Platform Solutions |
| Certification: | Microsoft |
| Question Number: | 170 |
| Publish Date: | May 29, 2026 |
|
Rating
100%
|
|
You need to recommend a solution to host a database in Microsoft Azure. The solution must meet the following requirements:
* Backups can be performed from a non-production node.
* Premium storage is used.
Which high-availability and storage redundancy solutions should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have Microsoft Azure SQL database named DB1.
You plan to monitor the resource utilization of DB1.
You need to review the following resource utilization:
* Average compute
* Average I/O
Which data managment view should you use?
Your company has a Microsoft Azure MySQL database that is used by an Azure Web App. The logical server that hosts the database contains other databases.
You move the database to another Azure tenant.
You need to ensure that the Web App can access the database.
What should you do?
You need to design a security strategy to support the planned changes for the customer databases, The solution must meet the security requirements.
Which two security roles should you grant to the customers? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
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.
