D467 Exploring Data - Set 1 - Part 2

Correct Answer: TRIM

The TRIM function is used to remove any extra spaces from the beginning or end of a text string in SQL.

Correct Answer: Integer

An integer is a data type that stores whole numbers, whereas floats store decimal numbers, strings store text, and Booleans store true/false values.

Correct Answer: Line chart

Line charts are most effective for showing changes over time, such as sales trends or stock prices.

Correct Answer: GROUP BY

The GROUP BY clause groups rows that have the same values in specified columns into summary rows, often used with aggregate functions like COUNT or SUM.

Correct Answer: It removes duplicates from the result set

The DISTINCT keyword is used in SQL to return only unique values, eliminating any duplicate entries in the result set.

Correct Answer: COUNT

The COUNT function is used to return the total number of records in a dataset.

Correct Answer: To organize data in a table-like structure

A CSV (Comma-Separated Values) file is a common format for storing tabular data, where each value is separated by a comma.

Correct Answer: Data that represents categories without a specific order

Nominal data refers to categories that do not have a specific order or ranking, such as colors or types of animals.

Correct Answer: Median

The median is the middle value of a dataset when the data is arranged in order. If the dataset has an even number of values, the median is the average of the two middle values.

Correct Answer: Confirmation bias

Confirmation bias occurs when an individual favors information that confirms their pre-existing beliefs, leading to errors in data interpretation.

Correct Answer: Qualitative

Qualitative data is descriptive and non-numerical, often used to gather information about opinions or experiences, such as customer feedback.

Correct Answer: Data is owned by the individual who provides it

The principle of ownership in data ethics states that individuals have control over their own data and its usage, unless they provide consent otherwise.

Correct Answer: CAST

The CAST function is used in SQL to convert data from one datatype to another, such as converting a string to an integer.

Correct Answer: Ensure data is accurate, complete, and consistent

Data integrity refers to maintaining and ensuring the accuracy, consistency, and completeness of data throughout its lifecycle.

Correct Answer: Adds all the values in a column

The SUM function in SQL is used to calculate the total sum of a column's values.

Correct Answer: A value that lies significantly outside the range of other values

An outlier is a data point that differs significantly from other observations, possibly indicating an error or a special case.

Correct Answer: They organize data into tables

Relational databases organize data into tables (also called relations), where each table consists of rows and columns, making it easy to manage and retrieve information.

Correct Answer: Pivot table

A pivot table is used to summarize large datasets by grouping, sorting, and filtering data, allowing for easy analysis and visualization.

Correct Answer: MIN

The MIN function in SQL returns the smallest value from a specified column in a dataset.

Correct Answer: Managing the people, processes, and tools used in data analysis

Data governance is the framework for managing data, ensuring that it is accurate, secure, and used in compliance with organizational and legal standards.