SnowPro Core Certification — Question 1190

The CUSTOMER table in the T1 database is accidentally dropped.

Which privileges are required to restore this table? (Choose two.)

Answer options

• A. SELECT privilege on the CUSTOMER table
• B. OWNERSHIP privilege on the CUSTOMER table
• C. All privileges on the CUSTOMER table
• D. All privileges on the T1 database
• E. CREATE TABLE privilege on the T1 database

Correct answer: B

Explanation

To restore the CUSTOMER table, the OWNERSHIP privilege on the CUSTOMER table is necessary, as it allows the user to perform recovery actions. The other options, such as SELECT privilege or privileges on the T1 database, do not provide the necessary permissions to restore a dropped table.