Fall Semester 2026 UNISA Assignment: Automation and Data
Analysis (AIN3701) – Complete Solved Assignment with Step-by-
Step Answers, Marking-Guideline Alignment & Exam-Focused
Study Guide (Updated 2026 Edition)
,Question 1:
What is the primary purpose of automation in data analysis?
A) To reduce human error
B) To increase data storage
C) To enhance data complexity
D) To decrease processing speed
Correct Option: A) To reduce human error
Rationale: The primary purpose of automation in data analysis is to minimize human
error and improve efficiency in data processing.
Question 2:
Which of the following tools is commonly used for data visualization?
A) Microsoft Word
B) Tableau
C) Notepad
D) Microsoft Excel
Correct Option: B) Tableau
Rationale: Tableau is a widely-used data visualization tool that helps users create
interactive and shareable dashboards.
Question 3:
In data analysis, what does the term "big data" refer to?
A) Data that is too large to be processed by traditional tools
B) Data that is always accurate
C) Data that is stored in the cloud
D) Data that comes from social media only
Correct Option: A) Data that is too large to be processed by traditional tools
Rationale: "Big data" typically refers to vast datasets that exceed the capabilities of
traditional database systems in terms of storage and analysis.
Question 4:
Which programming language is primarily used for statistical analysis?
A) Java
B) C#
C) Python
D) HTML
Correct Option: C) Python
Rationale: Python is widely used in the field of data science and statistical analysis due
to its robust libraries such as Pandas and NumPy.
, Question 5:
What is an ETL process in data integration?
A) Extract, Transform, Load
B) Evaluate, Transform, Load
C) Extract, Test, Load
D) Evaluate, Test, List
Correct Option: A) Extract, Transform, Load
Rationale: ETL stands for Extract, Transform, Load, which is a processing framework
used in data warehousing for moving data from one system to another.
Question 6:
What does "data mining" primarily involve?
A) Data collection
B) Extracting patterns and knowledge from large datasets
C) Data encryption
D) Data entry
Correct Option: B) Extracting patterns and knowledge from large datasets
Rationale: Data mining involves analyzing large datasets to discover patterns, trends,
and relationships that can provide useful insights.
Question 7:
Which of the following is a technique used in predictive analytics?
A) Regression analysis
B) Data normalization
C) Data cleaning
D) Data visualization
Correct Option: A) Regression analysis
Rationale: Regression analysis is a statistical method used in predictive analytics to
find relationships between variables and forecast future outcomes.
Question 8:
What is the main feature of a relational database?
A) Data is stored in hierarchical format
B) Data is organized in tables with relationships
C) Data is stored as flat files
D) Data can only be accessed sequentially
Correct Option: B) Data is organized in tables with relationships
Rationale: Relational databases store data in structured tables, allowing for
relationships between different data entities.
Analysis (AIN3701) – Complete Solved Assignment with Step-by-
Step Answers, Marking-Guideline Alignment & Exam-Focused
Study Guide (Updated 2026 Edition)
,Question 1:
What is the primary purpose of automation in data analysis?
A) To reduce human error
B) To increase data storage
C) To enhance data complexity
D) To decrease processing speed
Correct Option: A) To reduce human error
Rationale: The primary purpose of automation in data analysis is to minimize human
error and improve efficiency in data processing.
Question 2:
Which of the following tools is commonly used for data visualization?
A) Microsoft Word
B) Tableau
C) Notepad
D) Microsoft Excel
Correct Option: B) Tableau
Rationale: Tableau is a widely-used data visualization tool that helps users create
interactive and shareable dashboards.
Question 3:
In data analysis, what does the term "big data" refer to?
A) Data that is too large to be processed by traditional tools
B) Data that is always accurate
C) Data that is stored in the cloud
D) Data that comes from social media only
Correct Option: A) Data that is too large to be processed by traditional tools
Rationale: "Big data" typically refers to vast datasets that exceed the capabilities of
traditional database systems in terms of storage and analysis.
Question 4:
Which programming language is primarily used for statistical analysis?
A) Java
B) C#
C) Python
D) HTML
Correct Option: C) Python
Rationale: Python is widely used in the field of data science and statistical analysis due
to its robust libraries such as Pandas and NumPy.
, Question 5:
What is an ETL process in data integration?
A) Extract, Transform, Load
B) Evaluate, Transform, Load
C) Extract, Test, Load
D) Evaluate, Test, List
Correct Option: A) Extract, Transform, Load
Rationale: ETL stands for Extract, Transform, Load, which is a processing framework
used in data warehousing for moving data from one system to another.
Question 6:
What does "data mining" primarily involve?
A) Data collection
B) Extracting patterns and knowledge from large datasets
C) Data encryption
D) Data entry
Correct Option: B) Extracting patterns and knowledge from large datasets
Rationale: Data mining involves analyzing large datasets to discover patterns, trends,
and relationships that can provide useful insights.
Question 7:
Which of the following is a technique used in predictive analytics?
A) Regression analysis
B) Data normalization
C) Data cleaning
D) Data visualization
Correct Option: A) Regression analysis
Rationale: Regression analysis is a statistical method used in predictive analytics to
find relationships between variables and forecast future outcomes.
Question 8:
What is the main feature of a relational database?
A) Data is stored in hierarchical format
B) Data is organized in tables with relationships
C) Data is stored as flat files
D) Data can only be accessed sequentially
Correct Option: B) Data is organized in tables with relationships
Rationale: Relational databases store data in structured tables, allowing for
relationships between different data entities.
