Snowflake ADA-C01 Question Answer
A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directionalsynchronization 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?
Snowflake ADA-C01 Summary
- Vendor: Snowflake
- Product: ADA-C01
- Update on: Aug 15, 2025
- Questions: 78