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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 24

Add to Whishlist

List of questions

Question 231

Report Export Collapse

How would a user execute a series of SQL statements using a task?

Become a Premium Member for full access
  Unlock Premium Member

Question 232

Report Export Collapse

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Become a Premium Member for full access
  Unlock Premium Member

Question 233

Report Export Collapse

A user has a standard multi-cluster warehouse auto-scaling policy in place.

Which condition will trigger a cluster to shut-down?

Become a Premium Member for full access
  Unlock Premium Member

Question 234

Report Export Collapse

What is cached during a query on a virtual warehouse?

Become a Premium Member for full access
  Unlock Premium Member

Question 235

Report Export Collapse

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 236

Report Export Collapse

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called 'CONSUMER'

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

Become a Premium Member for full access
  Unlock Premium Member

Question 237

Report Export Collapse

Which of the following can be used when unloading data from Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 238

Report Export Collapse

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Become a Premium Member for full access
  Unlock Premium Member

Question 239

Report Export Collapse

Which formats does Snowflake store unstructured data in? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 240

Report Export Collapse

Which of the following are characteristics of security in Snowflake?

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