Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: merry71

Free SnowPro Core Recertification Exam Practice Questions

Question # 31

Which of the following statements are true of Snowflake releases: (Choose two.)

Options:

A.  

They happen approximately weekly

B.  

They roll up and release approximately monthly, but customers can request early release application

C.  

During a release, new customer requests/queries/connections transparently move over to the newer

version

D.  

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the

system will be unavailable and customer is upgraded

Discussion 0
Question # 32

What are the three things customers want most from their enterprise data warehouse solution?

Choose 3 answers

Options:

A.  

On-premise availability

B.  

Simplicity

C.  

Open source based

D.  

Concurrency

E.  

Performance

Discussion 0
Question # 33

Snowflake is designed for which type of workloads? (Choose two.)

Options:

A.  

OLAP (Analytics) workloads

B.  

OLTP (Transactional) workloads

C.  

Concurrent workloads

D.  

On-premise workloads

Discussion 0
Question # 34

Which interfaces can be used to create and/or manage Virtual Warehouses?

Options:

A.  

The Snowflake Web Interface (UI)

B.  

SQL commands

C.  

Data integration tools

D.  

All of the above

Discussion 0
Question # 35

When can a Virtual Warehouse start running queries?

Options:

A.  

12am-5am

B.  

Only during administrator defined time slots

C.  

When its provisioning is complete

D.  

After replication

Discussion 0
Question # 36

True or False: Snowflake supports federated authentication in all editions.

Options:

A.  

True

B.  

False

Discussion 0
Question # 37

True or False: An active warehouse is required to run a COPY INTO statement.

Options:

A.  

True

B.  

False

Discussion 0
Question # 38

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Options:

A.  

To accommodate more queries

B.  

To accommodate more users

C.  

To accommodate fluctuations in workload

D.  

To accommodate a more complex workload

Discussion 0
Question # 39

User-level network policies can be created by which of the following roles? (Select TWO).

Options:

A.  

ROLEADMIN

B.  

ACCOUNTADMIN

C.  

SYSADMIN

D.  

SECURITYADMIN

E.  

USERADMIN

Discussion 0
Question # 40

Which command can be used to stage local files from which Snowflake interface?

Options:

A.  

SnowSQL

B.  

Snowflake classic web interface (Ul)

C.  

Snowsight

D.  

.NET driver

Discussion 0

COF-R02 PDF

COF-R02 PDF (Printable)
$46.5
$154.99

COF-R02 Testing Engine

COF-R02 PDF (Printable)
$51
$169.99

COF-R02 PDF + Testing Engine

COF-R02 PDF (Printable)
$63.9
$212.99

Free Exams Sample Questions