Snowflake SnowPro Advanced Administrator - SnowPro Advanced Administrator ADA-C01 Exam
Page: 2 / 13
Total 65 questions
Question #6 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
What is required for stages, without credentials, to limit data exfiltration after a storage Integration and associated stages are created?
A. 
B. 
C. 
D. 
B.
C.
D.
Answer: D
Question #7 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
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.)
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
Answer: CD
Question #8 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
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
Answer: C
Question #9 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
When a role is dropped, which role inherits ownership of objects owned by the dropped role?
A. The SYSADMIN role
B. The role above the dropped role in the RBAC hierarchy
C. The role executing the command
D. The SECURITYADMIN rote
Answer: C
Question #10 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
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?
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.
Answer: C
