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?
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.
Answer is B, but it is incorrectly worded.
You can't grant "ddl_admin" on a schema level.
DDL_admin is a database level role.
On a schema level, you can grant ALTER/CREATE permission.
Since the requirement says - "Ensure that users can create their own DB object but be prevented from modifying any existing DB objects", it would be best to create a separate schema for that and provide access only on that schema.
Answer is Correct D,
As in Question , solution must meet the business goals : Ensure that users of the PaaS solution can create their own database objects but be prevented from modifying any of the existing database objects supplied by Contoso.
should be B.
"Users must be able to review the queries issued against the PaaS databases and identify any new objects created."
upvoted 2 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.
voodoo_sh
2 months, 1 week agoIcyb3r
7 months, 4 weeks agoeric0718
11 months, 4 weeks agoAlCubeHead
1 year, 2 months agoChunchi
1 year, 2 months agoSmartiup
1 year, 3 months agoSingii
1 year, 3 months agoAmitB
1 year, 7 months agoRegius13
1 year, 7 months agothomas0959
1 year, 8 months ago