1Z0-915-1 Sample Questions & Answers

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

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.

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:[email protected] mysql://admin:[email protected] -h10.0.1.221 -uadmin -pMySQL8.0E.mysqlsh -host 10.0.1.221 -user admin -password MySQL8.0

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.

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.

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?

You are consulting for a retail startup that fluctuates wildly in traffic. They are considering MySQL HeatWave versus a traditional Redshift solution. They need to handle both high-concurrency order processing and complex ad-hoc reporting on the same dataset. Which specific HeatWave capability should you highlight that addresses the performance of mixed workloads without manual intervention?

A DevOps engineer needs to perform emergency maintenance on a MySQL DB System located in a private subnet. Corporate security policy strictly forbids public IP addresses and VPN usage is currently unavailable due to a firewall outage. The engineer has access to the OCI Console. What is the most secure and immediate method to connect to the database?