The first query has an estimated cost of 100,000,000 and is offloaded to a HeatWave...

Oracle 1z0-915-1 Question Answer

The first query has an estimated cost of 100,000,000 and is offloaded to a HeatWave cluster for execution:

SELECT flightno, departure, country FROM flight JOIN airport_geo ON ‘from’=airport_id;

The second query has an estimated cost of 10,000 and is NOT offloaded to the Heatwave cluster for execution:

SELECT DISTINCT country FROM airport_geo ORDER BY country;

Which two methods can offload the second query to the Heatwave cluster for execution? (Choose two.)

SET use_secondary_engine=FORCED;

SET secondary_engine_cost_threshold=1000;

SET optimizer_trace=”enabled=on”;

CALL sys.heatwave_load(‘[“airport_geo”]’);

CALL sys.heatwave_advisor(JSON_OBJECT(“auto_enc”, JSON_OBJECT(“mode”, “recommend”)));

Oracle 1z0-915-1 Summary

Price: $52.5 ~~$149.99~~