Snowflake Exam ADA-C01 Topic 4 Question 36 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 36
Topic #: 4

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? (Select TWO).

AUse the following SQL command:
create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

BUse the following SQL command:
create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

CUse the following SQL commands:
create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants;
insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

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 period.

Show Suggested Answer

Suggested Answer: B, D

According to the Snowflake documentation1, 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. Option A is incorrect because it does not copy any grants from the original table. Option C is incorrect because it does not copy the data from the original table, only the structure and grants. Option E is incorrect because transient tables are not session-based and do not have a Fail-safe period, but they do have a Time Travel retention period2.

1: CREATE TABLE | Snowflake Documentation 2: Working with Temporary and Transient Tables | Snowflake Documentation

by Frankie at Apr 07, 2025, 05:58 AM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Pa

2 days ago

I think option C sounds familiar because it mentions creating a table like the original and then inserting data, but I can't recall if it actually copies the permissions.

upvoted 0 times

...

Tabetha

8 days ago

I remember something about using "copy grants" to ensure the new table has the same permissions, but I'm not sure which command to use.

upvoted 0 times

...

Delisa

13 days ago

I think options C and B are the way to go here. Creating the transient table with the same structure and permissions as the original table seems like the best approach to meet the requirements.

upvoted 0 times

...

Refugia

19 days ago

The storage cost consideration in option D is an important factor to keep in mind. Transient tables can add up quickly, so that's something I'll need to be mindful of.

upvoted 0 times

...

Billye

24 days ago

I'm a bit confused by the difference between "create transient table" and "create table like". I'll need to double-check the syntax and implications of each.

upvoted 0 times

...

Clarinda

30 days ago

Okay, I think I've got this. The key is to create the transient table in a way that inherits the same permissions as the original table. Options B and C look promising.

upvoted 0 times

...

Rebecka

1 month ago

Hmm, this seems like a tricky one. I'll need to carefully read through the options and think about the requirements.

upvoted 0 times

...

Cristy

6 months ago

Option B looks tempting, but the 'copy grants' part is a bit suspicious. I'd steer clear of that one.

upvoted 0 times

Anglea

4 months ago

E) Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

upvoted 0 times

...

Pete

4 months ago

D) Transient tables will persist until explicitly dropped and contribute to overall storage costs.

upvoted 0 times

...

Rikki

4 months ago

C) Use the following SQL commands: create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

upvoted 0 times

...

Eric

4 months ago

A) Use the following SQL command: create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

upvoted 0 times

...

Gail

6 months ago

Haha, I'm just glad I don't have to worry about transient tables and their storage costs. That's the administrator's problem!

upvoted 0 times

Dong

5 months ago

D) Transient tables will persist until explicitly dropped and contribute to overall storage costs.

upvoted 0 times

...

Billye

5 months ago

C) Use the following SQL commands: create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

upvoted 0 times

...

Louann

5 months ago

A) Use the following SQL command: create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

upvoted 0 times

...

Arthur

6 months ago

I agree, C is the correct answer. Replicating the table structure and then copying the data is the best approach here.

upvoted 0 times

Zona

6 months ago

E) Transient tables will be purged at the end of the user session and do not have any Fail-safe period.

upvoted 0 times

...

Ariel

6 months ago

D) Transient tables will persist until explicitly dropped and contribute to overall storage costs.

upvoted 0 times

...

Theodora

6 months ago

A) Use the following SQL commands: create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

upvoted 0 times

...

Belen

6 months ago

I'm not sure about the storage costs mentioned in option D, but creating a transient table with the same permissions is definitely important for data integrity.

upvoted 0 times

...

Donte

7 months ago

I agree with Tequila, using 'copy grants' in the SQL command will ensure the transient table inherits the same permissions.

upvoted 0 times

...

Mira

7 months ago

Option C is the way to go. Creating a table like the original one and then copying the data ensures the permissions are inherited.

upvoted 0 times

Josephine

6 months ago

D) Transient tables will persist until explicitly dropped and contribute to overall storage costs.

upvoted 0 times

...

Rhea

6 months ago

A) Use the following SQL commands: create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

upvoted 0 times

...

Tequila

7 months ago

I think the Administrator should use option C to create the transient table with the same permissions.

upvoted 0 times

...