Exam (elaborations)
SnowPro Core Exam Practice Questions Part 3; Questions and Answers 100% Pass
- Course
- Institution
SnowPro Core Exam Practice Questions Part 3; Questions and Answers 100% Pass
[Show more]
Content preview
SnowPro Core Exam Practice Questions Part 3;Questions and Answers 100% Pass
What is a SF virtual warehouse? Correct Ans-Virtual warehouse is the name given to the
compute clusters used by SF for query processing.
Which options can be used to bring semi structured data into SF? Correct Ans-Load semi
structured data into a VARIANT column; Transform the data while using the COPY command
T/F - A Small virtual warehouse (2 servers) executing for 2 hours will consume the same
number of credits as a Medium virtual warehouse (4 servers) executing for 1 hour Correct
Ans-True - with a larger size the credit consumption is more
In the SF staged release process for new releases, which account types are applied updates
ahead of everyone else? Correct Ans-Designated accounts opting for early access
The reader account belongs to: Correct Ans-The producer - created by, owned by, uses the
compute resources of the producer
T/F - In a VARIANT column, the NULL values are stored as a literal string "null" Correct Ans-
True
, SnowPro Core Exam Practice Questions Part 3;
Questions and Answers 100% Pass
Under the Download section in Snowflake Web UI, what are the connectors & programs that
can be downloaded? Correct Ans-Spark Connector, Python Components, Node.js driver;
not Redshift connector or Unload connector
Y/N - SF stores data for each table in a proprietary columnar format Correct Ans-Yes
On the WebUI, which button on the top bar should you select to run queries? Correct Ans-
Worksheets
To see existing virtual warehouses, what is the correct command? Correct Ans-SHOW
WAREHOUSES;
You are creating a new virtual warehouse that you want to auto suspend if no query has been
run in last 10 minutes. What is the correct syntax for creating such a virtual warehouse?
Correct Ans-CREATE OR REPLACE WAREHOUSE brand_new_warehouse
WAREHOUSE_SIZE=large AUTO_SUSPEND=600;
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 TheeGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. 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