UPDATED [Oct 08, 2026] Pass SnowPro Advanced Administrator ADA-C02 Exam with Latest Questions [Q24-Q44]

NEW QUESTION 24
In which scenario will use of an external table simplify a data pipeline?

When accessing a Snowflake table from a relational database

When accessing a Snowflake table from an external database within the same region

When continuously writing data from a Snowflake table to external storage

When accessing a Snowflake table that references data files located in cloud storage

NEW QUESTION 25
An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

Create it as an external table, which will not incur Time Travel costs.

Create it as a transient table with a retention time of 0 days.

Create it as a temporary table with a retention time of 0 days.

Create it as a permanent table with a retention time of 0 days.

NEW QUESTION 26
What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)

SELECT SYSTEM$CANCEL_QUERY(‘problematic_query_id’);

CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => ‘problematic_query_id’);

CREATE TABLE prd_table_bkp as SELECT * from table(result_scan(‘problematic_query_id’));

ALTER TABLE prd_table SWAP WITH prd_table_bkp;

Contact Snowflake Support to retrieve Fail-safe data.

NEW QUESTION 27
Which tasks can be performed by the ORGADMIN role? (Choose three.)

Create one or more accounts in the organization.

View a list of all regions enabled for the organization.

Create secure views on application tables within the organization.

View usage information for all accounts in the organization.

Perform zero-copy cloning on account data.

Create a reader account to share data with another organization.

NEW QUESTION 28
The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD.WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number);
Which role(s) can alter or drop table XYZ?

Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.

SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.

PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.

Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

NEW QUESTION 29
An organization’s sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE_NO
FROM CUSTOMERS
WHERE LAST_UPDATED BETWEEN TO_DATE(CURRENT_TIMESTAMP) AND (TO_DATE(CURRENT_TIMESTAMP)-7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

Wrap the query in a User-Defined Function (UDF) to match syntax execution.

Assign everyone on the sales team to the same virtual warehouse.

Assign everyone on the sales team to the same security role.

Leverage the CURRENT_DATE function for date calculations.

NEW QUESTION 30
A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = ‘hello world!’ MUST_CHANGE_PASSWORD = FALSE
default_role = DEVELOPER_ROLE;
The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?

The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.

The new role can only take effect after USERADMIN has logged out.

USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.

The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.

NEW QUESTION 31
What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

MIMIC CONSUMER ACCOUNT

TEST ACCOUNT ID

PRODUCER TEST ACCT

SIMULATED DATA SHARING CONSUMER

NEW QUESTION 32
An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:
At 80% usage notify the account Administrators.
At 100% usage suspend the warehouse and notify the account Administrators.
At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command will meet these requirements?

create or replace resource monitor RM1 with credit_quota=3000
start_timestamp = ‘2022-01-01 00:00 CET’
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

create or replace resource monitor RM1 with credit_quota=3000
frequency = yearly
start_timestamp = ‘2022-01-01 00:00 CET’
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

create or replace resource monitor RM1 with credit_quota=3000
start_timestamp = ‘2022-01-01 00:00 CET’
triggers on 80 percent do notify
on 100 percent do notify and suspend
on 120 percent do notify and suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

create or replace resource monitor RM1 with credit_quota=3000
frequency = yearly
triggers on 80 percent do notify
on 100 percent do suspend
on 120 percent do suspend_immediate;
alter warehouse WH1 set resource_monitor = RM1;

NEW QUESTION 33
Which type of listing in the Snowflake Marketplace can be added and queried immediately?

Monetized listing

Standard listing

Regional listing

Personalized listing

NEW QUESTION 34
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?

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.

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.

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.

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

NEW QUESTION 35
The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?

Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

Tables created by either user A or user B will be visible to both users.

All existing tables in schema PROD.WORKING will be visible to both users.

Both user A and user B can create tables in the PROD.WORKING schema.

NEW QUESTION 36
A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing only one schema, APP_SCHEMA. The company’s time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?

Set the data retention policy on the secondary database to 60 days.

Set the data retention policy on the schemas in the secondary database to 60 days.

Set the data retention policy on the primary database to 30 days and the schemas to 60 days.

Set the data retention policy on the primary database to 60 days.

NEW QUESTION 37
What are characteristics of Dynamic Data Masking? (Choose two.)

A masking policy that is currently set on a table can be dropped.

A single masking policy can be applied to columns in different tables.

A masking policy can be applied to the VALUE column of an external table.

The role that creates the masking policy will always see unmasked data in query results.

A single masking policy can be applied to columns with different data types.

NEW QUESTION 38
What SCIM integration types are supported in Snowflake? (Choose three.)

Amazon Web Services (AWS)

Google Cloud Platform (GCP)

Okta

Custom

Azure Active Directory (Azure AD)

Duo Security Provisioning Connector

NEW QUESTION 39
What are benefits of using Snowflake organizations? (Choose two.)

Administrators can change Snowflake account editions on-demand based on need.

Administrators can monitor and understand usage across all accounts in the organization.

Administrators can simplify data movement across all accounts within the organization.

User administration is simplified across all accounts within the organization.

Administrators have the ability to create accounts in any available cloud provider or region.

NEW QUESTION 40
What is the default data retention period for transient databases, schemas, and tables for Snowflake Enterprise edition and higher?

1 day

14 days

30 days

90 days

NEW QUESTION 41
When does auto-suspend occur for a multi-cluster virtual warehouse?

When there has been no activity on any cluster for the specified period of time.

After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.

When the minimum number of clusters is running and there is no activity for the specified period of time.

Auto-suspend does not apply for multi-cluster warehouses.

NEW QUESTION 42
An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?

Apply RBAC directly onto the partner’s shared secure views.

Individually grant imported privileges onto the schema in the share.

Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.

Create views over the incoming shared database and apply the desired RBAC onto these views.

NEW QUESTION 43
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

SHOW REGIONS;

SHOW USERS;

SHOW ORGANIZATION ACCOUNTS;

GRANT ROLE ORGADMIN TO USER <username>;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(‘ACCOUNT_LOCATOR’,’ENABLE_ACCOUNT_DATABASE_REPLICATION’,’true’);

NEW QUESTION 44
Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.
Company A’s Administrator created a share.
What object should be added to the share to allow Company B access to the files?

A secure view with a column for file URLs.

A secure view with a column for pre-signed URLs.

A secure view with a column for METADATA$FILENAME.

A secure view with a column for the stage name and a column for the file path.