Which of the following statements accurately describes the difference between dynamic and non-dynamic variables in a MySQL HeatWave configuration? ```mermaid 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] ```
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.
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.
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.