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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 50

List of questions

Question 491

Report Export Collapse

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 492

Report Export Collapse

How does Snowflake describe its unique architecture?

Become a Premium Member for full access
  Unlock Premium Member

Question 493

Report Export Collapse

What information does the Query Profile provide?

Become a Premium Member for full access
  Unlock Premium Member

Question 494

Report Export Collapse

By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

Become a Premium Member for full access
  Unlock Premium Member

Question 495

Report Export Collapse

Which role has the ability to create a share from a shared database by default?

Become a Premium Member for full access
  Unlock Premium Member

Question 496

Report Export Collapse

Why would a Snowflake user decide to use a materialized view instead of a regular view?

Become a Premium Member for full access
  Unlock Premium Member

Question 497

Report Export Collapse

Which command can be used to list all the file formats for which a user has access privileges?

Become a Premium Member for full access
  Unlock Premium Member

Question 498

Report Export Collapse

Which common query problems are identified by the Query Profile? (Select TWO.)

Become a Premium Member for full access
  Unlock Premium Member

Question 499

Report Export Collapse

By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

Become a Premium Member for full access
  Unlock Premium Member

Question 500

Report Export Collapse

If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

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