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

Viewing page 4 out of 10 pages
Viewing questions 31-40 out of questions
Questions # 31:

True or False: Snowflake charges a premium for storing semi-structured data.

Options:

A.

True


B.

False


Expert Solution
Questions # 32:

True or False: You can query the files in an External Stage directly without having to load the data into a table.

Options:

A.

True


B.

False


Expert Solution
Questions # 33:

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

Options:

A.

True


B.

False


Expert Solution
Questions # 34:

When unloading to a stage, which of the following is a recommended practice or approach?

Options:

A.

Set SINGLE: = true for larger files


B.

Use OBJECT_CONSTRUCT ( * ) when using Parquet


C.

Avoid the use of the CAST function


D.

Define an individual file format


Expert Solution
Questions # 35:

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Options:

A.

Internal stages


B.

Incremental backups


C.

Time Travel


D.

Zero-copy clones


E.

Fail-safe


Expert Solution
Questions # 36:

What is the purpose of an External Function?

Options:

A.

To call code that executes outside of Snowflake


B.

To run a function in another Snowflake database


C.

To share data in Snowflake with external parties


D.

To ingest data from on-premises data sources


Expert Solution
Questions # 37:

Which stage type can be altered and dropped?

Options:

A.

Database stage


B.

External stage


C.

Table stage


D.

User stage


Expert Solution
Questions # 38:

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Options:

A.

Okta Verify


B.

Duo Mobile


C.

Microsoft Authenticator


D.

Google Authenticator


Expert Solution
Questions # 39:

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Options:

A.

Via the Snowflake Web Interface (Ul)


B.

Via the data_share=true parameter


C.

Via SQL commands


D.

Via Virtual Warehouses


Expert Solution
Questions # 40:

True or False: A Virtual Warehouse can be resized while suspended.

Options:

A.

True


B.

False


Expert Solution
Viewing page 4 out of 10 pages
Viewing questions 31-40 out of questions