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

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

Add to Whishlist

List of questions

Question 131

Report Export Collapse

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Become a Premium Member for full access
  Unlock Premium Member

Question 132

Report Export Collapse

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Become a Premium Member for full access
  Unlock Premium Member

Question 133

Report Export Collapse

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Become a Premium Member for full access
  Unlock Premium Member

Question 134

Report Export Collapse

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

Become a Premium Member for full access
  Unlock Premium Member

Question 135

Report Export Collapse

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Become a Premium Member for full access
  Unlock Premium Member

Question 136

Report Export Collapse

Which stage type can be altered and dropped?

Become a Premium Member for full access
  Unlock Premium Member

Question 137

Report Export Collapse

Which command can be used to stage local files from which Snowflake interface?

Become a Premium Member for full access
  Unlock Premium Member

Question 138

Report Export Collapse

What is the recommended file sizing for data loading using Snowpipe?

Become a Premium Member for full access
  Unlock Premium Member

Question 139

Report Export Collapse

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 140

Report Export Collapse

What data is stored in the Snowflake storage layer? (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