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

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

List of questions

Question 401

Report Export Collapse

What happens when a Snowflake user changes the data retention period at the schema level?

Become a Premium Member for full access
  Unlock Premium Member

Question 402

Report Export Collapse

Which Snowflake function will parse a JSON-null into a SQL-null?

Become a Premium Member for full access
  Unlock Premium Member

Question 403

Report Export Collapse

While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

Become a Premium Member for full access
  Unlock Premium Member

Question 404

Report Export Collapse

Which Snowflake database object can be used to track data changes made to table data?

Become a Premium Member for full access
  Unlock Premium Member

Question 405

Report Export Collapse

What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 406

Report Export Collapse

Which Snowflake table objects can be shared with other accounts? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 407

Report Export Collapse

Which object can be used with Secure Data Sharing?

Become a Premium Member for full access
  Unlock Premium Member

Question 408

Report Export Collapse

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

Become a Premium Member for full access
  Unlock Premium Member

Question 409

Report Export Collapse

Which type of loop requires a BREAK statement to stop executing?

Become a Premium Member for full access
  Unlock Premium Member

Question 410

Report Export Collapse

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

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