Snowflake SnowPro Advanced Administrator ADA-C02 : ADA-C02 valid dump torrent

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. The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.
• C. The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.
• D. There should be another 2XL warehouse deployed to handle a portion of the load queries.

What are the MINIMUM grants required on the database, schema, and table for a stream to be properly created and managed?

• A. Database: Usage
  Schema: Usage, Create Stream
  Table: Select
• B. Database: Usage, Create Stream
  Schema: Usage
  Table: Select
• C. Database: Usage
  Schema: Usage
  Table: Select
• D. Database: Usage
  Schema: Usage
  Table: Select, Create Stream

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. No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
• B. No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
• C. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
• D. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.

For Snowflake network policies, what will occur when the account level and user level network policies are both defined?

• A. A network policy error will be generated with no definitions provided.
• B. The user_level network policies will not be supported.
• C. The account_level policy will override the user_level policy.
• D. The user_level policy will override the account_level policy.

A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.
Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

• A. Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.
• B. Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.
• C. Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.
• D. Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.