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

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

List of questions

Question 301

Report Export Collapse

What is cached during a query on a virtual warehouse?

Become a Premium Member for full access
  Unlock Premium Member

Question 302

Report Export Collapse

Which of the following activities consume virtual warehouse credits in the Snowflake environment?

(Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 303

Report Export Collapse

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

Become a Premium Member for full access
  Unlock Premium Member

Question 304

Report Export Collapse

Which of the following can be used when unloading data from Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 305

Report Export Collapse

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Become a Premium Member for full access
  Unlock Premium Member

Question 306

Report Export Collapse

Which formats does Snowflake store unstructured data in? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 307

Report Export Collapse

Which of the following are characteristics of security in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 308

Report Export Collapse

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

Become a Premium Member for full access
  Unlock Premium Member

Question 309

Report Export Collapse

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

Become a Premium Member for full access
  Unlock Premium Member

Question 310

Report Export Collapse

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

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