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

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

List of questions

Question 561

Report
Export
Collapse

Which Snowflake database object can be shared with other accounts?

Become a Premium Member for full access
  Unlock Premium Member

Question 562

Report
Export
Collapse

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

Become a Premium Member for full access
  Unlock Premium Member

Question 563

Report
Export
Collapse

A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?

Become a Premium Member for full access
  Unlock Premium Member

Question 564

Report
Export
Collapse

Which key access control concept does Snowflake descibe as a defined level of access to an object?

Become a Premium Member for full access
  Unlock Premium Member

Question 565

Report
Export
Collapse

Snowflake's access control framework combines which models for securing data? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 566

Report
Export
Collapse

What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

Become a Premium Member for full access
  Unlock Premium Member

Question 567

Report
Export
Collapse

How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

Become a Premium Member for full access
  Unlock Premium Member

Question 568

Report
Export
Collapse

Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

Become a Premium Member for full access
  Unlock Premium Member

Question 569

Report
Export
Collapse

When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 570

Report
Export
Collapse

Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?

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