Snowflake ADA-C01 Quiz 1 Topic 1 Questions 1-5

Question: 1

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

Acreate or replace masking policy maskstring as (val string) returns string ->
case
when is_role_in_session ('MASKED_VIEW_ROLE') then ' **
else val
end;
*,

Bcreate or replace masking policy maskString as (val string) returns string ->
case
when array_contains ('MASKED_VIEW_ROLE' :: variant, parse_json (current_available_roles ())) then '*
else val
end;
** '

Ccreate or replace masking policy maskstring as (val string) returns string ->
case
when invoker_role() in ('MASKED_VIEW_ROLE') then
else val
end;
' **

Dcreate or replace masking policy maskString as (val string) returns string ->
case
when current_role() in ('MASKED_VIEW_ROLE') then ' ********* '
else val
end;

Show Answer

Question: 2

A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have

external references.

What set of object references needs to be re-pointed before granting access for usage?

ASequences, views, and secure views

BSequences, views, secure views, and materialized views

CSequences, storage integrations, views, secure views, and materialized views

DThere are no object references that need to be re-pointed

Show Answer

Question: 3

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that

will perform the following tasks:

1. At 80% usage notify the account Administrators.

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

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

Which SQL command will meet these requirements?

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

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

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

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

Show Answer

Question: 4

A company's Snowflake account has multiple roles. Each role should have access only to data that resides in the given role's specific region.

When creating a row access policy, which code snippet below will provide privileges to the role ALL_ACCESS_ROLE to see all rows regardless of region, while the other

roles can only see rows for their own regions?

Acreate or replace row access policy region policy as (region_value varchar) returns boolean ->
'ALL ACCESS_ROLE' = current_role ()
and exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)

Bcreate or replace row access policy region policy as (region_value varchar) returns boolean ->
exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)

Ccreate or replace row access policy region policy as (region_value varchar) returns boolean ->
'ALL_ACCESS_ROLE' = current_role ()
or exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)

Dcreate or replace row access policy region policy as (region_value varchar) returns boolean ->
'ALL ACCESS ROLE' = current_role ()
)

Show Answer

Question: 5

A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business Critical edition. The minimum number of clusters is set to 2 and the

maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the

Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.

Which solutions will address the issues happening once a month? (Select TWO).

AUse 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.

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

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

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

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

Show Answer

Snowflake ADA-C01 Quiz:1 Topic:1 Questions:1-5