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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 17

Add to Whishlist

List of questions

Question 161

Report Export Collapse

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Become a Premium Member for full access
  Unlock Premium Member

Question 162

Report Export Collapse

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 163

Report Export Collapse

What affects whether the query results cache can be used?

Become a Premium Member for full access
  Unlock Premium Member

Question 164

Report Export Collapse

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Become a Premium Member for full access
  Unlock Premium Member

Question 165

Report Export Collapse

How many days is load history for Snowpipe retained?

Become a Premium Member for full access
  Unlock Premium Member

Question 166

Report Export Collapse

How can a row access policy be applied to a table or a view? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 167

Report Export Collapse

Which command can be used to load data files into a Snowflake stage?

Become a Premium Member for full access
  Unlock Premium Member

Question 168

Report Export Collapse

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 169

Report Export Collapse

What is the maximum Time Travel retention period for a temporary Snowflake table?

Become a Premium Member for full access
  Unlock Premium Member

Question 170

Report Export Collapse

When should a multi-cluster warehouse be used in auto-scaling mode?

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