Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
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.
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.