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

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

Add to Whishlist

List of questions

Question 531

Report Export Collapse

What do temporary and transient tables have m common in Snowflake? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 532

Report Export Collapse

What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

Become a Premium Member for full access
  Unlock Premium Member

Question 533

Report Export Collapse

Which activities are managed by Slowflake's Cloud Services layer? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 534

Report Export Collapse

Which statements reflect valid commands when using secondary roles? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 535

Report Export Collapse

What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

Become a Premium Member for full access
  Unlock Premium Member

Question 536

Report Export Collapse

A user wants to access stored in a stage without authenticating into Snowflake.

Which type of URL should be used?

Become a Premium Member for full access
  Unlock Premium Member

Question 537

Report Export Collapse

Which Snowflake objects can be restored using Time Travel? (Select VNO).

Become a Premium Member for full access
  Unlock Premium Member

Question 538

Report Export Collapse

Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?

Become a Premium Member for full access
  Unlock Premium Member

Question 539

Report Export Collapse

A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2< hour mark?

Become a Premium Member for full access
  Unlock Premium Member

Question 540

Report Export Collapse

Which user preferences can be set for a user profile in Snowsight? (Select 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).