Home / Snowflake / COF-R02

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

Question list

List of questions

Question 21

(0)

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

Question 22

(0)

Select the different types of Internal Stages: (Choose three.)

Question 23

(0)

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Question 24

(0)

True or False: The COPY command must specify a File Format in order to execute.

Question 25

(0)

Which of the following objects can be cloned? (Choose four.)

Question 26

(0)

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

Question 27

(0)

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

Question 28

(0)

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Question 29

(0)

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

Question 30

(0)

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)

Question 21

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

True

False

Show Answer Comment (0)

Question 22

Select the different types of Internal Stages: (Choose three.)

Named Stage

User Stage

Table Stage

Schema Stage

Show Answer Comment (0)

Question 23

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

Show Answer Comment (0)

Question 24

True or False: The COPY command must specify a File Format in order to execute.

True

False

Show Answer Comment (0)

Question 25

Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users

Show Answer Comment (0)

Question 26

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

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

Show Answer Comment (0)

Question 27

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

To accommodate more queries

To accommodate more users

To accommodate fluctuations in workload

To accommodate a more complex workload

Show Answer Comment (0)

Question 28

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

True

False

Show Answer Comment (0)

Question 29

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?

(Choose all that apply.)

JDBC

SnowSQL

Snowflake Web Interface (UI)

ODBC

PythonD18912E1457D5D1DDCBD40AB3BF70D5D

Show Answer Comment (0)

Question 30

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?

(Choose all that apply.)

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

Show Answer Comment (0)

Total 330 questions

1 2 3 4 5

Go to page: of 33

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

Question list

List of questions

Question 21

(0)

Question 22

(0)

Question 23

(0)

Question 24

(0)

Question 25

(0)

Question 26

(0)

Question 27

(0)

Question 28

(0)

Question 29

(0)

Question 30

(0)

Related questions

Question