Pre-Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: big60

Page: 1 / 5

Snowflake Certification SnowPro Advanced Administrator

SnowPro Advanced Administrator

Last Update Mar 26, 2025
Total Questions : 72

To help you prepare for the ADA-C01 Snowflake exam, we are offering free ADA-C01 Snowflake exam questions. All you need to do is sign up, provide your details, and prepare with the free ADA-C01 practice questions. Once you have done that, you will have access to the entire pool of SnowPro Advanced Administrator ADA-C01 test questions which will help you better prepare for the exam. Additionally, you can also find a range of SnowPro Advanced Administrator resources online to help you better understand the topics covered on the exam, such as SnowPro Advanced Administrator ADA-C01 video tutorials, blogs, study guides, and more. Additionally, you can also practice with realistic Snowflake ADA-C01 exam simulations and get feedback on your progress. Finally, you can also share your progress with friends and family and get encouragement and support from them.

Questions 2

What are characteristics of Dynamic Data Masking? (Select TWO).

Options:

A.  

A masking policy that is currently set on a table can be dropped.

B.  

A single masking policy can be applied to columns in different tables.

C.  

A masking policy can be applied to the VALUE column of an external table.

D.  

The role that creates the masking policy will always see unmasked data in query results.

E.  

A single masking policy can be applied to columns with different data types.

Discussion 0
Questions 3

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:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Miley
Hey, I tried Cramkey Dumps for my IT certification exam. They are really awesome and helped me pass my exam with wonderful score.
Megan Aug 30, 2024
That’s great!!! I’ll definitely give it a try. Thanks!!!
Josephine
I want to ask about their study material and Customer support? Can anybody guide me?
Zayd Oct 22, 2024
Yes, the dumps or study material provided by them are authentic and up to date. They have a dedicated team to assist students and make sure they have a positive experience.
Osian
Dumps are fantastic! I recently passed my certification exam using these dumps and I must say, they are 100% valid.
Azaan Aug 8, 2024
They are incredibly accurate and valid. I felt confident going into my exam because the dumps covered all the important topics and the questions were very similar to what I saw on the actual exam. The team of experts behind Cramkey Dumps make sure the information is relevant and up-to-date.
Sarah
Yeah, I was so relieved when I saw that the question appeared in the exam were similar to their exam dumps. It made the exam a lot easier and I felt confident going into it.
Aaliyah Aug 27, 2024
Same here. I've heard mixed reviews about using exam dumps, but for us, it definitely paid off.
Questions 4

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

Options:

A.  

No, because joins are not supported by materialized views.

B.  

No, because the optimizer might decide against it.

C.  

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

D.  

Yes, because materialized views are always faster.

Discussion 0
Questions 5

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:

A.  

ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;

B.  

USE ROLE ROLE MANAGED_ACCESS;

DROP SCHEMA WORK. SCHEMA_MANAGED_ACCESS;

CREATE SCHEMA SCHEMA_MANAGED_ACCESS;

Then recreate all needed objects.

C.  

REVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA_MANAGED_ACCESS FROM

ROLE_MANAGED_ACCESS;

ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;

D.  

USE ROLE ROLE_MANAGED_ACCESS;

DROP SCHEMA WORK. SCHEMA MANAGED_ACCESS;

CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITHOUT MANAGED ACCESS;

Then recreate all needed objects.

Discussion 0

ADA-C01
PDF

$42  $104.99

ADA-C01 Testing Engine

$50  $124.99

ADA-C01 PDF + Testing Engine

$66  $164.99