Exam (elaborations)
SnowPro Certification Study Guide ; Questions & Answers
- Course
- Institution
SnowPro Certification Study Guide ; Questions & Answers
[Show more]
Content preview
SnowPro Certification Study Guide ; Questions &Answers
What is the best way to store semi-structured data? Correct Ans-Data should be loaded
and stored in a VARIANT type column
What is the best practice for handling semi-structured data with 3rd party BI tools? Correct
Ans-Create a Snowflake view that parse the semi-structured column into structure columns
for the BI tool to retrieve
True or False: Micro-partitions are immutable? Correct Ans-True - subsequent changes of
any type to the data will be written to additional micro-partitions
A Snowflake mechanism that is used to limit the number of micro-partitions scanned by a
query is called ________? Correct Ans-Pruning
What command is used to load files into an Internal Stage within Snowflake?
A. PUT
B. COPY INTO
C. TRANSFER
D. INSERT Correct Ans-A. PUT
, SnowPro Certification Study Guide ; Questions &
Answers
When loading data into Snowflake, the COPY command supports:
Choose 2 answers
A. Joins
B. Fitters
C. Data type conversions
D. Column reordering
E. Aggregates Correct Ans-C. Data Type Conversion & D. Column Reordering
True or False: Snowpipe via RFST API can only reference External Stages as source. Correct
Ans-A. True
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers
A. Amazon Web Services
B. Private Virtual Cloud
C. Oracle Cloud
, SnowPro Certification Study Guide ; Questions &
Answers
D. Microsoft Azure Cloud Correct Ans-A. Amazon Web Services & D. Microsoft Azure Cloud
How would you execute a series of SQL statements using Task?
A. include the SQL statements in the body of the task create task mytask.. as insert into
target1 select., from stream_s1 where ..INSERT INTO target2 SELECT .. FROM stream .s1
where ..
B. A stored procedure can have only one DML statement per stored procedure invocation and
therefore you should sequence stored procedures calls in the task definition CREATE TASK
mytask.... AS call stored_prc1(); call stored_proc2t);
C. A stored procedure executing multiple SQL statements and invoke the stored procedure
from the task. CREATE TASK mytask.... AS callstored_proc_multiple_statements_inside():
D. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the
series of SQL statements by having a control taskcalling task 1, task 2 sequentially. Correct
Ans-C
True or False: Snowflake charges a premium for storing semi-structured data. Correct Ans-
False
, SnowPro Certification Study Guide ; Questions &
Answers
What are the three things customers want most from their enterprise data warehouse
solution?
Choose 3 answers
A. On-premise availability
B. Simplicity
C. Open source based
D. Concurrency
E. Performance Correct Ans-B, D, E
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
A. A multi-cluster Warehouse can add clusters automatically based on query activity
B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
C. A multi-cluster Warehouse can scale down when query activity slows
D. A multi-cluster Warehouse can automatically turn itself on when a query is executed
against it Correct Ans-A, B, C, D
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 $30.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