50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.
0/50 answered0 correct
Question 1 of 50
What is "data anonymization"?
Correct answer: A) Removing personally identifiable information from a dataset
Explanation: Data anonymization is the process of protecting individuals' privacy by removing personally identifiable information from a dataset, ensuring that the data cannot be traced back to a specific individual.
Question 2 of 50
Which of the following is a characteristic of unstructured data?
Correct answer: C) It may have an internal structure but is not organized in a predefined way
Explanation: Unstructured data does not fit neatly into a predefined structure, such as rows and columns. Examples include images, videos, and social media posts.
Question 3 of 50
What is the function of the CONCATENATE formula in a spreadsheet?
Correct answer: A) Joins together two or more text strings
Explanation: CONCATENATE is a spreadsheet function that combines two or more text strings into one, often used to create unique identifiers or labels.
Question 4 of 50
What does the SQL DISTINCT keyword do in a query?
Correct answer: A) Removes duplicate rows from the result set
Explanation: The DISTINCT keyword in SQL is used to eliminate duplicate records from the result set, ensuring that only unique values are returned.
Question 5 of 50
What type of data is best described as "qualitative"?
Correct answer: C) Data that describes qualities or characteristics
Explanation: Qualitative data refers to non-numerical information that describes qualities or characteristics, such as color, texture, or opinions.
Question 6 of 50
Which SQL function can be used to calculate the total sum of a column's values?
Correct answer: B) SUM
Explanation: The SUM function in SQL calculates the total sum of values in a specified column, often used for numerical data.
Question 7 of 50
In the context of data ethics, what does the principle of "openness" refer to?
Correct answer: A) The free access, use, and sharing of data
Explanation: Openness in data ethics promotes the free access, use, and sharing of data, often associated with open data initiatives.
Question 8 of 50
What does the SQL WHERE clause do?
Correct answer: B) Filters records based on specified conditions
Explanation: The WHERE clause is used in SQL to filter records based on specified conditions, ensuring that only records meeting the criteria are returned.
Question 9 of 50
What is a "cookie" in the context of online data?
Correct answer: A) A small file stored on a computer that contains information about the user
Explanation: A cookie is a small file stored on a user's computer by websites, containing information about the user's activities and preferences.
Question 10 of 50
In a dataset, what is a "population"?
Correct answer: B) All possible data values in a dataset
Explanation: A population in data analytics refers to the entire set of data points or individuals that are being studied or analyzed.
Question 11 of 50
What is the purpose of the SQL CAST function?
Correct answer: A) To convert data from one data type to another
Explanation: The CAST function in SQL is used to convert a value from one data type to another, such as converting a string to a number.
Question 12 of 50
What does the term "data bias" refer to?
Correct answer: C) A systematic preference in data collection or analysis that skews the results
Explanation: Data bias occurs when certain groups, preferences, or outcomes are overrepresented or underrepresented in data collection or analysis, leading to skewed results.
Question 13 of 50
What does the COUNT function do in SQL?
Correct answer: B) Counts the number of non-null values in a column
Explanation: The COUNT function in SQL returns the number of non-null values in a specified column, often used to count the number of rows or entries in a table.
Question 14 of 50
What is the purpose of the TRIM function in a spreadsheet?
Correct answer: A) Removes leading and trailing spaces from text
Explanation: The TRIM function removes any extra spaces from the beginning and end of a text string, ensuring data consistency in spreadsheets.
Question 15 of 50
In data ethics, what is the principle of "ownership"?
Correct answer: B) Individuals who create data own the data and control its use
Explanation: The principle of ownership in data ethics asserts that individuals who create data have control over how it is used, shared, and processed.
Question 16 of 50
Which SQL function is used to return only non-null values?
Correct answer: C) COALESCE
Explanation: The COALESCE function returns the first non-null value in a list of expressions, making it useful for handling missing data.
Question 17 of 50
What is a "primary key" in a relational database?
Correct answer: A) A field that uniquely identifies each record in a table
Explanation: A primary key is a unique identifier for each record in a relational database, ensuring that no two records are identical.
Question 18 of 50
In a spreadsheet, what does the COUNTA function do?
Correct answer: B) Counts the total number of non-blank cells in a range
Explanation: COUNTA counts the number of non-blank cells in a specified range, including both text and numeric values.
Question 19 of 50
What is the purpose of the SQL INSERT INTO statement?
Correct answer: B) To add new records to a table
Explanation: The INSERT INTO statement in SQL is used to insert new rows of data into a specified table.
Question 20 of 50
What is the definition of "metadata"?
Correct answer: A) Data that describes other data
Explanation: Metadata is information that provides details about other data, such as the structure, source, or attributes of a dataset.
Question 21 of 50
In SQL, what is the purpose of the CASE statement?
Correct answer: B) To implement conditional logic within a query
Explanation: The CASE statement in SQL allows for conditional logic within queries, enabling different results based on specified conditions.
Question 22 of 50
What is the function of the LEN formula in a spreadsheet?
Correct answer: A) Counts the number of characters in a text string
Explanation: The LEN function counts the number of characters in a text string, including spaces and punctuation, useful for data validation and formatting.
Question 23 of 50
What is the purpose of the INTERSECT operator in SQL?
Correct answer: A) Combines the result sets of two queries and returns only the common records
Explanation: The INTERSECT operator in SQL returns only the records that appear in both result sets of two queries, ensuring that only common data is included.
Question 24 of 50
What is the primary function of a "pivot table" in a spreadsheet?
Correct answer: B) Summarizes, organizes, and analyzes large datasets
Explanation: A pivot table allows users to summarize, reorganize, and analyze large datasets in a spreadsheet, providing insights into the data.
Question 25 of 50
What is the significance of a confidence interval in statistics?
Correct answer: A) It represents the range in which the true population parameter is likely to fall
Explanation: A confidence interval provides an estimated range that is likely to contain the true value of a population parameter, based on sample data.
Question 26 of 50
What is "cross-field validation" in data analysis?
Correct answer: A) A process to ensure multiple data fields meet specific conditions
Explanation: Cross-field validation checks that data in multiple fields meet specified conditions, ensuring accuracy and consistency across different fields in a dataset.
Question 27 of 50
In data ethics, what does the principle of "transaction transparency" ensure?
Correct answer: A) Individuals have the right to understand how their data is processed and used
Explanation: Transaction transparency ensures that individuals know how their data is collected, processed, and shared, promoting ethical data practices.
Question 28 of 50
What does the SQL ORDER BY clause do?
Correct answer: B) Sorts records in ascending or descending order
Explanation: The ORDER BY clause in SQL is used to sort the result set in either ascending or descending order based on one or more columns.
Question 29 of 50
What does the COUNTIF function do in a spreadsheet?
Correct answer: A) Counts the number of cells that meet a specific condition
Explanation: The COUNTIF function counts the number of cells within a specified range that meet a given condition, such as a value being greater than a specified number.
Question 30 of 50
In data analysis, what is "sampling bias"?
Correct answer: A) Overrepresentation or underrepresentation of certain members of a population
Explanation: Sampling bias occurs when certain groups or individuals are overrepresented or underrepresented in a sample, leading to skewed or inaccurate results.
Question 31 of 50
What does the LEFT function do in a spreadsheet?
Correct answer: A) Returns a set number of characters from the left side of a text string
Explanation: The LEFT function extracts a specified number of characters from the left side of a text string in a spreadsheet.
Question 32 of 50
In SQL, what is the function of the HAVING clause?
Correct answer: A) Filters records based on aggregate functions
Explanation: The HAVING clause in SQL is used to filter records based on the result of aggregate functions, such as SUM or COUNT, after the GROUP BY clause.
Question 33 of 50
What does the SQL SUBSTR function do?
Correct answer: A) Extracts a substring from a string variable
Explanation: The SUBSTR function extracts a specified portion of a string variable, starting at a given position and optionally ending at a specified length.
Question 34 of 50
In a dataset, what does "standard deviation" measure?
Correct answer: C) The spread or variability of data around the mean
Explanation: Standard deviation measures how much the values in a dataset deviate from the mean, providing insight into the variability or spread of the data.
Question 35 of 50
What is a "data warehouse"?
Correct answer: A) A centralized repository for storing large volumes of data
Explanation: A data warehouse is a large, centralized repository that stores and manages vast amounts of data from multiple sources, often used for reporting and analysis.
Question 36 of 50
What is "confirmation bias" in data analysis?
Correct answer: A) The tendency to search for information that confirms pre-existing beliefs
Explanation: Confirmation bias occurs when individuals seek out or interpret information in a way that supports their existing beliefs, leading to skewed data analysis.
Question 37 of 50
What does the SQL keyword SELECT do?
Correct answer: B) Retrieves data from a database
Explanation: The SELECT statement is used in SQL to retrieve data from one or more tables, specifying which columns to return.
Question 38 of 50
In a spreadsheet, what is the function of the FIND and REPLACE tool?
Correct answer: A) Searches for a specific value and replaces it with another value
Explanation: The FIND and REPLACE tool searches for a specified value or text string in a spreadsheet and replaces it with another value, saving time when editing data.
Question 39 of 50
In the context of a relational database, what is "normalization"?
Correct answer: A) A process for eliminating data redundancy and improving data integrity
Explanation: Normalization is a database design technique used to eliminate redundancy, improve data integrity, and optimize the structure of a relational database.
Question 40 of 50
In data analysis, what is the purpose of a "sample"?
Correct answer: A) To represent a subset of a population
Explanation: A sample is a subset of a population, used in data analysis to draw conclusions or make predictions about the entire population without analyzing every individual.
Question 41 of 50
What is the purpose of the MAX function in a spreadsheet?
Correct answer: A) Returns the largest numeric value in a range
Explanation: The MAX function returns the largest value from a specified range of cells, often used to find the maximum number in a dataset.
Question 42 of 50
What is "sampling error" in statistics?
Correct answer: A) The error caused by analyzing only a portion of the population
Explanation: Sampling error is the difference between the results obtained from a sample and the true values of the entire population, caused by analyzing only a portion of the population.
Question 43 of 50
In SQL, what is the function of the GROUP BY clause?
Correct answer: B) Groups records that have the same values in specified columns
Explanation: The GROUP BY clause in SQL is used to group records that have the same values in specified columns, allowing for aggregate functions to be applied to each group.
Question 44 of 50
In data ethics, what does the principle of "privacy" ensure?
Correct answer: B) Individuals have the right to control how their personal data is collected and used
Explanation: The principle of privacy in data ethics ensures that individuals have control over how their personal data is collected, used, and shared.
Question 45 of 50
What is "external data" in data analysis?
Correct answer: B) Data that is generated and stored outside of an organization
Explanation: External data refers to data that is collected and stored outside of an organization, often used to supplement internal data for analysis.
Question 46 of 50
What is the purpose of the SQL JOIN clause?
Correct answer: A) To combine rows from two or more tables based on related columns
Explanation: The JOIN clause in SQL is used to combine rows from two or more tables based on related columns, allowing for more comprehensive queries.
Question 47 of 50
What is "data visualization"?
Correct answer: A) The graphical representation of data
Explanation: Data visualization involves creating graphical representations of data, such as charts, graphs, and dashboards, to make data easier to understand and analyze.
Question 48 of 50
In a database, what is the function of a "foreign key"?
Correct answer: B) Links records in one table to records in another table
Explanation: A foreign key in a relational database is a field that creates a relationship between two tables by linking records in one table to records in another.
Question 49 of 50
What does the term "hypothesis testing" refer to in statistics?
Correct answer: A) A method for determining whether the results of a survey or experiment are meaningful
Explanation: Hypothesis testing is a statistical method used to determine if the results of a survey or experiment are meaningful or if they occurred by chance.
Question 50 of 50
In data analysis, what is "compatibility"?
Correct answer: A) The ability of two or more datasets to work together effectively
Explanation: Compatibility refers to the ability of different datasets to work together, often achieved by ensuring that the data is in a compatible format for analysis.
Set 4 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).