Ultimate access to all questions.
You are managing a Fabric tenant which includes a data warehouse named Warehouse1. Within Warehouse1, there are three distinct schemas: schemaA, schemaB, and schemaC. Your objective is to ensure that a user, referred to as User1, has the permission to truncate tables within schemaA exclusively. How would you complete the T-SQL statement to achieve this? NOTE: Each correct selection is worth one point.