1Z0-1093-25 practice question 6 of 15

Which two tools can you use to create a HeatWave MySQL Database Service System?

Full set: 99 questions
Answer options
A: OCI Console Correct answer
B: OCI Command Line Interface Correct answer
C: OCI Bastion Server
D: MySQL Shell on OCI Compute
E: OCI SQL Developer
Correct Answer:
A. OCI Console; B. OCI Command Line Interface
Explanation

The creation and management of Oracle Cloud Infrastructure (OCI) resources, such as a MySQL HeatWave Database Service System, are performed through OCI's control plane interfaces. The OCI Console is the primary web-based graphical user interface for provisioning and managing all OCI services. The OCI Command Line Interface (CLI) is a tool that provides the same core capabilities as the Console, enabling users to create and manage resources through commands, which is ideal for automation and scripting. Both are officially supported methods for creating a HeatWave DB System.

Why Incorrect

C. OCI Bastion Server: An OCI Bastion is a service that provides secure, session-based access to private resources. It is used for connectivity, not for provisioning or creating infrastructure.
D. MySQL Shell on OCI Compute: MySQL Shell is an advanced client and code editor for MySQL. It is used to connect to and manage an existing database, not to create the underlying DB System infrastructure.
E. OCI SQL Developer: OCI SQL Developer (or SQL Developer Web) is a database development and administration tool. Like MySQL Shell, it is used to interact with a database after it has been provisioned.

References

1. Oracle Cloud Infrastructure Documentation, MySQL HeatWave, "Creating a DB System": This document explicitly states, "You can create a DB system using the Console, CLI, or API." It then provides detailed instructions for using the OCI Console.

Source: Oracle Cloud Infrastructure Official Documentation, "Creating a DB System", Section: "Using the Console".

2. Oracle Cloud Infrastructure Documentation, CLI Reference, "oci mysql db-system create": This official CLI command reference details the syntax and parameters for the create command, which provisions a new MySQL DB System, including the option to specify a HeatWave shape.

Source: Oracle Cloud Infrastructure CLI Command Reference, mysql db-system section, create command.

3. Oracle Cloud Infrastructure Documentation, Bastion, "Overview of Bastion": This document describes the Bastion service's purpose: "Bastion provides restricted and time-limited secure access to target resources that don't have public endpoints." This confirms it is an access tool, not a creation tool.

Source: Oracle Cloud Infrastructure Official Documentation, "Overview of Bastion".

Scroll to Top