How accurate are the SnowPro Advanced Administrator ADA-C02 practice questions?

All SnowPro Advanced Administrator ADA-C02 questions are community-created and reviewed by moderators to align with Snowflake's published exam objectives. The community continuously reports and fixes issues to keep content accurate and up to date.

How should I study for the SnowPro Advanced Administrator ADA-C02 exam?

Start by browsing practice questions to identify weak areas. Use spaced repetition (Learn Mode) to focus study time on topics you struggle with. Combine practice questions with official Snowflake documentation and hands-on experience for best results.

SnowPro Advanced Administrator ADA-C02 Practice Exam — Free 57+ Questions

57Practice Questions

3Study Modes

FreeTo Get Started

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

That's the end of the Preview

This exam has 57 community-verified practice questions. Create a free account to access all questions, comments, and explanations.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 57

1 2 3

→

Know a question that should be here? Contribute to this exam

The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?

A Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.
B Tables created by either user A or user B will be visible to both users.
C All existing tables in schema PROD.WORKING will be visible to both users.
D Both user A and user B can create tables in the PROD.WORKING schema.

What steps are required to set up OKTAAPI token integration in Snowflake?

A
1. grant role okta_provisioner to role ACCOUNTADMIN;2. create or replace security integration okta_provisioningtype = scimscim_client = 'okta'run_as_role = 'OKTA_PROVISIONER';3. Update these steps every 12 months.
B
1. use role ACCOUNTADMIN;2. select system$ generate_scim_access_token ('OKTA_PROVISIONING');3. Update these steps every 12 months.
C
1. create or replace security integration okta_provisioningtype = scimscim client = 'okta'run_as_role = 'OKTA_PROVISIONER';2. Update this step every 6 months.
D
1. use role ACCOUNTADMIN;2. select system$ generate_scim_access_token ('OKTA_PROVISIONING');3. Update these steps every 6 months.

Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

A alter user user1 set MINS_TO_BYPASS_MFA=1440;
B alter user user1 set DISABLE_MFA=1440;
C alter user user1 set TEMPORARY_MFA_BYPASS=1440;
D alter user user1 set HOURS_TO_BYPASS_MFA=24;

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? (Choose two.)

A OPERATE
B MODIFY
C MONITOR
D USAGE
E OWNERSHIP

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?

A Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.
B Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
C Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
D Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.

What SCIM integration types are supported in Snowflake? (Choose three.)

A Amazon Web Services (AWS)
B Google Cloud Platform (GCP)
C Okta
D Custom
E Azure Active Directory (Azure AD)
F Duo Security Provisioning Connector

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

A Any role with GRANT USAGE on SECURITY INTEGRATION
B ACCOUNTADMIN and SYSADMIN
C ACCOUNTADMIN and SECURITYADMIN
D ACCOUNTADMIN only

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

A The account_level policy will override the user_level policy.
B The user_level policy will override the account_level policy.
C The user_level network policies will not be supported.
D A network policy error will be generated with no definitions provided.

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

A Database, privileges will take precedence over schema privileges.
B Schema privileges will take precedence over database privileges.
C An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.
D An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

What roles can be used to create network policies within Snowflake accounts? (Choose three.)

A SYSADMIN
B SECURITYADMIN
C ACCOUNTADMIN
D ORGADMIN
E Any role with the global permission of CREATE NETWORK POLICY
F Any rote that owns the database where the network policy is created

The following SQL command was executed:

Question Image

Which role(s) can alter or drop table XYZ?

A Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
B SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
C PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
D Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

A user with the proper role issues the following commands when setting up and activating network policies:

Question Image

Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?

A Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
B No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
C Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
D No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.

Which tasks can be performed by the ORGADMIN role? (Choose three.)

A Create one or more accounts in the organization.
B View a list of all regions enabled for the organization.
C Create secure views on application tables within the organization.
D View usage information for all accounts in the organization.
E Perform zero-copy cloning on account data.
F Create a reader account to share data with another organization.

A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:

Question Image

The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails: use DEVELOPER_ROLE;
Why does this command fail?

A The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.
B The new role can only take effect after USERADMIN has logged out.
C USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.
D The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.

What are characteristics of Dynamic Data Masking? (Choose two.)

A A masking policy that is currently set on a table can be dropped.
B A single masking policy can be applied to columns in different tables.
C A masking policy can be applied to the VALUE column of an external table.
D The role that creates the masking policy will always see unmasked data in query results.
E A single masking policy can be applied to columns with different data types.

What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

A The cost of running a resource monitor is only 10% of a credit, per day of operation.
B Multiple resource monitors can be applied to a single virtual warehouse.
C Resource monitors add no additional load to virtual warehouse compute.
D Multiple triggers can be configured across various virtual warehouse thresholds.
E Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
F Resource monitors can be applied to more than one virtual warehouse.

Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

A SHOW REGIONS;
B SHOW USERS;
C SHOW ORGANIZATION ACCOUNTS;
D GRANT ROLE ORGADMIN TO USER <username>;
E

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

A The account requires at least one ORGADMIN rote within one of the organization's accounts.
B The account name is immutable and cannot be changed.
C The account name must be specified when the account is created.
D The account name must be unique among all Snowflake customers.
E The account name must be unique within the organization.

What are benefits of using Snowflake organizations? (Choose two.)

A Administrators can change Snowflake account editions on-demand based on need.
B Administrators can monitor and understand usage across all accounts in the organization.
C Administrators can simplify data movement across all accounts within the organization.
D User administration is simplified across all accounts within the organization.
E Administrators have the ability to create accounts in any available cloud provider or region.

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?

A 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.
B Create a separate table for all the non-PII columns and grant the role DEVELOPER access to the new table.
C Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.
D Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.

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?

A select * from LINEITEM sample bernoulli (20);
B select * from LINEITEM sample system (20);
C select * from LINEITEM tablesample block (20 rows);
D select * from LINEITEM tablesample system (20) seed (1);

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?

A Sequences, views, and secure views
B Sequences, views, secure views, and materialized views
C Sequences, storage integrations, views, secure views, and materialized views
D There are no object references that need to be re-pointed

An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Choose two.)

A EXECUTE TASK on the task
B OWNERSHIP on the task
C OPERATE on the task
D USAGE on the database and schema containing the task
E OWNERSHIP on the database and schema containing the task

SnowPro Advanced Administrator ADA-C02Preview

About the SnowPro Advanced Administrator ADA-C02 Exam

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

That's the end of the Preview

SnowPro Advanced Administrator ADA-C02Preview

About the SnowPro Advanced Administrator ADA-C02 Exam

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

That's the end of the Preview