To query a PostgreSQL database from Presto in watsonx.data without moving data; what must be configured?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Data virtualization in watsonx.data requires registering the external database as a JDBC data source connection; Presto then uses the JDBC connector to push down queries to PostgreSQL without data movement.
Full explanation below image
Full Explanation
Data virtualization in watsonx.data requires registering the external database as a JDBC data source connection; Presto then uses the JDBC connector to push down queries to PostgreSQL without data movement. The incorrect options ("A Spark streaming job that replicates PostgreSQL changes to an Iceberg table", "An IBM DataStage job that exports PostgreSQL tables to CSV", "A new Presto engine dedicated exclusively to relational database queries") are distractors that don't fully capture the concept described.