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

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

Add to Whishlist

List of questions

Question 571

Report Export Collapse

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON <object> <object_name> To SHARE <share_name>;

Become a Premium Member for full access
  Unlock Premium Member

Question 572

Report Export Collapse

How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

Become a Premium Member for full access
  Unlock Premium Member

Question 573

Report Export Collapse

What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

Become a Premium Member for full access
  Unlock Premium Member

Question 574

Report Export Collapse

Which Snowflake privilege is required on a pipe object to pause or resume pipes?

Become a Premium Member for full access
  Unlock Premium Member

Question 575

Report Export Collapse

What information is stored in the ACCESS_HlSTORY view?

Become a Premium Member for full access
  Unlock Premium Member

Question 576

Report Export Collapse

In the Data Exchange, who can get or request data from the listings? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 577

Report Export Collapse

Authorization to execute CREATE <object> statements comes only from which role?

Become a Premium Member for full access
  Unlock Premium Member

Question 578

Report Export Collapse

Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

Become a Premium Member for full access
  Unlock Premium Member

Question 579

Report Export Collapse

Which file function provides a URL with access to a file on a stage without the need for authentication and authorization?

Become a Premium Member for full access
  Unlock Premium Member

Question 580

Report Export Collapse

Which governance feature is supported by all Snowflake editions?

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