Answer: OWNERSHIP privilege on the CUSTOMER table, CREATE TABLE privilege on the T1 database

To restore a dropped table in Snowflake, two specific privileges are required: OWNERSHIP privilege on the table (or the schema containing it) to have the authority to restore it, and CREATE TABLE privilege on the database (or schema) to recreate the table structure. Option B (OWNERSHIP privilege on the CUSTOMER table) grants the necessary control over the table for restoration. Option E (CREATE TABLE privilege on the T1 database) allows the user to create the table during the restore process. The community discussion consistently supports B and E with multiple comments and upvotes, confirming this as the consensus. Other options are less suitable: A (SELECT privilege) only allows data viewing, C (All privileges on the table) is excessive and not specifically required, and D (All privileges on the database) is broader than necessary and does not directly address table restoration.

Author: LeetQuiz Editorial Team