Exam (elaborations)
SnowPro Core Exam Practice Questions Part 2 – Questions With Solutions
- Course
- Institution
SnowPro Core Exam Practice Questions Part 2 – Questions With Solutions
[Show more]
Seller
Follow
LeCrae
Reviews received
Content preview
SnowPro Core Exam Practice Questions Part 2 –Questions With Solutions
Which of the following actions cannot be performed by the consumer of a
shared database? ✔️Ans - Create a new table in a shared database, insert
data in a shared table
Which function is used to find the query id of the last executed query?
✔️Ans - SELECT last_query_id()
Which of the following is true regarding how SF stores its data?
1. SF stores table data as simple comma separated files in cloud based storage
2. SF uses its own proprietary columnar format to store table data
3. SF uses parquet file format to store the table data ✔️Ans - SF uses its
own proprietary columnar format to store table data
SF patch releases are applied to all accounts at the same time ✔️Ans - True
- patch releases are applied to all accounts at the same time; the staged
released process is only used for new software releases
You increased the size of a virtual warehouse to improve performance of a
query. What is this an example of? ✔️Ans - Scale Up - Increasing the size of
a virtual warehouse will enable faster processing for queries but will not
necessarily accommodate more queries and more users
What is the SF recommended approach to identifying the minimum and
maximum values for a multi cluster virtual warehouse? ✔️Ans - 1. Track
the virtual warehouse usage over time and adjust the minimum and maximum
values that provide the best configuration for your workload
2. Start with a minimum of 1 & a maximum cluster value of 2 or 3
3. Start with the multi cluster virtual warehouse in auto scale mode
T/F - There is a cost associated with maintaining the partitions associated
with the clustering keys ✔️Ans - True - SF credits are used to organize the
data into correct partitions as it is added to the table
, What is the correct command to see all pipes which have the text TXN in their
name? ✔️Ans - SHOW PIPES LIKE '%TXN%';
In the SF staged release process for new releases, which account types are
applied updates the last? ✔️Ans - Enterprise & higher accounts
In a multi cluster virtual warehouse, if you set different values for minimum
cluster count and maximum cluster count: ✔️Ans - SF starts minimum
required clusters in the multi cluster virtual warehouse; the most is called
auto scale
What is one of the ways to improve performance in SF? ✔️Ans - Clustering
keys
Using the COPY command you can load data from which of the following
sources? ✔️Ans - Google Cloud Storage, Internal Stages, Azure Blob Storage,
AWS S3 - not IBM Cloud or Oracle Cloud
When a virtual warehouse is resized to a smaller size, the required servers are
only removed when? ✔️Ans - There are no SQL statements running on the
servers
Cloning a database will clone: ✔️Ans - All tables within every schema in
that database, all schemas in the database, the database itself
How are the columns stored in a SF micro partition (also referred to as
Columnar storage) ✔️Ans - Independently - each column is stored on its
own so they can be scanned more efficiently
Which of the following properties can be set for a multi cluster virtual
warehouse? ✔️Ans - MAX_CLUSTER_COUNT, AUTO_SUSPEND,
MIN_CLUSTER_COUNT, AUTO_RESUME
When a database or schema is cloned: ✔️Ans - External named stages are
cloned, named internal stages are NOT cloned, table internal stages are cloned
You are designing a SF based solution for a large retail chain. What should you
consider for ensuring performance once the SF based data warehouse goes
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 LeCrae. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now