SnowPro Advanced Administrator ADA-C02

Review 55 SNOWPRO-ADVANCED-ADMINISTRATOR-ADA-C02 practice questions with answer explanations and community insights.

Question 1

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?

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

Question 2

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

  1. 1. grant role okta_provisioner to role ACCOUNTADMIN; 2. create or replace security integration okta_provisioning type = scim scim_client = 'okta' run_as_role = 'OKTA_PROVISIONER'; 3. Update these steps every 12 months.
  2. 1. use role ACCOUNTADMIN; 2. select system$ generate_scim_access_token ('OKTA_PROVISIONING'); 3. Update these steps every 12 months.
  3. 1. create or replace security integration okta_provisioning type = scim scim client = 'okta' run_as_role = 'OKTA_PROVISIONER'; 2. Update this step every 6 months.
  4. 1. use role ACCOUNTADMIN; 2. select system$ generate_scim_access_token ('OKTA_PROVISIONING'); 3. Update these steps every 6 months.

Question 3

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

  1. alter user user1 set MINS_TO_BYPASS_MFA=1440;
  2. alter user user1 set DISABLE_MFA=1440;
  3. alter user user1 set TEMPORARY_MFA_BYPASS=1440;
  4. alter user user1 set HOURS_TO_BYPASS_MFA=24;

Question 4

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

  1. OPERATE
  2. MODIFY
  3. MONITOR
  4. USAGE
  5. OWNERSHIP

Question 5

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?

  1. Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.
  2. Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
  3. Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
  4. Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.