D467 - Exploring Data

Question 41: What is the purpose of the MAX function in a spreadsheet?

Returns the largest numeric value in a range

Returns the smallest numeric value in a range

Filters data based on specified criteria

Counts the number of non-blank cells in a range

Question 42: What is "sampling error" in statistics?

The error caused by analyzing only a portion of the population

The error caused by incorrect data entry

The error caused by missing values in a dataset

The error caused by data bias in the sample

Question 43: In SQL, what is the function of the GROUP BY clause?

Filters records based on specified conditions

Groups records that have the same values in specified columns

Combines two or more tables into one

Deletes duplicate records from a result set

Question 44: In data ethics, what does the principle of "privacy" ensure?

Data must be encrypted before being transmitted

Individuals have the right to control how their personal data is collected and used

Data must be anonymized before analysis

Data must be shared with authorized users only

Question 45: What is "external data" in data analysis?

Data that is collected from an organization's internal systems

Data that is generated and stored outside of an organization

Data that is structured in rows and columns

Data that is used for internal decision-making only

Question 46: What is the purpose of the SQL JOIN clause?

To combine rows from two or more tables based on related columns

To filter records based on specified conditions

To delete duplicate records from a result set

To convert data from one type to another

Question 47: What is "data visualization"?

The graphical representation of data

The process of anonymizing sensitive data

The conversion of text data to numeric data

The filtering of records based on specified conditions

Question 48: In a database, what is the function of a "foreign key"?

Uniquely identifies each record in a table

Links records in one table to records in another table

Converts data from one type to another

Filters records based on specific criteria

Question 49: What does the term "hypothesis testing" refer to in statistics?

A method for determining whether the results of a survey or experiment are meaningful

A process for calculating the mean of a dataset

A way to identify outliers in a dataset

A method for sorting records in a database

Question 50: In data analysis, what is "compatibility"?

The ability of two or more datasets to work together effectively