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

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

List of questions

Question 691

Report Export Collapse

What optional properties can a Snowflake user set when creating a virtual warehouse? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 692

Report Export Collapse

What is the purpose of the use of the VALIDATE command?

Become a Premium Member for full access
  Unlock Premium Member

Question 693

Report Export Collapse

Which function is used to unload a relational table into a JSON file*?

Become a Premium Member for full access
  Unlock Premium Member

Question 694

Report Export Collapse

Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake'>

Become a Premium Member for full access
  Unlock Premium Member

Question 695

Report Export Collapse

What is the primary purpose of using a masking policy in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 696

Report Export Collapse

When used with the UNLOAD command, which parameter specifies the destination of unloaded data?

Become a Premium Member for full access
  Unlock Premium Member

Question 697

Report Export Collapse

What happens when a table or schema with a standard retention period is dropped?

Become a Premium Member for full access
  Unlock Premium Member

Question 698

Report Export Collapse

How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?

Become a Premium Member for full access
  Unlock Premium Member

Question 699

Report Export Collapse

When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 700

Report Export Collapse

How does the search optimization service improve query performance?

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