Data Engineering Flashcards

1
Q

What is an ETL pipeline?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a data warehouse?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is your experience with data modeling?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is your experience with data cleaning?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is your experience with data visualization?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is data engineering?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Data modeling: Star Schema

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Data modeling: Snowflake Schema

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is big data?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is structured data?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is unstructured data?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is semi-structured data?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is Hadoop?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is AWS?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the difference between a data warehouse and a database?

A

Blank

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are common data structures?

A
Dictionaries
Lists
Sets
Strings
Tuples
17
Q

Difference between a for loop and a while loop

18
Q

NumPy

19
Q

SciPy

20
Q

SQLAlchemy

21
Q

BeautifulSoup

22
Q

Seaborn

23
Q

Matplotlib

24
Q

What is an API request?

25
Q

Example API request

26
Q

Float

27
Q

Boolean

28
Q

Integer

29
Q

Example function

30
Q

What is a function?

31
Q

What is a dataframe?

32
Q

Merge dataframes syntax

33
Q

What is object-oriented programming?

34
Q

.describe()

35
Q

.head()

36
Q

.info()

37
Q

What are methods?

38
Q

What are attributes?