Important Snowflake ADA-C01 Exam Questions

CertPrep • Snowflake • ADA-C01 Exam Questions

Select Certification Providers

Select Certification Exam

Get Full Version

Snowflake SnowPro Advanced: Administrator Certification ADA-C01 Exam

Attempt the SnowPro Certification practice test and solve real exam-like ADA-C01 questions to prepare efficiently and increase your chances of success. Our Snowflake ADA-C01 practice questions match the actual SnowPro Advanced: Administrator Certification exam format, helping you enhance confidence and improve performance. With our ADA-C01 practice exam software, you can analyze your performance, identify weak areas, and work on them effectively to boost your final SnowPro Certification exam score.

Vendor:	Snowflake
Exam Name:	SnowPro Advanced: Administrator Certification
Registration Code:	ADA-C01
Related Certification:	Snowflake SnowPro Certification, Snowflake SnowPro Advanced Certifications
Exam Audience:	Snowflake Administrators and Engineers,

Total Questions

Last Updated

22-05-2026

Exam Duration

115 MINUTES

Upgrade to Premium

GET FULL PDF

Question: 1

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).

AUSAGE on the schema DatabaseA clone

BUSAGE on the database DatabaseA_clone. Schemal

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

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

ESELECT on all tables and views in DatabaseA_clone. Schema1

Answer: C, E

Explanation:

According to the Snowflake documentation, when a database or schema is cloned, the clone inherits all granted privileges on the clones of all child objects contained in the source object, such as tables and views. However, the clone of the container itself does not inherit the privileges granted on the source container. Therefore, the ANALYST role will have SELECT privilege on all tables and views in DatabaseA_clone.Schema1, but not USAGE privilege on the database or schema. The type of view (secure or non-secure) does not affect the cloning of privileges.

Question: 2

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?

AThe STORE_ID should be numeric.

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

CSales across stores are not uniformly distributed.

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

Answer: C

Explanation:

According to the Snowflake documentation1, clustering keys are most effective when the data is evenly distributed across the key values. If the data is skewed, such as in this case where most sales come from only 20 stores out of 1000, then the micro-partitions will not be well-clustered and the pruning will be poor. This means that more bytes will be scanned by queries, even if they filter by STORE_ID. Option A is incorrect because the data type of the clustering key does not affect the pruning. Option B is incorrect because the table is large enough to benefit from clustering, if the data was more balanced. Option D is incorrect because the cardinality of the clustering key is not relevant for pruning, as long as the key values are distinct.

1: Considerations for Choosing Clustering for a Table | Snowflake Documentation

Question: 3

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to

make a transient copy of this table and wants the transient table to have all the same permissions as the original table.

How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the

requirements? (Select TWO).

AUse the following SQL command:
create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;

BUse the following SQL command:
create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;

CUse the following SQL commands:
create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants;
insert into TRANSIENT_SALES_DATA select * from SALES_DATA;

DTransient tables will persist until explicitly dropped and contribute to overall storage costs.

ETransient tables will be purged at the end of the user session and do not have any Fail-safe period.

Answer: B, D

Explanation:

According to the Snowflake documentation1, the COPY GRANTS option can be used to copy all privileges, except OWNERSHIP, from the existing table to the new transient table. This option also preserves any future grants defined for the object type in the schema. Option A is incorrect because it does not copy any grants from the original table. Option C is incorrect because it does not copy the data from the original table, only the structure and grants. Option E is incorrect because transient tables are not session-based and do not have a Fail-safe period, but they do have a Time Travel retention period2.

1: CREATE TABLE | Snowflake Documentation 2: Working with Temporary and Transient Tables | Snowflake Documentation

Question: 4

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:

Exam Question 4 Exhibit 1

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).

AALTER WAREHOUSE fin_wh1 RESUME;

BALTER WAREHOUSE fin_wh2 RESUME;

CALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;

DALTER WAREHOUSE fin_wh2 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;

EALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT SET CREDIT_QUOTA = 1500;

FALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;

GALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITORS;

Answer: E, F

Explanation:

Scenario:

Resource Monitor MONTHLY_FINANCE_LIMIT has a credit quota of 1000.

800 credits have been used and warehouses are already suspended.

According to monitor configuration:

At 80%, warehouses are suspended.

At 100%, warehouses would be suspended immediately.

Warehouses cannot resume until the monitor is reset or the quota is increased.

E. SET CREDIT_QUOTA = 1500

Increases the monthly credit limit to 1500.

Since current usage is 800 < 1500, this puts usage below 80%.

This allows resumption of warehouses.

F. RESET

sql

CopyEdit

ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;

Resets usage to zero for the current period.

Allows warehouses to resume immediately --- same effect as a fresh cycle.

Why Other Options Are Incorrect:

A . / B. ALTER WAREHOUSE ... RESUME

Won't work while the resource monitor is actively suspending the warehouses due to limits.

C . / D. UNSET RESOURCE_MONITOR

You can't remove a resource monitor from a warehouse while it is currently suspended by that same monitor.

You must first reset or adjust the monitor.

G . UNSET RESOURCE_MONITORS

Invalid syntax --- there's no RESOURCE_MONITORS plural keyword.

SnowPro Administrator Reference:

Resource Monitors Overview

ALTER RESOURCE MONITOR

Best Practices for Controlling Warehouse Credit Usage

Question: 5

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

AThe account_level policy will override the user_level policy.

BThe user_level policy will override the account_level policy.

CThe user_level network policies will not be supported.

DA network policy error will be generated with no definitions provided.

Answer: B

Explanation:

According to the Network Policies documentation, a network policy can be applied to an account, a security integration, or a user. If there are network policies applied to more than one of these, the most specific network policy overrides more general network policies. The following summarizes the order of precedence:

* Account: Network policies applied to an account are the most general network policies. They are overridden by network policies applied to a security integration or user.

* Security Integration: Network policies applied to a security integration override network policies applied to the account, but are overridden by a network policy applied to a user.

* User: Network policies applied to a user are the most specific network policies. They override both accounts and security integrations.

Therefore, if both the account_level and user_level network policies are defined, the user_level policy will take effect and the account_level policy will be ignored. The other options are incorrect because:

* The account_level policy will not override the user_level policy, as explained above.

* The user_level network policies will be supported, as they are part of the network policy feature.

* A network policy error will not be generated, as there is no conflict between the account_level and user_level network policies.

SAVE TIME & QUICKLY PREPARE WITH REAL QUESTIONS

GET FULL ACCESS

Other Snowflake Certification Exams

SOL-C01 Exam

SnowPro Associate: Platform Certification Exam

COF-C02 Exam

SnowPro Core Certification Exam

ARA-C01 Exam

SnowPro Advanced: Architect Certification Exam

ARA-R01 Exam

SnowPro Advanced: Architect Recertification

DSA-C02 Exam

SnowPro Advanced: Data Scientist Certification Exam

COF-R02 Exam

SnowPro Core Recertification Exam