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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 60

Add to Whishlist

List of questions

Question 591

Report Export Collapse

Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

Become a Premium Member for full access
  Unlock Premium Member

Question 592

Report Export Collapse

Which function returns the URL of a stage using the stage name as the input?

Become a Premium Member for full access
  Unlock Premium Member

Question 593

Report Export Collapse

When does a materialized view get suspended in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 594

Report Export Collapse

What does a table with a clustering depth of 1 mean in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 595

Report Export Collapse

Which Snowflake object contains all the information required to share a database?

Become a Premium Member for full access
  Unlock Premium Member

Question 596

Report Export Collapse

Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?

Become a Premium Member for full access
  Unlock Premium Member

Question 597

Report Export Collapse

Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

Become a Premium Member for full access
  Unlock Premium Member

Question 598

Report Export Collapse

The property mins_to_bypass_network_policy is set at which level?

Become a Premium Member for full access
  Unlock Premium Member

Question 599

Report Export Collapse

Which privilege is required on a virtual warehouse to abort any existing executing queries?

Become a Premium Member for full access
  Unlock Premium Member

Question 600

Report Export Collapse

What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member
Total 627 questions
Go to page: of 63