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

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

List of questions

Question 391

Report Export Collapse

Which commands are restricted in owner's rights stored procedures? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 392

Report Export Collapse

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

Become a Premium Member for full access
  Unlock Premium Member

Question 393

Report Export Collapse

Which privilege must be granted by one role to another role, and cannot be revoked?

Become a Premium Member for full access
  Unlock Premium Member

Question 394

Report Export Collapse

How can performance be optimized for a query that returns a small amount of data from a very large base table?

Become a Premium Member for full access
  Unlock Premium Member

Question 395

Report Export Collapse

What does the LATERAL modifier for the FLATTEN function do?

Become a Premium Member for full access
  Unlock Premium Member

Question 396

Report Export Collapse

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

Become a Premium Member for full access
  Unlock Premium Member

Question 397

Report Export Collapse

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 398

Report Export Collapse

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

Become a Premium Member for full access
  Unlock Premium Member

Question 399

Report Export Collapse

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

Become a Premium Member for full access
  Unlock Premium Member

Question 400

Report Export Collapse

What objects in Snowflake are supported by Dynamic Data Masking? (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).