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 eliminate the need for data visualization
C) To increase efficiency in data processing
D) To ensure all data is stored in the cloud
Correct Option: C
Rationale: Automation increases efficiency by allowing repetitive tasks in data
processing to be executed without manual intervention, enhancing speed and
consistency.
Question 2
Which of the following is a common tool used for data analysis?
A) Microsoft Word
B) Python
C) Adobe Photoshop
D) Microsoft PowerPoint
Correct Option: B
Rationale: Python is widely used for data analysis due to its comprehensive libraries
(e.g., Pandas, NumPy) that facilitate handling and analyzing large datasets.
Question 3
In the context of automation, what does ETL stand for?
A) Extract, Transform, Load
B) Evaluate, Test, Learn
C) Extract, Transfer, Load
D) Extract, Transform, Load
Correct Option: D
Rationale: ETL refers to the process of extracting data from various sources,
transforming it to fit operational needs, and loading it into a data warehouse or
database for analysis.
Question 4
Which data visualization tool is known for its capacity to manage big data?
, A) Excel
B) Tableau
C) Power BI
D) Google Sheets
Correct Option: C
Rationale: Power BI is recognized for its powerful data modeling and visualization
capabilities, particularly when handling large datasets.
Question 5
What role does machine learning play in automation?
A) It replaces data scientists.
B) It enhances predictive analytics.
C) It eliminates all manual processes.
D) It is only used for image recognition.
Correct Option: B
Rationale: Machine learning enhances predictive analytics by using algorithms to
analyze data patterns, enabling better decision-making and automation of insights.
Question 6
What type of automation can be achieved through scripting languages?
A) Manual automation
B) Process automation
C) Automated testing
D) Workflow automation
Correct Option: B
Rationale: Scripting languages enable process automation by allowing repetitive tasks
and workflows to be automated through code.
Question 7
Which of the following is an example of unstructured data?
A) Social media posts
B) Relational database entries
C) Excel spreadsheets
D) System logs
Correct Option: A
Rationale: Social media posts are considered unstructured data because they do not
have a predefined format or schema.
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 eliminate the need for data visualization
C) To increase efficiency in data processing
D) To ensure all data is stored in the cloud
Correct Option: C
Rationale: Automation increases efficiency by allowing repetitive tasks in data
processing to be executed without manual intervention, enhancing speed and
consistency.
Question 2
Which of the following is a common tool used for data analysis?
A) Microsoft Word
B) Python
C) Adobe Photoshop
D) Microsoft PowerPoint
Correct Option: B
Rationale: Python is widely used for data analysis due to its comprehensive libraries
(e.g., Pandas, NumPy) that facilitate handling and analyzing large datasets.
Question 3
In the context of automation, what does ETL stand for?
A) Extract, Transform, Load
B) Evaluate, Test, Learn
C) Extract, Transfer, Load
D) Extract, Transform, Load
Correct Option: D
Rationale: ETL refers to the process of extracting data from various sources,
transforming it to fit operational needs, and loading it into a data warehouse or
database for analysis.
Question 4
Which data visualization tool is known for its capacity to manage big data?
, A) Excel
B) Tableau
C) Power BI
D) Google Sheets
Correct Option: C
Rationale: Power BI is recognized for its powerful data modeling and visualization
capabilities, particularly when handling large datasets.
Question 5
What role does machine learning play in automation?
A) It replaces data scientists.
B) It enhances predictive analytics.
C) It eliminates all manual processes.
D) It is only used for image recognition.
Correct Option: B
Rationale: Machine learning enhances predictive analytics by using algorithms to
analyze data patterns, enabling better decision-making and automation of insights.
Question 6
What type of automation can be achieved through scripting languages?
A) Manual automation
B) Process automation
C) Automated testing
D) Workflow automation
Correct Option: B
Rationale: Scripting languages enable process automation by allowing repetitive tasks
and workflows to be automated through code.
Question 7
Which of the following is an example of unstructured data?
A) Social media posts
B) Relational database entries
C) Excel spreadsheets
D) System logs
Correct Option: A
Rationale: Social media posts are considered unstructured data because they do not
have a predefined format or schema.
