2025/November Latest Braindump2go DP-300 Exam Dumps with PDF and VCE Free Updated Today! Following are some new Braindump2go DP-300 Real Exam Questions!
QUESTION 205
You are training a new administrator for your company’s Azure data services, which includes database deployed on Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure virtual machines (VMs).
You need to identify the fixed roles that are supported by Azure SQL Database only.
Which two fixed roles are available with Azure SQL Database only?
Each correct answer presents a complete solution.
A. db_securityadmin
B. sysadmin
C. dbmanager
D. dbcreator
E. loginmanager
Answer: CE
QUESTION 206
You provision an Azure SQL Managed Instance database named MyDevData. The database will be used by in-house development for application development projects.
DevSupport custom database role members will use dynamic management views (DMVs) to retrieve performance and health information about MyDevData.
You need to ensure that DevSupport members can view information through DMVs.
Which statement should you use?
Each correct answer presents part of the solution.
A. GRANT VIEW DATABASE STATE TO DevSupport
B. GRANT VIEW SERVER STATE TO DevSupport
C. GRANT VIEW DEFINITION TO DevSupport
D. GRANT VIEW REFERENCES TO DevSupport