Administering Relational Databases on Microsoft Azure — Question 15

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals.
What should you include in the recommendation?

Answer options

• A. For each customer, grant the customer ddl_admin to the existing schema.
• B. For each customer, create an additional schema and grant the customer ddl_admin to the new schema.
• C. For each customer, create an additional schema and grant the customer db_writer to the new schema.
• D. For each customer, grant the customer db_writer to the existing schema.

Correct answer: B

Explanation

Option B is correct because it allows each customer to create their own database objects in a separate schema while maintaining control over the existing schema. Option A does not isolate the customer's objects, and options C and D do not provide the necessary permissions for creating database objects.