A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

• A.Concatenate
• B.Delimit
• C.Append
• D.Merge

Comment: *

Name: *

Email: *

Verification: *

An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?

• A.Scatter plot
• B.Heat map
• C.Pie chart
• D.Infographic

Comment: *

Name: *

Email: *

Verification: *

Which of the following descriptive statistical methods are measures of central tendency? (Choose two.)

• A.Mean
• B.Minimum
• C.Mode
• D.Variance
• E.Correlation
• F.Maximum

Comment: *

Name: *

Email: *

Verification: *

Which one of the following values will appear first if they are sorted in descending order?

• A.Aaron.
• B.Molly.
• C.Xavier.
• D.Adam.

Comment: *

Name: *

Email: *

Verification: *

Which of the following data manipulation techniques is an example of a logical function?

• A.WHERE
• B.AGGREGATE
• C.BOOLEAN
• D.IF

Correct Answer: D

Explanation
This is because an IF function is a type of logical function that returns a value based on a condition or a set of conditions. An IF function can be used to manipulate data by applying different actions or calculations depending on whether the condition is true or false. For example, an IF function in Excel that can achieve this is:
=IF (condition, value_if_true, value_if_false)
The other data manipulation techniques are not examples of logical functions. Here is why:
WHERE is a type of clause that filters data based on a condition or a set of conditions. A WHERE clause can be used to manipulate data by selecting only the rows that satisfy the condition(s). For example, a WHERE clause in SQL that can achieve this is:

AGGREGATE is a type of function that performs a calculation on a group of values, such as sum, average, count, etc. An AGGREGATE function can be used to manipulate data by summarizing or aggregating the values in a column or a table. For example, an AGGREGATE function in SQL that can achieve this is:

BOOLEAN is a type of data type that represents two possible values: true or false. A BOOLEAN data type can be used to manipulate data by storing or returning logical values based on a condition or a set of conditions. For example, a BOOLEAN data type in Python that can achieve this is:

Comment: *

Name: *

Email: *

Verification: *