Activate Your Black Friday Offer: 75% Discount on Exam Bundles! Use coupon code below! - Ends in 0d 00h 00m 00s - Coupon code: 75onlydt

ADA-C02 Questions and Answers

Question # 6

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;

Full Access
Question # 7

An Administrator receives data from a Snowflake partner. The partner shares a dataset containing multiple secure views. The Administrator wants to configure access so that only specific roles can view specific secure views.

How can this be achieved?

A.

Apply RBAC directly onto the partner's shared secure views.

B.

Individually grant imported privileges onto the schema in the share.

C.

Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.

D.

Create views over the incoming shared database and apply the desired RBAC onto these views.

Full Access
Question # 8

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?

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;

Full Access
Question # 9

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

Choose three

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.

Full Access
Question # 10

Which of the following are characteristics of Dynamic Data Masking?

Choose two

A.

A masking policy that is currently set on a table can be dropped.

B.

A single masking policy can be applied to columns in different tables.

C.

A masking policy can be applied to the VALUE column of an external table.

D.

The role that creates the masking policy will always see unmasked data in query results.

E.

A single masking policy can be applied to columns with different data types.

Full Access
Question # 11

Which information must be obtained from the Identity Provider (IdP) to enable federated authentication in Snowflake?

Choose two

A.

IdP account details

B.

URL endpoint for SAML requests

C.

SAML response format

D.

Authentication certificate

E.

IdP encryption key

Full Access
Question # 12

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?

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

Full Access
Question # 13

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?

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.

Full Access
Question # 14

A retailer has a TRANSACTIONS table (100M rows, 1.2 TB) clustered by the STORE_ID column (varchar(50)). The vast majority of analysis on this table is grouped by STORE_ID to evaluate store performance.

The retailer operates 1000 stores, but 20 stores account for most sales. The Administrator observes that most queries currently have poor pruning, processing large numbers of bytes even for simple queries.

Why is this happening?

A.

The STORE_ID should be numeric.

B.

The table is not big enough to take advantage of the clustering key.

C.

Sales across stores are not uniformly distributed.

D.

The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

Full Access
Question # 15

Which roles may be used to create network policies in Snowflake accounts?

Choose three

A.

SYSADMIN

B.

SECURITYADMIN

C.

ACCOUNTADMIN

D.

ORGADMIN

E.

Any role with the global permission of CREATE NETWORK POLICY

F.

Any rote that owns the database where the network policy is created

Full Access
Question # 16

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

Full Access
Question # 17

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.

Full Access
Question # 18

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the accountant role.

An application using the accountant role must use this warehouse to run financial reports and track the compute credits consumed by the warehouse. What minimum warehouse privileges should be granted to the role to satisfy these requirements?

Choose two

A.

OPERATE

B.

MODIFY

C.

MONITOR

D.

USAGE

E.

OWNERSHIP

Full Access