Data CloudIntermediatesegment-refreshschedulingoperations
Optimize segment refresh schedule against business calendar
Real World Scenario
500 segments refresh nightly causing credit spike and downstream activation failures when jobs overlap Black Friday campaign window.
Expected Answer
• Tier segments: real-time, hourly, daily, weekly by business criticality
• Stagger refresh windows to smooth compute load
• Freeze non-essential refreshes during peak campaign periods
• Dependency-aware scheduling: base insights before dependent segments
• Monitor job duration trends and fail early alerting
• Archive unused segments — zombie segments burn credits silently
• Align refresh to business timezone cutoffs for same-day campaigns
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Direct answer: Tier segments: real-time, hourly, daily, weekly by business criticality Also consider: Stagger refresh windows to smooth compute load In practice: Freeze non-essential refreshes during peak campaign periods Balance speed of delivery with maintainability.
Architect Perspective
Segment sprawl is operational debt — governance review quarterly to kill unused definitions.