Data Engineering - 7

What are some of the disadvantages of having an in-house cluster, choose all that apply?

• Primary costs are hardware and personnel

• Continuous maintenance

• Very flexible operations

• Difficult to predict use and upgrade equipment

Which of these are key cloud computing characteristics?

• Virtualization

• Speed

• Cost

• Lack of flexibility

Which one is correct?

• Join combines columns

• Join combines rows

• Join combines both rows and columns

Identify the function used by the pandas library to replace NULL values?

• fillnan()

• fillnull()

• fillall()

• fillna()

What JOIN should I perform if I wish to retain only the common rows between two tables?

• INNER JOIN

• LEFT JOIN

• CROSS JOIN

• OUTER JOIN

 LEFT JOIN and RIGHT JOIN can result in NULL values.

• True

• False

• None of the above

Identify command to read in csv file to a pandas dataframe?

• .read_txt

• .read_commasepartedvalue

• .read_json

• .read_csv

Which type of visualization is suited for understanding the distribution of  height of students in a class?

• Boxplot

• Stem plot

• Histogram

• Barplot

Select all ordinal variables only

• Weight

• Temperature

• Letter grades

• Army ranking

What are the two ways to get insights from your data?

• Calculate summary statistics

• Drawing plots

• Calculate number of rows in your data table

• Join tables