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

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

Add to Whishlist

List of questions

Question 271

Report Export Collapse

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 272

Report Export Collapse

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 273

Report Export Collapse

Which statement MOST accurately describes clustering in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 274

Report Export Collapse

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Become a Premium Member for full access
  Unlock Premium Member

Question 275

Report Export Collapse

How often are the Account and Table master keys automatically rotated by Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 276

Report Export Collapse

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement?

(Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 277

Report Export Collapse

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 278

Report Export Collapse

Which TABLE function helps to convert semi-structured data to a relational representation?

Become a Premium Member for full access
  Unlock Premium Member

Question 279

Report Export Collapse

Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

Become a Premium Member for full access
  Unlock Premium Member

Question 280

Report Export Collapse

What is the recommended compressed file size range for continuous data loads using Snowpipe?

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