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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 29

Add to Whishlist

List of questions

Question 281

Report Export Collapse

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 282

Report Export Collapse

What can a Snowflake user do with the information included in the details section of a Query Profile?

Become a Premium Member for full access
  Unlock Premium Member

Question 283

Report Export Collapse

How many network policies can be assigned to an account or specific user at a time?

Become a Premium Member for full access
  Unlock Premium Member

Question 284

Report Export Collapse

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

Become a Premium Member for full access
  Unlock Premium Member

Question 285

Report Export Collapse

What is the recommended way to change the existing file format type in my format from CSV to JSON?

Become a Premium Member for full access
  Unlock Premium Member

Question 286

Report Export Collapse

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

Become a Premium Member for full access
  Unlock Premium Member

Question 287

Report Export Collapse

Which command is used to unload files from an internal or external stage to a local file system?

Become a Premium Member for full access
  Unlock Premium Member

Question 288

Report Export Collapse

Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 289

Report Export Collapse

If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

Become a Premium Member for full access
  Unlock Premium Member

Question 290

Report Export Collapse

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

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