Permitting remains authoritative in a departmental SQL system while a Big Data platform will power citywide analytics. How should the architecture integrate them?
Select an answer to reveal the explanation.
Short Explanation
The SQL permitting system still owns the truth for clerks. The lake should sync that truth for analytics—not pretend HDFS suddenly became the cash register.
Full Explanation
Hybrid architectures keep operational systems of record while landing or synchronizing data into Big Data layers for scale analytics. Blindly replacing an authoritative permitting RDBMS with lake files breaks transactional workflows and accountability. Integration patterns—CDC, batch extracts, APIs—preserve the SQL system’s role while enabling broader analytical use.