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

Read More

March/2023 Latest Braindump2go DP-300 Exam Dumps with PDF and VCE Free Updated Today! Following are some new Braindump2go DP-300 Real Exam Questions!

QUESTION 109
You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies.
You need to ensure that users from each company can view only the data of their respective company.
Which two objects should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. a column encryption key
B. asymmetric keys
C. a function
D. a custom role-based access control (RBAC) role
E. a security policy

Answer: CE
Explanation:
Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Implement RLS by using the CREATE SECURITY POLICY Transact-SQL statement, and predicates created as inline table-valued functions.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac
https://docs.microsoft.com/en-us/security/benchmark/azure/baselines/synapse-analytics-security-baseline
https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

Read More