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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 36

List of questions

Question 351

Report Export Collapse

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

Become a Premium Member for full access
  Unlock Premium Member

Question 352

Report Export Collapse

Which metadata table will store the storage utilization information even for dropped tables?

Become a Premium Member for full access
  Unlock Premium Member

Question 353

Report Export Collapse

What does a masking policy consist of in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 354

Report Export Collapse

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Become a Premium Member for full access
  Unlock Premium Member

Question 355

Report Export Collapse

A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.

How can this be achieved?

Become a Premium Member for full access
  Unlock Premium Member

Question 356

Report Export Collapse

What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

Become a Premium Member for full access
  Unlock Premium Member

Question 357

Report Export Collapse

Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 358

Report Export Collapse

Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

Become a Premium Member for full access
  Unlock Premium Member

Question 359

Report Export Collapse

At what levels can a resource monitor be configured? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 360

Report Export Collapse

How do Snowflake data providers share data that resides in different databases?

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