[Q20-Q43] 100% Passing Guarantee - Brilliant ADA-C01 Exam Questions PDF [Dec-2025]

December 9, 2025 ADA-C01, Snowflake 0 Comments

[Q20-Q43] 100% Passing Guarantee – Brilliant ADA-C01 Exam Questions PDF [Dec-2025]

4.3/5 - (3 votes)

100% Passing Guarantee – Brilliant ADA-C01 Exam Questions PDF [Dec-2025]

ADA-C01 Dumps 2025 – NewSnowflake ADA-C01 Exam Questions

Snowflake ADA-C01 Exam Syllabus Topics:

Topic	Details
Topic 1	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.
Topic 2	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 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	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 5	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.

QUESTION 20
A Snowflake organization MYORG consists of two Snowflake accounts:

The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.
Management wants to have the PROD_DB database replicated to ACCOUNT2.
Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

USE ROLE ORGADMIN;
SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER (‘MYORG. ACCOUNT1’,
‘ENABLE_ACCOUNT_DATABASE_REPLICATION’, ‘TRUE’);
SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER (‘MYORG. ACCOUNT2’,
‘ENABLE_ACCOUNT_DATABASE_REPLICATION’, ‘TRUE’);
USE ROLE ACCOUNTADMIN;
ALTER DATABASE PROD DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2;

USE ROLE ORGADMIN;
SELECT SYSTEMSGLOBAL ACCOUNT SET_PARAMETER ( ‘MYORG. ACCOUNT1’,
‘ENABLE_ACCOUNT_DATABASE_REPLICATION’, ‘TRUE’);
USE ROLE ACCOUNTADMIN;
ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2
IGNORE EDITION CHECK;

No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.

It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

QUESTION 21
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

QUESTION 22
A resource monitor named MONTHLY_FINANCE_LIMIT has been created and applied to two virtual warehouses (fin_wh1 and fin_wh2) using the following SQL:

Given that the combined total of credits consumed by fin_wh1 and fin_wh2 (including cloud services) has reached 800 credits and both warehouses are suspended, what should the ACCOUNTADMIN execute to allow both warehouses to be resumed? (Select TWO).

ALTER WAREHOUSE fin_wh1 RESUME;

ALTER WAREHOUSE fin_wh2 RESUME;

ALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;

ALTER WAREHOUSE fin_wh2 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;

ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT SET CREDIT_QUOTA = 1500;

ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;

ALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITORS;

QUESTION 23
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);

QUESTION 24
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

To save costs on warehouse shutdowns and startups for different queries

To save costs by running the warehouse as little as possible

To keep the data cache warm to support good performance of similar queries

To keep the query result cache warm for good performance on repeated queries

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.

QUESTION 26
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

QUESTION 27
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).

SHOW REGIONS;

SHOW USERS;

SHOW ORGANIZATION ACCOUNTS;

GRANT ROLE ORGADMIN TO USER <username>;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER (

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

QUESTION 29
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

QUESTION 30
What are characteristics of data replication in Snowflake? (Select THREE).

The ALTER DATABASE … ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

Users must be granted REPLICATIONADMIN privileges in order to enable replication.

To start replication run the ALTER DATABASE … REFRESH command on the account where the secondary database resides.

Replication can only occur within the same cloud provider.

Databases created from shares can be replicated.

Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.

QUESTION 31
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;

QUESTION 32
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?

Alter the user and set MINS TO BYPASS MFA to a value that will disable MFA long enough for the user to log in.

Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.

Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.

Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.

QUESTION 33
A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous loT dat a. Time Travel is being used as a component of the company’s data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Select TWO).

Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.

The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_ DAYS.

The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).

Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.

The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.

According to the Understanding & Using Time Travel documentation, Time Travel is a feature that allows you to query, clone, and restore historical data in tables, schemas, and databases for up to 90 days. To meet the requirements of the scenario, the following best practices should be followed:
* The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS. This parameter specifies the number of days for which the historical data is preserved and can be accessed by Time Travel. To ensure that the fact and dimension tables can be reverted to a consistent state in case of any anomalies in the latest load, they should have the same retention period. Otherwise, some tables may lose their historical data before others, resulting in data inconsistency and quality issues.
* The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data. Cloning is a way of creating a copy of an object (table, schema, or database) at a specific point in time using Time Travel. To ensure that the fact and dimension tables are cloned with the same data set, they should be cloned together using the same AT or BEFORE clause. This will avoid any referential integrity issues that may arise from cloning tables at different points in time.
The other options are incorrect because:
* Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas. This is not a best practice for Time Travel, as it does not affect the ability to query, clone, or restore historical data. However, it may be a good practice for data modeling and organization, depending on the use case and design principles.
* The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas). This is not a best practice for Time Travel, as it limits the flexibility and granularity of setting the retention period for different objects. The retention period can be set at the account, database, schema, or table level, and the most specific setting overrides the more general ones. This allows for customizing the retention period based on the data needs and characteristics of each object.
* Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables. This is not a best practice for Time Travel, as it does not affect the referential integrity between the tables. Transient tables are tables that do not have a Fail-safe period, which means that they cannot be recovered by Snowflake after the retention period ends. However, they still support Time Travel within the retention period, and can be queried, cloned, and restored like permanent tables. The choice of table type depends on the data durability and availability requirements, not on the referential integrity.

QUESTION 34
A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Select TWO).

Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

Increase the multi-cluster maximum to 20 or more clusters.

Examine the complex queries and determine if they can be made more efficient usingclustering keys or materialized views.

Increase the minimum number of clusters started in the multi-cluster configuration to 5.

Explanation
According to the Snowflake documentation1, a multi-cluster warehouse is a virtual warehouse that consists of multiple clusters of compute resources that can scale up or down automatically to handle the concurrency and performance needs of the queries submitted to the warehouse. A multi-cluster warehouse has a minimum and maximum number of clusters that can be specified by the administrator. Option A is a possible solution to address the issues happening once a month, as it allows the administrator to use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete. This way, the warehouse can have more resources available to handle the complex queries without reaching the maximum limit of 10 clusters, and then return to the normal cluster size to save costs. Option B is another possible solution to address the issues happening once a month, as it allows the administrator to have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload. This way, the warehouse can isolate the complex queries from the standard workload and avoid queue time and resource contention. Option C is not a recommended solution to address the issues happening once a month, as it would increase the costs and complexity of managing the multi-cluster warehouse, and may not solve the underlying problem of inefficient queries. Option D is a good practice to improve the performance of the queries, but it is not a direct solution to address the issues happening once a month, as it requires analyzing and optimizing the complex queries using clustering keys or materialized views, which may not be feasible or effective in all cases. Option E is not a recommended solution to address the issues happening once a month, as it would increase the costs and waste resources by starting more clusters than needed for the standard workload.

QUESTION 35
.
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.

QUESTION 36
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.

QUESTION 37
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;

QUESTION 38
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)));

QUESTION 39
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.

QUESTION 40
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

QUESTION 41
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

QUESTION 42
What roles can be used to create network policies within Snowflake accounts? (Select 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

QUESTION 43
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.