Question 6 of 65

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

Answer

Suggested Answer

The suggested answer is D.

Question 7 of 65

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

Answer

Suggested Answer

The suggested answer is C, D.

Question 8 of 65

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

Answer

Suggested Answer

The suggested answer is C.

Question 9 of 65

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

Answer

Suggested Answer

The suggested answer is C.

Question 10 of 65

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:

Exam SnowPro Advanced Administrator: Question 10 - Image 1

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?

Answer

Suggested Answer

The suggested answer is C.