DA0-002 Question #22: Real Exam Question with Answer & Explanation

The correct answer is B: Logical. To identify customers who made a purchase in January, a data professional should use logical functions. While date functions can extract the month, logical functions are essential for comparing that extracted month to a specific value like 'January'.

Data Analysis

Question

A data professional wants to identify all customers who made a purchase in January. Given the following table: Which of the following types of functions should the professional use to flag the customers?

Options

AStatistical
BLogical
CMathematical
DDate

Explanation

To identify customers who made a purchase in January, a data professional should use logical functions. While date functions can extract the month, logical functions are essential for comparing that extracted month to a specific value like 'January'.

Common mistakes.

A. Statistical functions are used for calculations like averages, sums, counts, or standard deviations, not for directly identifying records based on a specific month.
C. Mathematical functions perform arithmetic operations (e.g., addition, subtraction, multiplication), which are not directly used to identify records based on a month condition.
D. Date functions are used to extract parts of a date (like MONTH(), YEAR()) or perform date calculations, but a logical function is still required to compare the extracted month to 'January'.

Concept tested. Data filtering with logical functions

Reference. https://docs.microsoft.com/en-us/sql/t-sql/language-elements/logical-operators-transact-sql

Topics

#Logical functions#Conditional statements#Data filtering#Flagging data

Community Discussion

No community discussion yet for this question.

Full DA0-002 Practice Browse All DA0-002 Questions