Month End Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

ADA-C01 Exam Dumps : SnowPro Advanced Administrator

PDF
ADA-C01 pdf
 Real Exam Questions and Answer
 Last Update: Apr 26, 2025
 Question and Answers: 78 With Explanation
 Compatible with all Devices
 Printable Format
 100% Pass Guaranteed
$25.5  $84.99
ADA-C01 exam
PDF + Testing Engine
ADA-C01 PDF + engine
 Both PDF & Practice Software
 Last Update: Apr 26, 2025
 Question and Answers: 78
 Discount Offer
 Download Free Demo
 24/7 Customer Support
$40.5  $134.99
Testing Engine
ADA-C01 Engine
 Desktop Based Application
 Last Update: Apr 26, 2025
 Question and Answers: 78
 Create Multiple Test Sets
 Questions Regularly Updated
  90 Days Free Updates
  Windows and Mac Compatible
$30  $99.99

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

SnowPro Advanced Administrator Questions and Answers

Question 1

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?

Options:

A.

Only the ACCOUNTADMIN role, and no other roles

B.

Any role with USAGE privilege on the Data Exchange

C.

Any role with IMPORT SHARE and CREATE DATABASE privileges

D.

Any role that the listing provider has designated as authorized

Buy Now
Question 2

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?

Options:

A.

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;

B.

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;

C.

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;

D.

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;

Question 3

A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the

database APP_DB containing only one schema, APP_SCHEMA. The company's Time Travel retention policy is currently set for 30 days for both accounts. An Administrator

has been asked to extend the Time Travel retention policy to 60 days on the secondary database only.

How can this requirement be met?

Options:

A.

Set the data retention policy on the secondary database to 60 days.

B.

Set the data retention policy on the schemas in the secondary database to 60 days.

C.

Set the data retention policy on the primary database to 30 days and the schemas to 60 days.

D.

Set the data retention policy on the primary database to 60 days.