Exam (elaborations)
Snowflake Exam Study Set Exam Prep Questions And Answers ()
- Course
- Institution
Snowflake Exam Study Set Exam Prep Questions And Answers ()
[Show more]
Seller
Follow
Content preview
Snowflakes Preparation Exam Exam Prep Questions And Answers(202472025)
Multi-cluster shared data - ✔✔Which of the following terms best describes Snowflake's database
architecture?
Pruning - ✔✔What technique does Snowflake use to limit the number of micro-partitions scanned
by each query?
All data in Snowflake is encrypted - ✔✔Which of the following statements apply to Snowflake in
terms of security? Select all that apply.
Snowflake leverages a role-based access control model - ✔✔Which of the following statements
apply to Snowflake in terms of security? Select all that apply.
Result caching , Metadata caching , warehouse caching - ✔✔Which of the following are types of
caching use by Snowflake?
view - ✔✔What is the recommended approached for making a variant column accessible in a BI
tool?
Native SQL - ✔✔Which of the following best describes Snowflake's processing engine?
Optimized storage based on repeated elements - ✔✔Which of the following are true about the
variant data type in Snowflake?
Can be queried using JSON path notation - ✔✔Which of the following are true about the variant
data type in Snowflake?
* Are the physical data files that comprise Snowflake's logical tables
* Enable horizontal and vertical query pruning - ✔✔Snowflake micro-partitions. Micro-partitions:
,ELT - ✔✔Which type of Data Integration tools leverage Snowflake's scalable compute for data
transformation?
auto-suspend and auto-resume - ✔✔Which of the following are options when creating a Virtual
Warehouse?
* Adds clusters automatically based on query activity
*Scales down when query activity slows - ✔✔Which of the following are true of Multi-Cluster
warehouses?
* Physical location of the Stage
* Gzip compression efficiency - ✔✔The following factors affect data load rates:
Data Catalog - ✔✔Which of the following is not a layer in Snowflake's Architecture?
Data sharing - ✔✔Consumers can query shared tables in the same query as their own tables
data sharing - ✔✔Data Sharing is integrated with role-based access controls
Unlimited - ✔✔What is the maximum number of consumer accounts that can be added to a Share
object?
accountadmin - ✔✔Which role in Snowflake allows a user to administer users and manage all
database objects?
Table definitions, Tracking of all versions of the table data within the data retention window -
✔✔Snowflake metadata repository contains
, Column data type conversion
Column concatenation - ✔✔Which transformations are available when using the COPY INTO
command to load data files into Snowflake from a stage?
Cluster Keys/Reclustering - ✔✔Which of the following techniques can be used in Snowflake to
improve query performance?
The role a user is set to each time they log in to the system. - ✔✔A user's default role is:
accountadmin,securityadmin,public,sysadmin - ✔✔Snowflake adds four roles to each new
account. Check the four default roles.
accountadmin - ✔✔Which default role has access to the Account and Notifications ribbon options?
securityadmin,accountadmin - ✔✔Which default roles have access to the ACCOUNT option in
the ribbon?
other - ✔✔Snowflake allows for custom column separators (a.k.a. column delimiters). In order to
use a caret symbol as a custom column separator, what option must you first choose?
Single Quotes
Double Quotes
None - ✔✔Snowflake does NOT allow for custom field enclosures like tildes. What three options
are offered for field enclosures?
Because Snowflake does not provide an "Other" option for field enclosures. - ✔✔Why did we
recommend making the description field 62 characters wide instead of 60?
Run a SQL command like "USE WAREHOUSE SMALL_WH;"
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 manassehtaliban95. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.44. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
82871 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now