CIS 5450 - Midterm 1, 2025) comprehensive
questions and verified answers (Detailed &
Elaborated) ACTUAL EXAM 2025 TEST 100% Solved
2025!!
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
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
What are effective general approaches to computing string similarity? -
(ANSWER)string edit distance and string overlap
questions and verified answers (Detailed &
Elaborated) ACTUAL EXAM 2025 TEST 100% Solved
2025!!
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
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
What are effective general approaches to computing string similarity? -
(ANSWER)string edit distance and string overlap
