ExamGecko
Login
Home / Snowflake / COF-R02 / List of questions
Ask Question

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

Add to Whishlist

List of questions

Question 201

Report Export Collapse

Network policies can be set at which Snowflake levels? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 202

Report Export Collapse

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Become a Premium Member for full access
  Unlock Premium Member

Question 203

Report Export Collapse

Which of the following objects are contained within a schema? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 204

Report Export Collapse

Which of the following statements describe features of Snowflake data caching? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 205

Report Export Collapse

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

Become a Premium Member for full access
  Unlock Premium Member

Question 206

Report Export Collapse

Which of the following describes a Snowflake stored procedure?

Become a Premium Member for full access
  Unlock Premium Member

Question 207

Report Export Collapse

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 208

Report Export Collapse

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Become a Premium Member for full access
  Unlock Premium Member

Question 209

Report Export Collapse

How are serverless features billed?

Become a Premium Member for full access
  Unlock Premium Member

Question 210

Report Export Collapse

Which Snowflake architectural layer is responsible for a query execution plan?

Become a Premium Member for full access
  Unlock Premium Member
Total 330 questions
Go to page: of 33
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
What is the default character set used when loading CSV files into Snowflake?
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Which of the following terms best describes Snowflake’s database architecture?
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
What are the three layers that make up Snowflake’s architecture? Choose 3 answer