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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 21

Add to Whishlist

List of questions

Question 201

Report Export Collapse

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Become a Premium Member for full access
  Unlock Premium Member

Question 202

Report Export Collapse

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Become a Premium Member for full access
  Unlock Premium Member

Question 203

Report Export Collapse

Where is Snowflake metadata stored?

Become a Premium Member for full access
  Unlock Premium Member

Question 204

Report Export Collapse

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 205

Report Export Collapse

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 206

Report Export Collapse

Which statement MOST accurately describes clustering in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 207

Report Export Collapse

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Become a Premium Member for full access
  Unlock Premium Member

Question 208

Report Export Collapse

How often are the Account and Table master keys automatically rotated by Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 209

Report Export Collapse

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 210

Report Export Collapse

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

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