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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 39

List of questions

Question 381

Report Export Collapse

Which function unloads data from a relational table to JSON?

Become a Premium Member for full access
  Unlock Premium Member

Question 382

Report Export Collapse

Which commands can only be executed using SnowSQL? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 383

Report Export Collapse

What is the relationship between a Query Profile and a virtual warehouse?

Become a Premium Member for full access
  Unlock Premium Member

Question 384

Report Export Collapse

What is the primary purpose of a directory table in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 385

Report Export Collapse

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 386

Report Export Collapse

Which commands are restricted in owner's rights stored procedures? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 387

Report Export Collapse

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

Become a Premium Member for full access
  Unlock Premium Member

Question 388

Report Export Collapse

Which privilege must be granted by one role to another role, and cannot be revoked?

Become a Premium Member for full access
  Unlock Premium Member

Question 389

Report Export Collapse

How can performance be optimized for a query that returns a small amount of data from a very large base table?

Become a Premium Member for full access
  Unlock Premium Member

Question 390

Report Export Collapse

What does the LATERAL modifier for the FLATTEN function do?

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