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

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

Add to Whishlist

List of questions

Question 231

Report Export Collapse

Which of the following are characteristics of security in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 232

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 233

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 234

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

Question 235

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 236

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 237

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 238

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 239

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 240

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
Total 716 questions
Go to page: of 72
Open VPLUS File
Convert VPLUS to PDF

Related questions

How can the outer array structure of a semi-structured file be removed?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
How does the search optimization service improve query performance?
What is a key feature of Snowflake architecture?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).