Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
8 Cards in this Set
- Front
- Back
|
What is nosql of redshift |
Columnar |
|
|
Is it parallel |
Yes, massively parallel execution mpp |
|
|
How to integrate with viz ? |
With quicksight |
|
|
Where redshift pull data |
From s3 csv files |
|
|
How redshift pull from s3 ? And how to pull directly |
He loads the data to construct the datawarehouse, use spectrum for direct load |
|
|
What are best practices |
Backup and restore, security vpc, iam, monitoring cloudwatch |
|
|
Give example of best practice ? |
Use redshift vpc routing : le flux de copy et unloads passe par le vpc, et ainsi appliquer les regles des security groups, gateway endooints pour assurer le routage entre les buckets s3 et redshift
* vpc flow logs pour monitorer le traffic de la copie et du unload des requetes |
|
|
Quand a tu utilise airflow ? Natif ou aws |
Aws C'etait pour orchestrer les jobs pyspark qui collectent les données, les nettoie et applique des regles fonctionnels et les charge dans une table hive |
