Updated Feb-2026 Test Engine to Practice ADA-C01 Dumps & Practice Exam [Q40-Q63]

ADA-C01 Snowflake

admin • February 24, 2026

Updated Feb-2026 Test Engine to Practice ADA-C01 Dumps & Practice Exam [Q40-Q63]

Rate this post

Updated Feb-2026 Test Engine to Practice ADA-C01 Dumps & Practice Exam

Dumps Collection ADA-C01 Test Engine Dumps Training With 80 Questions

NO.40 What Snowflake capabilities are commonly used in rollback scenarios? (Select 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.

NO.41 What are benefits of creating and maintaining resource monitors in Snowflake? (Select 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.42 Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

alter user userl set MINS_TO_BYPASS_MFA=1440;

alter user userl set DISABLE_MFA=1440;

alter user userl set TEMPORARY_MFA_BYPASS=1440;

alter user userl set HOURS_TO_BYPASS_MFA=24;

NO.43 Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

create or replace masking policy maskstring as (val string) returns string -> case when is_role_in_session (‘MASKED_VIEW_ROLE’) then ‘ ** else val end;
*,

create or replace masking policy maskString as (val string) returns string -> case when array_contains (‘MASKED_VIEW_ROLE’ :: variant, parse_json (current_available_roles ())) then
‘*
else val
end;
** ‘

create or replace masking policy maskstring as (val string) returns string -> case when invoker_role() in (‘MASKED_VIEW_ROLE’) then else val end;
‘ **

create or replace masking policy maskString as (val string) returns string -> case when current_role() in (‘MASKED_VIEW_ROLE’) then ‘ ********* ‘ else val end;

NO.44 A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.
Which action would provide optimal performance for the second SQL query?

Assign additional clusters to the virtual warehouse.

Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.

Prevent the virtual warehouse from suspending between the running of the first and second queries.

Use the RESULT_SCAN function to post-process the output of the first query.

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

NO.46 An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.
What select command will generate a sample of 20% of the table?

select * from LINEITEM sample bernoulli (20);

select * from LINEITEM sample system (20);

select * from LINEITEM tablesample block (20 rows);

select * from LINEITEM tablesample system (20) seed (1);

NO.47 A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTs rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

There should be another 2XL warehouse deployed to handle a portion of the load queries.

The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.

The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

NO.48 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?

1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (),
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID(1) ) ) ;

1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (), *
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ())) ;

1. SHOW WAREHOUSES;
2. INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP (),
OBJECT CONSTRUCT (*)
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ()));

1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (), *
FROM TABLE (RESULT_SCAN (SELECT
LAST QUERY ID(-1)));

NO.49 A requirement has been identified to allow members of a corporate Data Product team to bring in data sets from the Snowflake Marketplace. The members of this team use the role DP_TEAM.
What grant statements must the ACCOUNTADMIN execute in order for the DP TEAM role to import and work with data from the Marketplace?

grant marketplace in account to role dp_team;
grant create database from share to role dp_team;

grant usage on snowflake_marketplace to role dp_team;
grant create database on account to role dp_team;

grant imported privileges on account to role dp_team;
grant create database on account to role dp_team;

grant import share on account to role dp_team;
grant create database on account to role dp_team;

NO.50 DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA. Schema1. The SYSADMIN role clones DatabaseA to DatabaseA_clone.
What privileges does the ANALYST role have on tables and views in DatabaseA_clone? (Select TWO).

USAGE on the schema DatabaseA clone

USAGE on the database DatabaseA_clone. Schemal

SELECT on all tables, and only non-secure views in DatabaseA_clone. Schemal

SELECT on all tables, and only secure views in DatabaseA_clone. Schemal

SELECT on all tables and views in DatabaseA_clone. Schema1

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

NO.52 A company’s Snowflake account has multiple roles. Each role should have access only to data that resides in the given role’s specific region.
When creating a row access policy, which code snippet below will provide privileges to the role ALL_ACCESS_ROLE to see all rows regardless of region, while the other roles can only see rows for their own regions?

create or replace row access policy region policy as (region_value varchar) returns boolean ->
‘ALL ACCESS_ROLE’ = current_role ()
and exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)

create or replace row access policy region policy as (region_value varchar) returns boolean -> exists ( select 1 from entitlement_table where role = current_role () and region = region_value )

create or replace row access policy region policy as (region_value varchar) returns boolean ->
‘ALL_ACCESS_ROLE’ = current_role ()
or exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)

create or replace row access policy region policy as (region_value varchar) returns boolean ->
‘ALL ACCESS ROLE’ = current_role ()
)

NO.53 What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

Database: Usage
Schema: Usage
Table: Select, Create Stream

Database: Usage
Schema: Usage
Table: Select

Database: Usage, Create Stream
Schema: Usage
Table: Select

