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

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

Add to Whishlist

List of questions

Question 91

Report Export Collapse

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

Become a Premium Member for full access
  Unlock Premium Member

Question 92

Report Export Collapse

What is the default character set used when loading CSV files into Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 93

Report Export Collapse

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Become a Premium Member for full access
  Unlock Premium Member

Question 94

Report Export Collapse

Which cache type is used to cache data output from SQL queries?

Become a Premium Member for full access
  Unlock Premium Member

Question 95

Report Export Collapse

What is a key feature of Snowflake architecture?

Become a Premium Member for full access
  Unlock Premium Member

Question 96

Report Export Collapse

What is a limitation of a Materialized View?

Become a Premium Member for full access
  Unlock Premium Member

Question 97

Report Export Collapse

What features does Snowflake Time Travel enable?

Become a Premium Member for full access
  Unlock Premium Member

Question 98

Report Export Collapse

Which statement about billing applies to Snowflake credits?

Become a Premium Member for full access
  Unlock Premium Member

Question 99

Report Export Collapse

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

Become a Premium Member for full access
  Unlock Premium Member

Question 100

Report Export Collapse

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

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