NEW
Font size
WorksheetsFPBA1014 Chapter 2 Quiz
Total questions: 15
Worksheet time: 8mins
What is structured data?
Data without any organization or format.
Data organized in a specific format, typically using tables with rows and columns.
Data that is partially organized and partially chaotic.
Data with a flexible and evolving structure.
Which of the following is an example of structured data?
An Excel spreadsheet with columns for Name, Age, and Address.
A collection of social media posts.
A series of unformatted text documents.
A set of emails from different senders.
What are the characteristics of unstructured data?
Clearly defined and organised format.
Semi-organised, containing some structure.
Lacks a predefined data model, making it more challenging to analyse.
Highly regulated and standardised.
Which of the following is an example of unstructured data?
Database records in a relational database.
Free-form text documents, videos, audio and photos.
XML files with labeled elements.
Spreadsheets with rows and columns.
What is semi-structured data?
Data that is entirely chaotic and unorganized.
Data that has a well-defined structure but is not organized.
Data that is exclusively numerical.
Data with a bit of structure but not as rigid as in a relational database.
Which of the following is an example of semi-structured data?
CSV file containing sales transaction records.
JSON file with nested key-value pairs.
A list of customer names in alphabetical order.
A well-formatted table in a relational database.
An analyst identifies and collects the data that they need to perform data mining. They will then try to understand how the data can help them solve their business problems before beginning any analysis. Which part of the data mining process is this?
Data understanding
Data preparation
Modelling
Deployment
An analyst "cleans up" the data that has been collected; they will identify missing values, remove duplicate records, and standardise formats. Once this is done, the data is then ready for further analysis. Which part of the data mining process is this?
Data understanding
Data preparation
Modelling
Evaluation
An analyst selects a data mining technique to apply to the data already collected. From there, they then design a model that helps in description or prediction of the data, the model will be used to solve business problems. Which part of the data mining process is this?
Data understanding
Data preparation
Modelling
Evaluation
An analyst uses a data mining model that has predictive ability to help solve a business' problem on predicting what customers like to buy. Which part of the data mining process is this?
Data preparation
Modelling
Evaluation
Deployment
An analyst reviews all previous steps that were done to see if any important activities are missing or if any important data was not used. Which part of the data mining process is this?
Data preparation
Modelling
Evaluation
Deployment
What is a relational database?
A collection of unstructured data stored in a single file.
A system for organizing and storing data in tables with relationships between them.
A type of programming language used for web development.
A software tool for creating graphical user interfaces.
What are SQL-based systems?
Software tools for graphic design and animation.
Programming languages for artificial intelligence.
Systems designed for organizing and managing structured data using SQL.
Which tool or software is used to manage unstructured data?
Microsoft Excel
Google Sheets
Relational Database Management Systems (RDBMS)
Hadoop
Which of the following is NOT a challenge that data mining has?
Artificial intelligence is able to assist data mining by uncovering and explaining the hidden patterns that humans are unable to see.
Poor data quality will result in data mining outputs that cannot be trusted.
Some data have high levels of complexity that require deep understanding to be used effectively.
The users' security and privacy of data needs to be protected.
