SnowPro Core Certification — Question 555

What is the recommended way to obtain a cloned table with the same grants as the source table?

Answer options

• A. Clone the table with the COPY GRANTS command.
• B. Use an ALTER TABLE command to copy the grants.
• C. Clone the schema then drop the unwanted tables.
• D. Create a script to extract grants and apply them to the cloned table.

Correct answer: A

Explanation

The recommended approach is to use the COPY GRANTS command when cloning a table, as it directly transfers the permissions from the source table to the cloned one. The other options either do not provide a direct method for copying grants or involve more complex processes that are not necessary for this task.