Ticking Clock Black Friday Special: 75% Off! Apply coupon code below to save on all exam bundles! - Ends in 0d 00h 00m 00s - Coupon code: 75epass

Exact2Pass Menu

SnowPro Advanced: Administrator

Last Update 1 hour ago Total Questions : 60

The SnowPro Advanced: Administrator content is now fully updated, with all current exam questions added 1 hour ago. Deciding to include ADA-C02 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our ADA-C02 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these ADA-C02 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Advanced: Administrator practice test comfortably within the allotted time.

Question # 1

MY_TABLE is a table that has not been updated or changed for several days. On 01 January 2021 at 07:01, a user ran a query that updated this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.

Which queries allow the user to view the historical data that was in the table before this query ran?

Choose three

A.

SELECT * FROM my_table WITH TIME_TRAVEL(OFFSET = > -60*30);

B.

SELECT * FROM my_table AT(TIMESTAMP = > '2021-01-01 07:00:00'::timestamp);

C.

SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);

D.

SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';

E.

SELECT * FROM my_table AT(OFFSET = > -60*30);

F.

SELECT * FROM my_table BEFORE(STATEMENT = > '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');

Question # 2

Which steps are needed to configure OKTAAPI token integration in Snowflake?

A.

See original SQL exhibit above.

grant role okta_provisioner to role ACCOUNTADMIN;2. create or replace security integration okta_provisioningtype = scimscim_client = 'okta'run_as_role = 'OKTA_PROVISIONER';3. Update these steps every 12 months.

B.

See original SQL exhibit above.

use role ACCOUNTADMIN;2. select system$ generate_scim_access_token ('OKTA_PROVISIONING');3. Update these steps every 12 months.

C.

See original SQL exhibit above.

create or replace security integration okta_provisioningtype = scimscim client = 'okta'run_as_role = 'OKTA_PROVISIONER';2. Update this step every 6 months.

D.

See original SQL exhibit above.

use role ACCOUNTADMIN;2. select system$ generate_scim_access_token ('OKTA_PROVISIONING');3. Update these steps every 6 months.

Question # 3

Under what condition does auto-suspend take place for a multi-cluster virtual warehouse?

A.

When there has been no activity on any cluster for the specified period of time.

B.

After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.

C.

When the minimum number of clusters is running and there is no activity for the specified period of time.

D.

Auto-suspend does not apply for multi-cluster warehouses.

Question # 4

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

A.

SHOW NETWORK POLICIES IN ACCOUNT;

B.

SHOW PARAMETERS LIKE ‘NETWORK POLICY’ IN ACCOUNT;

C.

SHOW NETWORK POLICIES;

D.

DESC NETWORK POLICY < policy_name > ;

Question # 5

A company has configured Snowflake replication between two Snowflake accounts, both running Snowflake Enterprise Edition. Replication applies to database APP_DB, which contains only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently 30 days in both accounts. An Administrator must extend the Time Travel retention policy to 60 days on the secondary database only.

How can this requirement be fulfilled?

A.

Set the data retention policy on the secondary database to 60 days.

B.

Set the data retention policy on the schemas in the secondary database to 60 days.

C.

Set the data retention policy on the primary database to 30 days and the schemas to 60 days.

D.

Set the data retention policy on the primary database to 60 days.

Question # 6

Which Snowflake capabilities are typically used for rollback scenarios?

Choose two

A.

SELECT SYSTEM$CANCEL_QUERY(‘problematic_query_id’);

B.

CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT = > ‘problematic_query_id’);

C.

CREATE TABLE prd_table_bkp as SELECT * from table(result_scan(‘problematic_query_id’()));

D.

ALTER TABLE prd_table SWAP WITH prd_table_bkp;

E.

Contact Snowflake Support to retrieve Fail-safe data.

Question # 7

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

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

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)));

Question # 8

An Administrator has a warehouse that is intended to have a credit quota of 3000 for every calendar year. The Administrator must create a resource monitor that performs these tasks:

At 80% usage, notify the account Administrators.

At 100% usage, suspend the warehouse and notify the account Administrators.

At 120% usage, stop all running executions, suspend the warehouse, and notify the account Administrators.

Which SQL command meets these requirements?

A.

CREATE OR REPLACE RESOURCE MONITOR RM1

WITH CREDIT_QUOTA = 3000

START_TIMESTAMP = '2022-01-01 00:00 CET'

TRIGGERS

ON 80 PERCENT DO NOTIFY

ON 100 PERCENT DO SUSPEND

ON 120 PERCENT DO SUSPEND_IMMEDIATE;

ALTER WAREHOUSE WH1 SET RESOURCE_MONITOR = RM1;

B.

CREATE OR REPLACE RESOURCE MONITOR RM1

WITH CREDIT_QUOTA = 3000

FREQUENCY = YEARLY

START_TIMESTAMP = '2022-01-01 00:00 CET'

TRIGGERS

ON 80 PERCENT DO NOTIFY

ON 100 PERCENT DO SUSPEND

ON 120 PERCENT DO SUSPEND_IMMEDIATE;

ALTER WAREHOUSE WH1 SET RESOURCE_MONITOR = RM1;

C.

CREATE OR REPLACE RESOURCE MONITOR RM1

WITH CREDIT_QUOTA = 3000

START_TIMESTAMP = '2022-01-01 00:00 CET'

TRIGGERS

ON 80 PERCENT DO NOTIFY

ON 100 PERCENT DO NOTIFY AND SUSPEND

ON 120 PERCENT DO NOTIFY AND SUSPEND_IMMEDIATE;

ALTER WAREHOUSE WH1 SET RESOURCE_MONITOR = RM1;

D.

CREATE OR REPLACE RESOURCE MONITOR RM1

WITH CREDIT_QUOTA = 3000

FREQUENCY = YEARLY

TRIGGERS

ON 80 PERCENT DO NOTIFY

ON 100 PERCENT DO SUSPEND

ON 120 PERCENT DO SUSPEND_IMMEDIATE;

ALTER WAREHOUSE WH1 SET RESOURCE_MONITOR = RM1;

Question # 9

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

Choose two

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

Question # 10

Which roles or security privileges allow a consumer account to request and receive data from the Data Exchange?

Choose two

A.

SYSADMIN

B.

SECURITYADMIN

C.

ACCOUNTADMIN

D.

IMPORT SHARE and CREATE DATABASE

E.

IMPORT PRIVILEGES and SHARED DATABASE

Go to page: