DP-300 Certification Practice Question #291

Question

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:

Accepted Answer

Statement 2 is definitively No — Contributor cannot assign Azure RBAC roles (that requires Owner). Statement 3 is definitively Yes — DBAGroup2 has SQL DB Contributor on each server, which by definition allows creating and managing SQL databases. Statement 1 is the disputed point: Contributor (DBAGroup1) grants control-plane access to manage the Azure resource, but does NOT automatically grant data-plane access to sign in to the SQL database via Azure Data Studio (SSMS/ADS). Data-plane access requires an explicit SQL or Azure AD user inside the database, which must be granted by a database admin. The highest-voted commenter (Jeembeem 👍 27) and Kishorepi (👍 5) make this distinction correctly: the answer is No/No/Yes. Confidence is 82% because of the meaningful dissent from mark9999 (👍 12) who argues Yes for statement 1.

More DP-300 practice questions