Exam (elaborations)
Snowpro Certification Exam; Questions with Verified Solutions
- Course
- Institution
Snowpro Certification Exam; Questions with Verified Solutions
[Show more]
Content preview
Snowpro Certification Exam; Questions with VerifiedSolutions
What SQL extension did Snowflake add for use with the Time Travel feature Correct Ans-
AT, UNDROP, BEFORE
Data loading typically requires the use of a XXL Virtual Warehouse. True or False? Correct
Ans-False
On which version of Snowflake is Secure Data Sharing not available Correct Ans-Virtual
Private Snowflake (VPS)
Time Travel is not possible on transient tables. True or false Correct Ans-False
What are the snowflake editions Correct Ans-Enterprise, Standard, Business Critical
Edition, Virtual Private Snowflake (VPS)
If the PURGE copy option were set to TRUE what could happen to data files that are
successfully loaded into Snowflake from an external stage? Correct Ans-They would be
removed from the external stage.
, Snowpro Certification Exam; Questions with Verified
Solutions
The reuse the results cache which of the following requirements must be met? Correct
Ans-- The role executing the query must have the necessary access privileges for all the tables
used in the cached query when executing a SELECT
- The new query exactly matches the cached query
In which state is a Virtual Warehouse billable Correct Ans-STARTED
What level of cardinality is it recommended to a column have when selected in a query that
makes use of a GROUP BY Correct Ans-Low cardinality
What's the maximum number of days a user could set the table property
DATA_RETENTION_TIME_IN_DAYS to for a transient table on a business critical edition
Snowflake account? Choose one correct value Correct Ans-1
Which object does an external function make use of to hold security related information?
Choose one correct value Correct Ans-API Integration
, Snowpro Certification Exam; Questions with Verified
Solutions
Which object does an external function make use of to hold security related information?
Choose one correct value Correct Ans-- PARQUET
- AVRO
- XML
- ORC
- JSON
Snowflake uses the following access control schemas: role based access control (RBAC) and
_____ Correct Ans-Discretionary Access Control (DAC)
A Snowflake user creates a clone of a 'TABLE_A' and names it 'TABLE_B'. When new records
are inserted into 'TABLE A' what is expected to happen to 'TABLE B' Correct Ans-The
inserted records do not show at all in TABLE B
What is the behavior of the COPY INTO <table> command when the ON_ERROR option is set
to CONTINUE? Correct Ans-Load the file if errors are found
, Snowpro Certification Exam; Questions with Verified
Solutions
What is the behavior of the COPY INTO <table> command when the ON_ERROR option is set
to CONTINUE? Correct Ans-FALSE
Which system-defined role is it recommended to assign custom roles to Correct Ans-
SYSADMIN
What do you configure a SHARE object with Correct Ans-- Account identifiers
- Object privileges
Cloning a table copies the underlying data effectively doubling storage costs. True or false?
Correct Ans-False
What attributes make Snowflake a SaaS solution Correct Ans-- No hardware to manage
- Pay for what you use pricing plan
What is the function of the AUTO_SUSPEND property of Virtual Warehouse Correct Ans-
Specifies the number of seconds of inactivity after which a warehouse is automatically
suspended
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 $26.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