ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-915-1 All Questions

View all questions & answers for the 1z0-915-1 exam
Go to Exam

Exam 1z0-915-1 topic 1 question 21 discussion

Actual exam question from Oracle's 1z0-915-1
Question #: 21
Topic #: 1
[All 1z0-915-1 Questions]

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.)

  • A. SET use_secondary_engine=FORCED;
  • B. SET secondary_engine_cost_threshold=1000;
  • C. SET optimizer_trace=”enabled=on”;
  • D. CALL sys.heatwave_load(‘[“airport_geo”]’);
  • E. CALL sys.heatwave_advisor(JSON_OBJECT(“auto_enc”, JSON_OBJECT(“mode”, “recommend”)));
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️
by xylofivo at April 4, 2025, 3:25 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago