When migrating a MySQL instance to MySQL HeatWave, which method generally provides the MINIMAL downtime for large databases?

1. A. Using mysqldump to create a logical backup and restoring it to the HeatWave instance.
2. B. Creating a physical backup using MySQL Enterprise Backup and restoring it to the HeatWave instance.
3. C. Utilizing MySQL replication to replicate data to the HeatWave instance and then performing a switchover.
4. D. Copying the data files directly from the source instance to the HeatWave instance.
5. E. Using a third-party ETL tool to extract, transform, and load the data into the HeatWave instance.

Correct Answer: C

When provisioning a Base Database Service (BaseDB) virtual machine (VM) instance in Oracle Cloud Infrastructure (OCI), which of the following actions MUST be performed before launching the DB system?

1. A. Configuring the Data Guard association between the VM and a standby database.
2. B. Creating a backup policy for the database being provisioned.
3. C. Creating a Virtual Cloud Network (VCN) with appropriate subnets and security rules.
4. D. Configuring Oracle GoldenGate replication.

Correct Answer: C

Which statement BEST describes the primary architectural distinction between Exadata Database Service and a traditional Oracle Database deployed on virtual machines in the cloud?

1. A. Exadata Database Service utilizes only virtualized compute nodes, while traditional deployments use bare metal.
2. B. Exadata Database Service integrates specialized, high-performance storage servers and a high-bandwidth, low-latency RDMA over Converged Ethernet (RoCE) network, optimized for database workloads, which are not present in typical cloud VM deployments.
3. C. Exadata Database Service exclusively supports Oracle RAC, while traditional cloud deployments can support both single-instance and RAC databases.
4. D. Exadata Database Service uses a completely different SQL parsing engine compared to a traditional Oracle Database.

Correct Answer: B

A critical query running on your HeatWave cluster is experiencing significant performance degradation. Which tool or service should you use to identify and analyze the specific query causing the bottleneck?

1. A. OCI Vault for auditing query execution.
2. B. OCI Events for tracking query start and end times.
3. C. MySQL Slow Query Log and OCI Logging Analytics.
4. D. OCI Network Visualizer for analyzing network latency.
5. E. OCI Bastion for secure access to the query execution environment.

Correct Answer: C

In the context of BaseDB Database Lifecycle Management, what is the primary purpose of a "pre-check" utility before applying a patch or upgrading the database?

1. A. To automatically back up the database before the patch or upgrade.
2. B. To determine if the patch or upgrade is compatible with the existing database environment and identify potential conflicts.
3. C. To install the patch or upgrade in a test environment for validation.
4. D. To optimize the database performance after the patch or upgrade.
5. E. To migrate data to a different storage tier.

Correct Answer: B