Exam (elaborations)
Udemy Snowpro Core Certification Combined Questions with 100% Correct Answers
- Course
- Institution
Udemy Snowpro Core Certification Combined Questions with 100% Correct Answers
[Show more]
Content preview
1 of 230Term
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?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller codersimon. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
74735 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now