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

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

List of questions

Question 221

Report Export Collapse

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

How can this requirement be met?

Become a Premium Member for full access
  Unlock Premium Member

Question 222

Report Export Collapse

Users are responsible for data storage costs until what occurs?

Become a Premium Member for full access
  Unlock Premium Member

Question 223

Report Export Collapse

What affects whether the query results cache can be used?

Become a Premium Member for full access
  Unlock Premium Member

Question 224

Report Export Collapse

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Become a Premium Member for full access
  Unlock Premium Member

Question 225

Report Export Collapse

How many days is load history for Snowpipe retained?

Become a Premium Member for full access
  Unlock Premium Member

Question 226

Report Export Collapse

How can a row access policy be applied to a table or a view? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 227

Report Export Collapse

Which command can be used to load data files into a Snowflake stage?

Become a Premium Member for full access
  Unlock Premium Member

Question 228

Report Export Collapse

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 229

Report Export Collapse

What is the maximum Time Travel retention period for a temporary Snowflake table?

Become a Premium Member for full access
  Unlock Premium Member

Question 230

Report Export Collapse

When should a multi-cluster warehouse be used in auto-scaling mode?

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