Exam (elaborations)
Snowpro Core Certification Exam – Qs & As
- Course
- SnowPro Certification
- Institution
- SnowPro Certification
Snowpro Core Certification Exam – Qs & As
[Show more]
Content preview
Snowpro Core Certification Exam – Qs & AsWhat is the maximum total Continuous Data Protectiond (CDP) charges
incurred for a temporary table? ✔️Ans - 24 hours
When retrieving a query profile, what is a symptom that a query is too large to
fir into the memory? ✔️Ans - When partitions scanned is equal to
partitions total. For efficient pruning, partitions scanned should be a small
fraction of partitions total.
What type of query benefits the MOST from search optimization? ✔️Ans -
Queries that utilize:
1. Equality or IN Predicates
2. Substrings and Regular Expressions
3. Fields in VARIANT Columns
4. Geospatial Functions
5. Conjunctions of Supported Predicates (AND)
6. Disjunctions of Supported Predicates (OR)
What transformations are supported in the CREATE PIPE ... AS COPY `| FROM
(`|) statement ✔️Ans - Columns can be reordered or they can be omitted.
Cast operations are also supported.
docs.snowflake.com/en/sql-reference/sql/create-pipe.html
How does SnowSQL support specifying a default warehouse? ✔️Ans - A
configuration file option and a command line option
T/F: The default virtual warehouse size can be changed at any time. ✔️Ans -
True
Which command should be used to load data from a file, located in external
storage, into a table in Snowflake? ✔️Ans - COPY
The Snowflake Cloud Data Platform is described as having which of the
following architectures? ✔️Ans - Mutli-Clustered Shared Data (A hybrid of
shared disk and shared nothing architectures)
,Protegrity is an example of which type of integration partner? ✔️Ans - Data
Tokenization Integration
What versions of Snowflake should be used to manage compliance with PII
requirements? ✔️Ans - Virtual Private Snowflake or Business Critical
Edition
What are supported file formats for unloading data from snowflake? ✔️Ans
- JSON, Parquet, or any valid delimiter; default is CSV
The Snowflake cloud services layer is respsonsible for which tasks? ✔️Ans -
Authentication, infrastructure management, metadata management, query
parsing and optimization, access control
What is a key feature of the Snowflake architecture for managing user
requests and resource management? ✔️Ans - Multi-cluster warehouses
allow users to run a query that spans across multiple clusters.
The overarching performance challenge with traditional data warehouses
comes down to one thing: resource contention. Single-cluster systems—both
in shared-disk and shared-nothing architectures—require all users in the data
warehouse to share a limited set of resources. Too many concurrent users or
workloads can lead to significant performance degradation and queueing. In
contrast, Snowflake provides a patented multicluster, shared data architecture
and intelligent use of readily available cloud resources to allow essentially
limitless concurrency
T/F: A data provider can only share with other Snowflake customers? ✔️Ans
- True
A Snowflake user wants to share data with suppliers that don't use Snowflake,
what should the user do? ✔️Ans - Deploy a single reader account to be
shared by all of the non-Snowflake suppliers and extract the shared
transactional data to an external stage and use cloud stage utilities to reload
the suppliers regions.
What is a key characteristic of the Snowflake visual query profiler? ✔️Ans -
It provides a graphic representation of main components of the query
processing
, Which command is used to load files into an internal stage with Snowflake?
✔️Ans - PUT
What object type is granted permissions for reading a table? ✔️Ans -
Attribute
What is the default value in the Snowflake Web UI for auto-suspending a
virtual warehouse? ✔️Ans - 10 minutes
If too many users are using the same warehouse and reporting slow run times
and that many queries are getting queued, what is the Snowflake
recommended solution? ✔️Ans - Increase the warehouse
MAX_CLUSTER_COUNT parameter
List three invalid Snowflake data types ✔️Ans - BLOB, CLOB, JSON. JSON is
intended to be stored in VARIANT, OBJECT, and ARRAY data types.
Are queries running on a virtual warehouse affected when the size of a virtual
warehouse is changed? ✔️Ans - No, queries that are running on the current
warehouse configuration are not impacted.
How often are encryption keys automatically rotated by Snowflake? ✔️Ans -
365 Days
As a practice, all custom roles should be granted to which system-defined
role? ✔️Ans - ACCOUNTADMIN
Which Snowflake object can be accessed in the FROM clause of a query,
returning a set of rows having one or more columns? ✔️Ans - A User-
Defined Table Function (UDTF)
How are micro-partitions typically generated in Snowflake? ✔️Ans -
Automatically
What two recommendation does Snowflake make regarding database object
ownership? ✔️Ans - Create objects with ACCOUNTADMIN and do not
reassign ownership and use only managed access schemas for objects owned
by ACCOUNTADMIN
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 LeCrae. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for CA$26.45. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76669 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now