
Answer-first summary for fast verification
Answer: ALTER/SCHEMA
To grant User1 the ability to truncate tables in schemaA only, you need to modify the schema permissions. The correct T-SQL statement to do this is using the ALTER permission on the schema. This grants the necessary rights to modify (including truncating tables) within the specified schema, ensuring that the permission is restricted to schemaA and does not extend to other schemas or objects.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are managing a Fabric tenant that includes a data warehouse named Warehouse1, which is organized into three distinct schemas called schemaA, schemaB, and schemaC. Your goal is to grant a user named User1 the ability to truncate tables specifically within schemaA, without affecting their permissions on schemaB and schemaC. How should you complete the T-SQL statement to meet these requirements? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Correct Answer: ALTER/SCHEMA This statement allows the user to alter (which includes truncating) tables within the specified schema, ensuring that the permission is restricted to schemaA and does not grant access to other schemas or objects.
A
ALTER/SCHEMA
B
GRANT/SCHEMA
C
ALTER/OBJECT
D
EXECUTE/SCHEMA
No comments yet.