100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
SnowPro Core Exam Practice Questions Part 2 Questions and Answers 100% Correct $12.49   Add to cart

Exam (elaborations)

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...

[Show more]

Preview 2 out of 9  pages

  • August 22, 2024
  • 9
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • SnowPro Core
  • SnowPro Core
avatar-seller
NursingTutor1
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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

79271 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$12.49
  • (0)
  Add to cart