1 of 230
Term
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?
Give this one a try later!
, - The data is exported to multiple files.
- The exported file(s) are compressed.
- Each exported file is 16MB in size.
- You have provided a value for OFFSET in the AT clause that is outside of
the time travel retention period of the table
- You have provided a query id for STATEMENT in the BEFORE clause that
is outside of that tables time travel retention period
- You have provided a value for TIMESTAMP in the BEFORE clause that is
outside of that tables time travel retention period
Contact the Snowflake support team to facilitate the retrieval of this data
- Create an external stage on top of the S3 bucket where the near real time data
lands
- Configure notification event on the S3 bucket which triggers the Snowpipe
- Create a snowpipe that loads data from an external stage
Don't know?
2 of 230
Term
What are some general indicators that a clustering key is required on
a table?
Give this one a try later!
, - Load all files in a specific path
- Load specific files by providing exact file names
- Load files that match a pattern
- The query performance has slowed down over time
- The size of the table is multi-terabytes
- Large clustering depth
- 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
- AWS Lambda Function
- Node.js running on an EC2 instance
- Microsoft Azure Function
Don't know?
3 of 230
Term
Which of the following roles can import a dataset from Snowflake
Marketplace?
Give this one a try later!
Cluster Admin Compliance Viewer
, Storage Admin Account Admin
Don't know?
4 of 230
Term
You have shared a table with another Snowflake account. A user in
the consumer account has executed a query on the shared table.
Who will be charged for the query cost?
Give this one a try later!
Transient
The data consumer
Query the view SNOWFLAKE.ACCOUNT_USAGE.LOGIN_HISTORY
- an external table can be joined with other tables.
- you can query an external table just like a regular table.
- the data for a external table is stored in cloud storage managed by the
customer
- an external table supports only external stages
Don't know?
Term
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?
Give this one a try later!
, - The data is exported to multiple files.
- The exported file(s) are compressed.
- Each exported file is 16MB in size.
- You have provided a value for OFFSET in the AT clause that is outside of
the time travel retention period of the table
- You have provided a query id for STATEMENT in the BEFORE clause that
is outside of that tables time travel retention period
- You have provided a value for TIMESTAMP in the BEFORE clause that is
outside of that tables time travel retention period
Contact the Snowflake support team to facilitate the retrieval of this data
- Create an external stage on top of the S3 bucket where the near real time data
lands
- Configure notification event on the S3 bucket which triggers the Snowpipe
- Create a snowpipe that loads data from an external stage
Don't know?
2 of 230
Term
What are some general indicators that a clustering key is required on
a table?
Give this one a try later!
, - Load all files in a specific path
- Load specific files by providing exact file names
- Load files that match a pattern
- The query performance has slowed down over time
- The size of the table is multi-terabytes
- Large clustering depth
- 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
- AWS Lambda Function
- Node.js running on an EC2 instance
- Microsoft Azure Function
Don't know?
3 of 230
Term
Which of the following roles can import a dataset from Snowflake
Marketplace?
Give this one a try later!
Cluster Admin Compliance Viewer
, Storage Admin Account Admin
Don't know?
4 of 230
Term
You have shared a table with another Snowflake account. A user in
the consumer account has executed a query on the shared table.
Who will be charged for the query cost?
Give this one a try later!
Transient
The data consumer
Query the view SNOWFLAKE.ACCOUNT_USAGE.LOGIN_HISTORY
- an external table can be joined with other tables.
- you can query an external table just like a regular table.
- the data for a external table is stored in cloud storage managed by the
customer
- an external table supports only external stages
Don't know?
