Free Snowflake ADA-C01 Practice Test & Real Exam Questions

Exam Code/Number: ADA-C01
Exam Name/Title: SnowPro Advanced Administrator
Certification Provider: Snowflake
Corresponding Certification: SnowPro Advanced: Administrator

Exam Questions: 80
Updated On: Aug 12, 2026

Question #1

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

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

B. 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;
** '

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

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

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #2

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

A. ACCOUNTADMIN and SYSADMIN

B. Any role with GRANT USAGE on SECURITY INTEGRATION

C. ACCOUNTADMIN only

D. ACCOUNTADMIN and SECURITYADMIN

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #3

An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned.
The Administrator then runs the query to completion and opens the Query Profile. They notice that the partitions scanned value is 429.
Why might the actual partitions scanned be lower than the estimate from the EXPLAIN output?

A. In-flight data compression will result in fewer micro-partitions being scanned at the virtual warehouse layer than were identified at the storage layer.

B. The EXPLAIN results always include a 10-15% safety factor in order to provide conservative estimates.

C. The GlobalStats partition assignment includes the micro-partitions that will be assigned for preservation of the query results.

D. Runtime optimizations such as join pruning can reduce the number of partitions and bytes scanned during query execution.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #4

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?

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

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

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

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

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #5

Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).

A. Unpublishing the data listing

B. Adding region availability to the listing

C. Dropping a column from a table

D. Renaming a table

E. Deleting data from a table

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #6

A company has set up a new Snowflake account. An Identity Provider (IdP) has been configured for both Single Sign-On (SSO) and SCIM provisioning.
What maintenance is required to ensure that the SCIM provisioning process continues to operate without errors?

A. The IdP Administrator must issue a REFRESH transaction at least once every six months to synchronize all users and roles.

B. The Administrator must issue a POST RENEW call to the REST API at least once every six months.

C. The OAuth Bearer Tokens have a lifespan of six months and must be regenerated prior to expiration.

D. The IdP service account requires a new RSA key pair to be generated every six months.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #7

What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).

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

B. The account name must be unique among all Snowflake customers.

C. The account name is immutable and cannot be changed.

D. The account name must be unique within the organization.

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

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #8

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?

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

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

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

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

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Download Free Snowflake ADA-C01 Demo

Simply submit your e-mail address below to get started with our free demo of your Snowflake ADA-C01 exam.