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

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

Add to Whishlist

List of questions

Question 171

Report Export Collapse

What COPY INTO SQL command should be used to unload data into multiple files?

Become a Premium Member for full access
  Unlock Premium Member

Question 172

Report Export Collapse

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Become a Premium Member for full access
  Unlock Premium Member

Question 173

Report Export Collapse

When loading data into Snowflake, how should the data be organized?

Become a Premium Member for full access
  Unlock Premium Member

Question 174

Report Export Collapse

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 175

Report Export Collapse

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Become a Premium Member for full access
  Unlock Premium Member

Question 176

Report Export Collapse

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Become a Premium Member for full access
  Unlock Premium Member

Question 177

Report Export Collapse

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

Become a Premium Member for full access
  Unlock Premium Member

Question 178

Report Export Collapse

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 179

Report Export Collapse

Where can a user find and review the failed logins of a specific user for the past 30 days?

Become a Premium Member for full access
  Unlock Premium Member

Question 180

Report Export Collapse

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

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