Black Friday VIP Hour Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

Pass the Snowflake SnowPro Advanced: Administrator ADA-C02 Questions and answers with Dumpstech

Exam ADA-C02 Premium Access

View all detail and faqs for the ADA-C02 exam

Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions
Questions # 1:

Which role or roles should be used to correctly create the object needed to configure an OAuth 2.0 integration?

Options:

A.

Any role with GRANT USAGE on SECURITY INTEGRATION

B.

ACCOUNTADMIN and SYSADMIN

C.

ACCOUNTADMIN and SECURITYADMIN

D.

ACCOUNTADMIN only

Questions # 2:

In which scenario does using an external table simplify a data pipeline?

Options:

A.

When accessing a Snowflake table from a relational database

B.

When accessing a Snowflake table from an external database within the same region

C.

When continuously writing data from a Snowflake table to external storage

D.

When accessing a Snowflake table that references data files located in cloud storage

Questions # 3:

An Administrator must create a sample from the LINEITEM table. The sample must not be repeatable, and the sampling function must select data in blocks of rows.

Which SELECT command generates a sample of 20% of the table?

Options:

A.

select * from LINEITEM sample bernoulli (20);

B.

select * from LINEITEM sample system (20);

C.

select * from LINEITEM tablesample block (20 rows);

D.

select * from LINEITEM tablesample system (20) seed (1);

Questions # 4:

In general, monthly database-replication billing is proportional to which variables?

Choose two

Options:

A.

The frequency of changes to the primary database as a result of data loading or DML operations

B.

The amount of table data in the primary database that changes as a result of data loading or DML operations

C.

The frequency of the secondary database refreshes from the primary database

D.

The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

E.

The number and size of warehouses defined in the primary account

Questions # 5:

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 # 6:

An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:

B. etween 50 and 100 concurrent users will run reports.

C. osts must be minimized according to the number of users active at a particular time.

The virtual warehouse must automatically suspend and resume based on user activity.

Which configuration meets these requirements?

Options:

A.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;

B.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = FALSE;

C.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

AUTO_SUSPEND = 60

AUTO_RESUME = TRUE;

D.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;

Questions # 7:

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

Options:

A.

CURRENT_ROLE

B.

CURRENT_ACCOUNT

C.

CURRENT_USER

D.

CURRENT_CLIENT

Questions # 8:

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 # 9:

A Snowflake Administrator needs to retain all virtual warehouse configurations for auditing and backup. A table already exists with this schema:

Question # 9

Which commands should be run to persist the warehouse data at execution time in JSON format in the VWH_META table?

Options:

A.

1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP(),

FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(1)));

B.

1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP(), *

FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

C.

1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP(),

OBJECT_CONSTRUCT(*)

FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

D.

1. SHOW WAREHOUSES;

2. INSERT INTO VWH_META

SELECT CURRENT_TIMESTAMP(), *

FROM TABLE(RESULT_SCAN(SELECT

LAST_QUERY_ID(-1)));

Questions # 10:

A Snowflake Administrator uses a multi-cluster virtual warehouse in the Snowflake Business-Critical edition. The minimum cluster count is set to 2, and the maximum cluster count is set to 10. This configuration performs well for the normal workload, which seldom exceeds 5 running clusters. However, once each month, several complex long-running queries increase queue time and cause the warehouse to reach its maximum of 10 clusters.

Which solutions will resolve the issues that occur once a month?

Choose two

Options:

A.

Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

B.

Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

C.

Increase the multi-cluster maximum to 20 or more clusters.

D.

Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.

E.

Increase the minimum number of clusters started in the multi-cluster configuration to 5.

Viewing page 1 out of 2 pages
Viewing questions 1-10 out of questions