nerdexam
Snowflake

ADA-C01 · Question #29

ADA-C01 Question #29: Real Exam Question with Answer & Explanation

Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.

Question

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?

Options

  • AThe DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able
  • BThe new role can only take effect after USERADMIN has logged out.
  • CUSERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.
  • DThe new role will only take effect once the identity provider has synchronized by way of SCIM

Unlock ADA-C01 to see the answer

You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full ADA-C01 Practice