For a use case where a data scientist needs to run occasional ad-hoc queries joining watsonx.data tables with a live IBM Db2 operational database; which integration approach is most appropriate?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Data virtualization is ideal for occasional federated queries — no ETL pipeline or data duplication is needed; Presto's JDBC connector queries Db2 at runtime; keeping data fresh and eliminating the overhead of a nightly ETL job.
Full explanation below image
Full Explanation
Data virtualization is ideal for occasional federated queries — no ETL pipeline or data duplication is needed; Presto's JDBC connector queries Db2 at runtime; keeping data fresh and eliminating the overhead of a nightly ETL job. The incorrect options ("Run nightly ETL to copy Db2 data into an Iceberg table", "Export Db2 data to CSV and manually upload it to watsonx.data", "Replicate the entire watsonx.data lakehouse into Db2 for consolidated access") are distractors that don't fully capture the concept described.