Black Friday Grand offer - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code = drift75

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

Practice at least 50% of the questions to maximize your chances of passing.
Exam ADA-C02 Premium Access

View all detail and faqs for the ADA-C02 exam


0 Students Passed

0% Average Score

0% Same Questions
Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
Questions # 11:

Which tasks are available to the ORGADMIN role?

Choose three

Options:

A.

Create one or more accounts in the organization.

B.

View a list of all regions enabled for the organization.

C.

Create secure views on application tables within the organization.

D.

View usage information for all accounts in the organization.

E.

Perform zero-copy cloning on account data.

F.

Create a reader account to share data with another organization.

Questions # 12:

A user has enrolled in multi-factor authentication (MFA) to connect to Snowflake. The user tells the Snowflake Administrator that they lost their mobile phone the prior evening.

Which action should the Administrator take to enable the user to sign in to the system without revoking the user’s MFA enrollment?

Options:

A.

Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.

B.

Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.

C.

Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.

D.

Instruct the user to append the normal URL with /?mode=mfa_bypass & code= to log on.

Questions # 13:

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?

Options:

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;

Questions # 14:

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

Which Snowflake objects can be managed through SCIM integration?

Choose two

Options:

A.

Stages

B.

Users

C.

Warehouses

D.

Roles

E.

Shares

Questions # 16:

A sales team at an organization runs the following Snowflake query several times each day:

Question # 16

What can the Snowflake Administrator do to optimize use of persisted query results whenever possible?

Options:

A.

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

B.

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

C.

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

D.

Leverage the CURRENT_DATE function for date calculations.

Questions # 17:

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?

Options:

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.

Questions # 18:

Which access-control policy takes effect when future grants are assigned to both database-level and schema-level objects?

Options:

A.

Database, privileges will take precedence over schema privileges.

B.

Schema privileges will take precedence over database privileges.

C.

An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.

D.

An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

Viewing page 2 out of 2 pages
Viewing questions 11-20 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.