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

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

List of questions

Question 511

Report Export Collapse

What type of function returns one value for each Invocation?

Become a Premium Member for full access
  Unlock Premium Member

Question 512

Report Export Collapse

For Directory tables, what stage allows for automatic refreshing of metadata?

Become a Premium Member for full access
  Unlock Premium Member

Question 513

Report Export Collapse

Which command removes a role from another role or a user in Snowflak?

Become a Premium Member for full access
  Unlock Premium Member

Question 514

Report Export Collapse

The VALIDATE table function has which parameter as an input argument for a Snowflake user?

Become a Premium Member for full access
  Unlock Premium Member

Question 515

Report Export Collapse

Which function should be used to insert JSON format string data inot a VARIANT field?

Become a Premium Member for full access
  Unlock Premium Member

Question 516

Report Export Collapse

Which file function generates a SnowFlake-hosted URL that must be authenticated when used?

Become a Premium Member for full access
  Unlock Premium Member

Question 517

Report Export Collapse

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

Become a Premium Member for full access
  Unlock Premium Member

Question 518

Report Export Collapse

What are characteristic of Snowsight worksheet? (Select TWO.)

Become a Premium Member for full access
  Unlock Premium Member

Question 519

Report Export Collapse

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.

How will those object names be resolved during execution?

Become a Premium Member for full access
  Unlock Premium Member

Question 520

Report Export Collapse

What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

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