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: Jun 05, 2025

Add To Cart

Question 1

The maximum number of unique tag keys that can be set on a single object is

A : 100

B : 10

C : 50

D : 20

Answer: D

Question 2

Enable failover for a primary database to one or more accounts in your organization using which command?

A : ALTER DATABASE … ENABLE FAILOVER TO ACCOUNT

B : It can be set only via SnowSight web interface

C : ALTER DATABASE … ENABLE FAILOVER TO ACCOUNTS

D : ALTER DATABASE … ACTIVATE FAILOVER TO ACCOUNTS

Answer: C

Question 3

A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema: Table Name:VWH_META Column 1:SNAPSHOT_TIME TIMESTAMP_NTZ Column 2:CONFIG VARIANT Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH META?

A : 1. SHOW WAREHOUSES;2. INSERT INTO VWH METASELECT CURRENT TIMESTAMP (),FROM TABLE (RESULT_SCAN (LAST_QUERY_ID(1) ) ) ;

B : 1. SHOW WAREHOUSES;2. INSERT INTO VWH METASELECT CURRENT TIMESTAMP (), *FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ())) ;

C : 1. SHOW WAREHOUSES;2. INSERT INTO VWH_METASELECT CURRENT_TIMESTAMP (),OBJECT CONSTRUCT (*)FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ()));

D : 1. SHOW WAREHOUSES;2. INSERT INTO VWH METASELECT CURRENT TIMESTAMP (), *FROM TABLE (RESULT_SCAN (SELECTLAST QUERY ID(-1)));

Answer: C

Question 4

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 5

If a view references any object in another database (e.g. table columns, other views, UDFs, or stages), both databases must be replicated during database replication?

A : FALSE

B : TRUE

Answer: B

Page: 1 / 53

Total 265 Questions | Updated On: Jun 05, 2025

Add To Cart