01. Which three are prerequisites when enabling high availability of an existing standalone DB system?
a) The DB system must be active.
b) The region must have three available domains.
c) Crash recovery must be enabled.
d) All tables must have a primary key.
e) Point-in-time recovery is enabled.
f) All tables must have a foreign key.
02. You want to set up an inbound replication:
- The source MySQL server listens on a public IP address.
- The target DB system is placed in a private subnet of a VCN in your tenancy.
Which VCN setting is required?
a) The DB system subnet has a route rule pointing to the MySQL server IP address with a NAT gateway.
b) The DB system subnet has a route rule pointing to the MySQL server IP address with an internet gateway.
c) The DB system subnet has an ingress security rule that allows stateless connections from the MySQL server IP address.
d) The DB system subnet has an ingress security rule that allows stateful connections from the MySQL server IP address.
03. Which SQL statement grants all privileges to dba2 user on a DB system?
a) GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP ON *.* TO dba2 WITH GRANT OPTION;
b) GRANT administrator ON *.* TO dba2 WITH GRANT OPTION;
c) GRANT SUPER ON *.* TO dba2 WITH GRANT OPTION;
d) GRANT ALL ON *.* TO dba2 WITH GRANT OPTION;
04. Which two administrative SQL statements can you run on a DB system?
a) KILL 123; /* 123 is a connection id *\/
b) SET GLOBAL autocommit=OFF;
c) SHUTDOWN;
d) START REPLICA;
e) SET sort_buffer_size=1024000;
05. You export the data of a MySQL server with the MySQL Shell util.dumpInstance() method. Which option ensures that the exported data is compatible with a DB system?
a) dataOnly:true
b) ocimds: true
c) ociParManifest: true
d) dialect: csv
e) consistent: true
06. Which MySQL HeatWave AutoML routine creates a new model?
a) ML_TRAIN
b) ML_PREDICT
c) ML_SCORE
d) ML_EXPLAIN
e) ML_MODEL_LOAD
07. You create a Bastion server to connect to a DB system created with the default port numbers. Which two configurations are required on the subnet of the Bastion server?
a) Create an ingress rule that allows stateful connections on port 22.
b) Create an ingress rule that allows stateless connections on port 22.
c) Create an egress rule that allows stateful connections on port 3306 and 33060.
d) Create an ingress rule that allows stateful connections on port 3306 and 33060.
e) Create an egress rule that allows stateful connections on port 22.
08. You have created a custom configuration for MySQL HeatWave. Which two attributes can be changed after you saved the configuration?
a) Description
b) Compartment
c) System variables
d) Name
e) Initialization variables
09. What type of machine learning model do you use to predict whether a borrower will default on a loan payment?
a) Forecasting
b) Regression
c) Recommendation
d) Anomaly detection
e) Classification
10. A query is not offloaded to HeatWave cluster for execution. How do you determine the reason?
a) Use SHOW WARNINGS to view the notes after executing the query.
b) Use EXPLAIN to view the execution plan.
c) Use optimizer trace to view the detailed optimizer process.
d) Use SHOW WARNINGS to view the notes after explaining the query.
The Oracle MySQL HeatWave Implementation Associate Rel 1 (1Z0-915-1) Sample Question Set is designed to help you prepare for the Oracle MySQL HeatWave Implementation Certified Associate Rel 1 certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-915-1 Certification Practice Exam.