Database: Usage
Schema: Usage, Create Stream
Table: Select

NO.54 In general, the monthly billing for database replication is proportional to which variables? (Select TWO).

The frequency of changes to the primary database as a result of data loading or DML operations

The amount of table data in the primary database that changes as a result of data loading or DML operations

The frequency of the secondary database refreshes from the primary database

The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

The number and size of warehouses defined in the primary account

NO.55 A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Select TWO).

OPERATE

MODIFY

MONITOR

USAGE

OWNERSHIP

NO.56 Which Snowflake objects can be managed using SCIM integration? (Select TWO).

Stages

Users

Warehouses

Roles

NO.57 An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Select TWO).

Implement views on top of base tables that exclude or mask sensitive data.

Implement row access policies and Dynamic Data Masking policies.

Include masking rules as part of data ingestion and transformation pipelines.

Use a third-party tool to share the data.

Use zero-copy cloning to replicate the database schema and provide access as needed.

NO.58 What access control policy will be put into place when future grants are assigned to both database and schema objects?

Database privileges will take precedence over schema privileges.

Schema privileges will take precedence over database privileges.

An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.

An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

NO.59 The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in Account 123 are allowed to request and get data?

Only the ACCOUNTADMIN role, and no other roles

Any role with USAGE privilege on the Data Exchange

Any role with IMPORT SHARE and CREATE DATABASE privileges

Any role that the listing provider has designated as authorized

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

NO.61 In general, the monthly billing for database replication is proportional to which variables? (Select TWO).

The frequency of changes to the primary database as a result of data loading or DML operations

The amount of table data in the primary database that changes as a result of data loading or DML operations

The frequency of the secondary database refreshes from the primary database

The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

The number and size of warehouses defined in the primary account

NO.62 A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.
What set of object references needs to be re-pointed before granting access for usage?

Sequences, views, and secure views

Sequences, views, secure views, and materialized views

Sequences, storage integrations, views, secure views, and materialized views

There are no object references that need to be re-pointed

NO.63 When a role is dropped, which role inherits ownership of objects owned by the dropped role?

The SYSADMIN role

The role above the dropped role in the RBAC hierarchy

The role executing the command

The SECURITYADMIN role

Snowflake ADA-C01 Exam Syllabus Topics:

Topic	Details
Topic 1	Performance Monitoring and Tuning: This section of the exam measures the skills of Cloud Infrastructure Engineers and Performance Analysts and focuses on optimizing Snowflake compute and storage resources. Candidates will need to understand how to configure and manage virtual warehouses, evaluate query profiles, and apply caching and clustering strategies for performance tuning. It also includes monitoring concurrency, resource utilization, and implementing cost optimization strategies. The ability to interpret, explain plans, apply search optimization, and manage cost controls is key for maintaining efficient Snowflake environments.
Topic 2	Account Management and Data Governance: This section of the exam measures the skills of Data Governance Managers and Database Administrators and covers account organization, access control, and regulatory data protection. Candidates will learn how to manage organizational accounts, encryption keys, and Tri-Secret Secure implementations. It focuses on applying best practices in ORGADMIN and ACCOUNTADMIN roles, implementing masking and row access policies, and performing data classification and tagging. The domain also emphasizes data auditing, account identifiers, and effective management of tables, views, and query operations to support enterprise-wide governance standards.
Topic 3	Snowflake Security, Role-Based Access Control (RBAC), and User Administration: This section of the exam measures the skills of Snowflake Administrators and Cloud Security Engineers and covers authentication, access control, and network management in Snowflake. Candidates must understand how to configure authentication methods such as SSO, MFA, OAuth, and key-pair authentication, and how to manage network policies and private connectivity. The domain also tests knowledge of user and role management using SCIM, designing access control architecture, and applying the RBAC framework to ensure secure user authorization and data protection within Snowflake environments.
Topic 4	Data Sharing, Data Exchange, and Snowflake Marketplace: This section of the exam measures the skills of Data Integration Specialists and Data Platform Administrators and covers managing and implementing data-sharing solutions within Snowflake. It evaluates understanding of data sharing models across regions and clouds, secure data sharing methods, and managing provider-consumer relationships. The domain also includes the use of Snowflake Data Exchange and Marketplace to publish, consume, and manage data listings, ensuring secure collaboration and efficient data monetization.
Topic 5	Disaster Recovery, Backup, and Data Replication: This section of the exam measures the skills of Disaster Recovery Engineers and Cloud Operations Managers and covers Snowflake methods for ensuring business continuity. Candidates must understand how to replicate databases and account-level objects, implement failover strategies, and perform backup and restoration through Time Travel and Fail-safe features. The domain emphasizes replication across accounts, handling data consistency during failover, and applying cost-efficient disaster recovery strategies to maintain availability during outages or regional failures.