100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
SNOWPRO CERTIFICATION EXAM, PRACTICE EXAM AND STUDYGUIDE NEWEST ACTUAL EXAM QUESTIONS AND DETAILED CORRECT ANSWERS | A+ GRADE ALREADY PASSED$23.99
Add to cart
SNOWPRO CERTIFICATION EXAM,
PRACTICE EXAM AND STUDYGUIDE
NEWEST ACTUAL EXAM QUESTIONS
AND DETAILED CORRECT ANSWERS |
A+ GRADE ALREADY PASSED
Which type of data integration tools leverage SF's scalable
compute for data transformation?
A. Data Replication
B. ELT
C. ETL
D. Streaming Correct Answer B
Select all of the answers that describe SF micro-partitions. Micro-
partitions
A. Are the physical data files that comprise SF's logical tables
B. Are written to a customer configured cloud storage location
C. Will be updated as their row & column values are updated
D. Enable horizontal and vertical query pruning Correct Answer A
&D
Which of the following are TRUE about SF data sharing?
A. Consumers can query shared tables in the same query as their
own tables
B. Producers can share data to other databases such as Postgres
and MySQL
C. You don't need a SF virtual WH to query shared data
,D. Data sharing is integrated with role-based access control
Correct Answer A & D
True or False: When data is staged to a SF internal staging area
using the PUT command, the data is encrypted on the client's
machine. Correct Answer True
Which of the following are types of caching used by SF?
A. Warehouse Caching
B. Index Caching
C. Metadata Caching
D. Query result Caching Correct Answer A, C, & D
Which of the following is not a layer in SF's Architecture?
Storage
Cloud Services
Data Catalog
Virtual Warehouses Correct Answer Data Catalog
Which of the following techniques can be in SF to improve query
performance?
A. Index Definition
B. Cluster Keys/Reclustering
C. Distribution Keys
D. Query Hints Correct Answer B
True or False: SF offers tools to extract data from source
systems. Correct Answer False
Which of the following are options when creating a Virtual
Warehouse?
,A. Auto-suspend
B. Storage size
C. Auto-resume
D. Server Count Correct Answer A & C
True or False: The warehouse cache may be reset if a running
warehouse is suspended and then resumed. Correct Answer A
Which of the following best describes SF's processing engine?
Leverages Apache Spark
Based on Map Reduce
A derivative of Presto
Native SQL Correct Answer Native SQL
Which role in Snowflake allows a user to administer users and
manage all database objects?
Which transformations are available when using the COPY INTO
command to load data files into Snowflake from a stage?
Filters
Aggregates
Column data type conversion
Column concatention Correct Answer Column data type
conversion
Column concatention
The following factors affect data load rates:
, A. Physical location of the stage
B. RAM on the virtual warehouse
C. Gzip compression efficiency
D. Thread size Correct Answer Physical location of the stage
Gzip compression efficiency
True or False: Virtual Warehouses cannot be resized while
queries are running. Correct Answer False
True or False: A table in Snowflake can only be queried using the
Virtual Warehouse used to load the data. Correct Answer False
Which of the following statements apply to Snowflake in terms of
security?
A. Snowflake leverages a role-based access control model
B. Snowflake requires you to configure an IAM user in order to
connect to the database
C. All data in Snowflake is encrypte
D. Snowflake can run within a customer's VPC Correct Answer A
&C
True or False: Snowflake caches are automatically invalidated if
the underlying data changes. Correct Answer True
True or False: The query profiler view is only available for
completed queries. Correct Answer False
Which of the following are true about the variant data type in
Snowflake?
A. Optimized storage based on repeated elements
B. Stored in a separate file format from structured data
C. Can be queried using JSON path notation
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 TUTORWAC. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $23.99. You're not tied to anything after your purchase.
