CIS 5450 - Midterm 1 EXAM 2025
QUESTIONS AND ANSWERS
Which of the following is least likely to be a good example of big data
(Purchase behavior for 1000 users, Hundreds of gene sequences, Points on the trajectory of a
falling object, A thousand YouTube videos) - ANS Points on the trajectory of a falling object
Which of the following tasks is not part of preprocessing data?
(Model and annotate data, Extract the key parts of the data, Run machine learning algorithms
on the data, Clean the data) - ANS Run machine learning algorithms on the data
Features are: - ANS Values used to predict classes or groups
What are the three basic encodings of structured data? - ANS tables, arrays, nested
What kinds of data might need pattern-based extraction? - ANS web or text data
Which of the following is not a part of the standard data structuring process? - ANS training
When we read a structured file into a dataframe, what will occur? - ANS column names may
be assigned based on the file header
1
Page
@COPYRIGHT BRAINBARTER 2025/2026
, When we store a dataframe in a SQL database, what do we have an option of saving or
dropping? - ANS the dataframe index
What does projection do? - ANS returns a subset of the columns in a dataframe
The document object model is what kind of data structure? - ANS tree
XPath returns what as its result? - ANS set of matching nodes in order, as a list
The XPath //span matches what? - ANS the span element(s) at any level
An outerjoin will return the exact same results as an innerjoin if - ANS every tuple in the
input relations has a match.
If we join relations that each have an id column, what happens in Pandas? - ANS The input
columns will be renamed in the output, to be unique, by appending suffixes to the names
What does my_df['col1'] > 3 return? - ANS A series of Boolean values, true only for rows
where col1 is above 3
What SQL statement is equivalent to my_df[my_df['a'] != 3]? - ANS select * from my_df
where a <> 3
How do my_df['col1'] and my_df[['col1']] differ? - ANS The first returns a series and the
second returns a dataframe.
A lambda function is: - ANS An unnamed function that's defined where it's to be used, which
takes input parameters and returns a result.
2
Page
@COPYRIGHT BRAINBARTER 2025/2026
QUESTIONS AND ANSWERS
Which of the following is least likely to be a good example of big data
(Purchase behavior for 1000 users, Hundreds of gene sequences, Points on the trajectory of a
falling object, A thousand YouTube videos) - ANS Points on the trajectory of a falling object
Which of the following tasks is not part of preprocessing data?
(Model and annotate data, Extract the key parts of the data, Run machine learning algorithms
on the data, Clean the data) - ANS Run machine learning algorithms on the data
Features are: - ANS Values used to predict classes or groups
What are the three basic encodings of structured data? - ANS tables, arrays, nested
What kinds of data might need pattern-based extraction? - ANS web or text data
Which of the following is not a part of the standard data structuring process? - ANS training
When we read a structured file into a dataframe, what will occur? - ANS column names may
be assigned based on the file header
1
Page
@COPYRIGHT BRAINBARTER 2025/2026
, When we store a dataframe in a SQL database, what do we have an option of saving or
dropping? - ANS the dataframe index
What does projection do? - ANS returns a subset of the columns in a dataframe
The document object model is what kind of data structure? - ANS tree
XPath returns what as its result? - ANS set of matching nodes in order, as a list
The XPath //span matches what? - ANS the span element(s) at any level
An outerjoin will return the exact same results as an innerjoin if - ANS every tuple in the
input relations has a match.
If we join relations that each have an id column, what happens in Pandas? - ANS The input
columns will be renamed in the output, to be unique, by appending suffixes to the names
What does my_df['col1'] > 3 return? - ANS A series of Boolean values, true only for rows
where col1 is above 3
What SQL statement is equivalent to my_df[my_df['a'] != 3]? - ANS select * from my_df
where a <> 3
How do my_df['col1'] and my_df[['col1']] differ? - ANS The first returns a series and the
second returns a dataframe.
A lambda function is: - ANS An unnamed function that's defined where it's to be used, which
takes input parameters and returns a result.
2
Page
@COPYRIGHT BRAINBARTER 2025/2026
