Hurry! The Christmas Clock is Ticking! Get 50% Off | Limited Time Offer - Ends In 0d 00h 00m 00s Coupon code: JINGLE50

Home
Snowflake
ADA-C01 Exam Questions

Home ❯
Snowflake ❯
ADA-C01 Exam Questions

Free ADA-C01 Exam Questions - Snowflake ADA-C01 Exam

Snowflake ADA-C01 Exam

SnowPro Advanced: Administrator Certification

Total Questions: 72

Last Updated : 07-12-2024

Get Premium Files

Snowflake ADA-C01 Exam - Prepare from Latest, Not Redundant Questions!

Many candidates desire to prepare their Snowflake ADA-C01 exam with the help of only updated and relevant study material. But during their research, they usually waste most of their valuable time with information that is either not relevant or outdated. Study4Exam has a fantastic team of subject-matter experts that make sure you always get the most up-to-date preparatory material. Whenever there is a change in the syllabus of the SnowPro Advanced: Administrator Certification exam, our team of experts updates ADA-C01 questions and eliminates outdated questions. In this way, we save you money and time.

Snowflake ADA-C01 Exam Sample Questions:

Q1.

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?

AOnly the ACCOUNTADMIN role, and no other roles

BAny role with USAGE privilege on the Data Exchange

CAny role with IMPORT SHARE and CREATE DATABASE privileges

DAny role that the listing provider has designated as authorized

Q2.

A Snowflake Administrator is investigating why a query is not re-using the persisted result cache.

The Administrator found the two relevant queries from the SNOWFLAKE. ACCOUNT_USAGE. QUERY_HISTORY view:

q2_ADA-C01

Why is the second query re-scanning micro-partitions instead of using the first query's persisted result cache?

AThe second query includes a CURRENT_TIMESTAMP () function.

BThe second query includes a CURRENT_DATE () function.

CThe queries are executed with two different virtual warehouses.

DThe queries are executed with two different roles.

Q3.

How should an Administrator configure a Snowflake account to use AWS PrivateLink?

ACreate CNAME records in the DNS.

BContact Snowflake Support.

CBlock public access to Snowflake.

DUse SnowCD to evaluate the network connection.

Q4.

An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.

What select command will generate a sample of 20% of the table?

Aselect * from LINEITEM sample bernoulli (20);

Bselect * from LINEITEM sample system (20);

Cselect * from LINEITEM tablesample block (20 rows);

Dselect * from LINEITEM tablesample system (20) seed (1);

Q5.

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

Solutions:

Question: 1 Answer: B

Question: 2 Answer: A

Question: 3 Answer: A

Question: 4 Answer: B

Question: 5 Answer: C