MySQL HeatWave Implementation Free Sample Questions

Description

Covers MySQL HeatWave architecture, provisioning and connecting DB systems, backup and point-in-time recovery, read replicas and inbound replication, data migration, availability, and HeatWave AutoML.

17 free sample questions239 in the full practice test

Try simulator

1Z0-915-1 Sample Questions

  1. Question 1

    Intermediate

    MySQL HeatWave Configurations · Describe the effects of changing dynamic and non-dynamic variables

    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]

    Answer and explanation

    Correct answer: D

    In MySQL, system variables are categorized as either dynamic or non-dynamic. A change to a dynamic variable takes effect immediately while the server is running. A change to a non-dynamic variable, which often affects fundamental aspects like storage engine configuration or buffer sizes, requires the MySQL server instance (the DB System) to be restarted before the new value is applied.

  2. Question 2

    IntermediateMultiple answers

    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.

    Answer and explanation

    Correct answers: B, C

  3. Question 3

    Intermediate

    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.

    Answer and explanation

    Correct answer: C

  4. Question 4

    Intermediate

    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.

    Answer and explanation

    Correct answer: B

  5. Question 5

    IntermediateMultiple 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

    Answer and explanation

    Correct answers: A, C

  6. Question 6

    IntermediateMultiple answers

    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.

    Answer and explanation

    Correct answers: B, E

  7. Question 7

    IntermediateMultiple answers

    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

    Answer and explanation

    Correct answers: C, E

  8. Question 8

    Intermediate

    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.

    Answer and explanation

    Correct answer: C

Register free for 9 more questions

Or unlock all 239 1Z0-915-1 questions with explanations, timed mode and flashcards.