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

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

List of questions

Question 251

Report Export Collapse

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Become a Premium Member for full access
  Unlock Premium Member

Question 252

Report Export Collapse

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Become a Premium Member for full access
  Unlock Premium Member

Question 253

Report Export Collapse

A user created a transient table and made several changes to it over the course of several days.

Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

Become a Premium Member for full access
  Unlock Premium Member

Question 254

Report Export Collapse

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 255

Report Export Collapse

Where can a user find and review the failed logins of a specific user for the past 30 days?

Become a Premium Member for full access
  Unlock Premium Member

Question 256

Report Export Collapse

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 257

Report Export Collapse

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

Become a Premium Member for full access
  Unlock Premium Member

Question 258

Report Export Collapse

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 259

Report Export Collapse

Which statement is true about running tasks in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 260

Report Export Collapse

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

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