Exam (elaborations)
Udemy Snowpro Core Certification - Practice Questions Test 1 with Detailed Solutions
- Course
- Institution
Udemy Snowpro Core Certification - Practice Questions Test 1 with Detailed Solutions
[Show more]
Content preview
Udemy Snowpro Core Certification - Practice QuestionsTest 1 with Detailed Solutions
When defining a clustering key for a large table, consider using columns frequently used in
WHERE clauses. Correct Ans-True
Which query profile results indicate that a large table may not be well clustered? Correct
Ans-- The value in the 'Partitions Total' qual 'Partitions Scanned'
- A significant value for 'Partitions Scanned'
Snowflake can eliminate unneeded partitions while executing a query. What is the name
given to this optimization technique?
Retrieve needed data only (RNDO)
Predicate optimization
WHERE clause optimization
Partition pruning
(Correct) Correct Ans-Partition Pruning
A stored procedure can return which type of results? Correct Ans-- Single Value
- Tabular Data
, Udemy Snowpro Core Certification - Practice Questions
Test 1 with Detailed Solutions
What type of virtual warehouse automatically lets you add or remove additional clusters as
concurrency and demand change? Correct Ans-Multi-cluster virtual warehouse
Files already loaded from a stage to a table can be loaded again into a cloned table.
Correct Ans-True
Which of the following operations can be performed on a cloned table? Correct Ans-DROP,
SELECT, DELETE, CLONE
A cloned table is just like any other table
Which one of the following is supported by Snowflake for the purpose of auto-provisioning
users and group membership? Correct Ans-SCIM
- SCIM is an open standard that provides automatic user provisioning and role synchronization
based on identity provider information
, Udemy Snowpro Core Certification - Practice Questions
Test 1 with Detailed Solutions
Which of the following could be used as a remote service for an external function? Correct
Ans-- AWS Lambda Function
- Node.js running on an EC2 instance
- Microsoft Azure Function
True or False. To create Snowflake instances in different regions, you must maintain a separate
Snowflake account for each region. Correct Ans-True
True or False: When unloading data, each exported file is 16MB, and this configuration cannot
be changed. Correct Ans-False
- Default size of each output file is 16 MB but can be changed using the MAX_FILE_SIZE
parameter
Which of the following correctly describes the query profile shown?
QUERY RESULT REUSE[0] 1005 Correct Ans-- The query profile indicates that results
produced by a previous query were reused
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