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

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

List of questions

Question 601

Report Export Collapse

Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

Become a Premium Member for full access
  Unlock Premium Member

Question 602

Report Export Collapse

What command is used to export or unload data from Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 603

Report Export Collapse

Which of the following SQL statements will list the version of the drivers currently being used?

Become a Premium Member for full access
  Unlock Premium Member

Question 604

Report Export Collapse

Which object type is granted permissions for reading a table?

Become a Premium Member for full access
  Unlock Premium Member

Question 605

Report Export Collapse

When should a stored procedure be created with caller's rights?

Become a Premium Member for full access
  Unlock Premium Member

Question 606

Report Export Collapse

Which function can be used with the copy into <location> statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?

Become a Premium Member for full access
  Unlock Premium Member

Question 607

Report Export Collapse

By default, which role can create resource monitors?

Become a Premium Member for full access
  Unlock Premium Member

Question 608

Report Export Collapse

What happens to the privileges granted to Snowflake system-defined roles?

Become a Premium Member for full access
  Unlock Premium Member

Question 609

Report Export Collapse

Which type of role can be granted to a share?

Become a Premium Member for full access
  Unlock Premium Member

Question 610

Report Export Collapse

When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY <expression> parameter option?

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).