This class was created by Brainscape user Christine Carroll. Visit their profile to learn more about the creator.
- decks
- flashcards
- learners
Decks in this class (32)
General Architecture
Snowflake s architecture is a hyb...,
What does mpp stand for 2,
How does snowflake process queries 3
16
cards
Parameters
What are the different types of p...,
Where can account params be set 2,
Who can set account level params 3
25
cards
Time Travel
What tasks can be done via time t...,
How do you query data using time ...,
How do you create a new object us...
18
cards
Replication Failover/Failback
What does a replication group all...,
What does a failover group allow ...,
What objects can be replicated 3
14
cards
Authenticate
What are the five ways to authent...,
When might saml sso might not be ...,
T f saml sso can be used on publi...
10
cards
Network Security
What are two additions to the out...,
All snowflake network connectivit...,
What are the two types of data fl...
11
cards
General Security
What is used to encrypt data at r...,
Which snowflake edition is pci ds...,
What does tri secret secure offer 3
13
cards
Shared Databases
What are five general limitations...,
Using sql how can you view all th...,
What is the sql to show more info...
51
cards
Views
How are materialized views refres...,
T f secure views cannot take adva...,
What objects cannot be cloned 3
15
cards
Data Loading
Snowpipe supports loading from wh...,
Need to look into copy options 2,
Where can you define the file for...
12
cards
Querying
With default settings how long wi...,
T f any query that uses the metad...,
T f this statement would use the ...
19
cards
Tasks
How you resume a task 1,
What is the type of sql code can ...,
Can tasks be triggered manually 3
5
cards
Storage
What is a storage integration 1,
T f a single storage integration ...,
If your cloud storage is located ...
6
cards
General
Sharing cloning replication tables 1,
Sharing cloning replication exter...,
Sharing cloning replication views 3
38
cards
2025 - General Knowledge
What does the snowflake architect...,
What is a key benefit of snowflak...,
What does snowflake use to proces...
119
cards
2025 Kafka Connectors and Client Drivers
What versions of kafka does the s...,
What are the two variant columns ...,
If the user adds addiontional col...
11
cards
2025 Data Ingestion
What two options are provided for...,
What basic transformations are su...,
What are the three type of intern...
66
cards
2025 Data Unloading
What is the two step process for ...,
How is encryption handled when un...,
What encoding is used for unloade...
13
cards
2025 Tables and Views
What are the four types of tables...,
How long is the fail safe period 2,
What is the max number of days ti...
79
cards
2025 Clustering and Micro-Partitions
How is snowflake data stored 1,
What is the uncompressed size of ...,
Are the micro partitions immutable 3
21
cards
2025 Cloning
What is zero copy cloning 1,
In information schematablestorage...,
When created does the cloned tabl...
18
cards
2025 Secure Data Sharing
What is a share 1,
How many databases can be created...,
What are the two types of consume...
19
cards
2025 Semistructured Data
What are the three semistructured...,
What datatype does variant hold 2,
What datatype does array or objec...
14
cards
2025 Time Travel and Fail Safe
In a time travel statement how ca...,
What can the undrop statement be ...,
What table types do not have a fa...
11
cards
2025 Continuous Data Pipelines
In general what are the three way...,
What options are used to enable s...,
Streams can be created to query c...
17
cards
2025 Data Replication and Failovers
What are the two key performance ...,
What is tri secret secure 2,
What is data replication used for 3
25
cards
2025 Managing Accounts and Security
By default the max number of acco...,
What are the three type of parame...,
How long are people locked out of...
10
cards
2025 Query Profiles and Tuning
What is percentage scanned from c...,
How can you increase the percenta...,
What is remote disk i o 3
6
cards
2025 Performance and Resource Optimization
What type of queries does search ...,
Search optimization works best fo...,
What is the minimum table size to...
22
cards
2025 Snowflake Best Practices
What is the architecture behind s...,
What can you do with your warehou...,
Where should order by be in a que...
6
cards
More about
Snowflake Architect Cert
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Christine Carroll's Snowflake Architect Cert 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....
Looking for something else?
Snowflake
- 5 decks
- 142 flashcards
- 58 learners
Decks:
Snowflake Overview, Snowflake Test 1, Level Up Snowflake Key Concepts, And more!
AWS Certified Solutions Architect
- 59 decks
- 992 flashcards
- 2179 learners
Decks:
Iam 101, S3 Object Lock, S3 Performance, And more!
SnowPro Core Snowflake Cert
- 2 decks
- 193 flashcards
- 122 learners
Decks:
Practice Test 1, Practice Test 2, And more!
AWS Solutions Architect
- 20 decks
- 770 flashcards
- 60 learners
Decks:
Module 1 Architecture Fundamentals, Module 2 Account Security, Module 3 Networking, And more!
