Fall Semester 2025 UNISA Assignment: AIN3701 Automation and Data
Analysis – Solved Questions 1–40 with Step-by-Step Answers and Exam-
Focused Explanations (Updated 2025 Edition)
Question 1:
What is the primary purpose of automation in data analysis?
• A) To eliminate human error
• B) To slow down processes
• C) To increase manual workloads
• D) To create more data
CORRECT ANSWER: A) To eliminate human error
Rationale: Automation minimizes human intervention, significantly reducing the
likelihood of errors and enhancing efficiency in data processing.
Question 2:
Which of the following tools is commonly used for data visualization?
• A) Microsoft Word
• B) Excel
• C) Visual Studio
• D) Notepad
CORRECT ANSWER: B) Excel
Rationale: Excel is widely recognized for its data visualization capabilities, allowing
users to create charts and graphs easily.
Question 3:
In Python, which library is primarily used for data manipulation and analysis?
• A) TensorFlow
• B) NumPy
• C) pandas
• D) Matplotlib
CORRECT ANSWER: C) pandas
Rationale: The pandas library provides powerful data structures like DataFrames for
effective data manipulation and analysis.
,Fall Semester 2025 UNISA Assignment: AIN3701 Automation and Data
Analysis – Solved Questions 1–40 with Step-by-Step Answers and Exam-
Focused Explanations (Updated 2025 Edition)
Question 4:
What does ETL stand for in data processing?
• A) Extract, Transform, Load
• B) Execute, Test, Launch
• C) Evaluate, Transfer, Load
• D) Extract, Test, Link
CORRECT ANSWER: A) Extract, Transform, Load
Rationale: ETL refers to the process of extracting data from various sources,
transforming it into a suitable format, and loading it into a data warehouse.
Question 5:
Which programming language is known for its use in data science and automation?
• A) Java
• B) C++
• C) Python
• D) Ruby
CORRECT ANSWER: C) Python
Rationale: Python is widely endorsed in the data science community due to its
simplicity and the availability of numerous libraries for data analysis.
Question 6:
Which method is NOT a type of machine learning?
• A) Supervised learning
• B) Unsupervised learning
• C) Reinforcement learning
• D) Collaborative learning
CORRECT ANSWER: D) Collaborative learning
Rationale: Collaborative learning is not a recognized method of machine learning; the
other three are standard categories used in ML.
Question 7:
, Fall Semester 2025 UNISA Assignment: AIN3701 Automation and Data
Analysis – Solved Questions 1–40 with Step-by-Step Answers and Exam-
Focused Explanations (Updated 2025 Edition)
What is the purpose of data normalization?
• A) To increase data redundancy
• B) To reduce data storage
• C) To ensure consistent data scales
• D) To enhance manual processing
CORRECT ANSWER: C) To ensure consistent data scales
Rationale: Normalization standardizes data ranges, facilitating effective analysis and
comparison.
Question 8:
Which of the following is NOT a valid data type in Python?
• A) List
• B) Dictionary
• C) Boolean
• D) Character
CORRECT ANSWER: D) Character
Rationale: Python does not have a separate character datatype; characters are treated
as strings of length one.
Question 9:
In data visualization, what does a histogram represent?
• A) Categorical data
• B) Continuous data distributions
• C) Time series
• D) Hierarchical relationships
CORRECT ANSWER: B) Continuous data distributions
Rationale: Histograms effectively illustrate frequency distributions of continuous data.
Question 10:
What is a common disadvantage of using automation in data analysis?
Analysis – Solved Questions 1–40 with Step-by-Step Answers and Exam-
Focused Explanations (Updated 2025 Edition)
Question 1:
What is the primary purpose of automation in data analysis?
• A) To eliminate human error
• B) To slow down processes
• C) To increase manual workloads
• D) To create more data
CORRECT ANSWER: A) To eliminate human error
Rationale: Automation minimizes human intervention, significantly reducing the
likelihood of errors and enhancing efficiency in data processing.
Question 2:
Which of the following tools is commonly used for data visualization?
• A) Microsoft Word
• B) Excel
• C) Visual Studio
• D) Notepad
CORRECT ANSWER: B) Excel
Rationale: Excel is widely recognized for its data visualization capabilities, allowing
users to create charts and graphs easily.
Question 3:
In Python, which library is primarily used for data manipulation and analysis?
• A) TensorFlow
• B) NumPy
• C) pandas
• D) Matplotlib
CORRECT ANSWER: C) pandas
Rationale: The pandas library provides powerful data structures like DataFrames for
effective data manipulation and analysis.
,Fall Semester 2025 UNISA Assignment: AIN3701 Automation and Data
Analysis – Solved Questions 1–40 with Step-by-Step Answers and Exam-
Focused Explanations (Updated 2025 Edition)
Question 4:
What does ETL stand for in data processing?
• A) Extract, Transform, Load
• B) Execute, Test, Launch
• C) Evaluate, Transfer, Load
• D) Extract, Test, Link
CORRECT ANSWER: A) Extract, Transform, Load
Rationale: ETL refers to the process of extracting data from various sources,
transforming it into a suitable format, and loading it into a data warehouse.
Question 5:
Which programming language is known for its use in data science and automation?
• A) Java
• B) C++
• C) Python
• D) Ruby
CORRECT ANSWER: C) Python
Rationale: Python is widely endorsed in the data science community due to its
simplicity and the availability of numerous libraries for data analysis.
Question 6:
Which method is NOT a type of machine learning?
• A) Supervised learning
• B) Unsupervised learning
• C) Reinforcement learning
• D) Collaborative learning
CORRECT ANSWER: D) Collaborative learning
Rationale: Collaborative learning is not a recognized method of machine learning; the
other three are standard categories used in ML.
Question 7:
, Fall Semester 2025 UNISA Assignment: AIN3701 Automation and Data
Analysis – Solved Questions 1–40 with Step-by-Step Answers and Exam-
Focused Explanations (Updated 2025 Edition)
What is the purpose of data normalization?
• A) To increase data redundancy
• B) To reduce data storage
• C) To ensure consistent data scales
• D) To enhance manual processing
CORRECT ANSWER: C) To ensure consistent data scales
Rationale: Normalization standardizes data ranges, facilitating effective analysis and
comparison.
Question 8:
Which of the following is NOT a valid data type in Python?
• A) List
• B) Dictionary
• C) Boolean
• D) Character
CORRECT ANSWER: D) Character
Rationale: Python does not have a separate character datatype; characters are treated
as strings of length one.
Question 9:
In data visualization, what does a histogram represent?
• A) Categorical data
• B) Continuous data distributions
• C) Time series
• D) Hierarchical relationships
CORRECT ANSWER: B) Continuous data distributions
Rationale: Histograms effectively illustrate frequency distributions of continuous data.
Question 10:
What is a common disadvantage of using automation in data analysis?
