Exam (elaborations)
Snowflake SnowPro Certification Quiz – Q&A
- Course
- SnowPro Certification
- Institution
- SnowPro Certification
Snowflake SnowPro Certification Quiz – Q&A
[Show more]
Content preview
Snowflake SnowPro Certification Quiz – Q&AMaximum number of tasks in a tree ✔️Ans - 1000
SNOWSQL default directory ✔️Ans - ~/.snowsql%USERPROFILE%
\.snowsql
set configuration ✔️Ans - -o or --option
!set
config
Can you run snowDC for HTTP ✔️Ans - Yes
Who can create database from share ✔️Ans - AccountAdmin or the one with
Import Share permissions
Data Sharing & Data Replication - does they support Future grants ✔️Ans -
No
What will happen to PIPE when you Clone Database of Schema ✔️Ans - it
will clone PIPE
How many days - Load History in metadata for Table Copy ✔️Ans - 64
How many days - History in metadata for Snow PIPE ✔️Ans - 14
What is data exchange in snowflake ✔️Ans - It is a market place that utilize
secure data sharing
What does newly created reader account contains ✔️Ans - Only one user -
Administrator
Can you share a Standard View ✔️Ans - No
Can you share a Secure View ✔️Ans - Yes
Can you share data from multiple database ✔️Ans - Yes, as long as they
belong to same account by creating secure Views
,What access is needed to share secure View ✔️Ans - You should give
REFERENCE_USAGE privilege on each database referenced by Secure View
No Need to grant REFERENCE_USAGE on database where Secure View is
created
What does each Share consist of ✔️Ans - Privileges that grant access to the
database and schema containing.
Specific Objects
Consumer Accounts
Snowflake SCIM Can be used to ✔️Ans - Manage User
Manage Roles
Auditing
SCIM Can import roles from ✔️Ans - Okta
Azure AD
Custom build applications
Encrypted Key Hirearcy ✔️Ans - Root key
Account Master Key
Table Key
File Key
When databases is cloned,what will happen to Future Objects Privilege
✔️Ans - They copy the Privilege from source schema
Does DataSharing and Data Replication support Future granting ✔️Ans - No
Will Clone Objects will clone Privileges ✔️Ans - No
Does OUATH support Key Pair Authentication ✔️Ans - Yes
Who can Grant Privileges with Managed Access Schema ✔️Ans - Schema
Owner
Role with Mange Grants Privilege
How does SNowflake Support OAUTH ✔️Ans - Through Integration
, Native IDP Provider ✔️Ans - Okta
Microsft ADFS
Network Policies support what Protocol(IPV4 or IPV6 or both) ✔️Ans -
IPV4
Types of Parameters ✔️Ans - Account
Session
Object
Access required to Modify Resource Monitor ✔️Ans - Modify
Monitor
Data Transfer Charges ✔️Ans - Same Cloud Platform - One Region to Other
region.
Out of Cloud Platform - Everything
Compare rows in random set of tables in Primary and Secondary Databases
✔️Ans - HASH_AGG
Default Replication Duration ✔️Ans - 2 days
Can be extended to 7 days using STATEMEMT TIME OUT in SECONDS
parameter
Compute and Data Storage are dependent on each other ✔️Ans - False
Can you create Snowflake Temporary Stages ✔️Ans - False
True or False - Can you create Snowflake Temporary Tables ✔️Ans - True
Snowflake automatically Encrypt Internal Stage data ✔️Ans - True
True or False - Snowflake Automatically Encrypt data in External Stage
✔️Ans - No
All Virtual Wareshouse in your account has access to Same data ✔️Ans - Yes
Two Modes in which multi-cluster warehouse can run ✔️Ans - Maximized
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$25.06. 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