DP-300 Question #87: Real Exam Question with Answer & Explanation

Sign in or unlock DP-300 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.

Submitted by neha2k· Mar 6, 2026Implement and manage database security in Azure SQL Database, including creating server-level logins, database users, and role assignments to control access across multiple databases.

Question

Drag and Drop Question You have an Azure SQL Database instance named DatabaseA on a server named Server1. You plan to add a new user named App1 to DatabaseA and grant App1 db_datacenter permissions. App1 will use SQL Server Authentication. You need to create App1. The solution must ensure that App1 can be given access to other databases by using the same credentials. 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. Answer:

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock DP-300 - $49.99 / 30 days Sign in

Topics

#Azure SQL Database#SQL Server Authentication#Database Security#Logins and Users

Full DP-300 Practice Browse All DP-300 Questions