Snowflake ADA-C02 : SnowPro Advanced Administrator ADA-C02

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

• A. TEST ACCOUNT ID
• B. MIMIC CONSUMER ACCOUNT
• C. PRODUCER TEST ACCT
• D. SIMULATED DATA SHARING CONSUMER

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

• A. When the minimum number of clusters is running and there is no activity for the specified period of time.
• B. When there has been no activity on any cluster for the specified period of time.
• C. After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.
• D. Auto-suspend does not apply for multi-cluster warehouses.

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. EXECUTE TASK on the task
• B. OWNERSHIP on the task
• C. USAGE on the database and schema containing the task
• D. OPERATE on the task
• E. OWNERSHIP on the database and schema containing the task

A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ('1.1.1.0/24', '2.2.2.0/24', '3.3.3.0/24')
BLOCKED_IP_LIST = ('1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=foo_policy;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED_IP_LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER user1 SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?

• A. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
• B. No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
• C. No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
• D. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.

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?

• A. The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
• B. There should be another 2XL warehouse deployed to handle a portion of the load queries.
• C. The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.
• D. The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.