SnowPro Core Exam Practice Questions Part 2 Questions and Answers 100% Correct
7 views 0 purchase
Course
SnowPro Core
Institution
SnowPro Core
SnowPro Core Exam Practice Questions Part 2 Questions and Answers 100% CorrectSnowPro Core Exam Practice Questions Part 2 Questions and Answers 100% CorrectSnowPro Core Exam Practice Questions Part 2 Questions and Answers 100% CorrectSnowPro Core Exam Practice Questions Part 2 Questions and Answers...
SnowPro Core Exam Practice Questions
Part 2 Questions and Answers 100%
Correct
Which of the following actions cannot be performed by the consumer of a shared database? -
ANSWER - 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? - ANSWER - 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 - ANSWER - SF uses its own proprietary
columnar format to store table data
SF patch releases are applied to all accounts at the same time - ANSWER - 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? - ANSWER - 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? - ANSWER - 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
, Which of the following are characteristics of SF releases? No downtime, transparent to user,
allow user to choose whether to upgrade or not, require restart - ANSWER - No downtime,
transparent to user
Which type of short lived SF tables will continue to exist even if the session is closed? -
ANSWER - Transient - can be used as short lived tables for ETL work tables and are not
dropped when the session is closed
You are the SF Administrator for a large telecom company. You had a Medium sized virtual
warehouse on which a complex query was executing, you change the virtual warehouse size to
be Small. Will the query be impacted and perform slower? - ANSWER - No. The currently
executing query will keep on executing on the original cluster. Only new queries will execute on
the Small cluster
T/F - There is a cost associated with maintaining the partitions associated with the clustering
keys - ANSWER - 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? -
ANSWER - SHOW PIPES LIKE '%TXN%';
In the SF staged release process for new releases, which account types are applied updates
the last? - ANSWER - Enterprise & higher accounts
In a multi cluster virtual warehouse, if you set different values for minimum cluster count and
maximum cluster count: - ANSWER - 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? - ANSWER - Clustering keys
Using the COPY command you can load data from which of the following sources? - ANSWER -
Google Cloud Storage, Internal Stages, Azure Blob Storage, AWS S3 - not IBM Cloud or Oracle
Cloud
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 NursingTutor1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.