When using the OCI Console, which two options are configurable during the initial provisioning of a MySQL HeatWave DB system?

1. A. The number of HeatWave nodes.
2. B. The MySQL version.
3. C. The character set for the database.
4. D. The storage size for the database.
5. E. The name of the initial database user.

Correct Answer: AB

Which statement accurately describes the inherent trade-offs often associated with choosing a NoSQL database over a traditional relational database?

1. A. NoSQL databases universally guarantee stronger data consistency than relational databases, but at the expense of increased operational complexity.
2. B. NoSQL databases typically sacrifice strict data consistency (ACID) to gain horizontal scalability and higher availability.
3. C. NoSQL databases offer superior data integrity and reduced operational overhead compared to relational databases, making them ideal for transactional systems.
4. D. NoSQL databases provide simplified querying capabilities using standard SQL, enhancing developer productivity and reducing the learning curve.

Correct Answer: B

What is the primary purpose of the AutoML feature within MySQL HeatWave?

1. A. To automatically tune the MySQL server parameters for optimal transactional performance.
2. B. To automate the process of building, training, and deploying machine learning models directly within the database.
3. C. To automatically generate SQL queries based on natural language input.
4. D. To automatically back up and restore the MySQL database to Oracle Cloud Infrastructure Object Storage.
5. E. To automatically generate data visualization to present database insights.

Correct Answer: B

What role does the Exadata Storage Server Software play within the Exadata Database Service architecture?

1. A. It manages the virtual machines hosting the database instances.
2. B. It provides the operating system and management software for the database servers.
3. C. It provides intelligent storage capabilities, including data filtering, compression, and encryption.
4. D. It acts as a load balancer distributing connections across the database instances.

Correct Answer: C

Which of the following is a proactive strategy to avoid encountering table rate limits in Oracle NoSQL Database Cloud Service?

1. A. Regularly increasing the table's storage capacity to accommodate future growth.
2. B. Carefully designing the table schema and indexes to optimize query performance and minimize the number of read/write operations required.
3. C. Disabling data encryption to reduce the overhead of read/write operations.
4. D. Consolidating all data into a single large table to simplify management.

Correct Answer: B