Explanation:
Option D is the correct solution because:
- Lowest cost and fewest steps - Feeding posts directly from source to API eliminates intermediate storage steps
- Cloud Storage for archiving - Raw posts can be stored in Cloud Storage for cost-effective archival and reprocessing
- BigQuery for analytics - Extracted data (topics, sentiment) goes to BigQuery for analysis and dashboard creation
- Dashboard sharing - BigQuery integrates well with Data Studio for sharing dashboards internally and externally
- Cost optimization - Cloud Storage is cheaper for raw data storage than BigQuery
- Reprocessing capability - Raw posts in Cloud Storage can be reprocessed if needed
Other options are less optimal:
- Option A: Storing raw posts in BigQuery is expensive for archival
- Option B: Cloud SQL is not designed for large-scale analytics
- Option C: Adds unnecessary step of storing raw posts before processing