AI Associate Data for AI Practice Question
A dataset contains a 'date' column. Which feature engineering technique would best capture both long-term trends and seasonal patterns?
⚠ Common exam trap
Salesforce often tests whether candidates recognize that simple numeric extraction (e.g., month as 1–12) fails to model cyclical continuity, leading them to mistakenly choose Option A over the correct cyclic encoding.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create cyclic features (sin/cos of month, day).
Cyclic features using sine and cosine transformations preserve the circular nature of temporal data (e.g., month 12 and month 1 are adjacent, not far apart). This allows a model to learn both long-term trends (via the year component) and seasonal patterns (via the cyclic encoding of month and day) without imposing a false linear ordering. In contrast, simple numeric extraction treats time as linear, which can misrepresent seasonal cycles.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Extract year, month, day as separate features.
Why it's wrong here
This loses the cyclic nature of months and days (e.g., Dec and Jan are far apart numerically).
- ✗
Use only the day of week.
Why it's wrong here
This captures weekly seasonality but not long-term trends.
- ✓
Create cyclic features (sin/cos of month, day).
Why this is correct
Cyclic encoding preserves the periodic nature of time.
- ✗
Drop the date column.
Why it's wrong here
Dropping discards valuable temporal information.
Go deeper
Related to this question
About these practice questions
This AI Associate question is part of Courseiva's 753-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AI Associate practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AI Associate exam.