Valid ADA-C01 Test Answers & Snowflake ADA-C01 Exam PDF [Q10-Q33]

NEW QUESTION 10
Which Snowflake objects can be managed using SCIM integration? (Select TWO).

Stages

Users

Warehouses

Roles

Shares

NEW QUESTION 11
A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:
Table Name : VWH_META
Column 1 : SNAPSHOT_TIME TIMESTAMP_NTZ
Column 2 : CONFIG VARIANT
Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH META?

1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (),
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID(1) ) ) ;

1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (), *
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ())) ;

1. SHOW WAREHOUSES;
2. INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP (),
OBJECT CONSTRUCT (*)
FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ()));

1. SHOW WAREHOUSES;
2. INSERT INTO VWH META
SELECT CURRENT TIMESTAMP (), *
FROM TABLE (RESULT_SCAN (SELECT
LAST QUERY ID(-1)));

NEW QUESTION 12
.
Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.
Company A’s Administrator created a share.
What object should be added to the share to allow Company B access to the files?

A secure view with a column for file URLs.

A secure view with a column for pre-signed URLs.

A secure view with a column for METADATA$FILENAME.

A secure view with a column for the stage name and a column for the file path.

NEW QUESTION 13
An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?

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

Individually grant imported privileges onto the schema in the share.

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

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

NEW QUESTION 14
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?

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

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

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

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

NEW QUESTION 15
Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Select TWO).

Dropping a column from a table

Deleting data from a table

Unpublishing the data listing

Renaming a table

Adding region availability to the listing

NEW QUESTION 16
A requirement has been identified to allow members of a corporate Data Product team to bring in data sets from the Snowflake Marketplace. The members of this team use the role DP_TEAM.
What grant statements must the ACCOUNTADMIN execute in order for the DP TEAM role to import and work with data from the Marketplace?

grant marketplace in account to role dp_team;
grant create database from share to role dp_team;

grant usage on snowflake_marketplace to role dp_team;
grant create database on account to role dp_team;

grant imported privileges on account to role dp_team;
grant create database on account to role dp_team;

grant import share on account to role dp_team;
grant create database on account to role dp_team;

NEW QUESTION 17
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

To save costs on warehouse shutdowns and startups for different queries

To save costs by running the warehouse as little as possible

To keep the data cache warm to support good performance of similar queries

To keep the query result cache warm for good performance on repeated queries

NEW QUESTION 18
A company has set up a new Snowflake account. An Identity Provider (IdP) has been configured for both Single Sign-On (SSO) and SCIM provisioning.
What maintenance is required to ensure that the SCIM provisioning process continues to operate without errors?

The IdP service account requires a new RSA key pair to be generated every six months.

The Administrator must issue a POST RENEW call to the REST API at least once every six months.

The OAuth Bearer Tokens have a lifespan of six months and must be regenerated prior to expiration.

The IdP Administrator must issue a REFRESH transaction at least once every six months to synchronize all users and roles.

NEW QUESTION 19
A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.
Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.

Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.

NEW QUESTION 20
A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ( ‘1.1.1.0/24’, ‘2.2.2.0/24’ , ‘3.3. 3. 0/24’ )
BLOCKED IP LIST = ( ‘1.1.1.1’)
COMMENT = ‘Account level policy’;
ALTER ACCOUNT SET NETWORK_POLICY=FOO_POLICY;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = (‘3.3.3.0/24’)
BLOCKED IP LIST = (‘3.3.3.10’)
COMMENT = ‘user level policy’;
ALTER USER userl SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.

No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.

No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.

NEW QUESTION 21
Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

alter user userl set MINS_TO_BYPASS_MFA=1440;

alter user userl set DISABLE_MFA=1440;

alter user userl set TEMPORARY_MFA_BYPASS=1440;

alter user userl set HOURS_TO_BYPASS_MFA=24;

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

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

create 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;
** ‘

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

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

NEW QUESTION 23
What are benefits of creating and maintaining resource monitors in Snowflake? (Select THREE).

The cost of running a resource monitor is only 10% of a credit, per day of operation.

Multiple resource monitors can be applied to a single virtual warehouse.

Resource monitors add no additional load to virtual warehouse compute.

Multiple triggers can be configured across various virtual warehouse thresholds.

Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

Resource monitors can be applied to more than one virtual warehouse.

NEW QUESTION 24
What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

MIMIC_CONSUMER_ACCOUNT

TEST_ACCOUNT_ID

PRODUCER_TEST_ACCT

SIMULATED_DATA_SHARING_CONSUMER

NEW QUESTION 25
Which type of listing in the Snowflake Marketplace can be added and queried immediately?

Monetized listing

Standard listing

Regional listing

Personalized listing

NEW QUESTION 26
Which Snowflake objects can be managed using SCIM integration? (Select TWO).

Stages

Users

Warehouses

Roles

Shares

NEW QUESTION 27
What are benefits of using Snowflake organizations? (Select TWO).

Administrators can change Snowflake account editions on-demand based on need.

Administrators can monitor and understand usage across all accounts in the organization.

Administrators can simplify data movement across all accounts within the organization.

User administration is simplified across all accounts within the organization.

Administrators have the ability to create accounts in any available cloud provider or region.

NEW QUESTION 28
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?

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;

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;

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;

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;

NEW QUESTION 29
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select TWO).

SHOW REGIONS;

SHOW USERS;

SHOW ORGANIZATION ACCOUNTS;

GRANT ROLE ORGADMIN TO USER <username>;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER (
‘ACCOUNT LOCATOR’,
‘ENABLE ACCOUNT DATABASE_REPLICATION’,
‘true’
);

NEW QUESTION 30
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

No, because joins are not supported by materialized views.

No, because the optimizer might decide against it.

No, because the materialized view may not be up-to-date.

Yes, because materialized views are always faster.

NEW QUESTION 31
An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Select TWO).

EXECUTE TASK on the task

OWNERSHIP on the task

OPERATE on the task

USAGE on the database and schema containing the task

OWNERSHIP on the database and schema containing the task

NEW QUESTION 32
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

To keep the query result cache warm for good performance on repeated queries

To save costs by running the warehouse as little as possible

To keep the data cache warm to support good performance of similar queries

To save costs on warehouse shutdowns and startups for different queries

NEW QUESTION 33
The ACCOUNTADMIN of Account 123 works with Snowflake Support to set up a Data Exchange. After the exchange is populated with listings from other Snowflake accounts, what roles in Account 123 are allowed to request and get data?

Only the ACCOUNTADMIN role, and no other roles

Any role with USAGE privilege on the Data Exchange

Any role with IMPORT SHARE and CREATE DATABASE privileges

Any role that the listing provider has designated as authorized