<< Prev Question Next Question >>

Question 30/31

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:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE default_role = DEVELOPER_ROLE; 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?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (31q)
Question 1: A user has enrolled in Multi-factor Authentication (MFA) for...
Question 2: Which tasks can be performed by the ORGADMIN role? (Select T...
Question 3: A team of developers created a new schema for a new project....
Question 4: Which commands can be performed by a user with the ORGADMIN ...
Question 5: A company's Snowflake account has multiple roles. Each role ...
Question 6: Review the output of the SHOW statement below which displays...
Question 7: An organization's sales team leverages this Snowflake query ...
Question 8: An Administrator is evaluating a complex query using the EXP...
Question 9: What is required for stages, without credentials, to limit d...
Question 10: A Snowflake Administrator wants to create a virtual warehous...
Question 11: A requirement has been identified to allow members of a corp...
Question 12: What are the requirements when creating a new account within...
Question 13: What session parameter can be used to test the integrity of ...
Question 14: A Snowflake Administrator is investigating why a query is no...
Question 15: What SCIM integration types are supported in Snowflake? (Sel...
Question 16: For Snowflake network policies, what will occur when the acc...
Question 17: What are benefits of using Snowflake organizations? (Select ...
Question 18: A Snowflake organization MYORG consists of two Snowflake acc...
Question 19: The following commands were executed: Grant usage on databas...
Question 20: An Administrator receives data from a Snowflake partner. The...
Question 21: An Administrator loads data into a staging table every day. ...
Question 22: In general, the monthly billing for database replication is ...
Question 23: A virtual warehouse report_wh is configured with AUTO_RESUME...
Question 24: MY_TABLE is a table that has not been updated or modified fo...
Question 25: . Company A uses Snowflake to manage audio files of call rec...
Question 26: Which type of listing in the Snowflake Marketplace can be ad...
Question 27: What access control policy will be put into place when futur...
Question 28: What are the MINIMUM grants required on the database, schema...
Question 29: In which scenario will use of an external table simplify a d...
Question 30: A Snowflake account is configured with SCIM provisioning for...
Question 31: Which statement allows this user to access this Snowflake ac...