Question
You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains three schemas named schemaA, schemaB, and schemaC.
You need to ensure that a user named User1 can truncate tables in schemaA only.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
```
GRANT [Permission] ON [Securable] TO User1;
```
Explanation
For the Permission dropdown, choose ALTER: the minimum permission required for TRUNCATE TABLE is ALTER on the table, while CONNECT only allows connecting to the database and EXECUTE applies to procedures and functions. For the Securable dropdown, choose SCHEMA::schemaA: granting ALTER at the schema scope covers every table in schemaA and nothing in schemaB or schemaC. DATABASE:: would require a database name and would cover all schemas, and OBJECT:: refers to a single table or other object, not a schema.
