Snow14

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table. How can this be accomplished?

• • Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

• • The transient table version cannot be retrieved after 24 hours.

• • Contact Snowflake Support to have the data retrieved from Fail-safe storage.

• • Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

What is a key benefit of using organizations in Snowflake?

• Ability to use ACCOUNT_USAGE views

• Ability to use zero-copy cloning across accounts

• Ability to consolidate account management and billing

• Ability to access new releases for testing and validation purposes

When a database is cloned, which objects in the clone inherit all granted privileges from the source object? (Choose two.)

• Account

• Database

• Schemas

• Tables

• Internal named stages

What is the purpose of enabling Federated Authentication on a Snowflake account?"

• Disables the ability to use key pair and basic authentication (e.g., username/password) when connecting

• Allows dual Multi-Factor Authentication (MFA) when connecting to Snowflake

• Forces users to connect through a secure network proxy

• Allows users to connect using secure single sign-on (SSO) through an external identity provider

What is the maximum length of time travel available in the Snowflake Standard Edition?

• 1 Day

• 7 Days

• 30 Days

• 90 Days

What is the recommended compressed file size range for continuous data loads using Snowpipe?

• 8-16 MB

• 16-24 MB

• 10-99 MB

• 100-250 MB

What is a core benefit of clustering?

• • To guarantee uniquely identifiable records in the database

• • To increase scan efficiency in queries by improving pruning

• • To improve performance by creating a separate file for point lookups

• • To provide data redundancy by duplicating micro-partitions

Which of the following statements about data sharing are true? (Choose two.)

• New objects created by a Data Provider are automatically shared with existing Data Consumers and Reader Accounts.

• All database objects can be included in a shared database.

• Reader Accounts are created by Data Providers.

• Shared databases are read-only.

• Reader Accounts are charged for warehouse usage.

Which of the following statements describe features of Snowflake data caching? (Choose two.)

• • When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

• • When the data cache is full, the least-recently used data will be cleared to make room.

• • A user can only access their own queries from the query result cache.

• • A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

• • The RESULT_SCAN table function can access and filter the contents of the query result cache.

What is the purpose of a directory table in Snowflake?

• To store actual data from external stages.

• To automatically expire file URLs for security.

• To manage user privileges and access control.

• To store file-level metadata about data files in a stage.