solutions-architect-pro video for an investment firm collects daily stock trading data from exchanges and stores it in a data warehouse. The development team at
An investment firm collects daily stock trading data from exchanges and stores it in a data warehouse. The development team at the firm needs a solution that streams data directly into the data repository but should also allow SQL-based data modifications when needed. The solution should facilitate complex analytical queries that execute in the fastest possible time. The solution should also offer a business intelligence dashboard that highlights any stock price anomalies. Which of the following options represents the best solution for the given use case?