Question 1
How can you determine the uptime of a DB system?
Correct Answer:
C. By querying performance_schema.global_status from a connected MySQL client
Free Oracle MySQL HeatWave Implementation Associate Rel 1 1Z0-915-1 Exam Questions
Question 2
You want to enable high availability of a stand-alone DB system. Which two conditions are required? (Choose two.)
Correct Answer:
D. The DB system must be active.; E. The DB system automatic backup must be enabled.
Question 3
You create a new MySQL DB system. It fails because you use mysql.sys as the administrator username.
What is the reason?
Correct Answer:
A. mysql.sys is a reserved username that cannot be used in customer-defined user accounts.
Question 4
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.)
Correct Answer:
A. SET use_secondary_engine=FORCED;; B. SET secondary_engine_cost_threshold=1000;
Question 5
You have a MySQL DB system with five active read replicas. The workload consists of 5% writes and 95% reads.
Which connection method provides the fastest query response time?
Correct Answer:
C. Connect to the read replica load balancer to perform read-only operations.
Question 6
A query is not offloaded to the HeatWave cluster for execution. Which three are possible reasons? (Choose three.)
Correct Answer:
A. The use_secondary_engine session variable is OFF.; C. The query estimated cost is less than the query cost threshold.; E. A required column is excluded from the RAPID secondary engine.
Question 7
Which type of configuration variables CANNOT be modified in MySQL custom configurations?
Correct Answer:
A. Initialization variables
Question 8
You want to import data into a DB system with MySQL Shell util.loadDump().
Which option can speed up the load?
Correct Answer:
C. skipBinlog: true
Question 9
Why would you select "Source cannot use GTID auto-positioning" when creating a channel?
Correct Answer:
D. The source gtid mode is OFF.
Question 10
You want to migrate an on-premises MySQL database to MySQL HeatWave by exporting the MySQL database with MySQL Shell util.dumpInstance.
What is the purpose of the ocimds: true option?
Correct Answer:
B. It enables all MySQL HeatWave compatibility options.