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?

• A. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.
• B. The new role can only take effect after USERADMIN has logged out.
• C. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.
• D. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.

Explanation: Only visible for Actual4dump members. You can sign-up / login (it's free).

A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.
Which action would provide optimal performance for the second SQL query?

• A. Prevent the virtual warehouse from suspending between the running of the first and second queries.
• B. Use the RESULT_SCAN function to post-process the output of the first query.
• C. Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.
• D. Assign additional clusters to the virtual warehouse.

Explanation: Only visible for Actual4dump members. You can sign-up / login (it's free).

An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned.
The Administrator then runs the query to completion and opens the Query Profile. They notice that the partitions scanned value is 429.
Why might the actual partitions scanned be lower than the estimate from the EXPLAIN output?

• A. The EXPLAIN results always include a 10-15% safety factor in order to provide conservative estimates.
• B. The GlobalStats partition assignment includes the micro-partitions that will be assigned for preservation of the query results.
• C. In-flight data compression will result in fewer micro-partitions being scanned at the virtual warehouse layer than were identified at the storage layer.
• D. Runtime optimizations such as join pruning can reduce the number of partitions and bytes scanned during query execution.

Explanation: Only visible for Actual4dump members. You can sign-up / login (it's free).

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

• A. Manage system grants
• B. Create new users
• C. Reset a Snowflake user's password
• D. Create new roles

Explanation: Only visible for Actual4dump members. You can sign-up / login (it's free).

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

• A. create or replace masking policy maskString as (val string) returns string -> case when current_role() in ('MASKED_VIEW_ROLE') then ' ********* ' else val end;
• B. create or replace masking policy maskstring as (val string) returns string -> case when is_role_in_session ('MASKED_VIEW_ROLE') then ' ** else val end;
  *,
• C. create or replace masking policy maskString as (val string) returns string -> case when array_contains ('MASKED_VIEW_ROLE' :: variant, parse_json (current_available_roles ())) then '* else val end;
  ** '
• D. create or replace masking policy maskstring as (val string) returns string -> case when invoker_role() in ('MASKED_VIEW_ROLE') then else val end;
  ' **

Explanation: Only visible for Actual4dump members. You can sign-up / login (it's free).