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

Snowflake SnowPro Core Practice Test - Questions Answers, Page 43

List of questions

Question 421

Report Export Collapse

When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?

Become a Premium Member for full access
  Unlock Premium Member

Question 422

Report Export Collapse

When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

Become a Premium Member for full access
  Unlock Premium Member

Question 423

Report Export Collapse

What factors impact storage costs in Snowflake? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 424

Report Export Collapse

Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

Become a Premium Member for full access
  Unlock Premium Member

Question 425

Report Export Collapse

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 426

Report Export Collapse

How can a Snowflake user validate data that is unloaded using the COPY INTO <location> command?

Become a Premium Member for full access
  Unlock Premium Member

Question 427

Report Export Collapse

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Become a Premium Member for full access
  Unlock Premium Member

Question 428

Report Export Collapse

Which task is supported by the use of Access History in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 429

Report Export Collapse

Which feature of Snowflake's Continuous Data Protection (CDP) has associated costs?

Become a Premium Member for full access
  Unlock Premium Member

Question 430

Report Export Collapse

What command is used to export or unload data from Snowflake?

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