Azureサブスクリプションに、Serverlという論理SQLサーバーが含まれています。Serverlのマスターデータベースには、Userlというユーザーが含まれています。UserlがServerl上にデータベースを作成できるようにする必要があります。Userlにはどのデータベースロールを割り当てる必要がありますか?
正解:B
Basic Concept: This question tests implement a secure environment in the DP-300 exam context. The correct choice is determined by the exact service boundary and operational requirement stated in the scenario.
Why B is Correct: dbmanager matches the expected DP-300 administration action. dbmanager is a security- related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: You need to ensure that Userl can create databases on Serverl.
Why A is Wrong: db_owner is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It does not satisfy the required identity, encryption, firewall, auditing, or data-exposure boundary described in the scenario: You need to ensure that Userl can create databases on Serverl.
Why C is Wrong: dbo is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It is not the right enforcement point for this case; the scenario needs the control that governs the data or identity path being tested.
Why D is Wrong: db_ddladmin is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It does not satisfy the required identity, encryption, firewall, auditing, or data-exposure boundary described in the scenario: You need to ensure that Userl can create databases on Serverl.