Udemy Snowpro Core Certification - Practice Questions Test 1 Questions and Answers 100% Correct
13 views 0 purchase
Course
Udemy Snowpro Core Certification
Institution
Udemy Snowpro Core Certification
Udemy Snowpro Core Certification - Practice Questions Test 1 Questions and Answers 100% CorrectUdemy Snowpro Core Certification - Practice Questions Test 1 Questions and Answers 100% CorrectUdemy Snowpro Core Certification - Practice Questions Test 1 Questions and Answers 100% Correct
When definin...
Udemy Snowpro Core Certification -
Practice Questions Test 1 Questions and
Answers 100% Correct
When defining a clustering key for a large table, consider using columns frequently used in
WHERE clauses. - ANSWER - True
Which query profile results indicate that a large table may not be well clustered? - ANSWER - -
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) - ANSWER - Partition Pruning
A stored procedure can return which type of results? - ANSWER - - Single Value
- Tabular Data
What type of virtual warehouse automatically lets you add or remove additional clusters as
concurrency and demand change? - ANSWER - Multi-cluster virtual warehouse
Files already loaded from a stage to a table can be loaded again into a cloned table. - ANSWER
- True
Which of the following operations can be performed on a cloned table? - ANSWER - DROP,
SELECT, DELETE, CLONE
A cloned table is just like any other table
, Which of the following is an appropriate scenario for creating a Stored Procedure? - ANSWER -
Execute one or more SQL statements that are assembled dynamically
True or False: An ACCOUNTADMIN can see the results of any query executed by any user in a
Snowflake system. - ANSWER - False
Dynamic Data Masking provides what sort of security in Snowflake? - ANSWER - Column-level
security
Which one of the following is supported by Snowflake for the purpose of auto-provisioning users
and group membership? - ANSWER - SCIM
- SCIM is an open standard that provides automatic user provisioning and role synchronization
based on identity provider information
Which of the following could be used as a remote service for an external function? - ANSWER -
- 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. - ANSWER - True
True or False: When unloading data, each exported file is 16MB, and this configuration cannot
be changed. - ANSWER - 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 - ANSWER - - The query profile indicates that results
produced by a previous query were reused
- The query profile indicates that an active virtual warehouse was NOT required for this query
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 $11.99. You're not tied to anything after your purchase.
