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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 20

Add to Whishlist

List of questions

Question 191

Report Export Collapse

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Become a Premium Member for full access
  Unlock Premium Member

Question 192

Report Export Collapse

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Become a Premium Member for full access
  Unlock Premium Member

Question 193

Report Export Collapse

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

Become a Premium Member for full access
  Unlock Premium Member

Question 194

Report Export Collapse

What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

Become a Premium Member for full access
  Unlock Premium Member

Question 195

Report Export Collapse

Which file formats are supported for unloading data from Snowflake? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 196

Report Export Collapse

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Become a Premium Member for full access
  Unlock Premium Member

Question 197

Report Export Collapse

What are common issues found by using the Query Profile? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 198

Report Export Collapse

What happens to historical data when the retention period for an object ends?

Become a Premium Member for full access
  Unlock Premium Member

Question 199

Report Export Collapse

By default, which Snowflake role is required to create a share?

Become a Premium Member for full access
  Unlock Premium Member

Question 200

Report Export Collapse

In a Snowflake role hierarchy, what is the top-level role?

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