SnowPro Advanced Administrator Practice Test

SnowPro Advanced Administrator Practice Test practice questions, page 2 of 3, with answer review and explanations.

Question 6

What is required for stages, without credentials, to limit data exfiltration after a storage Integration and associated stages are created?

Question 7

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

  1. EXECUTE TASK on the task
  2. OWNERSHIP on the task
  3. OPERATE on the task
  4. USAGE on the database and schema containing the task
  5. OWNERSHIP on the database and schema containing the task

Question 8

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

  1. Any role with GRANT USAGE on SECURITY INTEGRATION
  2. ACCOUNTADMIN and SYSADMIN
  3. ACCOUNTADMIN and SECURITYADMIN
  4. ACCOUNTADMIN only

Question 9

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

  1. The SYSADMIN role
  2. The role above the dropped role in the RBAC hierarchy
  3. The role executing the command
  4. The SECURITYADMIN rote

Question 10

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: 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?

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