Exam (elaborations)
Snowpro Core Certification Questions with 100% Correct Answers
- Course
- Institution
Snowpro Core Certification Questions with 100% Correct Answers
[Show more]
Content preview
1 of 100Definition
Why would a materialized view be used? Select all that apply.
a. Materialized views can be created on top of external tables to
improve their query performance.
b. Materialized views are cheaper than storing data in a table.
c. Materialized views make complex queries that are commonly
executed readily available.
d. Materialized views store data temporarily during the data loading
process
Give this one a try later!
, a. Materialized views can be created on top of external tables to improve
their query performance.
c. Materialized views make complex queries that are commonly executed
readily available.
c. STARTED
d. A Virtual warehouse is a named abstraction for one or more compute nodes.
a. The new query exactly matches the cached query.
c. The role executing the query must have the necessary access privileges for all
the tables used in the cached query when executing a SELECT.
Don't know?
2 of 100
Definition
Which layers are in Snowflake's Multi-cluster Shared Data
Architecture? Choose two correct values.
[] Unloading Layer
[] ETL Layer
[] Storage Layer
[] Metadata Layer
[] Compute / Query Processing Layer
Give this one a try later!
, [X] Storage Layer
[X] ls @MY_STAGE;
[X] Compute / Query
[X] LIST @MY_STAGE;
Processing Layer
[X] Internal stages.
[x] Table.
[X] Materialized views.
[x] Stream.
[X] Database tables including time
[x] Stored Procedure.
travel & fail-safe.
Don't know?
3 of 100
Definition
If the query profile indicates queries are regularly spilling to remote
storage what are the recommended solutions? Select all that apply.
[] Process data in smaller batches.
[] Process data in larger batches.
[] Increase the size of the Virtual Warehouse.
[] Decrease the size of the Virtual Warehouse.
Give this one a try later!
[X] SELECT COUNT(*) FROM EMPLOYEE;
[X] DESCRIBE TABLE EMPLOYEE;
[X] Internal stages.
[X] Materialized views.
[X] Database tables including time travel & fail-safe.
, b. SELECT NAME, ADDRESS FROM EMPLOYEES WHERE EMP_EMAIL =
'support.help@corp.com';
d. SELECT NAME, ADDRESS FROM EMPLOYEES WHERE EMP_ID IN
('12867','0987SS');
[X] Process data in smaller batches.
[X] Increase the size of the Virtual Warehouse.
Don't know?
4 of 100
Definition
When setting DATA_RETENTION_TIME_IN_DAYS to 0 on a table, Time
Travel is effectively disabled for that table. True or false?
Give this one a try later!
True False
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)
81531 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now