Data Processing Methods Grade 10

What is data cleaning?

• The process of organizing and structuring data in a dataset

• The process of analyzing and interpreting data in a dataset

• The process of collecting and gathering data for a dataset

• The process of identifying and correcting or removing errors, inconsistencies, and inaccuracies in datasets to improve their quality and reliability.

Which of the following is a data cleaning technique?

• Data analysis

• Data visualization

• Data integration

• Outlier detection and removal

What is data transformation?

• Process of converting data from one type to another

• Process of analyzing data to find patterns

• Process of storing data in a database

• Process of converting data from one format to another

Which of the following is a data transformation method?

• Filtering, sorting, aggregating, and joining

• Copying, pasting, cutting

• Merging, deleting, updating

• Searching, replacing, inserting

What is data filtering and sorting?

• Data filtering and sorting involve organizing data in a random order.

• Data filtering and sorting involve removing all data from a dataset.

• Data filtering and sorting involve rearranging data based on alphabetical order.

• Data filtering and sorting involve selecting a subset of data based on specific criteria and arranging it in a specific order.

Which of the following is a data filtering and sorting technique?

• Python

• Excel

• HTML

• SQL

What is data validation and verification?

• Data validation is the process of ensuring that data is accurate, complete, and consistent. Data verification is the process of confirming that the data has been accurately and correctly entered or processed.

• Data validation is the process of ensuring that data is organized and structured. Data verification is the process of confirming that the data has been reviewed and approved by a supervisor.

• Data validation is the process of ensuring that data is encrypted and secure. Data verification is the process of confirming that the data has been backed up and stored in multiple locations.

• Data validation is the process of ensuring that data is free from errors and inconsistencies. Data verification is the process of confirming that the data has been tested and validated by a third-party.

Which of the following is a data validation and verification method?

• Checksums and data validation rules

• Data backup and recovery

• Encryption and decryption

• Data compression

True or False: Data cleaning is the process of removing errors and inconsistencies from data.

• Data cleaning is not necessary

• False

• Data cleaning only removes duplicates

• True

True or False: Data transformation involves converting data into a different format.

• False

• Data transformation is not a real thing

• True

• Data transformation involves deleting data