SnowPro Advanced Administrator Practice Test

Review 65 SNOWPRO-ADVANCED-ADMINISTRATOR practice questions with answer explanations and community insights.

Question 1

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.

Question 2

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

Question 3

Which authentication methods are available when connecting to Snowflake using the SQL API? (Choose two.)

  1. OAuth
  2. Key pair
  3. Username and password
  4. External browser
  5. Single Sign-On (SSO) with an external Identity Provider (IdP)

Question 4

The following SQL command was executed: Which role(s) can alter or drop table XYZ?

  1. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
  2. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
  3. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
  4. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

Question 5

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.