Free Practice Snowflake ADA-C01 Exam Questions 2025

Stay ahead with 100% Free SnowPro Advanced Administrator ADA-C01 Dumps Practice Questions

Page: 1 / 53

Total 265 Questions | Updated On: Apr 10, 2025

Add To Cart

Question 1

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

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

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

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;

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

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

Answer: B,D

Question 2

In case of Query Result Cache reuse requirements, Changes can be made to source tables, but only if they do not affect any micro-partitions relevant to query?

A : TRUE

B : FALSE

Answer: A

Question 3

A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size. Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

A : Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.

B : Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

C : Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.

D : Create four virtual warehouses (sized Small through XL) and set them to auto-suspend andauto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run

Answer: B

Question 4

Snowflake data providers can share data with data consumers in a different region?

A : FALSE

B : TRUE

Answer: B

Question 5

When future grants are defined at both the database and schema level, the schema level grants take precedence over the database level grants, and the database level grants are ignored.?

A : FALSE

B : TRUE

Answer: B

Page: 1 / 53

Total 265 Questions | Updated On: Apr 10, 2025

Add To Cart