Oracle Base Database Services 2023 Professional
Oracle 1Z0-1093-23 Exam Questions [2023]-
Latest Release-Part 2
Question 1: Correct
Which two requirements must be first met to
create an Exadata Database Service Instance?
You need to define the VCN, Private Client Subnet, and Service
Backup Subnet.
You need to create an Exadata Infrastructure and VM Cluster
resource.
(Correct)
You need to define the VCN, Private Client Subnet, and Private
Backup Subnet.
(Correct)
You only need a VCN and Universal Cloud Credits.
There are no prerequisites for creating an Exadata Database
Service_ instance.
Explanation
✅ To create an Exadata
Database Service Instance, the following two requirements must be met: You need
to define the VCN, Private Client Subnet, and Private Backup Subnet. This
involves setting up the virtual cloud network (VCN) and configuring the subnets
for the Exadata Database Service instance to ensure proper network connectivity
and isolation. You need to create an Exadata Infrastructure and VM Cluster
resource. This step involves provisioning the underlying Exadata infrastructure
and VM cluster that will host the database service instance. It includes
selecting the appropriate configuration, such as the number of compute and
storage servers, to meet your specific requirements. Therefore, the correct
options are: You need to define the VCN, Private Client Subnet, and Private
Backup Subnet. You need to create an Exadata Infrastructure and VM Cluster
resource.
Question 2: Correct
Which two actions does the Cloud Exadata
Infrastructure Resource GUI allow you to do?
Allowing customers to execute Infrastructure maintenance
Allowing customers to schedule Automatic Infrastructure
maintenance
(Correct)
Enabling Database Compute and Storage server expansion
(Correct)
Providing customers access to the Exadata Storage servers
Explanation
✅ The Cloud Exadata
Infrastructure Resource GUI allows you to perform the following two actions:
Allowing customers to schedule Automatic Infrastructure maintenance: The GUI
provides a user interface where customers can schedule and manage automatic
infrastructure maintenance tasks. This allows customers to control when
maintenance activities, such as patching and upgrades, are performed on the
Exadata infrastructure. Enabling Database Compute and Storage server expansion:
The GUI provides options for customers to expand the capacity of their Exadata
infrastructure by adding additional compute and storage servers. This allows
customers to scale up their database environment to meet growing demands.
Therefore, the correct options are: Allowing customers to schedule Automatic
Infrastructure maintenance Enabling Database Compute and Storage server
expansion
Question 3: Correct
Which two actions does the Cloud Exadata
Infrastructure Resource NOT allow you to do?
Allowing customers to execute Infrastructure maintenance
(Correct)
Allowing customers to schedule Automatic Infrastructure
maintenance
Enabling Database Compute and Storage server expansion
Providing customers access to the Exadata Storage servers
(Correct)
Question 4: Correct
Which two actions does the Cloud VM Cluster
Resource allow you to do?
Upgrade the Exadata System model to the latest version.
Manage networking, memory, storage, grid infrastructure, VM OS,
database homes, and databases.
(Correct)
Enable the addition of database compute and storage servers to
support the expansion of the Exadata Database Service.
Scale up and down the OCPUs to align with the workload demand.
(Correct)
Schedule Infrastructure Maintenance.
Explanation
✅ The Cloud VM Cluster
Resource allows you to perform the following two actions: Manage networking,
memory, storage, grid infrastructure, VM OS, database homes, and databases: The
VM Cluster Resource provides a comprehensive interface to manage various
aspects of the VM Cluster, including networking configurations, memory
allocations, storage configurations, grid infrastructure settings, VM operating
system configurations, database home management, and database management. This
allows administrators to have control over the resources and configurations of
the VM Cluster. Scale up and down the OCPUs to align with the workload demand:
The VM Cluster Resource allows administrators to scale the number of OCPUs
(Oracle Compute Units) allocated to the VM Cluster based on the workload
demands. This flexibility enables adjusting the resources to meet the
performance requirements of the databases running on the VM Cluster. Therefore,
the correct options are: Manage networking, memory, storage, grid
infrastructure, VM OS, database homes, and databases. Scale up and down the
OCPUs to align with the workload demand.
Question 5: Correct
Which statement is true about a Virtual Cloud
Network (VCN)?
A VCN spans multiple Regions to facilitate failover
requirements.
A VCN is subdivided into subnets, and subnets can only be
Availability Domain specific with custom route tables and security rules.
A VCN resides within a single Availability Domain, but can cross
multiple Regions.
A VCN resides within a single Region, but can cross multiple
Availability Domains.
(Correct)
Explanation
✅ Virtual Cloud Network
(VCN): Software-defined version of the traditional physical network including
subnet, route tables, security list, and gateways. VCN covers a single,
contiguous IPv4 CIDR Block of your choice. It resides within a single Region
but can cross multiple Availability Domain (AD).
Question 6: Correct
Which two are key features of MySQL Database
Service?
Interactive Documents: Uses a built-in web-based notebook tool
for designing and sharing SQL-based datadriven scripts
Integration with Oracle Technologies: Uses a dient's existing
Orade investments and easily integrates MySQL Database Service with Oracle
technologies
(Correct)
In-Memory Lookups: Avoids unnecessary I/O operations by
replacing storage indexes with a few in-memory lookups
Regulatory Compliance: Uses advanced security to help clients
meet industry and regulatory compliance requirements, including GDPR, PCI, and
HIPPA
(Correct)
Explanation
✅ The two key features of
MySQL Database Service are: Integration with Oracle Technologies: MySQL
Database Service is designed to seamlessly integrate with a client's existing
Oracle investments and technologies. This integration allows for easy data transfer
and interoperability between MySQL and other Oracle products and services,
enabling organizations to leverage their existing Oracle infrastructure.
Regulatory Compliance: MySQL Database Service provides advanced security
features to help clients meet industry and regulatory compliance requirements.
It offers robust security mechanisms and features such as encryption,
authentication, and access controls, which aid in compliance with regulations
such as GDPR (General Data Protection Regulation), PCI (Payment Card Industry),
HIPAA (Health Insurance Portability and Accountability Act), and other data
protection and privacy standards. Therefore, the correct options are:
Integration with Oracle Technologies. Regulatory Compliance.
Question 7: Correct
What is the maximum number of DDL operations
per minute allowed by the NoSQL Database Cloud Service?
1
10
5
4
(Correct)
2
Explanation
✅ The correct answer is 4.
The maximum number of DDL (Data Definition Language) operations per minute
allowed by the NoSQL Database Cloud Service is 4. This means that you can
perform up to 4 DDL operations, such as creating or altering tables, indexes, or
namespaces, per minute within the NoSQL Database Cloud Service.
Question 8: Correct
In which case can you fast provision a virtual
machine (VM) database (DB) systems, using Logical Volume Manager (LVM) for
storage management?
Orade Databases that could use Automatic Storage Management
(ASM)
(Correct)
Oracle Database versions 12.2 and greater
Any currently supported release of the Oracle Database
Oracle Database versions 18c and greater
Explanation
✅ The correct answer is:
Orade Databases that could use Automatic Storage Management (ASM). You can fast
provision a virtual machine (VM) database (DB) system using Logical Volume
Manager (LVM) for storage management when you have Orade databases that could
use Automatic Storage Management (ASM). LVM is an alternative to ASM for
storage management in certain scenarios. If you have databases that are already
using ASM, it is recommended to continue using ASM for storage management.
However, if you have databases that do not require ASM or could use an
alternative storage management solution, you can choose to use LVM for fast
provisioning of the VM DB system.
Question 9: Correct
.Which Exadata Database Service databases
restore option is NOT available from the console?
Restore using backup tag
(Correct)
Restore using SCN
Restore to latest
Restore to a timestamp
Explanation
✅ The correct answer is:
Restore using backup tag. The Exadata Database Service databases restore option
"Restore using backup tag" is not available from the console. This
option allows you to restore a database to a specific backup tag, which is a
user-defined identifier associated with a backup. However, this specific
restore option is not available directly from the console interface. Other
restore options like "Restore using SCN" (point-in-time recovery
using System Change Number), "Restore to latest" (restore to the
latest available backup), and "Restore to a timestamp" (point-in-time
recovery using a specific timestamp) are available and can be selected and
performed from the console.
Question 10: Correct
.Which three statements are true about Key
Management on Exadata Database Service?
You can change key management type from Oracle-managed to
Customer-managed keys after the database is created.
(Correct)
You must use the Vault service directly to rotate encryption
keys every 24 hours.
You cannot use Oracle Cloud Infrastructure Vault to centrally
manage encryption keys for the Exadata Database Service.
You should rotate the Vault encryption key from the database
details page on the Oracle Cloud Infrastructure Console.
(Correct)
You can choose Customer-managed keys or Oracle-managed keys when
the database is created.
(Correct)
Explanation
✅ The correct statements
are: You can change key management type from Oracle-managed to Customer-managed
keys after the database is created. When creating an Exadata Database Service,
you have the option to choose between Oracle-managed keys or Customer-managed
keys for key management. However, if you initially choose Oracle-managed keys,
you can later change it to Customer-managed keys. You should rotate the Vault
encryption key from the database details page on the Oracle Cloud
Infrastructure Console. To rotate the encryption keys used for the Exadata
Database Service, you can perform the key rotation from the database details
page on the Oracle Cloud Infrastructure Console. You can choose
Customer-managed keys or Oracle-managed keys when the database is created. When
creating an Exadata Database Service, you have the flexibility to choose either
Customer-managed keys or Oracle-managed keys for key management. You can select
the appropriate option based on your requirements and preferences. The
statement "You must use the Vault service directly to rotate encryption
keys every 24 hours" is false. The rotation of encryption keys every 24
hours is not a mandatory requirement, and it is not limited to using the Vault
service directly. The key rotation process can be performed manually or
automated using various methods, including through the Oracle Cloud
Infrastructure Console.
Question 11: Correct
A new international hacktivist group, based in
London, launched wide scale cyber attacks including SQL Injection and
Cross-Site Scripting (XSS) across multiple websites which are hosted in Oracle
Cloud Infrastructure (OCI). As an IT consultant, you must configure a Web
Application Firewall (WAF) to protect these websites against the attacks. How
should you configure your WAF to protect the website against those attacks?
(Choose the best answer.)
Enable a Protection Rule to block the attacks based on HTTP
Headers that contain XSS and SQL strings.
Enable an Access Rule to block the IP Address range from London.
Enable a Protection Rule to block requests XSS Filters
Categories and SQL Filters Categories.
(Correct)
Enable a Protection Rule to block requests that came from
London.
Enable an Access Rule that contains XSS Filters Categories and
SQL Filters Categories.
Explanation
✅ The best answer would
be: Enable a Protection Rule to block requests with XSS Filters Categories and
SQL Filters Categories. By enabling a Protection Rule that includes XSS Filters
Categories and SQL Filters Categories, the Web Application Firewall (WAF) can
actively inspect incoming requests to the website and block any requests that
contain known XSS or SQL injection strings. This helps protect the website
against SQL injection and Cross-Site Scripting (XSS) attacks, which were
mentioned as the specific types of attacks launched by the hacktivist group.
Enabling an Access Rule to block the IP address range from London would not be
an effective solution as it would block legitimate traffic from all users in that
location, potentially causing unnecessary disruptions to the website. Blocking
requests based on specific HTTP headers or blocking requests from a specific
location may not be sufficient to protect against the mentioned SQL injection
and XSS attacks. The recommended approach is to focus on the specific attack
vectors by using protection rules with XSS and SQL filters.
Question 12: Correct
You want to view the status of the storage
server disks to check that they are all mounted. How would you get this
information?
Query the storage servers disks status by using a dbaasci
command.
Raise a service request to get this information from Oracle
Cloud Support.
View the storage servers disks status from the console under the
Exadata Infrastructure section.
Query the storage servers disks by using an exacli command.
(Correct)
Explanation
✅ To view the status of
the storage server disks and check if they are all mounted, you can use the
exacli command. The correct option is: Query the storage servers disks by using
an exacli command. The exacli command is a command-line interface specifically
designed for managing Exadata Database Service. It provides various
administrative commands to interact with the Exadata infrastructure, including
retrieving information about the storage server disks. By using the appropriate
exacli command, you can query the status of the disks and verify if they are
mounted. The other options listed are not suitable for obtaining this specific
information. Raising a service request to Oracle Cloud Support may not be
necessary for checking the status of the storage server disks. Viewing the
Exadata Infrastructure section in the console may provide general information
but may not offer detailed disk status. The recommended approach is to use the
exacli command for retrieving the specific disk status information.
Question 13: Correct
NoSQL Database Cloud Service supports all
three types of big data. Which is NOT considered big data?
unstructured data
structured data
free-structured data
(Correct)
semi-structured data
Explanation
✅ Among the options
provided, "free-structured data" is not considered a type of big
data. Big data refers to large and complex data sets that cannot be easily
managed, processed, or analyzed using traditional data processing methods. It
typically involves data sets that are characterized by the three V's: volume,
velocity, and variety. Unstructured data: This refers to data that does not
have a predefined structure, such as text documents, social media posts,
emails, audio files, images, videos, etc. Structured data: This refers to data
that is organized in a specific format and has a predefined schema, such as
data stored in relational databases. Semi-structured data: This refers to data
that has some structure but does not adhere to a rigid schema, such as data in
XML or JSON format. On the other hand, "free-structured data" is not
a recognized term in the context of big data. It may be a misinterpretation or
a term that is not widely used in the field.
Question 14: Correct
Why is a dynamic group required as part of
installing and configuring management agents for OCI Database Management
Service?
To let the management agents carry on the communication with the
OCI Monitoring service via Instance Principals.
To let the management agents carry on the communication with the
OCI Management Agent service via Instance Principals.
To let the management agents carry on the communication with the
OCI Monitoring service via Resource Principals.
To let the management agents carry on the communication with the
OCI Management Agent service via Resource Principals.
(Correct)
Explanation
✅ A dynamic group is
required as part of installing and configuring management agents for OCI
Database Management Service to allow the management agents to communicate with
the OCI Management Agent service via Resource Principals. Resource Principals
are a feature of Oracle Cloud Infrastructure (OCI) that provide secure and
automatic authentication for resources within OCI. They allow resources to
prove their identity without the need for explicit credentials or keys. By
associating the management agents with a dynamic group, the agents are granted
the necessary permissions to access and interact with the OCI Management Agent
service using the authentication provided by Resource Principals. Therefore,
the correct statement is: "To let the management agents carry on the
communication with the OCI Management Agent service via Resource
Principals."
Question 15: Correct
Which statement is true about scaling OCPUs
for a Virtual Machine DB System?
Scaling the OCPUs of a Virtual Machine DB System requires you to
migrate to a new DB System.
Scaling the OCPUs of a Virtual Machine DB System requires that
the shape of the system be changed, which can be done online.
Scaling the OCPUs of a Virtual Machine DB System requires that
the shape of the DB system be changed.
(Correct)
For a 2-node RAC Virtual Machine DB System, the shape of the VMs
changes without needing to reboot the VM nodes.
Explanation
✅ The correct statement
about scaling OCPUs for a Virtual Machine DB System is: "Scaling the OCPUs
of a Virtual Machine DB System requires that the shape of the DB system be
changed." When scaling the OCPUs of a Virtual Machine DB System, you need
to change the shape of the DB system. This involves modifying the shape of the
underlying compute resources allocated to the DB system. This process typically
requires downtime as it involves restarting the DB system to apply the changes.
Once the shape is changed, the Virtual Machine DB System will have a different
number of OCPUs available for use. Therefore, the correct statement is:
"Scaling the OCPUs of a Virtual Machine DB System requires that the shape
of the DB system be changed."
Question 16: Correct
What is the minimum Infrastructure usage
commitment for Exadata Database Service on Exadara Cloud@Customer (ExaDB-C@C)?
ExaDB-C@C' requires a minimum of 30 Days usage commitment for
the Infrastructure and OCPU.
ExaDB-C@C' requires a minimum 4 Year usage commitment for the
Infrastructure.
(Correct)
ExaDB-C@C' requires a minimum 48 Year usage commitment for the
Infrastructure.
ExaDB-C@C' requires a minimum 48 Year usage commitment for the
Infrastructure and OCPU.
Explanation
✅ The correct statement
regarding the minimum Infrastructure usage commitment for Exadata Database
Service on Exadata Cloud@Customer (ExaDB-C@C) is: "ExaDB-C@C requires a
minimum 4-year usage commitment for the Infrastructure." When using Exadata
Database Service on Exadata Cloud@Customer, there is a minimum commitment
period for the Infrastructure, which refers to the duration for which you
commit to using the Exadata infrastructure. The minimum commitment period is
typically stated in terms of years. In this case, the correct answer indicates
a 4-year minimum usage commitment for the Infrastructure. Therefore, the
correct statement is: "ExaDB-C@C requires a minimum 4-year usage
commitment for the Infrastructure."
Question 17: Correct
Which two are the same for a Base System and a
Quarter Rack?
Maximium Number of enabled OCPUs.
Total Raw Storage Capacity.
Number of Exadata Storage Servers.
(Correct)
Number of Compute Servers
Total Raw Flash Storage Capacity.
(Correct)
Explanation
✅ The two options that are
the same for a Base System and a Quarter Rack are: Number of Exadata Storage
Servers: Both the Base System and Quarter Rack have a fixed number of Exadata
Storage Servers. A Base System consists of two Exadata Storage Servers, while a
Quarter Rack consists of four Exadata Storage Servers. Total Raw Flash Storage
Capacity: Both the Base System and Quarter Rack have a specific amount of raw
flash storage capacity. The exact capacity may vary depending on the specific
model and configuration, but both systems provide a significant amount of flash
storage for high-performance data storage. The other options mentioned, such as
the maximum number of enabled OCPUs, total raw storage capacity, and number of compute
servers, can vary between a Base System and a Quarter Rack depending on the
specific configuration and capacity of the system.
Question 18: Correct
Which two statements are true about using a
Service Gateway?
The Service Gateway can connect to services in the order regions
outside of the VCN.
The Service Gateway can be used to connect to the Internet.
The Service Gateway can Connect to services in the same region
of its VCN.
(Correct)
The Service Gateway with a private subnet can be used to access
Object Storage.
(Correct)
The Service Gateway with a public subnet can be used to access
Object Storage.
Explanation
The service gateway is regional and enables access only to
supported Oracle services in the same region as the VCN. Service gateway: To
provide the private subnet with private access to supported Oracle services
within the region. Connections can be initiated only from the subnet.
Question 19: Correct
Which two statements are true regarding MySQL
Database Service HeatWave? (Choose two.)
HeatWave uses periodic long-running ETL batch jobs to refresh
data.
HeatWave is an in-memory, query-processing engine designed for
fast execution of analytic queries.
(Correct)
The HeatWave data that is needed for analytic processing is
stored in disk files.
HeatWave uses machine learning to automate operations,
increasing DBA Productivity, and reducing costs.
(Correct)
Question 20: Correct
What is true about scheduling maintenance
operations in the cloud?
Customers can reschedule Infrastructure Maintenance up to 180
days from the previous maintenance date.
(Correct)
Customers do not have control over the Automatic Infrastructure
maintenance schedule because Oracle undertake this effort.
You can only choose the day of the week and the time that
Automatic Infraestructure maintenance occurs.
Infrastructure maintenance is done on Mondays, by default.
Explanation
✅ The correct statement
about scheduling maintenance operations in the cloud is: "Customers can
reschedule Infrastructure Maintenance up to 180 days from the previous
maintenance date." When it comes to maintenance operations in the cloud,
customers typically have control over rescheduling the Infrastructure
Maintenance. Oracle provides options for customers to reschedule maintenance
operations within certain time frames. In this case, the correct answer states
that customers can reschedule Infrastructure Maintenance up to 180 days from
the previous maintenance date. Therefore, the statement that is true about
scheduling maintenance operations in the cloud is: "Customers can
reschedule Infrastructure Maintenance up to 180 days from the previous maintenance
date."
Question 21: Correct
Which two statements are true about Routing
tables?
You can delete the default Routing Table it is not required.
Gateway added to your VCN do not requiere an entry in the
Routing table.
A Routing Table controls ingress and egress rules, that specify
the types od traffic allowed.
A VCN uses the Routing Table to send traffic out of the VCN.
(Correct)
The default Routing Table is shared by all the Subnets in the
VCN.
The Routing Table rules specify a destination CIDR Block and
target.
(Correct)
Explanation
VCN uses route tables to send traffic outside VCN (Internet,
On-Premise, other Peered VCN). Each Route rule specifies: Destination CIDR
block Route Target for the traffic that matches that CIDR Each Subnet uses a
single route table specified at the time of Subnet creation and can be edited
later. The route table is used only if the destination IP Address is not within
VCN’s CIDR block. When you add any gateway (IGW, DRG, NAT, SGW), you must
update the Route Table of the Subnet that uses these gateways. Multiple Route
Tables can be created from VCN Page but only 1 can be used by a specific Subnet
with Multiple Rules inside.
Question 22: Correct
In a two-node Real Applications Cluster
environment, the Internet and VCN Resolver are supported for DNS in the DB
system. Which TWO tasks are required for the network setup? (Choose all correct
answers)
After the VCN is created, modify the DNS settings to use DNS Hostnames.
When creating the database, specify a value in the Hostname
Prefix.
(Correct)
Select 'Use DNS Hostnames in this VCN' as the VCN is being
created.
(Correct)
Select the hostname field for a DNS label when the subnet is
being created.
Explanation
✅ Here are the two tasks
required for the network setup in a two-node Real Applications Cluster (RAC)
environment with Internet and VCN Resolver support for DNS in the DB system:
When creating the database, specify a value in the Hostname Prefix: This is
necessary to set the common prefix for the hostnames of the individual database
nodes in the RAC cluster. It helps in identifying and resolving the hostnames
within the cluster. Select the hostname field for a DNS label when the subnet
is being created: This step involves providing a DNS label for the subnet
during its creation. This associates the subnet with a DNS label, allowing the
resources within the subnet, including the database nodes, to be accessible via
DNS hostname resolution. These two tasks are essential for configuring the
network setup correctly in a two-node RAC environment with DNS support.
Question 23: Correct
Which is NOT a prerequisite for patching Grid
Infrastructure or database homes when using the console?
Oracle Clusterware is down on the VM cluster.
(Correct)
All database compute nodes of the VM cluster are up and running.
The required patch is available on the Control Plane server.
The /uo1 directory on the database host file system has at least
15 GB of free space for the execution of Patching processes.
Explanation
✅ The statement that is
NOT a prerequisite for patching Grid Infrastructure or database homes when
using the console is: "Oracle Clusterware is down on the VM cluster."
When patching Grid Infrastructure or database homes using the console, it is
not necessary for Oracle Clusterware to be down on the VM cluster. In fact, the
patching process can be performed while the cluster is up and running, as long
as the required conditions are met. Therefore, the correct answer is:
"Oracle Clusterware is down on the VM cluster."
Question 24: Correct
Which TWO statements are true when enabling
autonomous Data Guard on Autonomous Exadata. (Choose all correct answers)
Autonomous databases inherit their Data Guard configuration from
their Autonomous Container Database.
(Correct)
When in a Data Guard configuration patching will always take
place on the standby database first.
(Correct)
Data Guard can be set per individual Autonomous Database within
a Container Database.
Data Guard is not currently supported on Autonomous Exadata
Cloud@Customer.
Autonomous Data Guard only supports Maximum Performance and
Maximum Protection protection modes.
Explanation
✅ The correct answers are:
Autonomous databases inherit their Data Guard configuration from their
Autonomous Container Database. When in a Data Guard configuration, patching
will always take place on the standby database first. Explanation: Autonomous
databases inherit their Data Guard configuration from their Autonomous
Container Database: When enabling Autonomous Data Guard on Autonomous Exadata,
the Data Guard configuration is inherited from the Autonomous Container
Database. This means that the Data Guard setup, including the standby database,
is configured at the container level, and all autonomous databases within that
container share the same Data Guard configuration. When in a Data Guard
configuration, patching will always take place on the standby database first:
In a Data Guard configuration, the recommended patching sequence is to apply
patches to the standby database first before applying them to the primary
database. This approach helps ensure minimal downtime and maintains high
availability during the patching process. It's important to note that Data
Guard configuration and patching procedures may vary depending on specific
requirements, maintenance strategies, and Oracle's recommendations. It's always
advisable to consult the official Oracle documentation and best practices for
the most accurate and up-to-date information.
Question 25: Correct
Which system configuration is offered by the
Oracle Database Exadata Cloud Service?
Each system configuration starts with a fixed amount of memory
and storage resources.
Each system configuration starts with a fixed amount of OCPU and
storage resources.
Each system configuration starts with a fixed amount of OCPU,
memory, storage, and network resources.
(Correct)
Each system configuration starts with a fixed amount of OCPU,
memory, and network resources.
Explanation
✅ The correct answer is:
Each system configuration starts with a fixed amount of OCPU, memory, storage,
and network resources. The Oracle Database Exadata Cloud Service offers system
configurations that include fixed amounts of OCPU (Oracle CPU), memory,
storage, and network resources. These configurations are designed to meet the
performance and capacity requirements of different workloads and applications.
Question 26: Correct
When configuring connectivity for hosts in the
VCN, security lists contain defaults for implementing security rules. Which TWO
additional rules are needed for database systems? (Choose all correct answers)
allows SQL*NET traffic from within the VCN
allows ONS and FAN traffic from within the VCN
allows SSH traffic from anywhere
(Correct)
allows Path MTU Discovery fragmentation messages
(Correct)
Explanation
✅ The correct answers are:
Allows SSH traffic from anywhere Allows Path MTU Discovery fragmentation
messages When configuring connectivity for hosts in the VCN (Virtual Cloud
Network) to work with database systems, two additional rules are typically
needed for proper functionality and security: Allows SSH traffic from anywhere:
This rule allows Secure Shell (SSH) traffic, which is used for secure remote
administration of the hosts. It enables system administrators to manage and
troubleshoot the hosts from any location. Allows Path MTU Discovery
fragmentation messages: Path MTU Discovery (Maximum Transmission Unit) is a
mechanism for determining the maximum packet size that can be transmitted on a
network path. Allowing Path MTU Discovery fragmentation messages ensures that
the network can handle packets of the appropriate size for efficient and
reliable communication between hosts and the database system. Implementing
these additional rules in the security lists helps ensure secure and proper
connectivity for the database systems within the VCN.
Question 27: Incorrect
Resources are allocated to the DB system based
on the shape selected. Which two are options for a DB system? (Choose two.)
Single-Node Virtual Machine with Logical Volume Manager (UUM) as
the storage software for the "fast provisioning" option
(Correct)
Two-Node Virtual Machine with Logical Volume Manager (L) as the
ragem software
Single-Node Virtual Machine with Local Storage
(Incorrect)
Two-Node Virtual Machine with Automatic Storage Management (ASM)
tha management software
(Correct)
Question 28: Correct
.Which two tools are used to monitor Exadata
Database Service?
Oracle Internet Monitoring Suite (IMS)
Oracle Cloud Monitor
(Correct)
Service Console
Oracle Management Cloud
Oracle Enterprise Manager
(Correct)
Explanation
✅ The two tools used to
monitor Exadata Database Service are: Oracle Cloud Monitor Oracle Enterprise
Manager The other options, Oracle Internet Monitoring Suite (IMS) and Service
Console, are not specifically used for monitoring Exadata Database Service. Oracle
Management Cloud is a comprehensive monitoring and management solution but is
not specific to Exadata Database Service monitoring.
Question 29: Correct
.Which is NOT a resource type for NoSQL
Database Cloud Service?
Nosql-indexes
Nosql-tables
Nosql-rows
Nosql-keys
(Correct)
Explanation
✅ The correct answer is
"Nosql-keys." NoSQL Database Cloud Service does not have a resource
type specifically for managing keys. Instead, it focuses on managing resources
such as NoSQL tables, indexes, and rows, which are essential components for
storing and querying data in a NoSQL database.
Question 30: Correct
Which two use cases can be used by the Oracle
database with Object Storage in Oracle Cloud Infrastructure (OCI)? (Choose
two.)
Database log files
(Correct)
Database datafiles
Database backups
(Correct)
Database binaries
Explanation
✅ The two use cases that
can be used by the Oracle database with Object Storage in Oracle Cloud
Infrastructure (OCI) are: Database log files Database backups By leveraging
Object Storage in OCI, Oracle databases can store and retrieve database log
files and perform backups directly to Object Storage for data protection and
archival purposes. Database datafiles and database binaries are not typically
stored in Object Storage. Datafiles are usually stored in block storage or file
systems for database operations, while database binaries are stored in the file
system of the database server.
Question 31: Correct
What statement is FALSE about terminating a
Virtual Machine DB System?
Terminating a DB system removes all Full On-Demand backups of
the DB system from Oracle Cloud Infrastructure Object Storage.
(Correct)
When terminating a VM Database System, it is important to note
that the database data will be lost when the system is terminated.
Full On-Demand backups remain in Object Storage as stand-alone
backups.
Terminating a DB system removes all automatic incremental
backups of the DB system from Oracle Cloud Infrastructure Object Storage.
Explanation
✅ The false statement
about terminating a Virtual Machine DB System is: "Terminating a DB system
removes all Full On-Demand backups of the DB system from Oracle Cloud
Infrastructure Object Storage." When terminating a VM Database System, the
Full On-Demand backups of the DB system are not removed from Object Storage.
These backups remain intact as stand-alone backups and are not affected by the
termination process. The other statements are true: When terminating a VM
Database System, it is important to note that the database data will be lost
when the system is terminated. Termination permanently deletes the database and
its associated data. Terminating a DB system removes all automatic incremental
backups of the DB system from Oracle Cloud Infrastructure Object Storage.
Incremental backups are removed as part of the termination process, and only
Full On-Demand backups remain in Object Storage.
Question 32: Correct
Which statement is true about rebooting a
virtual machine (VM) DB system node using the the Oracle Cloud Infrastructure
Console?
Under Database, click Bare Metal, VM, and Exadata; select the DB
system you want to reboot; and then dick Stop and Start after a few minutes
under the Actions (three dots) menu.
The VM Oh system can be rebooted only born Ora( le cloud
Infrastructure REST APIs or dbcli.
On the VM DB system details page, find the node that you want to
reboot, click the Actions (three dots) menu for that node, and then click
Reboot.
(Correct)
The VM DB system nodes cannot be rebooted individually. For
rnultinode 013 systems, you have to act on all the VM nodes concurrently.
Explanation
✅ The statement that is
true about rebooting a virtual machine (VM) DB system node using the Oracle
Cloud Infrastructure Console is: "On the VM DB system details page, find
the node that you want to reboot, click the Actions (three dots) menu for that
node, and then click Reboot." You can reboot a specific node of a VM DB
system by accessing the VM DB system details page, selecting the desired node,
and choosing the "Reboot" option from the Actions (three dots) menu
for that specific node. This allows you to perform a targeted reboot for
individual nodes within a multi-node VM DB system.
Question 33: Correct
To which two files used in local installations
of MySQL Server are MySQL configurations analogous?
mysqld-auto.cnf
mysqld-auto.cnf
my.cnf
(Correct)
my.ini
(Correct)
mylogin.cnf
Explanation
✅ The two files used in
local installations of MySQL Server that are analogous to MySQL configurations
are: my.cnf (or my.ini on Windows) This file is the main configuration file for
MySQL Server. It contains various settings and options that define the behavior
of the server, such as port number, buffer sizes, character set, etc. The exact
file name depends on the operating system. mylogin.cnf This file is used to
store login credentials securely. It allows users to save their MySQL login
information, such as username and password, in an encrypted format. This file
is often used in automation scripts or by applications that need to access the
MySQL server without requiring users to enter their credentials manually. Note:
The option "mysqld-auto.cnf" appears twice in your list, but it is
not a valid configuration file for MySQL Server.
Question 34: Incorrect
Which statement is FALSE related to loading a
table into HeatWave?
Data is distributed among analytics nodes by slicing tables by
vertically.
(Incorrect)
Data is read from InnoDB using batched, multi-threaded reads.
Data is partitioned by primary key unless data placement keys
are defined.
(Correct)
Data is converted into columnar format and sent over the
network.
Question 35: Correct
You have decided to use the Estimate Node
Count option to generate the ileatWave Node Count for your HeatWave cluster.
What is a mandatory step before performing the node count estimate?
When preparing the data on the MySQL DB System exclude columns
with INT data types.
Connect to the MySQL DB System with SSH and the MySQL Client to
give the Node Count Estimator access to your data.
Make sure the data you intend to load into the HeatWave clustens
present on the MySQL DB System.
To ensure that estimates are as accurate as‘possible 10-9 into
the associated MySQL DB Systemand run UPDATE on the tables.
(Correct)
Explanation
✅ The mandatory step
before performing the node count estimate in the HeatWave cluster is: "To
ensure that estimates are as accurate as possible, log into the associated
MySQL DB System and run UPDATE on the tables." Performing an UPDATE on the
tables in the associated MySQL DB System helps to gather accurate statistics
about the data. This is important because the node count estimate relies on the
statistics of the data to provide an accurate estimation of the number of
HeatWave nodes required. By updating the tables, you ensure that the node count
estimate is based on up-to-date and relevant information about the data in the
MySQL DB System.
Question 36: Correct
What should you do to verify that tables are
loaded in HeatWave?
Open the OCI navigation menu. Under MySQL HeatWave Clusters
select view Load status.
Query the LOAD_STATUS data from the HeatWave Performance Schema
tables.
(Correct)
Run the execute SQL command to find the LOAD_STATUS of the
appropriate tables in the MySQL Performance Schema.
From the OCI MySQL DB System Details page select HeatWave
Cluster Information to list the TABLE STATUS of all loaded tables.
Use the MySQL Workbench ANALYTICLOAD_sTATus-View dialog to list
the loaded tables.
Explanation
✅ To verify that tables
are loaded in HeatWave, you should: "Query the LOAD_STATUS data from the
HeatWave Performance Schema tables." By querying the LOAD_STATUS data from
the HeatWave Performance Schema tables, you can retrieve information about the
loading status of the tables in HeatWave. This will provide details on which
tables have been successfully loaded and their current status. The other
options listed are not the correct methods to verify table loading in HeatWave.
Question 37: Correct
Which is NOT an Oracle best practice for
updating Virtual Machine DB System databases?
Patch the DB System before updating a database for DB Systems
with Grid Infrastructure/ASM storage management.
Back up your databases before you apply any updates to your
system.
Run the precheck operation before you apply any update.
Ensure all servers and database instances are stopped before
applying a patch to your DB system to avoid data corruption.
(Correct)
Explanation
The option that is NOT an Oracle best practice for updating
Virtual Machine DB System databases is: "Ensure all servers and database
instances are stopped before applying a patch to your DB system to avoid data
corruption." It is not necessary to stop all servers and database
instances before applying a patch to a Virtual Machine DB System. Oracle
recommends using rolling patching, where the patch is applied to individual
nodes while the system is online and operational. This allows for minimal
downtime and uninterrupted access to the database during the patching process.
The other options listed are valid Oracle best practices for updating Virtual
Machine DB System databases. These practices include patching the DB System
before updating a database with Grid Infrastructure/ASM storage management,
backing up databases before applying updates, and running precheck operations
to ensure a smooth update process.
Question 38: Correct
(DUP) Which two circumstances are FALSE when
you use the Console to recover a DB system database from a backup stored in
Oracle Cloud Infrastructure Object Storage?
There is an option to restore the database, but before that you
must either disable Data Guard or remove the Data Guard association by
terminating the standby database.
(Correct)
There is an option to restore the database to an existing System
Change Number (SCN).
There is an option to restore the database from an Automatic
backup or On-Demand backup stored in Object Storage.
There is an option to restore the database to a point in time.
The DB system has no access to the Oracle Cloud Infrastructure
Object Storage service location where the backup is stored.
(Correct)
Explanation
✅ The false statements
when using the Console to recover a DB system database from a backup stored in
Oracle Cloud Infrastructure Object Storage are: There is an option to restore
the database, but before that, you must either disable Data Guard or remove the
Data Guard association by terminating the standby database: This statement is
false. When using the Console to recover a database from backup, there is no
requirement to disable Data Guard or terminate the standby database. The
restore operation can be performed without affecting the Data Guard
configuration. The DB system has no access to the Oracle Cloud Infrastructure
Object Storage service location where the backup is stored: This statement is
false. The DB system has access to the Oracle Cloud Infrastructure Object
Storage service location where the backup is stored. The backup files are
stored in Object Storage and can be accessed by the DB system during the
recovery process. The true statements are: There is an option to restore the
database to an existing System Change Number (SCN): When using the Console, you
have the option to specify a specific SCN to which you want to restore the
database. This allows for precise point-in-time recovery. There is an option to
restore the database from an Automatic backup or On-Demand backup stored in
Object Storage: The Console provides the capability to restore the database
from both Automatic backups and On-Demand backups that are stored in Oracle
Cloud Infrastructure Object Storage.
Question 39: Correct
You use the Oracle Cloud Infrastructure
console to create a MySQL DB system. You give it the name "mysql" and
set the administrator username to "mysql.sys." You give it a data
storage size of 50 GB and set the host name to "mysql-host." You do
not specify a Maintenance Window start day and time. Which action causes an
error?
Host name should contain only letters.
Usemame "mysql.sys" is reserved.
(Correct)
Maintenance Window start time is required.
Storage size is too small.
Explanation
First of all that account’s username has some limitations.
Indeed, some names are reserved as it’s mentioned in the manual. So you could
not use the following usernames: administrator ociadmin ocirpl mysql.sys
mysql.session mysql.infoschema
Question 40: Correct
You try to access MySQL Database Service by
using MySQL Workbench. The direct remote private IP connection to the MySQL DB
system endpoint does not work. What three resources are required for MySQL
Workbench to successfully conned to the MySQL Database Service system?
(REVISAR)
Oracle Cloud Infrastructure tenancy name where the MySQL
database system exists
username and password defined when creating the database system
(Correct)
Oracle Cloud Infrastructure compartment name where the MySQL
database system exists
Linux compute instance on the same VCN as the DB system to
connect to and from the compute instance to the MySQL database system
(Correct)
username and public IP address of the compute instance
(Correct)
Explanation
✅ To successfully connect
MySQL Workbench to the MySQL Database Service system, the following three
resources are required: "Username and password defined when creating the
database system": You need the correct username and password that were
defined during the creation of the MySQL Database Service system. These
credentials are used to authenticate and establish a connection. "Linux
compute instance on the same VCN as the DB system to connect to and from the
compute instance to the MySQL database system": A Linux compute instance
located within the same Virtual Cloud Network (VCN) as the MySQL Database
Service system is needed. This compute instance acts as a bridge to connect to
the MySQL database system. "Username and public IP address of the compute
instance": You need the username and public IP address of the Linux
compute instance mentioned in the previous resource. This information is used
to establish a connection between MySQL Workbench and the MySQL Database
Service system through the compute instance. The other options listed, such as
the Oracle Cloud Infrastructure tenancy name and compartment name, are not
required for connecting MySQL Workbench to the MySQL Database Service system.
Question 41: Correct
Which statement is FALSE about a compartment?
It can be organized in a hierarchical fashion.
After creating a compartment, you need to write at least one
policy for it.
(Correct)
It allows you to isolate resources.
Compartments are not tenancy-wide, across regions.
Explanation
✅ The statement that is
FALSE about a compartment is: "After creating a compartment, you need to
write at least one policy for it." When creating a compartment, it is not
mandatory to write at least one policy for it. Policies in Oracle Cloud
Infrastructure (OCI) are used to define access permissions and control the
actions that can be performed on resources within a compartment. However, it is
not a requirement to write a policy for every compartment. You can choose to
assign policies to compartments based on your specific security and access
control needs. The other statements listed are true about compartments.
Compartments can be organized in a hierarchical fashion, allowing for logical
grouping and management of resources. They provide the ability to isolate
resources, enabling better organization and security. Compartments are also not
tenancy-wide and are specific to a particular region within Oracle Cloud
Infrastructure.
Question 42: Correct
Which component is NOT included as part of an
Oracle NoSQL table Oracle Cloud Identifier (OCID)?
Compartment ID
(Correct)
Resource type
Region
Unique ID
Explanation
✅ The component that is
NOT included as part of an Oracle NoSQL table Oracle Cloud Identifier (OCID) is
"resource type, region and Unique ID."
Question 43: Correct
What is true about scaling your Exadata
Infrastructure in the cloud?
You can expand a Quarter Rack and a Half Rack X8M by adding
Compute servers or Storage servers.
You can only expand a Base system by adding Compute and Storage
servers offline.
You can expand a Quarter Rack and a Half Rack X8M by adding Compute
servers or Storage servers online.
(Correct)
You must move between shapes to expand Exadata--X8M-.-
Explanation
✅ The correct statement
about scaling your Exadata Infrastructure in the cloud is: "You can expand
a Quarter Rack and a Half Rack X8M by adding Compute servers or Storage servers
online." When it comes to Quarter Rack and Half Rack X8M Exadata systems,
you have the flexibility to scale up your infrastructure by adding additional
Compute servers or Storage servers while the system is online and running. This
means you can expand the capacity and performance of your Exadata
Infrastructure without any downtime or interruption to your services. On the
other hand, the statement that you must move between shapes to expand Exadata
(X8M) is not true. Scaling Exadata does not require moving between shapes.
Instead, you can add servers to increase capacity or performance as needed
within the existing shape/configuration of your Exadata system.
Question 44: Correct
You are asked to create a policy to allow a
DBA cluster group to read and edit VM duster networks in tenancy However, you
do not want to allow them to create or delete cluster networks. Which IAM
policy should you add to permit this level of access?
Allow group DBACluster to manage exadata-infrastructure in
tenancy
Allow group DBACluster to manage vmcluster-networks in tenancy
Allow group DBACluster to use exadata-infrastructure in tenancy
Allow group DBACluster to read exadata-infrastructure in tenancy
Allow group DBACluster to modify vmcluster-networks in tenancy
(Correct)
Explanation
✅ The correct IAM policy
to allow a DBA cluster group to read and edit VM cluster networks in the
tenancy while disallowing the creation or deletion of cluster networks is:
"Allow group DBACluster to modify vmcluster-networks in tenancy" This
policy grants the DBA cluster group permission to modify (read and edit) VM
cluster networks specifically, without granting them the ability to create or
delete cluster networks. By using this policy, the DBA cluster group can manage
the existing VM cluster networks within the tenancy, making necessary changes
or configurations, but they won't have the permission to create new cluster
networks or delete existing ones. The other options listed in the
multiple-choice are not suitable for the given requirement.
Question 45: Correct
Which users created on Database Servers can be
used for both Oracle database and host management of your Exadata Database
Service?
root, oracle, and grid users
opc, oracle, and grid users
root, opc, oracle, and grid users
(Correct)
root, opc, oracle, grid, and cloud users
Explanation
✅ The correct answer is:
"root, opc, oracle, and grid users" These users can be used for both
Oracle database and host management of your Exadata Database Service. The root
user has administrative privileges on the host operating system, while the opc
user is used for management operations in Oracle Cloud Infrastructure. The
oracle user is the default user for managing the Oracle database, and the grid
user is used for managing Oracle Grid Infrastructure. Having these users allows
you to perform various administrative tasks related to both the database and
the host system in your Exadata Database Service. The "cloud" user
mentioned in the last option is not typically used for managing the Exadata
Database Service and is not relevant to this context.
Question 46: Correct
Which two statements are true when enabling
Data Guard on Exadata Database Service?
You cannot edit your configuration to change between synchronous
or asynchronous transport of data to the DR site, after enabling Data Guard.
You should use similar configurations for your Primary and
Standby databases to ensure you meet the same performance service level after a
role transition.
(Correct)
You can use Active Data Guard, which extends Oracle Data Guard
capabilities by providing read/write functionality on the Standby or Disaster
Recovery system.
(Correct)
You must configure Data Guard manually to create the Standby or
DR instance for your Primary Exadata Database.
You can enable Data Guard to support your Standby or Disaster
Recovery (DR) needs with a single API call or mouse click in the UI using cloud
automation.
Explanation
✅ The correct statements
are: You should use similar configurations for your Primary and Standby
databases to ensure you meet the same performance service level after a role
transition. This is important to maintain consistency and performance across
the Primary and Standby databases. You can use Active Data Guard, which extends
Oracle Data Guard capabilities by providing read/write functionality on the
Standby or Disaster Recovery system. Active Data Guard allows you to offload
read operations to the Standby database, providing additional scalability and
flexibility. The statements that are not true: You cannot edit your
configuration to change between synchronous or asynchronous transport of data
to the DR site after enabling Data Guard. This statement is false. You can
modify the configuration to change the transport mode from synchronous to
asynchronous or vice versa. You must configure Data Guard manually to create
the Standby or DR instance for your Primary Exadata Database. This statement is
false. In Oracle Exadata Database Service, you can enable Data Guard support
with a single API call or using the user interface (UI) through cloud
automation.
Question 47: Correct
Where are the Automatic backups located when
your Exadata Database Service is deployed in the public cloud?
Object Storage
(Correct)
NFS Mount
Block Storage
Exadata Storage (RECO)
Recovery Appliance
Explanation
✅ The Automatic backups in
Exadata Database Service deployed in the public cloud are located in Object
Storage. Object Storage is a scalable, durable, and highly available storage
solution provided by Oracle Cloud Infrastructure. It is used to store various
types of data, including backup files, in a cloud-native manner. Automatic
backups of Exadata Database Service are typically stored in Object Storage to
ensure data protection and easy accessibility for recovery purposes.
Question 48: Correct
You are designing an Exadata Database
Service-based architecture for a customer who has a requirement that all
maintenance, including database upgrades, be completed with as little downtime
as possible. Which technology should be used?
Active Data Guard
(Correct)
Application Continuity
RMAN
ASM instead of LVM
Multitenant
Explanation
✅ To minimize downtime
during maintenance, including database upgrades, the technology that should be
used in an Exadata Database Service-based architecture is Active Data Guard.
Active Data Guard extends the capabilities of Oracle Data Guard by allowing
read/write access to the standby database, which enables offloading reporting
and backup operations from the primary database. By leveraging Active Data
Guard, you can perform rolling upgrades and apply patches without impacting the
availability of the database, thus achieving minimal downtime during
maintenance activities.
Question 49: Correct
Your company's security policy requires you to
patch the database within a month of a relevant database patch being released
by Oracle. Which method requires the least amount of downtime?
Create a new database home, patch it to the version you want,
and then move the database to the new home.
(Correct)
Download the latest patch from MOS, back up your database, run a
precheck, then apply the patch on the database home.
Back up your database, run a precheck, then apply the patch on
the database home where the database resides.
Download the latest patch from MOS, back up your database, and
use dbaascli to apply the patch on the database home.
Explanation
✅ To minimize downtime
while patching the database, the method that requires the least amount of
downtime is to create a new database home, patch it to the desired version, and
then move the database to the new home. This approach involves setting up a
separate database home, applying the patch to it, and then using Oracle
Database tools to move the database to the newly patched home. By performing
the patching process in a separate home, you can minimize the downtime by reducing
the time required for the actual switchover of the database to the patched
home. This method allows for a smooth transition and ensures that the database
remains available during the patching process.
Question 50: Correct
You want to create a backup of only the data
that was added or changed since the last FULL backup. Which type of supported
backup by MySQL Database Service must you use?
Mirror
mysqldump
Full
Incremental
(Correct)
Explanation
✅ To create a backup of
only the data that was added or changed since the last FULL backup in MySQL
Database Service, you must use the Incremental backup type. Incremental backups
capture and store only the changes made to the database since the last full or
incremental backup. This approach allows for more efficient backup operations
by reducing the amount of data that needs to be processed and stored. By using
Incremental backups, you can minimize the backup time and storage requirements
while still ensuring that your data is adequately protected.
Question 51: Incorrect
What is the NoSQLHandle interface NOT used
for?
to set the row retention time
(Correct)
to access multiple tables
(Incorrect)
to get dynamic information on a table
to gets rows from a table
Question 52: Correct
Which two statements are true about Oracle
Cloud Infrastructure (OCI) Management Interfaces?
OCI CLI and dbcli (database CLI) are command-line interfaces
that can be used with virtual machine DB systems.
(Correct)
Virtual Machine DB Systems cannot be managed from the Web
Console and must use the provided Cloud REST APIs.
Terraform is an OCI Management Interface that allows for
programmatic access via https for secure application integration.
(Correct)
dbcli is available only on virtual machine DB systems and must
be run on the host.
OCI CLI and VMCLI are command-line interfaces that can be used
with virtual machine DB systems. 5. VMCLI is a command-line interface that is
available only on virtual machine DB systems and must be run on the host.
Question 53: Incorrect
Which tool should you use to run the LIST
FLASHCACHE DETAIL command in the Exadata Database Service environment?
OCI CLI
(Incorrect)
cellcli
(Correct)
dbaascli
exacli
Explanation
✅ The tool you should use
to run the LIST FLASHCACHE DETAIL command in the Exadata Database Service
environment is: cellcli. The cellcli tool is specifically designed for managing
and monitoring Exadata storage cells. It provides a command-line interface to
interact with the Exadata storage cell and perform various administrative
tasks, including running commands like LIST FLASHCACHE DETAIL to retrieve
detailed information about the flash cache configuration and usage in the
Exadata environment.
Question 54: Correct
Which Oracle Cloud service does NOT support
Real Application Cluster database?
Autonomous Database
(Correct)
VM
Exadata Cloud Service (both ExaCS and ExaCC)
Bare Metal
Explanation
✅ The Oracle Cloud service
that does NOT support Real Application Cluster (RAC) database is: Autonomous
Database. Autonomous Database is a cloud-based, fully managed database service
provided by Oracle. It is designed for simplicity and ease of use, and it does
not support the Real Application Cluster (RAC) feature. RAC is a feature that
enables clustering of multiple database instances to provide high availability
and scalability, but it is not available in the Autonomous Database service.
Therefore, the correct answer is Autonomous Database.
Question 55: Correct
You write policy statements to allow a trusted
developer to manage all aspects of the MySQL Database Services in your tenancy.
Which three MySQL resources, within Oracle Cloud Infrastructure, can this
developer control?
mysql-monitor
mysql-work-requests
(Correct)
mysql-shell
mysql-backups
(Correct)
mysql-instances
(Correct)
Explanation
✅ The three MySQL
resources, within Oracle Cloud Infrastructure, that a trusted developer can
control are: mysql-instances: The developer can manage and control MySQL
Database Service instances, including provisioning, scaling, configuring, and
monitoring the instances. mysql-backups: The developer can manage and control
MySQL Database Service backups, including scheduling, configuring backup
policies, and performing backup and restore operations. mysql-work-requests:
The developer can manage and control MySQL Database Service work requests, such
as creating, monitoring, and managing various tasks and operations related to
the database service. Therefore, the correct options are: mysql-instances
mysql-backups mysql-work-requests
Question 56: Incorrect
Which three statements are true about Exadata
Snapshots on the Exadata Database Service?
Exadata Snapshots utilize the Exadata SPARSE disk group to store
the sparse files that contain only changed blocks.
(Correct)
Before creating Exadata Snapshots from the test master, you can
modify the data in the test master, if required.
(Correct)
Multiple users can create independent Exadata Snapshots from the
same test master, which is a full Read-Only clone of the source database.
(Correct)
Exadata Snapshots are unable to utilize all the Exadata
features.
(Incorrect)
Exadata Snapshots utilize the Exadata SPARSE disk group to store
the sparse files that contain all the data that is read and written by the
Snapshots.
Question 57: Incorrect
You have successfully created a MySQL database
server and all its required components. What should you use to keep track of
the health, capacity, and performance of your MySQL system on C Cloud
Infrastructure?
MySQL Database Service monitor
(Incorrect)
MySQL Database Service metrics
(Correct)
MySQL Database Service manager
MySQL Database service check
Question 58: Incorrect
Which statement is true about scaling storage
for a Virtual Machine DB System?
You must concurrently scale up the storage used by the VM DB
System for the Available Data storage size and the Recovery Area storage size.
You must concurrently scale up or down the storage used by the
VM DB System for the Available Data storage size and the Recovery Area storage
size.
(Incorrect)
You can independently scale the storage used by the VM DB System
but the Available Data storage size cannot be decreased, whereas the Recovery
Area storage size can be decrease
You can independently scale the storage used by the VM DB System
but the Available Data storage size and Recovery Area storage size cannot be
decreased.
(Correct)
Question 59: Incorrect
On the Add HeatWave Cluster dialog, you are
asked to provide the shape for the HeatWave nodes. Which detail does the shape
selection provide to HeatWave?
The private IP address for the Analytic Cluster
The Disk partition count for the HeatWave cluster
The number of CPUs for the Analytic cluster
(Incorrect)
The associated database system network Gbps
(Correct)
Question 60: Incorrect
With Exadata Database Service, what is true
about the available licensing models?
You can switch between licensing models as many times as you
like online.
(Incorrect)
You can switch between licensing models as many times as you
like, but it will require an outage.
You cannot switch from the License Included to BYOL.
(Correct)
You can only switch from BYOL to License Included, once online.
Question 61: Incorrect
You want to check if cloud tools are
up-to-date in Exadata Database Service. Which two steps should you perform to
obtain the current version of cloud tooling on a database server?
Run the dbaascli patch tools list command.
(Incorrect)
Run the rpm -qa |grep -i dbaastools_exadata command.
(Correct)
You must first connect to Exadata Cloud Service as the oracle
user.
(Correct)
You must first connect to Exadata Cloud Service as opc and sudo
to the root user.
Question 62: Incorrect
Which two statements are true when configuring
an Oracle Data Guard standby for a database system Oracle Cloud Infrastructure?
Both DB systems must be in the same region.
(Correct)
The database editions must be Enterprise Edition - Extreme
Performance.
(Incorrect)
Both DB systems must be in the same compartment.
(Incorrect)
Both DB systems must be in the same subnet.
Both DB systems must be the same type; for example, if the
primary database is a virtual machine, then the standby database must also be
that of a virtual machine.
(Correct)
Question
63: Incorrect
You no longer want to manually back up your
MySQL Database Service What must you do to turn on automatic backup?
Use Oracle Enterprise Manager to enable Automatic Backups
Install MySQL Enterprise Backup on the MySQL Database Service
system
(Incorrect)
Backups. Recreate the MySQL Database Service system and enable
Automatic Backups
Update the MySQL Database Service system and enable Automatic
Backup.
(Correct)
Question 64: Incorrect
What two reasons do you need a minimum of
three storage cells when using Exadata Cloud Service?
For high availability
(Correct)
For Fast Start Failover of storage cells
For Data Guard
For Real Application Clusters
(Incorrect)
For triple mirroring of data
(Correct)
Question 65: Incorrect
Assume that there are no resource limits on
your underlying Exadata Cloud@Customer hardware. What is the maximum number of
Autonomous container databases that can be created on one Autonomous VM
Cluster?
4
32
(Incorrect)
5
12
(Correct)
Question 66: Incorrect
You are considering whether or not to
implement bare metal or virtual machine shapes. Which TWO statements are true
about bare metal and virtual machine (VM) database (DB) systems?
The Console, API, and Oracle Cloud Infrastructure CLI are
options for managing bare metal DB systems.
(Correct)
Both bare metal and vm DB systems support two-node Real
Application Clusters (RAC) systems.
(Incorrect)
Bare metal shapes determine the total raw storage allocated to
bare metal DB systems.
(Correct)
Bare metal and VM DB can only have a single Database Home, and
the single database will be the version of the Database Home.
Question 67: Correct
Which statement is FALSE about using
compartments?
They are a physical concept that separates users.
(Correct)
They allow you to isolate resources.
They can be organized in a hierarchical fashion.
They can be used to secure resources.
Question 68: Correct
Which three actions can you perform on a DB
system that has an Oracle Data Guard association with a standby database?
(Choose three.)
Write on both primary and standby databases because DB system
standby databases in Oracle Cloud Infrastructure Database are logical standbys.
Terminate a primary database in the DB system.
Failover the standby database to the primary role if the primary
database becomes unavailable.
(Correct)
Switch over the primary database to the standby role, perform
maintenance on the standby database, and then switch it back to the primary
role.
(Correct)
Use the reinstate command to return a failed database to the
standby role after correcting the cause of failure.
(Correct)
Question 69: Correct
How many IP addresses do you need at a minimum
for the client subnet when you plan to have four Exadata compute nodes on
Exadata Cloud Service? (Choose the best answer.)
0
(Correct)
1
2
3
4
Explanation
✅ The correct answer is:
"0." When planning to have four Exadata compute nodes on Exadata
Cloud Service, you do not need any additional IP addresses for the client
subnet. The client subnet refers to the network subnet used for client access
to the Exadata Database Service. The Exadata Cloud Service uses a virtual IP
(VIP) for client connectivity. The VIP is a single IP address that is
associated with the Exadata compute nodes and provides access to the database
service. It acts as the entry point for client connections and load balancing.
Therefore, in this scenario, you do not require any additional IP addresses
specifically for the client subnet. The virtual IP (VIP) associated with the
Exadata compute nodes is used to handle client connections, making additional
IP addresses unnecessary. ((3 address * 2 nodes) +3 for SCANs +3 reserved in
subnet )
Question 70: Correct
Which statement is true about MySQL Database
Service?
It is a public cloud service built on MySQL Community Edition.
Its users are responsible for database and operating system
patching tasks.
It is a fully managed Oracle Cloud Infrastructure (OCI) native
service.
(Correct)
It supports MySQL Enterprise Edition version 5.7 with InnoDB
Storage Engine.
Question 71: Incorrect
You are in the DatabaseAdmins group. To
execute patching functions for DB Systems only in your tenancy, permission must
be granted to your group. Because permissions are not granted by default, which
permission needs to be added to the DatabaseAdmins group to allow you to patch
the DB system?
Allow group DatabaseAdmins to manage db-systems in the
DatabaseAdmins tenancy.
Allow group DatabaseAdmins to manage db-systems in tenancy.
Allow group DatabaseAdmins to patch db-systems in tenancy.
(Correct)
Allow group DatabaseAdmins to patch db-systems in compartment.
(Incorrect)
Question 72: Incorrect
You want to protect all the network
communications between your organization network and Oracle Cloud using secure
encryption and integrity algorithms. Which two statements are correct?
You should purchase TDE for your cloud environment.
You should configure the database parameters to only allow
connections from encrypted clients.
(Incorrect)
You should consider leveraging a VPN.
(Correct)
You should use AES, DES, and EBT certified cryptosystems that
Oracle database provides for protecting the confidentiality of Oracle Net
Traffic.
You should consider leveraging FastConnect.
(Correct)
Question 73: Correct
You want to scale within the Exadata System.
Which two statements are true?
If you have set the database parameter cpu_count for instance
caging, it is not affected by any modification to the number of enabled OCPUs.
(Correct)
If you have set the database parameter cpu_count for instance
caging, it is affected by any modification to the number of enabled OCPUs.
Modifying the number of enabled OCPUs does not require database
downtime.
(Correct)
Modifying the number of enabled OCPUs requires database
downtime.
Question 74: Incorrect
You have a group called DatabaseAdmins and you
need to allow them to create Exadata Database Services. Which is the correct
IAM policy to use?
Allow group DatabaseAdmins to manage databases in tenancy
Allow group DatabaseAdmins to create database-family in tenancy
(Correct)
Allow databases in tenancy to be managed by DatabaseAdmins
(Incorrect)
Allow tenancy DatabaseAdmins to manage database-family in group
Allow group DatabaseAdmins to manage database-family in tenancy
Question 75: Incorrect
You are using the CLI command oci mysql
db-system get, to retrieve the MySQL Database System details. What value must
you provide to perform this task?
DB System IP address
DB System DB ID
(Incorrect)
DB System Tenancy ID
DB System OCID
(Correct)
Question 76: Correct
Which statement is FALSE about updating your
Virtual Machine DB System database?
Updating the DB system updates the Grid Infrastructure for
two-node RAC DB Systems with Automatic Storage Management (ASM) storage
management software.
Ensuring /u01 has 15 GB of free space.
Updating the DB System does NOT update the operating system.
(Correct)
Updating the DB System also updates the operating system.
Continue
Retake test
