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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 19

Add to Whishlist

List of questions

Question 181

Report Export Collapse

Which of the following accurately describes shares?

Become a Premium Member for full access
  Unlock Premium Member

Question 182

Report Export Collapse

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 183

Report Export Collapse

What is the minimum Snowflake edition required for row level security?

Become a Premium Member for full access
  Unlock Premium Member

Question 184

Report Export Collapse

The is the minimum Fail-safe retention time period for transient tables?

Become a Premium Member for full access
  Unlock Premium Member

Question 185

Report Export Collapse

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 186

Report Export Collapse

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 187

Report Export Collapse

What COPY INTO SQL command should be used to unload data into multiple files?

Become a Premium Member for full access
  Unlock Premium Member

Question 188

Report Export Collapse

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Become a Premium Member for full access
  Unlock Premium Member

Question 189

Report Export Collapse

When loading data into Snowflake, how should the data be organized?

Become a Premium Member for full access
  Unlock Premium Member

Question 190

Report Export Collapse

Which of the following objects can be directly restored using the UNDROP command? (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).