An online e-commerce shopping site offers money-saving promotions for different products every hour. A data analyst would like to review the sales of products two days prior in the afternoon . Which data type would they search for in their query of the sales data?
- Floating point
- Date and time
Answers Explanation & Hints:
In the given scenario, the data analyst is interested in reviewing the sales of products for a specific time period, which is “two days prior in the afternoon.” In order to extract the relevant data from the sales data, the data analyst would need to search for the data type that represents date and time information.
The date and time data type allows for storing and manipulating data that represents dates and times. By searching for this data type, the data analyst would be able to filter the sales data based on the specific time period of interest, which is two days prior in the afternoon. This would enable the analyst to focus on the data that is relevant to their analysis and ignore the data that is not relevant.