Designing and Implementing Cloud Data Platform Solutions

Here you have the best Microsoft 70-473 practice exam questions

You have 26 total questions across 6 pages (5 per page)
These questions were last updated on February 14, 2026
This site is not affiliated with or endorsed by Microsoft.

Question 1 of 26

DRAG DROP -
You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database.
You need to configure firewall rules to meet the following requirements:
✑ Access the database remotely.
✑ Manage the server remotely by using Windows PowerShell.
✑ Manage the server remotely by using Remote Desktop.
Which Azure endpoint ports should you open? To answer, drag the appropriate ports to the correct types of access. Each port 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.
Select and Place:
Exam 70-473: Question 1 - Image 1

Question 2 of 26

You have a Microsoft SQL Server instance on a Microsoft Azure virtual machine.
The members of an Active Directory group named HelpDesk can log in to the SQL Server instance.
You need to ensure that the members of HelpDesk can query dynamic management views and gather performance metrics from the SQL Server instance.
Which three actions should you perform? Each correct answer presents part of the solution.

Add HelpDesk to the db_owner role for all of the databases.

Add HelpDesk to the new role.

Grant VIEW ANY DATABASE to the new role.

Grant VIEW SERVER STATE to the newrole.

Create a database role.

Create a server role.

Question 3 of 26

You have a Microsoft Azure SQL database.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.

Question 4 of 26

Your company has two offices located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft Azure SQL database. Currently, only the users in the London office use the database.
You plan to provide the users in the New York office with access to the database.
You need to ensure that the New York office users can access the database.
Which command should you execute?

EXECUTE sp_set_database_firewall_rule N’NewYork,’131.107.15.1’,’255.255.255.255’

EXECUTE sp_set_database_firewall_rule N’NewYork, ’192.168.8.0’, ‘192.168.8.255’;

EXECUTE sp_set_database_firewall_rule N’NewYork,’192.168.8.0’, ’255.255.255.0’;

EXECUTE sp_set_database_firewall_rule N’NewYork,’131.107.15.1’,’131.107.15.1’;

Question 5 of 26

You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine.
You need to ensure that all SQL Server audits are written to the Windows Security log.
Which two actions should you perform? Each correct answer presents part of the solution.

Configure the Audit policy change policy.

Assign the Generate security audits user right.

Configure the Audit object access policy.

Assign the Log on as a service user right.

Configure the Audit the access of global system objects policy.

About the Microsoft 70-473 Certification Exam

About the Exam

The Microsoft 70-473 (Designing and Implementing Cloud Data Platform Solutions) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 26 practice questions across 6 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our 70-473 questions are regularly updated to reflect the latest exam objectives.