SnowPro Core Recertification Exam (COF-R02) Practice Test

Questions # 1:

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.

Options:

True

False

Questions # 2:

Which of the following statements would be used to export/unload data from Snowflake?

Options:

COPY INTO @stage

EXPORT TO @stage

INSERT INTO @stage

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Questions # 3:

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

Options:

True

False

Questions # 4:

The PUT command: (Choose two.)

Options:

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Automatically encrypts files

Questions # 5:

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Options:

The validation_mode option is used when creating an Internal Stage

validation_mode=return_all_errors is a parameter of the copy command

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Questions # 6:

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Options:

Custom

Economy

Optimized

Standard

Questions # 7:

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

Options:

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

Questions # 8:

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.

Options:

True

False

Questions # 9:

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Options:

Standard

Premier

Enterprise

Business Critical Edition

Questions # 10:

Which of the following are options when creating a Virtual Warehouse?

Options:

Auto-suspend

Auto-resume

Local SSD size

User count

Viewing page 1 out of 10 pages

Viewing questions 1-10 out of questions

Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with ExamsMirror

Exam COF-R02 Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES