1z0-1093-23 Exam Dumps - Oracle Database Cloud Service Questions and Answers

A compartment is a logical container that can hold resources such as databases, compute instances, networks, etc. A compartment can be organized in a hierarchical fashion, with parent and child compartments1. After creating a compartment, you do not need to write any policies for it, unless you want to grant access to other users or groups2. Compartments are tenancy-wide, meaning that they are available across all the regions that the tenancy subscribes to3. A compartment allows you to isolate resources for different purposes, such as development, testing, production, etc. Therefore, statement C is false, and statements A, B, and D are true. References: 1: Become an Oracle Base Database Services Professional (2023), Section 2.1.1: Compartments 2: Base Database Service, Section 1.2.1: Compartments 3: Oracle Base Database Services 2023 Professional, Section 2.1.1: Compartments : [Oracle Cloud Infrastructure Documentation], Compartments and Subcompartments

A Routing Table is a set of rules that determine how traffic is routed within a VCN and to other networks. Each rule consists of a destination CIDR Block and a target, which can be a gateway, a private IP, or a service gateway1. A Routing Table controls only the egress (outbound) traffic from a subnet, not the ingress (inbound) traffic2. Therefore, statements B and F are true, and statements A, C, D, and E are false. References: 1: Oracle Base Database Services 2023 Professional, Section 3.3.2: Routing Tables 2: Base Database Service, Section 2.2.3: Routing Tables

To use the MySQL Database Service, you need to have the following three prerequisites1:

• You must create a tenancy and be able to sign in to it. A tenancy is a secure and isolated partition within Oracle Cloud Infrastructure where you can create, organize, and administer your cloud resources2. You need to have a valid Oracle Cloud account and credentials to access your tenancy and use the MySQL Database Service.
• You must create a compartment to store your resources. A compartment is a logical container that you can use to organize and isolate your cloud resources within a tenancy3. You can create one or more compartments to store your MySQL Database Service resources, such as MySQL DB systems, backups, and connections. You can also control the access and permissions for each compartment using policies4.
• You or your group must be granted the policies described in Mandatory Policies. Policies are documents that specify who can access which resources, and how5. To use the MySQL Database Service, you need to have the necessary permissions to create and manage the MySQL Database Service resources, as well as the related Oracle Cloud Infrastructure resources, such as Virtual Cloud Networks, subnets, and security lists. The documentation provides a list of mandatory policies that you or your group must be granted to use the MySQL Database Service.

D is incorrect, because you do not have to download the latest MySQL version from https://edelivery.oracle.com/. The MySQL Database Service is a fully managed service that provides you with the MySQL version that you select when creating a MySQL DB system. You do not have to download or install any MySQL software on Oracle Cloud Infrastructure.

E is incorrect, because you do not have to install the downloaded MySQL version onto Oracle Cloud Infrastructure. As mentioned above, the MySQL Database Service is a fully managed service that handles the installation and configuration of the MySQL software for you.

References: 1: Getting Started With MySQL Database Service 2: About Your Tenancy 3: About Compartments 4: Managing Compartments 5: About Policies : Mandatory Policies : Creating a MySQL DB System

The correct IAM policy to use to allow a group called DatabaseAdmins to create Exadata Database Services is to allow the group to manage the database-family resource type in the tenancy. The database-family resource type includes all the resources related to Oracle Database services, such as DB systems, databases, backups, patches, and Exadata infrastructure1. The syntax for the policy statement is as follows2:

Allow group DatabaseAdmins to manage database-family in tenancy

This policy statement grants the DatabaseAdmins group the permission to perform any action on any resource in the database-family resource type within the tenancy. This includes creating, updating, deleting, and viewing Exadata Database Services and other database resources12.

The other options are not correct IAM policies to use for this purpose. Option A is not a valid syntax, as the tenancy cannot be used as a target for a policy statement. Option B is not a valid syntax, as the databases cannot be used as a principal for a policy statement. Option D is not sufficient, as it only grants the permission to create database-family resources, but not to manage them. Option E is not comprehensive, as it only grants the permission to manage databases, but not other database-family resources, such as Exadata infrastructure12. References:

• Resource Types - Oracle Help Center
• Policy Syntax - Oracle Help Center

A Service Gateway is a virtual router that enables private access to multiple Oracle services in the Oracle Services Network, a conceptual network that is reserved for Oracle services and composed of a list of regional CIDR blocks1. A Service Gateway can be used to access Object Storage, which is one of the Oracle services supported by the Service Gateway2. A Service Gateway can only connect to services in the same region of its VCN, not in other regions3. A Service Gateway cannot be used to connect to the Internet, as it does not have a public IP address4. A Service Gateway can be used with either a private or a public subnet, as long as the subnet has a route table that directs traffic to the Service Gateway5. References: 1: Service Gateway | Oracle 2: [Oracle Cloud Infrastructure Documentation] 3: [Oracle Cloud Infrastructure Documentation] 4: [Oracle Cloud Infrastructure Documentation] 5: [Oracle Cloud Infrastructure Documentation]

When you permanently delete a MySQL database system, the backups that are associated with the deleted database system are not automatically deleted. They are retained for their retention periods, which are specified when you create the backup policy for the database system. You can view, restore, or delete the backups from the Oracle Cloud Infrastructure Console or the API1. References: 1: MySQL Database Service Backups

The users created on Database Servers that can be used for both Oracle database and host management of your Exadata Database Service are the root, opc, oracle, and grid users1. These users have different roles and privileges as follows:

• root: The root user is the superuser on the Database Servers. The root user can perform any administrative task on the host, such as installing software, configuring the network, and managing the file system. The root user can also access the Oracle Database as the SYSDBA user1.
• opc: The opc user is the default user that you use to connect to the Database Servers using SSH. The opc user has sudo privileges to run commands as root or other users. The opc user can also access the Oracle Database as the SYSDBA user1.
• oracle: The oracle user is the owner of the Oracle Database software and the Oracle Database home directory. The oracle user can perform database administration tasks, such as creating and managing databases, tablespaces, and users. The oracle user can also access the Oracle Database as the SYSDBA user1.
• grid: The grid user is the owner of the Oracle Grid Infrastructure software and the Oracle Automatic Storage Management (ASM) home directory. The grid user can perform ASM administration tasks, such as creating and managing disk groups, volumes, and files. The grid user can also access the Oracle Database as the SYSASM user1.

The other options are incorrect because:

• B. root, opc, oracle, grid, and cloud users: The cloud user is not a valid user on the Database Servers. The cloud user is a user that you create in the Oracle Cloud Infrastructure Identity and Access Management (IAM) service to access the Oracle Cloud resources. The cloud user cannot access the Oracle Database or the host management of the Exadata Database Service2.
• C. opc, oracle, and grid users: This option is missing the root user, which is a valid user on the Database Servers that can access the Oracle Database and the host management of the Exadata Database Service1.
• D. root, oracle, and grid users: This option is missing the opc user, which is the default user on the Database Servers that can access the Oracle Database and the host management of the Exadata Database Service1.

References: 1: Users on Database Servers 2: Users and Roles in Oracle Cloud Infrastructure

To check if cloud tools are up-to-date in Exadata Database Service, you need to perform the following two steps1:

• You must first connect to Exadata Cloud Service as opc and sudo to the root user. This is because the cloud tools are installed and updated by the root user on the database servers1. The opc user is the default administrative user that has sudo privileges to run commands as root1. The oracle user is the default database user that owns the Oracle software and the database files, but it does not have access to the cloud tools1.
• Run the rpm -qa|grep -i dbaastools_exadata command. This command will list the installed packages that match the dbaastools_exadata pattern, which is the name of the cloud tooling package for Exadata Database Service1. The output will show the current version of the cloud tooling package, such as dbaastools_exadata-20.4.1-1.el7.x86_641. You can compare this version with the latest version available from the Oracle Base Database Service documentation1.

The other option, running the dbaascli patch tools list command, is incorrect because it is not a valid command for Exadata Database Service. The dbaascli utility is a command-line interface that provides various functions for managing the database service, such as patching, backup, recovery, and encryption1. However, the patch tools subcommand is not supported for Exadata Database Service, as the cloud tools are automatically updated by Oracle1. Therefore, the correct answer is C and D. References:

• 4: About Oracle Base Database Service - Oracle Help Center

 Oracle Cloud Infrastructure (OCI) Management Interfaces are the various ways that you can interact with OCI resources and services. Some of the OCI Management Interfaces are:

• Terraform: Terraform is an open-source tool that allows you to define and provision infrastructure as code. You can use Terraform to create, modify, and delete OCI resources and services using a declarative configuration language. Terraform communicates with OCI via HTTPS for secure application integration1.
• OCI CLI: OCI CLI is a command-line interface that you can use to perform most OCI tasks. You can install OCI CLI on your local machine or use it from the Cloud Shell in the OCI Console. OCI CLI uses REST APIs to send requests and receive responses from OCI2.
• dbcli: dbcli is a command-line interface that is available only on virtual machine DB systems and must be run on the host. dbcli allows you to perform various lifecycle and administration operations on the database, such as creating, deleting, starting, stopping, patching, and backing up the database3.

Therefore, option A and B are true statements and the rest are false. Option C is false because there is no such thing as VMCLI in OCI. Option D is false because dbcli is also available on bare metal DB systems, not just on virtual machine DB systems4. Option E is false because virtual machine DB systems can be managed from the Web Console, as well as from the Cloud REST APIs5. References: 1: Terraform Provider for Oracle Cloud Infrastructure 2: Command Line Interface (CLI) - Oracle Help Center 3: dbcli Command Reference - Oracle Help Center 4: dbcli Command Reference - Oracle Help Center 5: Managing DB Systems - Oracle Help Center

To manage an external database using the Oracle Cloud Infrastructure Database Management Service, you must create or configure a database handle and a database connection1. A database handle is a resource that represents an external database in Oracle Cloud Infrastructure2. It contains information such as the database name, version, edition, and deployment type. A database connection is a resource that enables you to connect a database handle to an Oracle Database instance located outside of Oracle Cloud Infrastructure3. It contains information such as the host name, port number, service name, and credentials. You can create and manage database handles and connections using the Oracle Cloud Infrastructure Console or the REST API23.

A is incorrect, because a dynamic group is not required to manage an external database. A dynamic group is a group of Oracle Cloud Infrastructure resources that are dynamically matched according to rules that you define4. You can use a dynamic group to grant permissions to the Database Management agent, which is a software component that runs on the host where the external database is located and communicates with the Database Management service5. However, creating a dynamic group is not mandatory, as you can also use other methods to grant permissions to the agent, such as using a user API key or an instance principal5.

C is incorrect, because a database group is not required to manage an external database. A database group is a logical grouping of databases that you can use to perform actions on multiple databases at once. You can create a database group for external databases, but it is not a prerequisite for managing them.

References: 1: About Database Management 2: Manage the Handles for External Database 3: Manage the Connections for External Database 4: Managing Dynamic Groups 5: About Database Management Agent : Managing Database Groups