Home » Microsoft » 70-762 » Which schema permissions should you assign?
HOTSPOT
A database administrator needs to perform specific actions for objects in the database.
You need to ensure the administrator can perform the tasks using the principle of least privilege.
Which schema permissions should you assign? To answer, select the appropriate permissions for each task in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Explanation/Reference:
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-schema-transact-sql?view=sql-server-2017#permissions
https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-database-collation?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-schema-transact-sql?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/relational-databases/tables/rename-tables-database-engine?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql?view=sql-server-2017#permissions