ExamGecko
Home / Snowflake / COF-C02
Ask Question

Snowflake COF-C02 Practice Test - Questions Answers, Page 60

Question list
Search

Question 591

Report
Export
Collapse

Which command can be used to list all network policies available in an account?

Become a Premium Member for full access
  Unlock Premium Member

Question 592

Report
Export
Collapse

What should be considered when deciding to use a secure view? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 593

Report
Export
Collapse

Which virtual warehouse consideration can help lower compute resource credit consumption?

Become a Premium Member for full access
  Unlock Premium Member

Question 594

Report
Export
Collapse

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.

What should the user do?

Become a Premium Member for full access
  Unlock Premium Member

Question 595

Report
Export
Collapse

To use the overwrite option on insert, which privilege must be granted to the role?

Become a Premium Member for full access
  Unlock Premium Member

Question 596

Report
Export
Collapse

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

Become a Premium Member for full access
  Unlock Premium Member

Question 597

Report
Export
Collapse

What is the default access of a securable object until other access is granted?

Become a Premium Member for full access
  Unlock Premium Member

Question 598

Report
Export
Collapse

What happens when a suspended virtual warehouse is resized in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 599

Report
Export
Collapse

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

Become a Premium Member for full access
  Unlock Premium Member

Question 600

Report
Export
Collapse

Which task is supported by the use of Access History in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member
Total 716 questions
Go to page: of 72