Passing exam with ADA-C02 latest training materials

Snowflake ADA-C02 Exam Overview:

Snowflake ADA-C02 Exam Syllabus Topics:

Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:

Question 1

What is the default data retention period for transient databases, schemas, and tables for Snowflake Enterprise edition and higher?

A. 14 days
B. 1 day
C. 90 days
D. 30 days

Question 2

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

Question 3

A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.
The primary database object is : PROD_AWS_EAST. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?

A. Location : AWS_EAST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;
B. Location : AWS_EAST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH;
C. Location : AWS_WEST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;
D. Location : AWS_WEST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH;

Question 4

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 = xxxlarge
auto_suspend = 60
auto_resume = true;
B. create or replace warehouse reporting_wh
warehouse_size = medium
auto_suspend = 600
auto_resume = true;
C. create or replace warehouse reporting_wh
warehouse_size = xxxlarge
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = false;
D. create or replace warehouse reporting_wh
warehouse_size = medium
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = true;

Question 5

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
Table: Select
B. Database: Usage
Schema: Usage
Table: Select, Create Stream
C. Database: Usage, Create Stream
Schema: Usage
Table: Select
D. Database: Usage
Schema: Usage, Create Stream
Table: Select

Solutions: