A Snowflake account uses SCIM provisioning for user accounts and has bidirectional synchronization of user identities. An Administrator with access to SECURITYADMIN creates a user in the Snowflake UI by issuing these commands:

The new user, PTORRES, logs in successfully but sees PUBLIC as the default role in the web UI. The following command fails when attempted:
USE DEVELOPER_ROLE;
Why does this command fail?
A user with the appropriate role runs the following commands to configure and activate network policies:

An Administrator receives data from a Snowflake partner. The partner shares a dataset containing multiple secure views. The Administrator wants to configure access so that only specific roles can view specific secure views.
How can this be achieved?
Which roles may be used to create network policies in Snowflake accounts?
Choose three
MY_TABLE is a table that has not been updated or changed for several days. On 01 January 2021 at 07:01, a user ran a query that updated this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries allow the user to view the historical data that was in the table before this query ran?
Choose three
Which Snowflake objects can be managed through SCIM integration?
Choose two
An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:
B. etween 50 and 100 concurrent users will run reports.
C. osts must be minimized according to the number of users active at a particular time.
The virtual warehouse must automatically suspend and resume based on user activity.
Which configuration meets these requirements?
A large multinational company with numerous operating regions needs data to be shared bidirectionally among all offices: from the head office to regional offices and among regional offices themselves. The company holds a Snowflake account, with its European operations deployed in Microsoft Azure in a single region, while North American regional offices use AWS in a single region as their deployment cloud. This configuration is required to comply with Personal Identifiable Information (PII) regulations in certain European countries. The corporate head office is located in Europe.
How can the data be shared bidirectionally while MINIMIZING costs?
Which information must be obtained from the Identity Provider (IdP) to enable federated authentication in Snowflake?
Choose two
A company has configured Snowflake replication between two Snowflake accounts, both running Snowflake Enterprise Edition. Replication applies to database APP_DB, which contains only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently 30 days in both accounts. An Administrator must extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be fulfilled?
Which role or roles should be used to correctly create the object needed to configure an OAuth 2.0 integration?
Which steps are needed to configure OKTAAPI token integration in Snowflake?
When adding secure views to a share in Snowflake, which function is required to authorize users from another account to access rows in a base table?
A user has enrolled in multi-factor authentication (MFA) to connect to Snowflake. The user tells the Snowflake Administrator that they lost their mobile phone the prior evening.
Which action should the Administrator take to enable the user to sign in to the system without revoking the user’s MFA enrollment?
Which commands can a user with the ORGADMIN role, but without the ACCOUNTADMIN role, perform?
Choose two
What is the default data-retention period for transient databases, schemas, and tables in Snowflake Enterprise Edition and higher?
What is one characteristic of Snowflake’s transaction locking and concurrency model?
A company has many users assigned to the ANALYST role who regularly query Snowflake through a reporting tool. The Administrator observes that the ANALYST users continuously keep two small clusters busy and occasionally require three or four clusters of that same size.
B. ased on this scenario, how should the Administrator configure a virtual warehouse to MOST efficiently support this user group?