Home » Microsoft » 70-473 v.2 » Which two security roles should you grant to the customers?
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.
A. db_datawriter
B. dbcreator
C. db_owner
D. db_ddladmin
E. db_datareader
Correct Answer: DE
Explanation/Reference:
From Scenario: Security requirements
Relecloud identifies the following requirements:
• Customers must be able to read data only. (db_datareader)
• Customers must be able to create custom views. (db_ddladmin)
• Customers must be able to use two-factor authentication when accessing Azure SQL databases.
