SNOWPRO SAMPLE EXAM
What is the maximum duration of Time Travel allowed in the Snowflake Standard edition? 45 days, 0 days, 90 days, 1 day
1 day
Which two of the following illustrations represents the tables that have the same clustering depth. Select two. 4, 2, 1, 3
2, 3
What is the maximum duration for which the query result cache for a query can be retained? 31 days, 365 days, 24 hours, 3600 seconds
31 days
A virtual warehouse was started, used for 45 seconds, and shut down after that. The customer will be charged for how many seconds? 3600 seconds, 60 seconds, 315 seconds, 45 seconds
60 seconds
Which of the following statements best describes SnowSQL? A mobile app that can be used to connect to your Snowflake instance., A lightweight desktop application with a user interface to administer your Snowflake instance., A web-based interface to connect to your Snowflake instance., A command-line interface to connect to your Snowflake instance
A command-line interface to connect to your Snowflake instance
Which of the following correctly describes a materialized view? Select all that apply. A materialized view re-computes its results every time a query uses the materialized view., A materialized view pre-computes the results of an SQL statement., A materialized view is like a secondary index., A materialized view physically stores the results.
A materialized view pre-computes the results of an SQL statement., A materialized view physically stores the results.
In Snowflake, all data at rest is encrypted using which encryption method? AES 256-bit encryption, MD5, AES 128-bit encryption, SHA
AES 256-bit encryption
The Database Storage layer in Snowflake architecture can be on which of the following? Select all that apply. AWS S3, Google Cloud Storage, Azure Blob Storage, Hybrid Cloud, On-Premise NAS
AWS S3, Google Cloud Storage, Azure Blob Storage
Which of the following statement about MFA is correct? Select all that apply. All Snowflake editions support MFA., MFA is only available in the Business Critical edition and above., All Snowflake client tools support MFA., MFA is supported only by the Snowflake web interface.
All Snowflake editions support MFA., All Snowflake client tools support MFA.
During a weekly release cycle, which of the following accounts may be updated on the second day of release? All enterprise edition (and above) accounts that have not opted into early access, All standard edition accounts, Only those Enterprise edition accounts which have opted into early access, All business critical edition accounts
All enterprise edition (and above) accounts that have not opted into early access, All standard edition accounts
Cloning a database will clone which of the following? Select all that apply. All tables ONLY in the public schema in the database, All tables within every schema in that database, All schemas in the database, ONLY the public schema in the database, The database
All tables within every schema in that database, All schemas in the database, The database
Which of the following statements are true regarding External Tables? Select all that apply. An external table supports internal stages., An external table supports only external stages., The data for an external table is stored in cloud storage managed by the customer., An external table is another name for transient tables.
An external table supports only external stages., The data for an external table is stored in cloud storage managed by the customer.
The cloud services layer in Snowflake provides which of the following? Select all that apply. Authorization, Query Planning, Query Execution, Authentication, Query Optimisation
Authorization, Query Planning, Authentication, Query Optimisation
Which of the following correctly describes Automatic Clustering? Select all that apply. Automatic Clustering redistributes data in micro-partitions based on the clustering key., Automatic Clustering requires an active virtual warehouse to be running., Automatic Clustering can be turned off at the account level., Automatic Clustering is a serverless service.
Automatic Clustering redistributes data in micro-partitions based on the clustering key., Automatic Clustering is a serverless service.
What is the minimum Snowflake edition that supports Tri-Secret Secure encryption? Standard, Business Critical, Virtual Private Snowflake, Enterprise
Business Critical
Which of the following are the four available Snowflake editions? Select all that apply. Government, Business Critical, Standard, Virtual Private Snowflake, Enterprise, On-Premise
Business Critical, Standard, Virtual Private Snowflake, Enterprise
Which one of the following loading methods will use Virtual Warehouse resources? COPY command, Snowpipe
COPY command
In Snowflake architecture, which layer is responsible for managing data sharing? Cloud Storage Layer, Cloud Services Layer, Query Processing Layer, Data Sharing Layer, Share Management Layer
Cloud Services Layer
Which of the following layer facilitates the cloning of tables? Cloning Management Layer, Cloud Services Layer, Sharing Management Layer, Query Processing Layer
Cloud Services Layer
Dynamic Data Masking provides what sort of security in Snowflake? Row-level security, Column-level security, Object Security, Database-level security
Column-level security
When defining a clustering key which type of columns should be considered? Columns with high enough cardinality to enable efficient partition pruning, Columns with extremely high cardinality, Columns with extremely low cardinality
Columns with high enough cardinality to enable efficient partition pruning
Which of the following operations can be fulfilled without needing an active virtual warehouse? Select all that apply. Count the number of rows in a table, Find the maximum value of a numeric column, Find the total of a numeric column, Find the average of a numeric column
Count the number of rows in a table, Find the maximum value of a numeric column
Which of the following actions cannot be performed by the consumer of a shared database? Select all that apply. Create a new table in the shared database., Insert data in a shared table., View the list of tables in a shared database., Use shared data in complex queries.
Create a new table in the shared database., Insert data in a shared table.
You are required to share data from various tables in separate databases. What is the recommended approach to simplify the sharing process? Create one Share per database., Clone tables from the separate databases into a new database. Share the new database., Create secure views in a single database to consolidate the data from various databases into a new database. Share the new database., Copy all data from the various tables into new tables in a new database. Share the new database.
Create secure views in a single database to consolidate the data from various databases into a new database. Share the new database.
Cloning does not contribute towards the overall storage unless which of the following conditions are met? Data is changed in the cloned table., The cloned object is too big., The CREATE_COPY parameter is set to true while cloning data., Data is changed in the source table.
Data is changed in the cloned table., Data is changed in the source table.
Which of the following is true regarding data encryption when using PUT to upload data to a Snowflake internal stage? Select two. Snowflake's internal stages do not support encryption., Data is encrypted automatically at the client machine before being transmitted to the Snowflake internal stage., The PUT command does not support encryption., Data is stored encrypted in the Snowflake internal stage.
Data is encrypted automatically at the client machine before being transmitted to the Snowflake internal stage., Data is stored encrypted in the Snowflake internal stage.
Which of the following are the key layers in Snowflake architecture? Select all that apply. Authentication Services, Database Storage, Cloud Services, Global Services, Query Processing
Database Storage, Cloud Services, Query Processing
What are some of the ways to improve performance in Snowflake? Select all that apply Dedicated Virtual Warehouse, Multi-cluster Virtual Warehouse, Clustering Keys, Secondary Indices, Query Result Caching
Dedicated Virtual Warehouse, Multi-cluster Virtual Warehouse, Clustering Keys, Query Result Caching
The Query Processing Layer can run multiple compute clusters (virtual warehouses) simultaneously. Which statement is true regarding how the compute clusters access data? Each virtual warehouse accesses the same shared data., Each virtual warehouse gets a complete copy of all data., Each virtual warehouse gets a portion of the data.
Each virtual warehouse accesses the same shared data.
Which of the following Scaling Policy aims to preserve costs? Standard, Efficient, Economy, Fast
Economy
What is the minimum Snowflake edition that supports Column Level Masking? Standard, Enterprise, Virtual Private Snowflake, Business Critical
Enterprise
What can you expect if the filters specified in an INFORMATION_SCHEMA query are not sufficiently selective? Success, Error, Empty resultset, Warning
Error
Which of the following statements accurately describes Snowflake's encryption for data at rest? Select all that apply. Every 30 days, Snowflake rotates the keys used for encryption, Snowflake rekeys encrypted data after 1 year, Snowflake manages encryption keys by default, Snowflake uses AES - 128-bit encryption to encrypt data at rest
Every 30 days, Snowflake rotates the keys used for encryption, Snowflake rekeys encrypted data after 1 year, Snowflake manages encryption keys by default
Which of the following is an appropriate scenario for creating a Stored Procedure? Given two inputs, calculate the MAX of the two values., Execute one or more SQL statements that are assembled dynamically., Convert a character column into a numeric column
Execute one or more SQL statements that are assembled dynamically.
Which of the following statements correctly describes fail-safe in Snowflake? Select all that apply. Failsafe is the same as Time Travel., Failsafe provides up to 7 days of historical data protection for permanent tables., Failsafe provides up to 90 days of historical data protection for permanent tables., The fail-safe protection is in addition to the protection provided by Time Travel., Failsafe ensures that historical data is protected in the event of a catastrophic failure.
Failsafe provides up to 7 days of historical data protection for permanent tables., The fail-safe protection is in addition to the protection provided by Time Travel., Failsafe ensures that historical data is protected in the event of a catastrophic failure.
True or False: A reader account can consume data from sources other than the data provider that created the reader account. False, True
False
True or False: The COPY command exports to a single file by default. False, True
False
A scalar UDF will return what type of result? For each input, it will return multiple rows containing multiple columns, For each input, it will return one row containing multiple columns, For each input, it will return one row containing a single column, For each input, it will return multiple rows containing a single columns
For each input, it will return one row containing a single column
Which of the following are the types of releases that Snowflake deploys weekly? Select two answers. Full Release, Beta Release, Alpha Release, Patch Release
Full Release, Patch Release
Which of the following transformations are NOT supported by the COPY command? Select all that apply. GROUP BY, Truncate columns, SUM, JOIN
GROUP BY, SUM, JOIN
Which of the following statement is correct regarding Snowflake billing? Select all that apply. Snowflake billing is based on the number of queries executed., If a virtual warehouse is suspended, it does not contribute to the cost., Snowflake billing is based on the actual used storage., Snowflake billing is based on the amount of data processed by queries
If a virtual warehouse is suspended, it does not contribute to the cost., Snowflake billing is based on the actual used storage.
Snowflake can load data staged in which of the following? Internal Stage, Google Cloud Storage, AWS S3, Azure Blob Storage, Oracle Cloud Storage, VMWare Storage
Internal Stage, Google Cloud Storage, AWS S3, Azure Blob Storage
Which statements best describe the cloud services layer in Snowflake architecture? Select all that apply. The cloud services layer can be shut down and restarted by a Snowflake customer., It is highly available, fault-tolerant, and always-on service., Cloud services is an optional service that allows Snowflake customers to manage costs more efficiently., All access to a Snowflake account is via the cloud services layer.
It is highly available, fault-tolerant, and always-on service., All access to a Snowflake account is via the cloud services layer.
Which of the following statement is true regarding key pair authentication in Snowflake? Select all that apply. Key pair authentication is an alternative to simple username/password authentication., Key pair authentication enables single sign-on (SSO)., Key pair authentication requires the user to provide a password., Key pair authentication consists of a private key and one or two public keys.
Key pair authentication is an alternative to simple username/password authentication., Key pair authentication consists of a private key and one or two public keys.
The COPY command allows the following options for selecting files for loading data from a stage. Select all that apply. Load all files in a specific path., Load specific files by providing exact file names., Load files that match a pattern.
Load all files in a specific path., Load specific files by providing exact file names., Load files that match a pattern.
When creating a clustering key with multiple columns, in what order should the columns be specified in the CLUSTER BY clause? The order does not matter., Reverse alphabetical order., Alphabetical order., Lowest cardinality to highest cardinality., Highest cardinality to lowest cardinality.
Lowest cardinality to highest cardinality.
A virtual warehouse provides which of the following resources? Select all that apply. Memory, Shared Storage, Temporary Local Storage, CPU
Memory, Temporary Local Storage, CPU
Which one of the following objects can NOT be cloned? External Stage, Named Internal Stage, Schemas, Databases
Named Internal Stage
What is the range of latency of data in the INFORMATION_SCHEMA schema? 5 - 10 mins, No Latency, 45 mins to 3 hours, 5 - 10 days
No Latency
Which of the following occurs when a Snowflake account shares a table with another Snowflake account? Select all that apply. The target Snowflake account is charged for shared data storage., No actual data is copied or transferred between accounts., Sharing is managed through the Snowflake metadata services layer., Data is copied to the target Snowflake account.
No actual data is copied or transferred between accounts., Sharing is managed through the Snowflake metadata services layer.
Snowflake provides which of the following drivers? ODBC driver for Snowflake, .NET driver for Snowflake, Snowflake driver for the Go language, JDBC driver for Snowflake, PHP PDO driver
ODBC driver for Snowflake, .NET driver for Snowflake, Snowflake driver for the Go language, JDBC driver for Snowflake, PHP PDO driver
Which of the following statements best describe Snowflake's federated authentication? Select all that apply Once authenticated with an external identity provider, a user is not required to submit their Snowflake username & password individually., Snowflake is compatible with the majority of SAML 2.0 identity providers., Snowflake has native support for Okta and ADFS., After being authorized by an external identity source, users must enter their Snowflake username and password.
Once authenticated with an external identity provider, a user is not required to submit their Snowflake username & password individually., Snowflake is compatible with the majority of SAML 2.0 identity providers., Snowflake has native support for Okta and ADFS.
Snowflake can eliminate unneeded partitions while executing a query. What is the name given to this optimization technique? Predicate optimization, Partition pruning, WHERE clause optimization, Retrieve needed data only (RNDO)
Partition pruning
Snowpark supports which of the following languages? C++, Python, Scala, Java
Python, Scala, Java
A virtual warehouse must generally be running to process SQL queries. Which queries can generate results without the need for a running virtual warehouse? Select all that apply. Queries that produce a result set that is smaller than 100 MB., Queries like row count, minimum, and maximum for a column., Queries that only use one table., Queries that have already been run and produced a result cache.
Queries like row count, minimum, and maximum for a column., Queries that have already been run and produced a result cache.
A clustering key is added or modified for a large table. Which type of queries will likely see performance improvement? Select all that apply. Queries that select all rows in the table., Queries that sort on the columns that are part of the cluster key., Queries that filter on the columns which are part of the cluster key., Queries that select all columns in the table., Queries that group on the columns that are part of the cluster key., Queries that join on the columns which are part of the cluster key.
Queries that sort on the columns that are part of the cluster key., Queries that filter on the columns which are part of the cluster key., Queries that group on the columns that are part of the cluster key., Queries that join on the columns which are part of the cluster key.
Using Time Travel SQL, which of the following can be performed by a user? Retrieve data as it existed 365 days ago., Retrieve data as it will exist in the future., Retrieve data as it was before a timestamp., Retrieve data as it was before a query was executed.
Retrieve data as it was before a timestamp., Retrieve data as it was before a query was executed.
When cloning a table, your current role must have which privilege on the source table? WRITE, SELECT, USAGE
SELECT
How does a secure UDF differ from a different typical UDF? Secure UDFs don't allow unauthorized users to see the UDF definition., Secure UDFs can only be executed by administrators., Secure UDFs are written in machine language and are compiled into Snowflake's code., Secure UDF does not use specific SQL optimizations.
Secure UDFs don't allow unauthorized users to see the UDF definition., Secure UDF does not use specific SQL optimizations.
You have written an SQL statement in the worksheet view. You must share the SQL statement with another user in your Snowflake account. Which would be the simplest way to share the SQL statement? Create a view that contains the SQL statement. Let the other users know about the view name and location., Save the SQL statement to an internal stage and let the other user load the statement from the internal stage., Copy the SQL statement and email it to the other user., Share the worksheet containing the SQL with the other user.
Share the worksheet containing the SQL with the other user.
A stored procedure can return which type of results? Exe files, Single Value, Tabular Data, Binary Executables
Single Value, Tabular Data
Which of the following tool is used for connectivity diagnostics? SnowSQL, Snowsight, Snowpipe, SnowCD
SnowCD
Multi-factor authentication can be enabled for which of the following? Select all that apply. SnowSQL, JDBC, Snowpipe, Snowflake WebUI
SnowSQL, JDBC, Snowflake WebUI
Which of the following best describes Snowflake scripting? Snowflake Scripting is used to create client-side code that runs in web browsers., Snowflake Scripting adds parallel execution capability to the existing Snowflake SQL execution engine., Snowflake Scripting is a flavor of ActionScript code and can be used to create mobile apps., Snowflake Scripting is an extension to SQL that allows you to use procedural logic similar to that found in programming languages.
Snowflake Scripting is an extension to SQL that allows you to use procedural logic similar to that found in programming languages.
Which of the following statements about Snowflake's data clustering are correct? Snowflake clusters data in a table automatically., If necessary, clustering keys can be defined to recluster or reorganize the data., Snowflake does not cluster table data automatically., The data in a Snowflake table cannot be reclustered.
Snowflake clusters data in a table automatically., If necessary, clustering keys can be defined to recluster or reorganize the data.
Which of the following statements best describe Snowpark? Select all that apply. Snowpark does not rely on the Snowflake SQL execution engine., Snowpark automatically converts the data-processing programming constructs to SQL and pushes them down to Snowflake for execution., Snowflake provides APIS that allows programmers to access the internals of the Snowflake cloud services layer., Snowpark is a library created by Snowflake that provides APIs for accessing and processing data in applications written in a programming language other than SQL.
Snowpark automatically converts the data-processing programming constructs to SQL and pushes them down to Snowflake for execution., Snowpark is a library created by Snowflake that provides APIs for accessing and processing data in applications written in a programming language other than SQL.
Which of the following correctly describe Snowpipe? Snowpipe is a security mechanism providing a secure pipe for communication., Snowpipe is used for backup and recovery., Snowpipe is used to load a small volume of data that arrives frequently and continuously., Snowpipe is used to load large volumes of data in a batch manner.
Snowpipe is used to load a small volume of data that arrives frequently and continuously.
Which of the following statements are true for Snowpipe? Select all that apply. Snowpipe uses serverless compute resources managed by Snowflake., Snowpipe makes use of the active virtual warehouse for compute resources., You must scale a virtual warehouse yourself to manage the compute available to Snowpipe., The resource for Snowpipe are automatically scaled up and down by Snowflake.
Snowpipe uses serverless compute resources managed by Snowflake., The resource for Snowpipe are automatically scaled up and down by Snowflake.
What is the minimum Snowflake edition required to create User Defined Functions (UDFs) in Java? Standard, Virtual Private Snowflake, Business Critical, Enterprise
Standard
Which of the following are Snowflake Data Integration partners? Select all that apply. Talend, AbInitio, IBM DataStage, Matillion, Informatica
Talend, AbInitio, IBM DataStage, Matillion, Informatica
Which of the following table types are not protected by fail-safe storage? Select all that apply. Temporary, Transient, Permanent, Clustered
Temporary, Transient
A data consumer has created a read-only database on a Share object shared by a data provider. The data provider adds an object to the Share. Which of the following statement correctly describe what happens? The data consumer can see and consume the new object immediately., Adding objects to a Share is impossible after a consumer creates a read-only database., The data consumer needs to run "ALTER SHARE <share_name> REFRESH" to ensure that the added object appears in the read-only database.
The data consumer can see and consume the new object immediately.
You are unloading data from a multi-gigabyte table to an external stage; which of the following statements regarding the exported file(s) are correct? Select all that apply. The exported file(s) are compressed., The exported file(s) are NOT compressed., Each exported file is 16MB in size., The data is exported to multiple files., The data is exported to a single large file.
The exported file(s) are compressed., Each exported file is 16MB in size., The data is exported to multiple files.
Which of the following statement is true regarding the Query Processing Layer? The query processing layer is responsible for executing queries., The query processing layer is responsible for optimizing query plans, The query processing layer can run multiple compute clusters (virtual warehouses) simultaneously., The query processing layer is responsible for generating query plans.
The query processing layer is responsible for executing queries., The query processing layer can run multiple compute clusters (virtual warehouses) simultaneously.
Under which circumstances will the query result cache fulfill the query result? Select all that apply The query returns a result set of fewer than 100 thousand rows., The query results cache was generated or used less than 24 hours ago., The role executing the query matches the role that generated the previous results., The micro-partitions for the tables in the query have not changed., The query is being executed from the same virtual warehouse as the previously executed query.
The query results cache was generated or used less than 24 hours ago., The role executing the query matches the role that generated the previous results., The micro-partitions for the tables in the query have not changed.
Which of the following statements correctly describe Search Optimization in Snowflake? Select all that apply. The search optimization service doesn't use a persistent data structure., The search optimization configuration on a table and its maintenance service are transparent to the users., The search optimization service uses a persistent data structure
The search optimization configuration on a table and its maintenance service are transparent to the users., The search optimization service uses a persistent data structure
A stored procedure has been set up as a stored procedure with owner's rights. A system administrator runs the stored procedure. Which of the following statement correctly describes how the stored procedure will execute? The stored procedure executes with ACCOUNTADMIN role permissions., The stored procedure executes using the privileges of the users executing the stored procedure., The stored procedure executes with SYSADMIN role permissions., The stored procedure executes using the privileges of the role owning the stored procedure.
The stored procedure executes using the privileges of the role owning the stored procedure.
Which of the following can be tracked and managed by a resource monitor? A single Snowpipe, The whole account, A group of virtual warehouses, A single virtual warehouse
The whole account, A group of virtual warehouses, A single virtual warehouse
For which one of the following scenarios, Scaling Out a virtual warehouse, is a good option? There is an increase in query complexity., The query uses a materialized view., There are more active concurrent queries than the current virtual warehouse can handle., A query is accessing more than 5 tables.
There are more active concurrent queries than the current virtual warehouse can handle.
True or False. The variant data type can hold up to 16MB of data per row. True, False
True
True or False: Files already loaded from a stage to a table can be loaded again into a cloned table. False, True
True
True or False: Only Snowflake staff can access data in fail-safe storage. True, False
True
True or False: The COPY command can load data using a SELECT query. True, False
True
True or False: When a file has been loaded into a table, Snowflake marks that file as loaded in the metadata so that the file does not get processed again. True, False
True
True/False: Snowflake automatically determines the most efficient algorithm to compress columns in a micro-partition.
True
True/False: Snowflake automatically determines the most efficient algorithm to compress columns in a micro-partition. False, True
True
True/False: Snowflake automatically determines the most efficient algorithm to compress columns in micro-partition. True, False
True
You are required to see the query history for a date seven months ago. Which of the following methods will provide you with the query history for seven months ago? Use the QUERY_HISTORY view in the ACCOUNT_USAGE schema, Use the QUERY_HISTORY table function in the INFORMATION schema, View the historical queries using the query history page, Request Snowflake support to provide query history
Use the QUERY_HISTORY view in the ACCOUNT_USAGE schema
As the security administrator for your organization's Snowflake instance, you are required to continuously track a list of all users who logged into the system in the last 60 minutes. Which one of the following methods can you use? Query the view SNOWFLAKE.ACCOUNT_USAGE.LOGIN_HISTORY, Ask Snowflake support to provide these details., Use the table function INFORMATION_SCHEMA.LOGIN_HISTORY (), Use the table function INFORMATION_SCHEMA.LOGIN_HISTORY_BY_USER()
Use the table function INFORMATION_SCHEMA.LOGIN_HISTORY ()
You can upload data into which of the following stages using the PUT command? Select all that apply. User Stage, Table Stage, External Stage, Named Internal Stage
User Stage, Table Stage, Named Internal Stage
Which of the following Snowflake edition doesn't support Snowflake Marketplace? Standard, Enterprise, Business Critical, VPS or Virtual Private Snowflake
VPS or Virtual Private Snowflake
Which of the following are ways to see a history of the queries executed on a Snowflake account? View the historical queries using the query history page, Request Snowflake support to provide query history, Use the QUERY_HISTORY table function in the INFORMATION schema, Use the QUERY_HISTORY view in the ACCOUNT_USAGE schema
View the historical queries using the query history page, Use the QUERY_HISTORY table function in the INFORMATION schema, Use the QUERY_HISTORY view in the ACCOUNT_USAGE schema
What is the minimum Snowflake edition that supports a dedicated metadata store? Standard, Enterprise, Business Critical, Virtual Private Snowflake
Virtual Private Snowflake
Which of the following Snowflake editions support database failover and failback between Snowflake accounts, thus providing business continuity and disaster recovery? Select all that apply. Virtual Private Snowflake, Enterprise, Standard, Business Critical
Virtual Private Snowflake, Business Critical
How frequently does Snowflake release new software? Yearly, Daily, Weekly, Monthly, Fortnightly
Weekly
Can files already processed into the source table be loaded again into a cloned table? Yes, No
Yes
Is it possible to share data with a Snowflake customer whose Snowflake instance exists in a different cloud platform than the data provider? Yes. Nothing special needs to be done to enable cross-cloud platform data sharing., No, sharing with customers in other cloud platforms is not possible., Yes, but to enable data sharing to a different cloud platform, you must enable replication first.
Yes, but to enable data sharing to a different cloud platform, you must enable replication first.
Which of the following statements regarding Zero-Copy cloning are true? Select all that apply. You can clone tables, schemas, and even databases., Only tables can be cloned, Zero-copy cloning is a metadata process., Zero-copy cloning involves the physical copying of data
You can clone tables, schemas, and even databases., Zero-copy cloning is a metadata process.
What is the minimum Snowflake edition required to browse Snowflake Marketplace? Business Critical, Virtual Private Snowflake, Standard, Enterprise, You don't need a Snowflake edition to browse the Snowflake marketplace listings
You don't need a Snowflake edition to browse the Snowflake marketplace listings
You execute a time travel query on a table but get the following error. "Time travel data is not available for the table. The requested time is either beyond the allowed time travel period or before the object creation time." What could this error indicate? Select all that apply. You have provided a value for OFFSET in the AT clause that is outside of the Time Travel retention period of that table., You have provided a query id for STATEMENT in the BEFORE clause that is outside of that table's Time Travel retention period., The table is being loaded; therefore, Time Travel is unavailable., You have provided a value for TIMESTAMP in the BEFORE clause that is outside of that table's Time Travel retention period., Your role is not authorized to use Time Travel.
You have provided a value for OFFSET in the AT clause that is outside of the Time Travel retention period of that table., You have provided a query id for STATEMENT in the BEFORE clause that is outside of that table's Time Travel retention period., You have provided a value for TIMESTAMP in the BEFORE clause that is outside of that table's Time Travel retention period.