SnowPro Advanced AdministratorPreview

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows:

The Administrator now wants to disable the managed access on the schema.
How can this be accomplished?

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?

A Snowflake organization MYORG consists of two Snowflake accounts:

The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.
Management wants to have the PROD_DB database replicated to ACCOUNT2.
Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

The following SQL command was executed:

Which role(s) can alter or drop table XYZ?

What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business-Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Choose two.)

A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTS rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTs that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

Which type of listing in the Snowflake Marketplace can be added and queried immediately?

A user has built a view named DB.VWS.TEST_VIEW in Snowflake which only allows users having ROLE_XYZ to retrieve data from the view.
Roles Setup:
GRANT USAGE ON DATABASE DB TO ROLE ROLE_ALPHA;
GRANT USAGE ON SCHEMA DB.VWS TO ROLE ROLE_ALPHA;
GRANT SELECT ON VIEW TEST_VIEW IN SCHEMA DB.VWS TO ROLE ROLE_ALPHA;
GRANT ROLE ROLE_ALPHA TO ROLE ROLE_XYZ;
GRANT ROLE ROLE_XYZ TO ROLE ROLE_BETA;
GRANT ROLE ROLE_ALPHA TO USER USER1;
GRANT ROLE ROLE_BETA TO USER USER2;
GRANT ROLE ROLE_XYZ TO USER USER3;
View definition:

CREATE VIEW DB.VWS.TEST_VIEW AS -
(

SELECT * FROM TEST TABLE -
WHERE IS_ROLE_IN_SESSION('ROLE_XYZ')=TRUE
) ;
Which user and current role combination can retrieve data from the view? (Choose two.)

What is required for stages, without credentials, to limit data exfiltration after a storage Integration and associated stages are created?

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Choose two.)

What SCIM integration types are supported in Snowflake? (Choose three.)

Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

When does auto-suspend occur for a multi-cluster virtual warehouse?

An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Choose two.)

A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:

1. At 80% usage notify the account Administrators.
2. At 100% usage suspend the warehouse and notify the account Administrators.
3. At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
   Which SQL command will meet these requirements?

What are characteristics of Dynamic Data Masking? (Choose two.)

Which tasks can be performed by the ORGADMIN role? (Choose three.)