[Sep-2026] Latest Snowflake ADA-C02 Certification Practice Test Questions [Q15-Q31]

NO.15 What is a characteristic of Snowflake’s transaction locking and concurrency modeling?

A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

Transaction locking in Snowflake is enforced exclusively at the row and table levels.

Queries executed within a given transaction see that transaction’s uncommitted changes.

NO.16 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.

NO.17 What roles can be used to create network policies within Snowflake accounts? (Choose three.)

SYSADMIN

SECURITYADMIN

ACCOUNTADMIN

ORGADMIN

Any role with the global permission of CREATE NETWORK POLICY

Any role that owns the database where the network policy is created

NO.18 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.

NO.19 What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Choose two.)

IdP account details

URL endpoint for SAML requests

SAML response format

Authentication certificate

IdP encryption key

NO.20 A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?

The STORE_ID should be numeric.

The table is not big enough to take advantage of the clustering key.

Sales across stores are not uniformly distributed.

The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

NO.21 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.

NO.22 A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.
How can this data be shared bi-directionally, while MINIMIZING costs?

Use data replication everywhere to reduce costs associated with same-region sharing.

Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.

Move all the Snowflake accounts to a single region, and implement data sharing.

Use bi-directional data sharing among offices in the same region and replication among offices across the continents.

NO.23 A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.
The primary database object is : PROD_AWS_EAST. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?

Location : AWS_WEST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

Location : AWS_WEST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH;

Location : AWS_EAST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

Location : AWS_EAST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH;

NO.24 Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

Reset a Snowflake user’s password

Manage system grants

Create new users

Create new roles

NO.25 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.

NO.26 What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

The cost of running a resource monitor is only 10% of a credit, per day of operation.

Multiple resource monitors can be applied to a single virtual warehouse.

Resource monitors add no additional load to virtual warehouse compute.

Multiple triggers can be configured across various virtual warehouse thresholds.

Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

Resource monitors can be applied to more than one virtual warehouse.

NO.27 What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

Any role with GRANT USAGE on SECURITY INTEGRATION

ACCOUNTADMIN and SYSADMIN

ACCOUNTADMIN and SECURITYADMIN

ACCOUNTADMIN only

NO.28 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.

NO.29 A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = (‘1.1.1.0/24’, ‘2.2.2.0/24’, ‘3.3.3.0/24’)
BLOCKED_IP_LIST = (‘1.1.1.1’)
COMMENT = ‘Account level policy’;
ALTER ACCOUNT SET NETWORK_POLICY=foo_policy;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = (‘3.3.3.0/24’)
BLOCKED_IP_LIST = (‘3.3.3.10’)
COMMENT = ‘user level policy’;
ALTER USER user1 SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.

No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.

No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.

NO.30 What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)

The account requires at least one ORGADMIN role within one of the organization’s accounts.

The account name is immutable and cannot be changed.

The account name must be specified when the account is created.

The account name must be unique among all Snowflake customers.

The account name must be unique within the organization.

NO.31 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;