Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 4

Question list

List of questions

Question 31

(0)

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

Question 32

(0)

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Question 33

(0)

The PUT command: (Choose two.)

Question 34

(0)

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

Question 35

(0)

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

Question 36

(0)

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Question 37

(0)

True or False: It is possible to load data into Snowflake without creating a named File Format object.

Question 38

(0)

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Question 39

(0)

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

Question 40

(0)

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

Question 31

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

True

False

Show Answer Comment (0)

Question 32

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

Show Answer Comment (0)

Question 33

The PUT command: (Choose two.)

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

Show Answer Comment (0)

Question 34

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

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

Show Answer Comment (0)

Question 35

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

Show Answer Comment (0)

Question 36

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Standard

Premier

Enterprise

Business Critical Edition

Show Answer Comment (0)

Question 37

True or False: It is possible to load data into Snowflake without creating a named File Format object.

True

False

Show Answer Comment (0)

Question 38

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

True

False

Show Answer Comment (0)

Question 39

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

True

False

Show Answer Comment (0)

Question 40

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

They happen approximately weekly

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

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

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

Show Answer Comment (0)

Total 330 questions