1Z0-915-1 sample questions

Question 1

What must you do before deleting a DB system? A.Take a manual backup.B.Stop the instance if it is running.C.Disable delete protection if it is enabled.D.Stop and remove any connected HeatWave Cluster.

Accepted Answer

Disable delete protection if it is enabled.

Answer

Take a manual backup.

Answer

Stop the instance if it is running.

Answer

Stop and remove any connected HeatWave Cluster.

Question 2

You want to create a new DB system with data import. How do you prepare the data? A.Export the data into the file system with a MySQL Shell dump utility.B.Export the data into an Object Storage bucket with a MySQL Shell dump utility.C.Back up the database into an Object Storage bucket with MySQL Enterprise Backup.D.Export the data into the file system with the mysqldump client utility.

Accepted Answer

Export the data into an Object Storage bucket with a MySQL Shell dump utility.

Answer

Export the data into the file system with a MySQL Shell dump utility.

Answer

Back up the database into an Object Storage bucket with MySQL Enterprise Backup.

Answer

Export the data into the file system with the mysqldump client utility.

Question 3

Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.) A.High availabilityB.MySQL LakehouseC.Standalone serverD.Read replicaE.HeatWave cluster

Accepted Answer

High availability

Accepted Answer

Standalone server

Answer

MySQL Lakehouse

Answer

Read replica

Answer

HeatWave cluster

Question 4

You want to train a classification model with MySQL HeatWave AutoML. Which two are requirements of the training data set? (Choose two.) A.The target column must be numeric.B.The target column and all feature columns must be stored in a single table.C.All feature columns must be numeric.D.There must be at least two feature columns.E.The target column must have at least two distinct values.

Accepted Answer

The target column and all feature columns must be stored in a single table.

Accepted Answer

The target column must have at least two distinct values.

Answer

The target column must be numeric.

Answer

All feature columns must be numeric.

Answer

There must be at least two feature columns.

Question 5

You want to connect to a DB system with MySQL Shell.DB system endpoint IP address: 10.0.1.221Username: admin -Password: MySQL8.0 -Which two commands work? (Choose two.) A.mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0B.mysqlsh mysql://MySQL8.0:admin@10.0.1.221C.mysqlsh mysql://admin:MySQL8.0@10.0.1.221D.mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0E.mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

Accepted Answer

mysqlsh mysql://admin:MySQL8.0@10.0.1.221

Accepted Answer

mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

Answer

mysqlsh -h 10.0.1.221 -u admin -p MySQL8.0

Answer

mysqlsh mysql://MySQL8.0:admin@10.0.1.221

Answer

mysqlsh -h10.0.1.221 -uadmin -pMySQL8.0

Question 6

Which sequence of steps must you perform to change the configuration of a high-availability DB system? A.Disable high availability, edit the DB system, change the configuration, and enable high availability.B.Stop the DB system, edit the DB system, change the configuration, and start the DB system.C.Edit and change the configuration of all secondary instances, switch over to a secondary instance, and edit and change the configuration of the former primary instance.D.Edit the DB system and change the configuration.

Accepted Answer

Edit and change the configuration of all secondary instances, switch over to a secondary instance, and edit and change the configuration of the former primary instance.

Answer

Disable high availability, edit the DB system, change the configuration, and enable high availability.

Answer

Stop the DB system, edit the DB system, change the configuration, and start the DB system.

Answer

Edit the DB system and change the configuration.

Question 7

Why would you select "Source cannot use GTID auto-positioning" when creating a channel? A.The target DB system is a high-availability DB system.B.Some tables have no primary key.C.The binary log offset is unknown.D.The source gtid_mode is OFF.

Accepted Answer

The source gtid_mode is OF

Answer

The target DB system is a high-availability DB system.

Answer

Some tables have no primary key.

Answer

The binary log offset is unknown.

Question 8

A global financial institution is architecting a MySQL HeatWave solution for their fraud detection system. The system requires real-time analysis of transaction data occurring in the OLTP database combined with historical logs stored in OCI Object Storage. The Chief Data Officer requires a solution that minimizes data movement costs and latency while maintaining a unified security model. Which architectural approach best meets these requirements?

Accepted Answer

Deploy MySQL HeatWave Lakehouse, enabling the cluster to query data in InnoDB and files in Object Storage simultaneously without ETL.

Answer

Implement a hybrid architecture using MySQL HeatWave for OLTP and OCI Data Flow for historical logs, using OCI GoldenGate to sync data between them.

Answer

Provision a separate Autonomous Data Warehouse for historical logs and use Database Links to query the MySQL OLTP instance.

Answer

Configure Inbound Replication to sync Object Storage data into the MySQL HeatWave cluster's InnoDB storage engine.

Free 1Z0-915-1 sample questions

What must you do before deleting a DB system? A.Take a manual backup.B.Stop the instance if it is running.C.Disable delete protection if it is enabled.D.Stop and remove any connected HeatWave Cluster.

Which two are available when creating a new MySQL DB system in OCI Console? (Choose two.) A.High availabilityB.MySQL LakehouseC.Standalone serverD.Read replicaE.HeatWave cluster

Why would you select "Source cannot use GTID auto-positioning" when creating a channel? A.The target DB system is a high-availability DB system.B.Some tables have no primary key.C.The binary log offset is unknown.D.The source gtid_mode is OFF.

9 more free samples are waiting