Try and practice the latest Snowflake : ADA-C02 real questions & answers

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

What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)

• A. CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => 'problematic_query_id');
• B. SELECT SYSTEM$CANCEL_QUERY('problematic_query_id');
• C. CREATE TABLE prd_table_bkp as SELECT * from table(result_scan('problematic_query_id'));
• D. Contact Snowflake Support to retrieve Fail-safe data.
• E. ALTER TABLE prd_table SWAP WITH prd_table_bkp;

A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.
How can this data be shared bi-directionally, while MINIMIZING costs?

• A. Use bi-directional data sharing among offices in the same region and replication among offices across the continents.
• B. Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.
• C. Move all the Snowflake accounts to a single region, and implement data sharing.
• D. Use data replication everywhere to reduce costs associated with same-region sharing.

An Administrator needs to configure a virtual warehouse in Snowflake for a new use case with these details:
1. There will be 50-100 concurrent users running reports
2. Minimize costs based on the number of active users at a given time
3. The virtual warehouse should suspend and resume automatically based on user activity
Which configuration will meet these requirements?

• A. create or replace warehouse reporting_wh
  warehouse_size = medium
  max_cluster_count = 10
  scaling_policy = standard
  auto_suspend = 600
  auto_resume = true;
• B. create or replace warehouse reporting_wh
  warehouse_size = xxxlarge
  auto_suspend = 60
  auto_resume = true;
• C. create or replace warehouse reporting_wh
  warehouse_size = medium
  auto_suspend = 600
  auto_resume = true;
• D. create or replace warehouse reporting_wh
  warehouse_size = xxxlarge
  max_cluster_count = 10
  scaling_policy = standard
  auto_suspend = 600
  auto_resume = false;

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. Individually grant imported privileges onto the schema in the share.
• B. Create views over the incoming shared database and apply the desired RBAC onto these views.
• C. Apply RBAC directly onto the partner's shared secure views.
• D. Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.