This class was created by Brainscape user Jaime Tirado. Visit their profile to learn more about the creator.
By:
Jaime Tirado
- decks
- flashcards
- learners
Decks in this class (22)
D1.1 - EXPLAIN HOW TO MANAGE SNOWFLAKE ACCOUNTS
Account_usagesnowflake database i...,
Account access,
System defined roles
4
cards
D1.2 - OUTLINE SECURITY PRINCIPLES
Multi factor authentication mfa,
Data encryption,
Network security and policies
6
cards
D1.3 - DEFINE THE ENTITIES AND ROLES THAT ARE USED IN SNOWFLAKE
How are privilleges granted and r...,
Explain role hierarchy and privil...,
Explain privilege s inheritance
3
cards
D1.4 - EXPLAIN THE SECURITY CAPABILITIES ASSOCIATED WITH EACH SNOWFLAKE EDITION
Column level security,
Snowflake editions,
Snowflake standard edition
6
cards
D1.5 - OUTLINE DATA GOVERNANCE CAPABILITES IN SNOWFLAKE
Data masking,
Dynamic data masking features,
Account usage views
5
cards
D2.1 - OUTLINE COMPUTING PRINCIPLES
Credit usages and billing,
Snowflake managed compute resourc...,
Snowflake managed compute resourc...
22
cards
D2.2 - EXPLAIN VIRTUAL WAREHOUSE BEST PRACTICES
Scale up compared to scale out,
Benefits of reisizing a warehouse,
Benefits of a multi cluster wareh...
8
cards
D3.1 - OUTLINE DIFFERENT COMMANDS USED TO LOAD DATA AND WHEN THEY SHOULD BE USED
Copy into,
Insert,
Put
16
cards
D3.2 - DEFINE BULK AS COMPARED TO CONTINUOUS DATA LOADING METHODS
Copy,
Snowpipe
2
cards
D3.3 - DEFINE BEST PRACTICES THAT SHOULD BE CONSIDERED WHEN LOADING DATA
Best practices file size,
File size very large files,
File size handling very large files
7
cards
D3.4 - OUTLINE HOW DATA CAN BE UNLOADED FROM SNOWFLAKE TO EITHER LOCAL STORAGE OR CLOUD STORAGE
Define supported formats,
Commands that help when unloading...,
Define best practice when unloadi...
3
cards
D3.5 - EXPLAIN HOW TO WORK AND LOAD SEMI-STRUCTURED DATA
What are the supported file forma...,
What is the variant column,
What are the steps for loading se...
5
cards
D4.1 - OUTLINE BEST PRACTICES FOR SNOWFLAKE PERFORMANCE MANAGEMENT ON STORAGE
What is micro partitioning,
How does micro partitioning enabl...,
What metadata is saved for cluste...
7
cards
D4.2 - OUTLINE BEST PRACTICES FOR SNOWFLAKE PERFORMANCE MANAGEMENT ON VIRTUAL WAREHOUSES
What are the realted query perfor...,
Benefits of clustering a table,
Search optimization service speed...
6
cards
D5.1 - OUTLINE KEY COMPONENTS OF SNOWFLAKES CLOUD DATA PLATFORM
What are the data types within sn...,
What is a snowflake optimizer,
What is continuous data protectio...
12
cards
D5.2 - OUTLINE SNOWFLAKE DATA SHARING CAPABILITIES
What are the snowflake account types,
What is the data market place,
What is the data exchange
6
cards
D5.3 - EXPLIAN HOW SNOWFLAKE IS DIFFERENT COMPARED TO LEGACY WAREHOUSE SOLUTIONS
What makes snowflake different fr...,
Elastic storage,
Elastic compute
4
cards
D5.5 - IDENTIFY SNOWFLAKE's PARTNER ECOSYSTEM
Cloud partners,
Connectors
2
cards
D5.6 - OUTLINE AND DEFINE THE PURPOSE OF SNOWFLAKES THREE DISTINCT LAYERS
What are snowflakes distinct layers,
Storage layer,
Computer layer
4
cards
D5.7 - OUTLINE SNOWFLAKES CATALOG AND OBJECTS
What is a database,
What is a schema,
What are the types of tables with...
12
cards
SAMPLE QUESTIONS
Which of the following will contr...,
What are the connectors programs ...,
A snowflake share
7
cards
FOCUS QUESTIONS
11 what is it in the information_...,
When to use the reference_usage p...,
When can the select privilege on ...
6
cards
More about
SNOWFLAKE_PRO_CORE
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Jaime Tirado's SNOWFLAKE_PRO_CORE flashcards now!
How studying works.
Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.
Add your own flashcards.
Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!
What's Brainscape anyway?
Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.
We use an adaptive study algorithm that is proven to help you learn faster and remember longer....
