Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: s2p65

Easiest Solution 2 Pass Your Certification Exams

ADA-C01 Snowflake SnowPro Advanced Administrator Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Snowflake ADA-C01 SnowPro Advanced Administrator certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Page: 2 / 2
Total 78 questions

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?

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.

What are benefits of creating and maintaining resource monitors in Snowflake? (Select 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.

Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

A.

CREATE NETWORK POLICY ADMIN_POLICY

ALLOWED_IP_LIST = ('192.168.1.100');

ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

User ABC is the only user with an ACCOUNTADMIN role.

B.

CREATE NETWORK POLICY ADMIN POLICY

ALLOWED_IP_LIST = ('192.168.1.100');

ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY';

C.

CREATE NETWORK POLICY ADMIN_POLICY

ALLOWED IP LIST = ('192.168.1.100')

BLOCKED_IP_LIST = ('0.0.0.0/0');

ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

D.

CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY

ALLOWED_IP_LIST = ('192.168. 1. 100/0') ;

ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

Page: 2 / 2
Total 78 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved