Logo ExamsQA
Exit
Official Bank 0/78

Snowflake SnowPro Advanced: Administrator Certification (ADA-C01) - Snowflake Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
78 Total Questions
1
Question
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:

Exhibit

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).
Select 2
Options
A ALTER WAREHOUSE fin_wh1 RESUME;
B ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;
G. ALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITORS;
C ALTER WAREHOUSE fin_wh2 RESUME;
D ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT SET CREDIT_QUOTA = 1500;
E ALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;
F ALTER WAREHOUSE fin_wh2 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
What roles can be used to create network policies within Snowflake accounts? (Select THREE).
Select 3
Options
A Any role that owns the database where the network policy is created
B SYSADMIN
C SECURITYADMIN
D Any role with the global permission of CREATE NETWORK POLICY
E ACCOUNTADMIN
F ORGADMIN
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Select TWO).
Select 2
Options
A SAML response format
B IdP account details
C URL endpoint for SAML requests
D IdP encryption key
E Authentication certificate
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
An Administrator has been asked to support the company's application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team's role is DEVELOPER. CREATE TABLE customer_data ( customer_first_name string, customer_last_name string, customer_address string, customer_email string, ... some other columns,
);
The application team would like to access the customer data, but the email field must be obfuscated.

How can the Administrator protect the sensitive information, while maintaining the usability of the data?
Options
A Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.
B Create a view on the customer_data table to eliminate the email column by omitting it from the
SELECT clause. Grant the role DEVELOPER access to the view.
C Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table.
D Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
What are benefits of using Snowflake organizations? (Select TWO).
Select 2
Options
A Administrators can change Snowflake account editions on-demand based on need.
B Administrators can simplify data movement across all accounts within the organization.
C Administrators can monitor and understand usage across all accounts in the organization.
D Administrators have the ability to create accounts in any available cloud provider or region.
E User administration is simplified across all accounts within the organization.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.