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

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

Add to Whishlist

List of questions

Question 311

Report Export Collapse

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

Become a Premium Member for full access
  Unlock Premium Member

Question 312

Report Export Collapse

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Become a Premium Member for full access
  Unlock Premium Member

Question 313

Report Export Collapse

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

Become a Premium Member for full access
  Unlock Premium Member

Question 314

Report Export Collapse

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Become a Premium Member for full access
  Unlock Premium Member

Question 315

Report Export Collapse

A materialized view should be created when which of the following occurs? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 316

Report Export Collapse

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Become a Premium Member for full access
  Unlock Premium Member

Question 317

Report Export Collapse

Which feature allows a user the ability to control the organization of data in a micro-partition?

Become a Premium Member for full access
  Unlock Premium Member

Question 318

Report Export Collapse

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

Become a Premium Member for full access
  Unlock Premium Member

Question 319

Report Export Collapse

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 320

Report Export Collapse

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose 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