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?
Question 02
Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?
Question 03
Which authentication methods are available when connecting to Snowflake using the SQL API? (Choose two.)
Select all that apply.
Question 04
The following SQL command was executed: Which role(s) can alter or drop table XYZ?
Question 05
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?
Question 06
What is required for stages, without credentials, to limit data exfiltration after a storage Integration and associated stages are created?
Question 07
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.)
Select all that apply.
Question 08
What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?
Question 09
When a role is dropped, which role inherits ownership of objects owned by the dropped role?
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?