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

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

Question list
Search
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

Question 261

Report
Export
Collapse

What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

Become a Premium Member for full access
  Unlock Premium Member

Question 262

Report
Export
Collapse

Which file formats are supported for unloading data from Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 263

Report
Export
Collapse

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Become a Premium Member for full access
  Unlock Premium Member

Question 264

Report
Export
Collapse

What are common issues found by using the Query Profile? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 265

Report
Export
Collapse

What happens to historical data when the retention period for an object ends?

Become a Premium Member for full access
  Unlock Premium Member

Question 266

Report
Export
Collapse

By default, which Snowflake role is required to create a share?

Become a Premium Member for full access
  Unlock Premium Member

Question 267

Report
Export
Collapse

In a Snowflake role hierarchy, what is the top-level role?

Become a Premium Member for full access
  Unlock Premium Member

Question 268

Report
Export
Collapse

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Become a Premium Member for full access
  Unlock Premium Member

Question 269

Report
Export
Collapse

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Become a Premium Member for full access
  Unlock Premium Member

Question 270

Report
Export
Collapse

Where is Snowflake metadata stored?

Become a Premium Member for full access
  Unlock Premium Member
Total 330 questions
Go to page: of 33