HOTSPOT - You are evaluating the role assignments. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
Suggested Answer:
Box 1: No - DBAGroup1 is member of the Contributor role. The Contributor role grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC, manage assignments in Azure Blueprints, or share image galleries.
Box 2: No - Contributor - Grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC SQL DB Contributor - Lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers.
Box 3: Yes - DBAGroup2 is member of the SQL DB Contributor role. The SQL DB Contributor role lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers. As a member of this role you can create and manage SQL databases. Reference: https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles
Proposed answer is wrong.
The correct answer is:
NO - with contributor you cannot access database, you can only manage them (except for security)
NO (contributor cannot manage security)
YES (since you have this permission on each logical server, you can create database)
NO, permission is only on THIS logical server.
The group has no right to create databases on another server (unless there is more privileges that are not shown here)
so NO, NO, NO
Microsoft states that the following rules apply:
Contributor - Grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC
SQL DB Contributor - Lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers.
Answer looks good from this perspective: Yes-No-Yes
No, No, Yes
Contributor - Grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC. All these permissions are to make changes to the database setting at Azure Portal level. For the user to connect to database using SSMS/Data Studio to perform any tasks at database level, user/group need to be given permissions by Admin first.
upvoted 5 times
...
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Jeembeem
Highly Voted 2 years, 8 months agoSTH
2 years, 4 months agoSTH
2 years, 4 months agouzairahm
1 year, 3 months agomark9999
Highly Voted 2 years, 8 months agoamazonalex
Most Recent 7 months, 2 weeks agoreachmymind
1 year, 8 months agojerkyflexoff
2 years agojerkyflexoff
2 years agoKishorepi
2 years, 6 months ago