ExamDumpster
Sign in

Free 1Z0-915-1 sample questions

Real questions from the MySQL HeatWave Implementation practice bank, with the correct answer and an explanation for each one. No junk, no filler.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 8 of 17 free sample questions.

Question 1Choose one

Which of the following statements accurately describes the difference between dynamic and non-dynamic variables in a MySQL HeatWave configuration? graph TD A[Configuration Change] --> B{Restart Required?} B -->|Yes| C[Non-Dynamic Variable] B -->|No| D[Dynamic Variable] C --> E[Change applied after DB System restart] D --> F[Change applied immediately]

Question 2Choose 2

You can perform a node estimate when adding a HeatWave cluster to a DB system in OCI Console. Which two tasks are performed by the node estimate process? (Choose two.) A.Generate a load command to activate Auto Parallel Load.B.Estimate the number of OCPUs required to process selected user tables.C.Estimate the memory required for each user table.D.Generate a set of ALTER statements to load selected tables into the HeatWave cluster.E.Estimate the disk storage required for each user table.

Question 3Choose one

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.

Question 4Choose one

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.

Question 5Choose 2

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

Question 6Choose 2

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.

Question 7Choose 2

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

Question 8Choose one

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.

9 more free samples are waiting

Create a free account to unlock the whole 1Z0-915-1 sample bank, or get full access to all 239 practice questions in the simulator.

Create account