Snowflake
ADA-C01 · Question #71
ADA-C01 Question #71: Real Exam Question with Answer & Explanation
The correct answer is B. Use the following SQL command: D. Transient tables will persist until explicitly dropped and contribute to overall storage costs.. The COPY GRANTS option can be used to copy all privileges, except OWNERSHIP, from the existing table to the new transient table. This option also preserves any future grants defined for the object type in the schema.
Question
An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table. How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements? (Choose two.)
Options
- AUse the following SQL command:
- BUse the following SQL command:
- CUse the following SQL commands:
- DTransient tables will persist until explicitly dropped and contribute to overall storage costs.
- ETransient tables will be purged at the end of the user session and do not have any Fail-safe
Explanation
The COPY GRANTS option can be used to copy all privileges, except OWNERSHIP, from the existing table to the new transient table. This option also preserves any future grants defined for the object type in the schema.
Community Discussion
No community discussion yet for this question.