SnowPro Advanced Administrator ADA-C02 (ADA-C02) Free Practice Test

Question 1

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 : ALTER DATABASE PROD_AWS_WEST REFRESH;

B. Location : AWS_EAST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

C. Location : AWS_WEST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH;

D. Location : AWS_WEST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

A. CURRENT CLIENT

B. CURRENT USER

C. CURRENT ROLE

D. CURRENT ACCOUNT

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

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

A. View usage information for all accounts in the organization.

B. Create a reader account to share data with another organization.

C. View a list of all regions enabled for the organization.

D. Create one or more accounts in the organization.

E. Perform zero-copy cloning on account data.

F. Create secure views on application tables within the organization.

Correct Answer: A,C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.
What set of object references needs to be re-pointed before granting access for usage?

A. Sequences, views, secure views, and materialized views

B. Sequences, storage integrations, views, secure views, and materialized views

C. There are no object references that need to be re-pointed

D. Sequences, views, and secure views

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

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

A. PRODUCER TEST ACCT

B. MIMIC CONSUMER ACCOUNT

C. TEST ACCOUNT ID

D. SIMULATED DATA SHARING CONSUMER

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

An organization's sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER_ID, CUSTOMER_NAME, ADDRESS, PHONE_NO
FROM CUSTOMERS
WHERE LAST_UPDATED BETWEEN TO_DATE(CURRENT_TIMESTAMP) AND (TO_DATE(CURRENT_TIMESTAMP)-7);
What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

A. Assign everyone on the sales team to the same virtual warehouse.

B. Wrap the query in a User-Defined Function (UDF) to match syntax execution.

C. Assign everyone on the sales team to the same security role.

D. Leverage the CURRENT_DATE function for date calculations.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

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 INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

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 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.

D. There should be another 2XL warehouse deployed to handle a portion of the load queries.

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Snowflake SnowPro Advanced Administrator ADA-C02 (ADA-C02) Free Practice Test