Weekend Special Sale 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale75best

Free Snowflake ADA-C02 Practice Exam with Questions & Answers | Set: 2

Questions 11

What are the advantages of using Snowflake organizations?

Choose two

Options:
A.

Administrators can change Snowflake account editions on-demand based on need.

B.

Administrators can monitor and understand usage across all accounts in the organization.

C.

Administrators can simplify data movement across all accounts within the organization.

D.

User administration is simplified across all accounts within the organization.

E.

Administrators have the ability to create accounts in any available cloud provider or region.

Snowflake ADA-C02 Premium Access
Questions 12

Which statement enables a Snowflake Administrator to retrieve the network policy applied to the Snowflake account?

Options:
A.

SHOW NETWORK POLICIES IN ACCOUNT;

B.

SHOW PARAMETERS LIKE ‘NETWORK POLICY’ IN ACCOUNT;

C.

SHOW NETWORK POLICIES;

D.

DESC NETWORK POLICY < policy_name > ;

Questions 13

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

Options:
A.

1 day

B.

14 days

C.

30 days

D.

90 days

Questions 14

Which are characteristics of data replication in Snowflake?

Choose three

Options:
A.

The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.

B.

Users must be granted REPLICATIONADMIN privileges in order to enable replication.

C.

To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.

D.

Replication can only occur within the same cloud provider.

E.

Databases created from shares can be replicated.

F.

Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.

Questions 15

Which benefits result from creating and maintaining resource monitors in Snowflake?

Choose three

Options:
A.

The cost of running a resource monitor is only 10% of a credit, per day of operation.

B.

Multiple resource monitors can be applied to a single virtual warehouse.

C.

Resource monitors add no additional load to virtual warehouse compute.

D.

Multiple triggers can be configured across various virtual warehouse thresholds.

E.

Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

F.

Resource monitors can be applied to more than one virtual warehouse.

Questions 16

A Snowflake customer is incurring higher-than-expected costs while migrating data-warehouse workloads from on premises to Snowflake. The migration workloads run on one warehouse and consist of many small INSERT statements rather than bulk-loading large extracts. That warehouse is configured as a single 2XL cluster because many parallel INSERT statements are scheduled during nightly loads.

How can the Administrator lower costs while minimizing the overall time required to load data-warehouse history?

Options:
A.

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

B.

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

Questions 17

What requirements apply when creating a new account in a Snowflake organization?

Choose two

Options:
A.

The account requires at least one ORGADMIN rote within one of the organization's accounts.

B.

The account name is immutable and cannot be changed.

C.

The account name must be specified when the account is created.

D.

The account name must be unique among all Snowflake customers.

E.

The account name must be unique within the organization.

Questions 18

The following commands have been run:

Grant usage on database PROD to role PROD_ANALYST;

Grant usage on database PROD to role PROD_SUPERVISOR;

Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;

Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;

Grant role PROD_ANALYST to user A;

Grant role PROD_SUPERVISOR to user B;

What authority does each user have on the WORKING schema?

Options:
A.

Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

B.

Tables created by either user A or user B will be visible to both users.

C.

All existing tables in schema PROD.WORKING will be visible to both users.

D.

Both user A and user B can create tables in the PROD.WORKING schema.