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

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

Add to Whishlist

List of questions

Question 331

Report Export Collapse

Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

Become a Premium Member for full access
  Unlock Premium Member

Question 332

Report Export Collapse

Which items are considered schema objects in Snowflake? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 333

Report Export Collapse

What are benefits of using Snowpark with Snowflake? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 334

Report Export Collapse

If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?

Become a Premium Member for full access
  Unlock Premium Member

Question 335

Report Export Collapse

Which transformation is supported by a COPY INTO <table> command?

Become a Premium Member for full access
  Unlock Premium Member

Question 336

Report Export Collapse

Which task privilege does a Snowflake role need in order to suspend or resume a task?

Become a Premium Member for full access
  Unlock Premium Member

Question 337

Report Export Collapse

Which role has the ability to create and manage users and roles?

Become a Premium Member for full access
  Unlock Premium Member

Question 338

Report Export Collapse

Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 339

Report Export Collapse

A permanent table and temporary table have the same name, TBL1, in a schema.

What will happen if a user executes select * from TBL1 ;?

Become a Premium Member for full access
  Unlock Premium Member

Question 340

Report Export Collapse

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

Become a Premium Member for full access
  Unlock Premium Member
Total 716 questions
Go to page: of 72