CompTIA Updated DA0-001 Exam Questions and Answers by georgi

A discrete data type is a data type that can only take on a finite number of values, such as integers or categories. An example of a discrete data type is the number of kids, as it can only be a whole number. The other options are examples of continuous data types, as they can take on any value within a range. The length in inches or centimeters, the distance in miles or kilometers, and the weight in pounds or kilograms are all continuous data types. Reference: CompTIA Data+ (DA0-001) Practice Certification Exams | Udemy

The best chart to use to identify the composition between the categories of the survey response data set is a pie chart. A pie chart is a circular chart that shows the relative proportions of different categories in a whole. A pie chart is divided into slices that represent the percentage or frequency of each category. A pie chart is suitable for displaying categorical data that has a few categories and does not have any hierarchical or temporal relationship. In this case, a pie chart can show the composition of the favorite colors among the survey respondents, as well as the percentage of each color. The other options are not as good as a pie chart for this purpose, as they are more suitable for displaying numerical data that has some kind of distribution, trend, correlation, or comparison. A histogram is a bar chart that shows the frequency distribution of a single numerical variable. A line chart is a chart that shows the change of one or more numerical variables over time or another continuous variable. A scatter plot is a chart that shows the relationship between two numerical variables by plotting them as points on a Cartesian plane. A waterfall chart is a chart that shows how an initial value is increased or decreased by a series of intermediate values, resulting in a final value. Reference: [Choosing the Right Chart Type - DataCamp]

The option that is not considered an aggregate function is SELECT. An aggregate function is a function that performs a calculation on a set of values and returns a single value. Examples of aggregate functions are SUM, MIN, MAX, AVG, COUNT, etc. SELECT is not an aggregate function, but a SQL command that is used to select data from a table or a query. Reference: SQL Aggregate Functions - W3Schools