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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 14

Add to Whishlist

List of questions

Question 131

Report Export Collapse

When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Become a Premium Member for full access
  Unlock Premium Member

Question 132

Report Export Collapse

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 133

Report Export Collapse

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Become a Premium Member for full access
  Unlock Premium Member

Question 134

Report Export Collapse

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

Become a Premium Member for full access
  Unlock Premium Member

Question 135

Report Export Collapse

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Become a Premium Member for full access
  Unlock Premium Member

Question 136

Report Export Collapse

How long is the Fail-safe period for temporary and transient tables?

Become a Premium Member for full access
  Unlock Premium Member

Question 137

Report Export Collapse

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Become a Premium Member for full access
  Unlock Premium Member

Question 138

Report Export Collapse

How does Snowflake Fail-safe protect data in a permanent table?

Become a Premium Member for full access
  Unlock Premium Member

Question 139

Report Export Collapse

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

Snowflake SnowPro Core image Question 139 74500 09232024004504000000

What action should be taken to address this situation?

Become a Premium Member for full access
  Unlock Premium Member

Question 140

Report Export Collapse

Which minimum Snowflake edition allows for a dedicated metadata store?

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