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

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

Add to Whishlist

List of questions

Question 351

Report Export Collapse

What is a directory table in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 352

Report Export Collapse

Which Snowflake command can be used to unload the result of a query to a single file?

Become a Premium Member for full access
  Unlock Premium Member

Question 353

Report Export Collapse

When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?

Become a Premium Member for full access
  Unlock Premium Member

Question 354

Report Export Collapse

When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

Become a Premium Member for full access
  Unlock Premium Member

Question 355

Report Export Collapse

What factors impact storage costs in Snowflake? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 356

Report Export Collapse

Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

Become a Premium Member for full access
  Unlock Premium Member

Question 357

Report Export Collapse

Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

Become a Premium Member for full access
  Unlock Premium Member

Question 358

Report Export Collapse

Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

Become a Premium Member for full access
  Unlock Premium Member

Question 359

Report Export Collapse

How can a dropped internal stage be restored?

Become a Premium Member for full access
  Unlock Premium Member

Question 360

Report Export Collapse

Who can grant object privileges in a regular schema?

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