ExamGecko
Login
Home / Snowflake / SnowPro Core / List of questions
Ask Question

Snowflake SnowPro Core Practice Test - Questions Answers, Page 16

Add to Whishlist

List of questions

Question 151

Report Export Collapse

Which statement is true about running tasks in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 152

Report Export Collapse

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

Become a Premium Member for full access
  Unlock Premium Member

Question 153

Report Export Collapse

Which of the following describes a Snowflake stored procedure?

Become a Premium Member for full access
  Unlock Premium Member

Question 154

Report Export Collapse

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 155

Report Export Collapse

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Become a Premium Member for full access
  Unlock Premium Member

Question 156

Report Export Collapse

How are serverless features billed?

Become a Premium Member for full access
  Unlock Premium Member

Question 157

Report Export Collapse

Which Snowflake architectural layer is responsible for a query execution plan?

Become a Premium Member for full access
  Unlock Premium Member

Question 158

Report Export Collapse

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 159

Report Export Collapse

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 160

Report Export Collapse

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

Which diagram indicates a well-clustered table?

Become a Premium Member for full access
  Unlock Premium Member
Total 627 questions
Go to page: of 63
Open VPLUS File
Convert VPLUS to PDF

Related questions

What is a key feature of Snowflake architecture?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
How is unstructured data retrieved from data storage?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
A materialized view should be created when which of the following occurs? (Choose two.)
What happens when a virtual warehouse is resized?
How can a Snowflake user traverse semi-structured data?
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
User-level network policies can be created by which of the following roles? (Select TWO).