CIS 5450 - Midterm 1, Fall 2026 Exam Questions and Answers (Verified
Answers) Most Recent exam COMPLETE (2026) (Latest Update 2026)
UPDATE!!
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) - (ANSWER)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) - (ANSWER)Run machine learning algorithms on the data
Features are: - (ANSWER)Values used to predict classes or groups
What are the three basic encodings of structured data? - (ANSWER)tables, arrays, nested
What kinds of data might need pattern-based extraction? - (ANSWER)web or text data
Which of the following is not a part of the standard data structuring process? - (ANSWER)training
When we read a structured file into a dataframe, what will occur? - (ANSWER)column names may be
assigned based on the file header
When we store a dataframe in a SQL database, what do we have an option of saving or dropping? -
(ANSWER)the dataframe index
What does projection do? - (ANSWER)returns a subset of the columns in a dataframe
The document object model is what kind of data structure? - (ANSWER)tree
XPath returns what as its result? - (ANSWER)set of matching nodes in order, as a list
, CIS 5450 - Midterm 1, Fall 2026 Exam Questions and Answers (Verified
Answers) Most Recent exam COMPLETE (2026) (Latest Update 2026)
UPDATE!!
The XPath //span matches what? - (ANSWER)the span element(s) at any level
An outerjoin will return the exact same results as an innerjoin if - (ANSWER)every tuple in the input
relations has a match.
If we join relations that each have an id column, what happens in Pandas? - (ANSWER)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? - (ANSWER)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]? - (ANSWER)select * from my_df where a <>
3
How do my_df['col1'] and my_df[['col1']] differ? - (ANSWER)The first returns a series and the second
returns a dataframe.
A lambda function is: - (ANSWER)An unnamed function that's defined where it's to be used, which takes
input parameters and returns a result.
Iteration is undesirable because of which reason? - (ANSWER)It sequentializes operations instead of
letting Python decide how to do the evaluation.
What is the most important thing to do when you run data validation rules? - (ANSWER)Log and
periodically inspect the data that violates the rules
Why would we prefer validation against a master (data) list, vs using a data validation function? -
(ANSWER)The master list captures all possible domain values rather than patterns
Answers) Most Recent exam COMPLETE (2026) (Latest Update 2026)
UPDATE!!
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) - (ANSWER)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) - (ANSWER)Run machine learning algorithms on the data
Features are: - (ANSWER)Values used to predict classes or groups
What are the three basic encodings of structured data? - (ANSWER)tables, arrays, nested
What kinds of data might need pattern-based extraction? - (ANSWER)web or text data
Which of the following is not a part of the standard data structuring process? - (ANSWER)training
When we read a structured file into a dataframe, what will occur? - (ANSWER)column names may be
assigned based on the file header
When we store a dataframe in a SQL database, what do we have an option of saving or dropping? -
(ANSWER)the dataframe index
What does projection do? - (ANSWER)returns a subset of the columns in a dataframe
The document object model is what kind of data structure? - (ANSWER)tree
XPath returns what as its result? - (ANSWER)set of matching nodes in order, as a list
, CIS 5450 - Midterm 1, Fall 2026 Exam Questions and Answers (Verified
Answers) Most Recent exam COMPLETE (2026) (Latest Update 2026)
UPDATE!!
The XPath //span matches what? - (ANSWER)the span element(s) at any level
An outerjoin will return the exact same results as an innerjoin if - (ANSWER)every tuple in the input
relations has a match.
If we join relations that each have an id column, what happens in Pandas? - (ANSWER)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? - (ANSWER)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]? - (ANSWER)select * from my_df where a <>
3
How do my_df['col1'] and my_df[['col1']] differ? - (ANSWER)The first returns a series and the second
returns a dataframe.
A lambda function is: - (ANSWER)An unnamed function that's defined where it's to be used, which takes
input parameters and returns a result.
Iteration is undesirable because of which reason? - (ANSWER)It sequentializes operations instead of
letting Python decide how to do the evaluation.
What is the most important thing to do when you run data validation rules? - (ANSWER)Log and
periodically inspect the data that violates the rules
Why would we prefer validation against a master (data) list, vs using a data validation function? -
(ANSWER)The master list captures all possible domain values rather than patterns
