Exam (elaborations)
SnowPro Core Exam: Completely Correct Answers for Account Access and Security on Udemy
- Course
- Institution
SnowPro Core Exam: Completely Correct Answers for Account Access and Security on Udemy
[Show more]
Content preview
1 of 62Definition
- transparently replaces existing account and table keys every 30
days with a new key
- old keys are still kept for data that was encrypted using the old
keys
Give this one a try later!
Future Grants Key Rotation
, Key Pair Authentication Key Pair flow
Don't know?
2 of 62
Definition
- schema-level objects
- don't need be an owner to create/apply a Masking Policy
- can be nested, existing in tables and views that reference those
tables
- can be added to a table/view during or after creation of the
table/view
- ex:) if you try to join columns from two tables that have masking
policies attached to them, they will join based on the masked data
not the actual data --> policy is always applied
Give this one a try later!
Privileges for schema objects Row Access Policies
Key Concepts of Masking
Privileges for Account Objects
Policies
Don't know?
3 of 62
,Definition
- automatically granted to every user and every role in an account
- can own securable objects, however objects owned by this role
are available to every other user and role within an account
Give this one a try later!
Securable object Periodic Re-Keying
Capabilities of the owner role of an
PUBLIC
object
Don't know?
4 of 62
Definition
- views displaying metadata for all objects contained in the database
- ex:) Tables, Stages, Pipes, Functions
- views displaying metadata for account-level objects (non-database
objects like toles, warehouses, and databases)
- ex:) Databases, Load History, Enable Roles, Applicable Roles
- table functions displaying metadata for historical and usage data
across an account (return multiple rows and can be queried like a
table)
- ex;) Task History, Login History, Copy History, Tag References, etc.
, Give this one a try later!
Privileges for Account Objects Discretionary Access Control (DAC)
What does
What is the purpose of Account
INFORMATION_SCHEMA
Usage?
contain?
Don't know?
5 of 62
Definition
- ORGADMIN
- ACCOUNTADMIN
- SECURITYADMIN
- SYSADMIN
- USERADMIN
- PUBLIC
Give this one a try later!
READER_ACCOUNT_USAGE DATA_SHARING_USAGE
Static Data Masking System-Defined Roles
Don't know?
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 codersimon. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
74735 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now