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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 25

Add to Whishlist

List of questions

Question 241

Report Export Collapse

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

Become a Premium Member for full access
  Unlock Premium Member

Question 242

Report Export Collapse

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

Become a Premium Member for full access
  Unlock Premium Member

Question 243

Report Export Collapse

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Become a Premium Member for full access
  Unlock Premium Member

Question 244

Report Export Collapse

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

Become a Premium Member for full access
  Unlock Premium Member

Question 245

Report Export Collapse

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Become a Premium Member for full access
  Unlock Premium Member

Question 246

Report Export Collapse

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

Become a Premium Member for full access
  Unlock Premium Member

Question 247

Report Export Collapse

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Become a Premium Member for full access
  Unlock Premium Member

Question 248

Report Export Collapse

A materialized view should be created when which of the following occurs? (Choose two.)

Become a Premium Member for full access
  Unlock Premium Member

Question 249

Report Export Collapse

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Become a Premium Member for full access
  Unlock Premium Member

Question 250

Report Export Collapse

Which feature allows a user the ability to control the organization of data in a micro-partition?

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