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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 59

List of questions

Question 581

Report
Export
Collapse

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.

What should the user do?

Become a Premium Member for full access
  Unlock Premium Member

Question 582

Report
Export
Collapse

To use the overwrite option on insert, which privilege must be granted to the role?

Become a Premium Member for full access
  Unlock Premium Member

Question 583

Report
Export
Collapse

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

Become a Premium Member for full access
  Unlock Premium Member

Question 584

Report
Export
Collapse

What is the default access of a securable object until other access is granted?

Become a Premium Member for full access
  Unlock Premium Member

Question 585

Report
Export
Collapse

What happens when a suspended virtual warehouse is resized in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 586

Report
Export
Collapse

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

Become a Premium Member for full access
  Unlock Premium Member

Question 587

Report
Export
Collapse

When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY <expression> parameter option?

Become a Premium Member for full access
  Unlock Premium Member

Question 588

Report
Export
Collapse

What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 589

Report
Export
Collapse

Which views are included in the data_sharing_usage schema? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 590

Report
Export
Collapse

How does the Access_History view enhance overall data governance pertaining to read and write operations? (Select TWO).

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