Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam ADA-C01 Premium Access

View all detail and faqs for the ADA-C01 exam

Go to Exam

798 Students Passed

94% Average Score

91% Same Questions

Viewing page 2 out of 3 pages

Viewing questions 11-20 out of questions

Questions # 11:

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?

Options:

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.

Questions # 12:

Which tasks can be performed by the ORGADMIN role? (Select THREE).

Options:

Create one or more accounts in the organization.

View a list of all regions enabled for the organization.

Create secure views on application tables within the organization.

View usage information for all accounts in the organization.

Perform zero-copy cloning on account data.

Create a reader account to share data with another organization.

Questions # 13:

When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

Options:

CURRENT_ROLE

CURRENT ACCOUNT

CURRENT_USER

CURRENT_CLIENT

Questions # 14:

In which scenario will use of an external table simplify a data pipeline?

Options:

When accessing a Snowflake table from a relational database

When accessing a Snowflake table from an external database within the same region

When continuously writing data from a Snowflake table to external storage

When accessing a Snowflake table that references data files located in cloud storage

Questions # 15:

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?

Options:

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;

Questions # 16:

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

Options:

MIMIC_CONSUMER_ACCOUNT

TEST_ACCOUNT_ID

PRODUCER_TEST_ACCT

SIMULATED_DATA_SHARING_CONSUMER

Questions # 17:

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows:

USE ROLE SECURITYADMIN;

CREATE ROLE ROLE_MANAGED_ACCESS;

GRANT ROLE ROLE_MANAGED_ACCESS TO ROLE SYSADMIN;

GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE ROLE_MANAGED_ACCESS;

GRANT ALL privileges ON DATABASE WORK TO ROLE ROLE_MANAGED_ACCESS;

USE ROLE ROLE_MANAGED_ACCESS;

CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITH MANAGED ACCESS;

USE ROLE SECURITYADMIN;

GRANT SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA MANAGED ACCESS to ROLE_MANAGED_ACCESS;

The Administrator now wants to disable the managed access on the schema.

How can this be accomplished?

Options:

ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;

USE ROLE ROLE MANAGED_ACCESS;

DROP SCHEMA WORK. SCHEMA_MANAGED_ACCESS;

CREATE SCHEMA SCHEMA_MANAGED_ACCESS;

Then recreate all needed objects.

REVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA_MANAGED_ACCESS FROM

ROLE_MANAGED_ACCESS;

ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;

USE ROLE ROLE_MANAGED_ACCESS;

DROP SCHEMA WORK. SCHEMA MANAGED_ACCESS;

CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITHOUT MANAGED ACCESS;

Then recreate all needed objects.

Questions # 18:

An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to

make a transient copy of this table and wants the transient table to have all the same permissions as the original table.

How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the

requirements? (Select TWO).