Oracle Base
Database Services 2023 Professional
Oracle 1Z0-1093-23 Exam Questions [2023] - Latest Release-Part
1
Question
1: Correct
.What
capability in the OCI Database Management Service is available using Database
Groups?
Execute
a SQL query for the databases.
(Correct)
Install
patches for the databases.
View
database log events.
Predict
long-term capacity trends for the databases.
Explanation
✅ The correct capability in the OCI Database Management
Service that is available using Database Groups is: "Execute a SQL query
for the databases." Database Groups in the OCI Database Management Service
provide a way to group databases together for easier management and monitoring.
They offer various capabilities for managing and analyzing databases
collectively. One of the capabilities of Database Groups is the ability to
execute a SQL query for the databases within the group. This allows you to run
a SQL query across multiple databases simultaneously, making it convenient for
tasks such as data analysis or applying changes to multiple databases at once.
The other options mentioned in the answer choices are not directly associated
with Database Groups: Viewing database log events can be performed using the
Database Logs feature, which is separate from Database Groups. Installing
patches for databases is done using the Patching feature, which is also independent
of Database Groups. Predicting long-term capacity trends for databases is
typically part of capacity planning and forecasting, which is not a specific
capability of Database Groups. Therefore, the correct capability that can be
achieved using Database Groups is executing a SQL query for the databases.
Question
2: Correct
.Which
are the three strategies to migrate Oracle Database to Oracle Cloud
Infrastructure (OCI)? (Choose three.)
Zero
Downtime Migration (ZDM)
(Correct)
Autonomous
migration
Real
Application Clusters (RAC)
Migration
Workbench
(Correct)
GoldenGate
(Correct)
Explanation
✅ The three strategies to migrate Oracle Database to Oracle
Cloud Infrastructure (OCI) are: Migration Workbench: The Migration Workbench is
a tool provided by Oracle that assists in migrating Oracle databases to OCI. It
helps streamline the migration process by providing step-by-step guidance,
automation, and validation checks to ensure a successful migration. GoldenGate:
GoldenGate is a data replication and integration tool provided by Oracle. It
enables real-time data synchronization and replication between on-premises and
cloud databases, allowing for a phased or ongoing migration approach. With
GoldenGate, you can migrate your Oracle Database to OCI while minimizing
downtime and ensuring data consistency. Zero Downtime Migration (ZDM): Zero
Downtime Migration (ZDM) is a cloud service provided by Oracle that facilitates
the migration of on-premises Oracle Databases to OCI with minimal or no
downtime. ZDM automates the migration process, performs pre-checks, handles
data replication, and provides failback capabilities, ensuring a smooth and
seamless migration experience. Autonomous migration and Real Application
Clusters (RAC) are not specifically recognized as strategies to migrate Oracle
Database to OCI. Autonomous migration is not a well-defined term in the context
of Oracle Database migration to OCI, and Real Application Clusters (RAC) refers
to a database configuration option rather than a migration strategy.
Question
3: Correct
.Your
company has decided on a Hybrid Cloud strategy and wants to monitor their cloud
and on-premises Oracle databases. Which action should they take?
Subscribe
to cloud events to send custom notifications about cloud Exadata systems to the
on-premises Enterprise Manager.
Use
Enterprise Manager to monitor all your Exadata systems that are on-premises or
in the cloud from a single interface.
(Correct)
Configure
the cloud console to send notifications about cloud Exadata systems to the
on-premises Enterprise Manager.
Use
the cloud console to monitor all your Exadata systems that are on-premises or
in the cloud from a single interface.
Explanation
✅ The correct answer is: Use Enterprise Manager to monitor
all your Exadata systems that are on-premises or in the cloud from a single
interface. To monitor both on-premises and cloud Oracle databases, including
Exadata systems, in a hybrid cloud environment, it is recommended to use Oracle
Enterprise Manager. Enterprise Manager is a comprehensive management solution
provided by Oracle that allows you to monitor and manage your Oracle databases,
including Exadata systems, from a single interface. By using Enterprise Manager,
you can centrally monitor and manage your on-premises and cloud-based Oracle
databases, including Exadata systems, regardless of their location. It provides
features such as performance monitoring, diagnostics, configuration management,
and automation, allowing you to efficiently monitor and maintain your database
environment in a hybrid cloud scenario. While the cloud console and custom
notifications can be useful for specific purposes, Enterprise Manager offers a
more comprehensive and unified approach to monitoring and managing databases in
a hybrid cloud setup.
Question
4: Correct
Which
tool can be used to monitor a storage server in Exadata Database Service?
OCI
CLI
dbaascli
ocpucli
exacli
(Correct)
Explanation
✅ The "exacli" tool can be used to monitor a
storage server in Exadata Database Service. The "exacli" tool is a
command-line utility specific to Exadata systems that provides various
administrative and monitoring functionalities. With "exacli", you can
gather information and statistics related to the storage servers in an Exadata
system. You can monitor storage cell metrics, such as disk health, disk
utilization, I/O performance, and storage server availability. This tool
enables you to troubleshoot and analyze storage-related issues, allowing you to
maintain and optimize the performance of your Exadata Database Service.
Question
5: Incorrect
.You
have been brought in to help an organization with slow nightly batch processing
running on their Exadata Database Service. You determine that the workload is
CPU-bound during the batch window. Which command-line tool would you use to
script an increase or decrease in OCPUs?
dbnodecli
OCI
CLI
(Incorrect)
ocpucli
(Correct)
exacli
Question
6: Correct
.A
database is running on Exadata Database Service on Dedicated Infrastructure in
the public cloud. Which statement is true for Performance Hub?
Performance
Hub in Basic or Full mode is free but Full mode requires more storage
Performance
Hub with the Basic Database Management option delivers advanced features for
monitoring Exadata, RAC Database Monitoring. SQL Tuning Advisor, Database Fleet
Monitoring, and Database Administration features.
Performance
Hub is only available once you enable and pay for the Full Database Management
option.
Performance
Hub provides Database Management features for Oracle Cloud Databases and is
available as part of two management options (Basic and Full).
(Correct)
Explanation
✅ The correct statement is: Performance Hub provides Database
Management features for Oracle Cloud Databases and is available as part of two
management options (Basic and Full). Performance Hub offers advanced monitoring
and management features for Exadata Database Service on Dedicated
Infrastructure in the public cloud. It provides capabilities such as Exadata
and RAC Database Monitoring, SQL Tuning Advisor, Database Fleet Monitoring, and
Database Administration features. Performance Hub is available in two
management options: Basic and Full.
Question
7: Correct
How
do you remove a MySQL Database Service backup from the Oracle Cloud
Infrastructure system?
Open
the backup details page by clicking on the backup's name, and click the Delete
button.
(Correct)
Open
the database, select the backup screen and click the Delete button.
Select
the database service and set the Backup Retention Period value to 0.
Select
the database service and click the remove backup button.
Explanation
✅ To remove a MySQL Database Service backup from the Oracle
Cloud Infrastructure system, you should follow these steps: Open the Oracle
Cloud Infrastructure Console. Navigate to the MySQL Database Service. Click on
the "Backups" tab to view the list of backups. Locate the backup you
want to remove and click on its name to open the backup details page. On the
backup details page, click the "Delete" button to remove the backup.
(Correct) By following these steps, you can specifically select the backup you
want to delete and remove it from the system.
Question
8: Correct
How
many IPs are required for the Backup Subnet supporting an Exadata Database
Service with six Database Compute Servers?
9
16
12
24
(Correct)
Explanation
✅ The correct answer is: "24." When setting up an
Exadata Database Service with six Database Compute Servers, you would typically
require 24 IPs for the Backup Subnet. Each Database Compute Server requires
four IPs for the backup network. Since there are six Database Compute Servers
in this scenario, the total number of IPs needed would be 4 IPs per server
multiplied by 6 servers, which equals 24 IPs. Therefore, the correct answer is
24 IPs.
Question
9: Correct
Exadata
Database Service is started with BYOL as the license type. How can you change
your license type?
Update
the license type by submitting a service request (SR) to support.
Use
the Update License Type option on the VM Cluster details page to switch license
type online.
(Correct)
Use
the Update License Type option on the VM Cluster details page to restart the VM
Cluster with the desired license type.
Use
the Move database option to relocate to a new Database Home on the VM Cluster
with the desired license type.
Explanation
✅ The correct answer is: "Use the Update License Type
option on the VM Cluster details page to switch license type online." To
change the license type in Exadata Database Service when it is started with
Bring Your Own License (BYOL), you can use the "Update License Type"
option available on the VM Cluster details page in the Oracle Cloud
Infrastructure Console. This allows you to switch the license type online
without the need for service requests or restarting the VM Cluster. By
selecting the appropriate license type in the update process, you can change
the licensing model for your Exadata Database Service and ensure compliance
with your licensing requirements. The other options mentioned (submitting a
service request, restarting the VM Cluster, and relocating to a new Database
Home) are not the recommended methods for changing the license type in Exadata
Database Service.
Question
10: Correct
.As
part of your daily maintenance process, you log in to Oracle Cloud
Infrastructure, select your DB system name, and select the Stop action. Which
two statements are true about your stopped MySQL Database Service system?
(Choose two.)
Maintenance
starts when the DB system is restarted.
You
can no longer connect to a stopped MySQL database.
(Correct)
The
database system stops billing for all OCPUs associated with it.
(Correct)
Any
backups associated with the database system are deleted.
The
database system is permanently deleted.
Explanation
✅ The two statements that are true about a stopped MySQL
Database Service system in Oracle Cloud Infrastructure (OCI) are: You can no
longer connect to a stopped MySQL database: When a MySQL Database Service
system is stopped, it is no longer accessible for database connections. The
database is effectively offline and cannot be accessed until it is started
again. The database system stops billing for all OCPUs associated with it: When
a MySQL Database Service system is stopped, billing for the OCPUs (Oracle Compute
Units) associated with the system is paused. This means you won't be billed for
the compute resources while the system is in a stopped state. Billing resumes
when the database system is started again. The other statements are incorrect:
The database system is not permanently deleted when it is stopped. It can be
started again to resume normal operation. Stopping the database system does not
delete any backups associated with it. Backups are separate entities and are
not automatically deleted when the database system is stopped. Maintenance
activities do not start automatically when the DB system is restarted.
Maintenance tasks need to be initiated separately as per your maintenance
process. Therefore, the two true statements about a stopped MySQL Database
Service system are that you can no longer connect to the database, and billing
for the associated OCPUs is paused.
Question
11: Correct
.(CHK)You
want to permanently delete the DB System and its attached Heatwave cluster. Which
action should you perform?
Terminate
the DB system and drop the associated HeatWave Cluster.
Delete
the DB system and it will also delete the attached HeatWave Cluster.
(Correct)
Delete
the HeatWave Cluster and it will also delete the DB system.
Drop
the DB system and terminate the associated Heatwave Cluster.
Explanation
✅ To permanently delete a DB System and its attached HeatWave
cluster, you should perform the following action: Delete the DB system, and it
will also delete the attached HeatWave Cluster. By deleting the DB system, you
initiate the removal of all resources associated with the DB system, including
the attached HeatWave Cluster. Deleting the DB system ensures that both the DB
system and its associated HeatWave Cluster are permanently removed from your
Oracle Cloud Infrastructure (OCI) environment. The other options mentioned are
not the correct actions for deleting the DB System and its HeatWave Cluster:
Terminating the DB system and dropping the associated HeatWave Cluster is not
the recommended action, as terminating the DB system will only stop and remove
the DB system itself, but the HeatWave Cluster will not be automatically
deleted. Dropping the DB system and terminating the associated HeatWave Cluster
is not the correct action because dropping the DB system alone will not trigger
the termination of the HeatWave Cluster. Therefore, the correct action is to
delete the DB system, and it will also delete the attached HeatWave Cluster.
Question
12: Correct
.Which
two key architecture choices lead to a compelling performance and cost advantage
with HeatWave? (Choose two.)
Optimized
for Oracle Cloud Infrastructure
(Correct)
Innovative
in-memory columnar analytics engine
(Correct)
Combination
of Innodb and MyISAM tables to improve HeatWave performance
Data
stored in binary JavaScript Object documents
Explanation
✅ The two key architecture choices that lead to a compelling
performance and cost advantage with HeatWave are: Innovative in-memory columnar
analytics engine: HeatWave utilizes an innovative in-memory columnar analytics
engine. This engine is designed to accelerate query performance for MySQL
databases. By storing and processing data in a columnar format in memory,
HeatWave can efficiently execute complex analytical queries, resulting in
significant performance improvements compared to traditional storage and query
processing methods. Optimized for Oracle Cloud Infrastructure: HeatWave is
optimized to take advantage of the underlying infrastructure provided by Oracle
Cloud Infrastructure (OCI). OCI offers high-performance networking, storage,
and compute resources, which are leveraged by HeatWave to deliver enhanced
performance and scalability. By leveraging the optimized infrastructure,
HeatWave can efficiently process and analyze large datasets, resulting in
improved performance and cost-effectiveness. Data stored in binary JavaScript
Object (JSON) documents and using a combination of InnoDB and MyISAM tables do
not directly contribute to the compelling performance and cost advantage with
HeatWave. Therefore, the two key architecture choices that lead to a compelling
performance and cost advantage with HeatWave are the innovative in-memory
columnar analytics engine and the optimization for Oracle Cloud Infrastructure.
Question
13: Correct
.You
are asked to measure useful quantitative data about a MySQL Database Service
system. You must provide information such as current connection information,
statement activity, latency, and host OCPU, memory, and disk I/O utilization.
Which three Oracle Cloud Infrastructure monitoring methods should you use?
(Choose three.)
alarms
(Correct)
metrics
(Correct)
data
points
queries
notifications
(Correct)
Explanation
✅ You are asked to measure useful quantitative data
Question
14: Correct
.Which
three Oracle Cloud Infrastructure (OCI) services can be used to connect to
on-premises networks? (Choose three.)
Internet
Gateway
Service
Gateway
Dynamic
Routing Gateway (DRG)
(Correct)
IPSec
VPN
(Correct)
FastConnect
(Correct)
Explanation
✅ The three Oracle Cloud Infrastructure (OCI) services that
can be used to connect to on-premises networks are: FastConnect: FastConnect
provides a dedicated and private connection between an on-premises network and
OCI. It offers higher bandwidth and lower latency compared to public internet
connections, making it suitable for connecting critical workloads and
transferring large amounts of data. Dynamic Routing Gateway (DRG): The DRG is a
virtual router that enables secure communication between an on-premises network
and the virtual cloud network (VCN) in OCI. It allows for the exchange of
network traffic and routing information between the on-premises network and the
resources in OCI. IPSec VPN: IPSec VPN (Internet Protocol Security Virtual
Private Network) enables secure connectivity between an on-premises network and
OCI over the public internet. It establishes an encrypted tunnel for secure
data transmission, allowing for remote access and secure communication between
the on-premises network and OCI resources. Service Gateway and Internet Gateway
are not used for connecting to on-premises networks. Service Gateway enables
private connectivity from a VCN to Oracle services, while Internet Gateway
provides access to the internet from a VCN. Therefore, the three OCI services
that can be used to connect to on-premises networks are FastConnect, Dynamic
Routing Gateway (DRG), and IPSec VPN.
Question
15: Correct
Your
MySQL Database Service system is automatically backed up between midnight and 1
AM. What must you do to change the starting time to 4 AM?
Select
Backup Window from the Edit MySQL DB System Details page and set the start time
to 4 AM.
(Correct)
Use
the mysqlbackup command to establish a 4 AM backup start time.
Update
the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify
the 4 AM backup window start time.
Edit
the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4
AM.
Explanation
✅ The correct answer is: "Select Backup Window from the
Edit MySQL DB System Details page and set the start time to 4 AM." To
change the starting time of the automatic backups for your MySQL Database
Service system in Oracle Cloud Infrastructure (OCI), you need to access the Edit
MySQL DB System Details page and modify the Backup Window settings. Here are
the steps to change the backup start time to 4 AM: Go to the OCI Console and
navigate to the MySQL Database Service page. Locate and select the specific
MySQL DB System you want to modify. On the DB System Details page, click on the
"Edit" button. In the Edit MySQL DB System Details form, scroll down
to the Backup Window section. Click on the "Change" link next to the
existing backup window time. Select the desired start time of 4 AM from the
dropdown menu. Save the changes by clicking the "Save Changes"
button. By following these steps, you will be able to update the backup window
start time for your MySQL Database Service system to 4 AM.
Question 16: Correct
After
you have provisioned a virtual machine (VM) database (DB) system, what action
can you take to meet changes in block storage requirements?
If
a VM DB system requires more block storage, you can increase the storage at any
time without impacting the system.
(Correct)
If
you want to increase or decrease the storage, you must change the shape of the
VM DB system.
After
you have provisioned a VM DB system. you cannot increase or decrease block
storage.
If
a VM DB system has different requirements for block storage, you can increase
or decrease the storage at any time without impacting the system.
Explanation
✅ The correct answer is: If a VM DB system requires more
block storage, you can increase the storage at any time without impacting the
system. After provisioning a VM DB system, you have the flexibility to increase
the block storage if the system requires more storage capacity. This can be
done without impacting the system's availability or functionality. Oracle Cloud
Infrastructure allows you to dynamically scale the block storage of a VM DB
system based on your changing requirements. By increasing the block storage,
you can accommodate additional data or growth in your database workload. This
ensures that you have the necessary storage capacity to meet your evolving
needs without any disruption to the system. It's important to note that
decreasing the block storage of a VM DB system may not be possible without
impacting the system. In some cases, reducing the block storage may require
changes to the VM DB system's shape or configuration.
Question
17: Incorrect
.Which
two statements are true about changing the shape of a virtual machine (VM)
database (DB) system to adapt to changes in performance needs? (Choose two.)
After
you provision a VM DB system, you cannot change the shape: you have to
provision another VM DBsystem using a full backup.
It
is possible to change the shape of a VM DB system with a higher number of
OCPUs. However, reducingthe number of OCPUs is not permitted.
(Correct)
After
you provision a VM DB system with a shape that supports Oracle RAC, you can
change the currentshape to another shape that does not support Oracle RAC.
(Correct)
It
is possible to change the shape of a VM DB system without impacting the amount
of storage available tothe DB system.
If
the current shape of the VM DB system supports Oracle Real Application Clusters
(RAC), then you canonly change the current shape to another shape that also
supports Oracle RAC.
(Incorrect)
Question
18: Correct
.While
configuring a Virtual Machines (VM) database (DB) system, the next step after
selecting a shape for the DB system is to select storage options and
configuration. Which two configurations should you select and use? (Choose
two.)
Use
Logical Volume Manager (LVM) for the storage management of single-node VM
deployments.
Configure
storage to assign 40% to DATA and the rest to redo logs and archive logs.
(Correct)
Use
Object Storage buckets for DATA, redo logs, and archive logs.
Use
Automatic Storage Management (ASM) for the storage management software of
single and two node VM deployments.
(Correct)
Explanation
✅ The two configurations that you should select and use while
configuring a Virtual Machines (VM) database (DB) system are: Use Automatic
Storage Management (ASM) for the storage management software of single and
two-node VM deployments: ASM is a feature of Oracle Database that simplifies
storage management and provides high availability and performance. It is
commonly used with Oracle VM DB systems to manage the underlying storage for
the database. Selecting ASM ensures efficient and reliable storage management
for your VM DB system. Configure storage to assign 40% to DATA and the rest to
redo logs and archive logs: This configuration involves setting up the storage
allocation for different components of the database. Allocating 40% of the
storage to DATA (the main data files) and the remaining storage to redo logs
and archive logs is a common practice. It ensures that sufficient space is
allocated for storing the actual data while also accommodating the necessary
logs for transaction processing and recovery. Therefore, the two configurations
you should select and use for the VM DB system are using Automatic Storage
Management (ASM) and configuring storage allocation to assign 40% to DATA and
the rest to redo logs and archive logs.
Question
19: Correct
.You
define a maintenance window for your MySQL DB systems. When the automatic
maintenance process takes place, which two activities does the system perform
while its status is set to UPDATING? (Choose two.)
It
patches the underlying operating system of the MySQL database.
(Correct)
It
patches the MySQL server itself along with any underlying hardware.
(Correct)
It
upgrades the associated compute instance to the latest Linux operating system
version.
It
analyzes, rebuilds, and optimizes MySQL database tables and indexes.
Explanation
✅ The two activities that the system performs while its
status is set to UPDATING during the automatic maintenance process are: It
patches the underlying operating system of the MySQL database. (Correct) This
activity involves updating the Linux operating system on the compute instance
where the MySQL database is running. It ensures that the system has the latest
security patches and bug fixes. It patches the MySQL server itself along with
any underlying hardware. (Correct) This activity involves updating the MySQL
server software to the latest version. It may also include patching any
underlying hardware components related to the MySQL DB system. Note: The
automatic maintenance process typically focuses on updating the software and
components related to the MySQL DB system rather than upgrading the entire
compute instance's operating system.
Question
20: Correct
Which
statement is true about moving virtual machine (VM) database (DB) systems from
one compartment to another?
You
can move DB systems to a different compartment if you have sufficient access
permissions to the compartment that the resource is being moved to, as well as
the current compartment.
(Correct)
You
do not need access permissions to the compartment that the resource is being
moved to when moving VM DB systems to a different compartment.
You
have to move dependent resources such as Database Homes and database to the
destination compartment before moving the VM DB system.
You
can only move VM DB systems from one compartment to another by using Oracle
Cloud Infrastructure REST APIS.
Explanation
✅ The correct statement is: "You can move DB systems to
another compartment as long as you have access permissions on the source and
target compartments." When moving a virtual machine (VM) database (DB)
system from one compartment to another in Oracle Cloud Infrastructure (OCI),
you need to have access permissions for both the source and target compartments.
This ensures that you have the necessary privileges to initiate and complete
the move operation. The process of moving the DB system typically involves
using the OCI Console or the OCI CLI (Command Line Interface). The other
statements mentioned are not entirely accurate: You do need access permissions
to both the source and target compartments. While there might be dependent
resources associated with the DB system, such as Database Homes and databases,
moving the DB system itself can be done independently. While REST APIs can be
used to interact with OCI services, it is not the only method for moving VM DB
systems between compartments. The OCI Console and OCI CLI also provide options
for this task.
Question
21: Correct
.You
notice that throttling is occurring on your NoSQL Database Cloud Service. What
must you increase to solve this?
Index
size
OCPU
for all servers in the cluster
(Correct)
Data
size
Storage
capacity
Explanation
✅ To solve throttling issues on your NoSQL Database Cloud
Service, you need to increase the OCPU (Oracle Compute Unit) for all servers in
the cluster. Throttling occurs when the database workload exceeds the available
processing capacity of the servers in the cluster. By increasing the OCPU
allocation, you provide more processing power to handle the workload, reducing
or eliminating throttling. Increasing the data size, index size, or storage
capacity alone may not directly address the throttling issue. Throttling is
typically caused by CPU resource limitations rather than data or storage
capacity constraints. Therefore, increasing the OCPU allocation is the
recommended action to resolve the throttling problem.
Question
22: Incorrect
.Which
two statements are true when deciding which Oracle Cloud Infrastructure (OCI)
region to register an Exadata Cloud@Customer infrastructure in? (Choose two.)
Consider
which availability domain (within the region) to create the Exadata Cloud@Customer
infrastructure in.
Exadata
Cloud@Customer is hosted in a customer data center so the Exadata
infrastructure is not registered in an OCI region
(Correct)
Consider
the physical proximity of the region you register the infrastructure in to your
data center.
(Incorrect)
The
Exadata Cloud@Customer region can be changed after the infrastructure is
created.
Consider
any business policies or regulations that preclude the use of a particular
region.
(Correct)
Question
23: Correct
.Which
two statements are true about recommended Subnet configurations for Exadata
Database Service? (Choose two.)
Use
Regional Subnets for both Client and Backup.
(Correct)
Use
two Public Subnets for Client and Backup.
Use
a Private Subnet for Client and a Service Subnet for Backup.
Use
a Public Subnet for Client and a Service Subnet for Backup.
Use
a Private Subnet for Client and Private Subnet for Backup.
(Correct)
Explanation
✅ The two statements that are true about recommended Subnet
configurations for Exadata Database Service are: Use a Private Subnet for
Client and Private Subnet for Backup: It is recommended to use private subnets
for both the client network and backup network. This ensures that the database
traffic and backup traffic are isolated within the private network, providing
an additional layer of security. Use Regional Subnets for both Client and
Backup: It is recommended to use regional subnets for both the client network
and backup network. Regional subnets are accessible from any availability
domain within the region, allowing for better availability and redundancy.
Using a Public Subnet for Client and a Service Subnet for Backup is not
recommended as it exposes the client network to the public internet, which can
pose security risks. Using two Public Subnets for Client and Backup is also not
recommended as it does not provide the desired level of isolation and security
for the database traffic and backup traffic.
Question
24: Correct
What
can you use to enable an on-premises Enterprise Manager instance to monitor
Exadata Database Service in a Private Oracle Cloud Infrastructure (OCI) Subnet?
Virtual
Cloud Network (VCN)
Client
Subnet
Virtual
Network Interface Card (VNIC)
FastConnect
(Correct)
Explanation
✅ To enable an on-premises Enterprise Manager instance to
monitor Exadata Database Service in a Private Oracle Cloud Infrastructure (OCI)
Subnet, you can use FastConnect. FastConnect is a dedicated network connection
service that allows you to establish a high-bandwidth, low-latency connection
between your on-premises network and your private OCI Subnet. By setting up a
FastConnect connection, you can extend your on-premises network into the OCI
environment and enable your on-premises Enterprise Manager instance to securely
monitor and manage the Exadata Database Service running in the private subnet.
The Virtual Cloud Network (VCN) is the networking construct in OCI that
provides the foundation for all network resources, but it alone does not enable
the connectivity between the on-premises Enterprise Manager and the private
subnet. The Client Subnet and Virtual Network Interface Card (VNIC) are
components of the OCI networking infrastructure but are not directly involved
in enabling the on-premises Enterprise Manager monitoring of the Exadata
Database Service in a private subnet.
Question
25: Correct
.How
many IPs do you need at a minimum for the Client Subnet, when you plan to have
six Database Compute Servers for your Exadata Database Service?
12
(Correct)
9
24
18
16
Explanation
✅ Therefore, the minimum number of IPs required for the
Client Subnet would be: 6 Database Compute Servers * 2 IPs per server = 12 Ips
Question
26: Correct
Which
network is used to facilitate the secure monitoring and administration of
Oracle-managed infrastructure components in Exadata Cloud@Customer?
InfiniBand
network
Client
network
Backup
network
Cloud
operations network
(Correct)
Explanation
✅ The correct answer is: "Cloud operations
network." In Exadata Cloud@Customer, the cloud operations network is used
to facilitate the secure monitoring and administration of Oracle-managed
infrastructure components. The cloud operations network is a dedicated network
infrastructure provided by Oracle for managing and monitoring the Exadata
infrastructure. This network is designed to ensure secure communication between
the Oracle-managed infrastructure components, such as the Exadata compute nodes
and storage servers, and the Oracle operations and management systems. It
allows Oracle to remotely manage and monitor the Exadata infrastructure,
perform maintenance tasks, and provide support services. The client network is
used for client access to the databases hosted on the Exadata Cloud@Customer
infrastructure. The InfiniBand network is a high-speed interconnect used for
communication between the Exadata compute nodes and storage servers. The backup
network is specifically used for backup and recovery operations within the
Exadata infrastructure. Therefore, the network used for secure monitoring and
administration of Oracle-managed infrastructure components in Exadata
Cloud@Customer is the "Cloud operations network."
Question
27: Correct
.For
which two reasons do you need a minimum of three storage cells when using
Exadata Database Service? (Choose two.)
Triple
mirroring of data.
(Correct)
High
availability
(Correct)
Real
Application Clusters
Fast
Start Failover of storage cells
Data
Guard
Explanation
✅ The two reasons why you need a minimum of three storage
cells when using Exadata Database Service are: High availability: Having at
least three storage cells allows for high availability and fault tolerance in
the Exadata infrastructure. The data in Exadata is distributed across multiple
storage cells, and having three or more cells ensures that there are redundant
copies of the data. If one storage cell fails, the data can still be accessed
from the remaining cells, ensuring continuous availability of the database.
Triple mirroring of data: Exadata Database Service uses a triple mirroring
configuration, where data is stored on three separate storage cells. This
provides data redundancy and protection against the failure of a single storage
cell. Having a minimum of three storage cells is necessary to achieve this
triple mirroring configuration and ensure that data is stored in a highly
resilient manner. It's important to note that Fast Start Failover, Real
Application Clusters, and Data Guard are not directly related to the minimum
requirement of three storage cells. They are additional features or
configurations that can be used in conjunction with Exadata but do not
specifically dictate the minimum number of storage cells required.
Question
28: Correct
.Which
two external databases can be monitored by the Oracle Cloud Infrastructure
(OCI) Database Management Service? (Choose two.)
Oracle
Autonomous Database 19c deployed on an OCI Tenant.
Oracle
12cR1 Database deployed on an Oracle Exadata Database Machine.
Oracle
18c Database deployed on Oracle Exadata Cloud@Customer.
(Correct)
Oracle
11gR2 Database deployed on an Oracle Private Cloud.
(Correct)
Explanation
✅ The two external databases that can be monitored by the
Oracle Cloud Infrastructure (OCI) Database Management Service are: Oracle 18c
Database deployed on Oracle Exadata Cloud@Customer: The OCI Database Management
Service can monitor Oracle 18c databases deployed on Exadata Cloud@Customer
infrastructure. This allows for comprehensive monitoring and management of the
database. Oracle 11gR2 Database deployed on an Oracle Private Cloud: The OCI
Database Management Service can also monitor Oracle 11gR2 databases deployed on
an Oracle Private Cloud. It provides monitoring capabilities for these
databases, allowing administrators to track performance, diagnose issues, and
perform management tasks. Oracle 12cR1 Database deployed on an Oracle Exadata
Database Machine and Oracle Autonomous Database 19c deployed on an OCI Tenant
are not mentioned as supported options for monitoring by the OCI Database
Management Service.
Question
29: Correct
.You
are asked to create a MySQL Database Service system. You log in to the group's
Oracle Cloud Infrastructure tenancy and access the assigned compartment, and
find that all policies have been configured and tested. What is the next step
to create a MySQL Database Service?
Create
a Linux compute instance.
Connect
to the MySQL Database Service system endpoint.
Create
a Virtual Cloud Network by using the VCN Wizard.
(Correct)
Create
the MySQL DB system.
Explanation
✅ The correct next step to create a MySQL Database Service
system is to create a Virtual Cloud Network (VCN) by using the VCN Wizard. A
Virtual Cloud Network is a fundamental networking construct in Oracle Cloud
Infrastructure that allows you to define your own private network in the cloud.
It provides the network infrastructure for your resources, including the MySQL
DB system. By creating a VCN, you can define the network configuration, such as
IP addressing, subnets, and security rules, to ensure proper connectivity and
security for your MySQL Database Service. After creating the VCN, you can
proceed with creating the MySQL DB system and then connect to the MySQL
Database Service system endpoint. Creating a Linux compute instance may be
required if you need to access the MySQL DB system from a separate compute
instance, but it is not the immediate next step in the process.
Question
30: Correct
.You
want to connect to your MySQL DB system's endpoint. You create an Oracle Linux compute
instance on the same Virtual Cloud Network as your MySQL DB system. Which two
actions must you perform to connect to your MySQL Database Service system?
(Choose two.)
Install
the MySQL client on your local computer.
Connect
to your database system by using the MySQL client on the Linux compute
instance.
(Correct)
SSH
into the compute instance from your local machine.
(Correct)
Define
a SQL Developer connection in your MySQL Database Service database system.
Explanation
✅ To connect to your MySQL Database Service system from an
Oracle Linux compute instance on the same Virtual Cloud Network, you need to
perform the following two actions: SSH into the compute instance from your
local machine. This step allows you to access and manage the compute instance
remotely. Connect to your database system by using the MySQL client on the
Linux compute instance. Once you are logged into the compute instance, you can
install the MySQL client and use it to establish a connection to your MySQL
Database Service system. Defining a SQL Developer connection in your MySQL
Database Service database system is not necessary to establish the connection
from the Oracle Linux compute instance, and installing the MySQL client on your
local machine is not directly related to connecting from the compute instance.
Question
31: Correct
.Which
three are prerequisites for using the MySQL Database Service?
You
must install the downloaded MySQL version onto Oracle Cloud Infrastructure.
You
must create a compartment to store your resources.
(Correct)
You
must download the latest MySQL version from https://edelivery.oracle.com/.
You
must create a tenancy and be able to sign in to it.
(Correct)
You
or your group must be granted the policies described in Mandatory Policies.
(Correct)
Explanation
✅ The three prerequisites for using the MySQL Database
Service are: You must create a compartment to store your resources. A
compartment is a logical container within Oracle Cloud Infrastructure where you
can organize and manage your resources. You need to create a compartment to
store and manage your MySQL Database Service instance and related resources.
You must create a tenancy and be able to sign in to it. A tenancy is the main
organization or account in Oracle Cloud Infrastructure. To use the MySQL Database
Service, you need to have a tenancy created and be able to sign in to it with
appropriate permissions and access. You or your group must be granted the
policies described in Mandatory Policies. The MySQL Database Service requires
specific policies to be granted to your user or group. These policies define
the necessary permissions and access rights to create, manage, and use the
MySQL Database Service instance and associated resources. It's important to
note that downloading and installing the MySQL software is not a prerequisite
for using the MySQL Database Service. The service is a managed database
offering where Oracle takes care of the installation, configuration, and
maintenance of the MySQL software for you.
Question 32: Correct
Which
service is used by default by the MySQL Database Service to store user data to
make it more resistant to failures?
OCI
Data Safe
OCI
Object Storage
OCI
File Storage
OCI
Block Volumes
(Correct)
Explanation
✅ The correct answer is "OCI Block Volumes." The
MySQL Database Service in Oracle Cloud Infrastructure (OCI) uses OCI Block
Volumes by default to store user data and make it more resistant to failures.
OCI Block Volumes provide persistent block storage that can be attached to
instances, such as the MySQL Database Service, to store data. These block
volumes are highly available and provide data durability and reliability. OCI
Data Safe is a separate service in OCI that helps enhance the security of
databases, including MySQL Database Service, by providing a comprehensive set
of security controls and practices. While OCI Data Safe contributes to the
security aspect of the MySQL Database Service, it is not directly related to
the storage of user data or making it more resistant to failures. OCI Object
Storage and OCI File Storage are other storage options in OCI, but they are not
the default storage options used by the MySQL Database Service for storing user
data. OCI Object Storage is designed for storing large amounts of unstructured
data, while OCI File Storage provides a scalable and high-performance file
system.
Question
33: Correct
.Which
two steps must be taken before installing a management agent for the Oracle
Cloud Infrastructure (OCI) Database Management Service? (Choose two.)
Create
or copy an Agent Install Key.
(Correct)
Install
TLS 1.3 on the database system.
Create
or copy an Agent OCID.
Patch
the database to be managed.
Confirm
the OS and networking requirements.
(Correct)
Explanation
✅ The two steps that must be taken before installing a
management agent for the Oracle Cloud Infrastructure (OCI) Database Management
Service are: Confirm the OS and networking requirements: Before installing the
management agent, you need to ensure that the operating system (OS) of the
target system meets the requirements specified by Oracle. Additionally, you
need to ensure that the network connectivity and firewall settings are
configured correctly to allow communication between the management agent and the
Database Management Service. Create or copy an Agent Install Key: An Agent
Install Key is a unique identifier used to authenticate the management agent
with the Database Management Service. Before installing the agent, you need to
create or copy an Agent Install Key from the OCI Console. This key will be used
during the installation process to establish the secure connection between the
agent and the service. The steps of patching the database or installing TLS 1.3
are not directly related to the installation of the management agent for the
Database Management Service and are not required prerequisites for the agent
installation.
Question
34: Correct
.Which
two statements are true about monitoring a DB system in Oracle Cloud Infrastructure
(OCI)? (Choose two.)
Performance
Hub is a time-based monitoring system that provides information only on CPU
utilization and SQL query response times.
You
can view Database Metrics directly in the console with Virtual Machine DB
Systems by navigating to Observability & Management and then selecting
Database Management.
(Correct)
You
can view database performance analysis and tuning through Performance Hub,
which provides a consolidated view of real-time and historical performance
data.
(Correct)
You
can view database performance analysis and tuning through Performance Hub,
which provides only a consolidated view of historical performance data for
comparative analysis.
Advanced
Database Management features for Oracle Cloud Databases with the Full
Management option is available at no additional cost by enabling the feature on
the Database details page.
Question
35: Correct
Which
three actions can you perform on a DB system that has an Oracle Data Guard association
with a standby database? (Choose three.)
If
the primary database becomes unavailable, then you can use Oracle Data Guard to
fail over the standby database to the primary role.
(Correct)
You
can write on both primary and standby databases because DB system standby
databases in Oracle Cloud Infrastructure Database are logical standbys.
You
can terminate a primary database DB system.
You
can use the reinstate command to return a failed database into standby role
after correcting the cause of failure.
(Correct)
You
can 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)
Question
36: Incorrect
How
many DB systems must you provision before you can enable Oracle Data Guard for
a virtual machine DB system database?
Three,
first for the primary database, second for the standby database, and a third
for the staging database in the Oracle Data Guard configuration.
Only
one for the primary database, because a new DB system is provisioned for the
standby database when it is created and associated with the primary database
while enabling Oracle Data Guard.
(Correct)
Two
for both the primary and standby databases, because a DB system with the
database that you want to use as the standby must already exist before you
enable Oracle Data Guard.
(Incorrect)
It
depends on how many standby databases you want for your primary database in the
Oracle Data Guard configuration in Oracle Cloud Infrastructure.
Question
37: Correct
.Which
two statements are true about cloning a Virtual Machine DB System? (Choose
two.)
When
creating a clone of the Virtual Machine DB system, you need to specify a new
SSH key and admin password.
(Correct)
Cloning
creates a copy of a source Virtual Machine DB system as it exists at the time
of the cloning operation, including the storage configuration software and
database volumes.
(Correct)
When
creating a clone, you must use the same SSH key and admin password as the
source Virtual Machine DB system.
Cloning
only creates a copy of a source Virtual Machine DB system as it exists at the
time of the cloning operation, but does not include the storage configuration
software and database volumes.
Explanation
✅ The two statements that are true about cloning a Virtual
Machine DB System are: Cloning creates a copy of a source Virtual Machine DB
system as it exists at the time of the cloning operation, including the storage
configuration software and database volumes. This means that the cloned system
will have the same storage configuration, software setup, and database volumes
as the source system at the time of cloning. This allows for easy replication
of an existing environment. When creating a clone of the Virtual Machine DB
system, you need to specify a new SSH key and admin password. During the
cloning process, you have the opportunity to specify a new SSH key and admin
password for the cloned system. This allows for customization and improved
security by using different credentials for the cloned system compared to the
source system. It's important to note that the cloning operation creates a
snapshot of the source system, so any changes made to the source system after
the cloning process will not be reflected in the cloned system.
Question
38: Correct
What
permissions do you need to perform actions on a NoSQL table?
NOSQL_ROWS_READ,
NOSQL_ROWS DELETE
(Correct)
NOSQL_TABLE
INSPECT, NOSQL_TABLE_UPDATE
NOSQL_TABLE_WRITE,
NOSOL_ROWS_INSERT
NOSQL_TABLE_DESTROY,
NOSQL_TABLE_ALTER
Explanation
✅ The correct permissions required to perform actions on a
NoSQL table are: NOSQL_ROWS_READ: This permission allows you to read the rows
from the table. NOSQL_ROWS_DELETE: This permission allows you to delete rows
from the table. These permissions enable you to perform the necessary actions
on the NoSQL table, such as reading data from it and deleting rows as needed.
Question
39: Correct
.Which
two must you create or configure to manage an external database? (Choose two.)
A
database group
A
database handle
(Correct)
A
database connection
(Correct)
A
dynamic group
Explanation
✅ The correct answers are: A database handle: A database
handle is required to uniquely identify and manage an external database in
Oracle Cloud Infrastructure. It serves as a logical representation of the
database. A database connection: A database connection is necessary to
establish a connection between the Oracle Cloud Infrastructure resources and
the external database. It provides the necessary information to connect to the
database, such as host, port, username, and password. A dynamic group: A dynamic
group is not specifically required to manage an external database. Dynamic
groups are used for defining policies based on dynamic criteria, such as
matching certain attributes of resources. A database group: A database group is
not specifically required to manage an external database. Database groups are
used for managing collections of Oracle Cloud Databases within Oracle Cloud
Infrastructure.
Question
40: Correct
.What
is the minimum OCPUS per compute server allowed on Exadata Database Service on
Dedicated Infrastructure (ExaDB-D) in the public cloud?
Zero
enabled OCPUS per compute server is allowed for ExaDB-D.
(Correct)
Four
minimum enabled OCPUS per compute server are allowed for ExaDB-D.
Minimum
enabled OCPUs for ExaDB-D must match your BYOL entitlement.
Two
minimum enabled OCPUS per compute server are allowed for ExaDB-D.
Explanation
✅ The correct answer is: Zero enabled OCPUS per compute
server is allowed for Exadata Database Service on Dedicated Infrastructure
(ExaDB-D) in the public cloud. In Exadata Database Service on Dedicated
Infrastructure, the compute servers are used exclusively for running the Oracle
database, and the minimum enabled OCPUs per compute server is set to zero. This
means that the compute servers can be provisioned without any CPU cores
enabled, and the CPU cores can be enabled later based on the workload
requirements. This flexibility allows users to optimize resource allocation and
scaling based on their specific needs.
Question
41: Correct
.What
three capabilities does the database fleet summary provide? (Choose three.)
View
the status of the databases.
(Correct)
Compare
database performance metrics over time.
(Correct)
View
the current database resource usage.
(Correct)
Migrate
databases to OCI.
Execute
a DDL command on the databases.
View
database log entries.
Explanation
✅ The three capabilities provided by the database fleet
summary are: View the current database resource usage: The database fleet
summary allows you to see the resource utilization of your databases, such as
CPU usage, memory usage, and storage consumption. This helps you monitor and
optimize the resource allocation for your databases. Compare database
performance metrics over time: The database fleet summary provides performance
metrics for your databases, allowing you to compare and analyze their
performance over different time periods. This helps identify trends,
bottlenecks, and areas for improvement. View the status of the databases: The
database fleet summary displays the status of your databases, indicating
whether they are running, stopped, or have any issues. This helps you quickly
identify any problems and take appropriate actions. Note that executing a DDL
command on the databases and migrating databases to OCI are not capabilities
provided by the database fleet summary.
Question
42: Correct
In
addition to Automatic backups of your Oracle database, you want to take
On-Demand backups of the database on Exadata Database Service on Dedicated
Infrastructure in the public cloud. How can you do this?
Disable
Automatic backup and then take an On-Demand backup.
On-Demand
backups are not allowed on Exadata Database Service because they use Automatic
backups.
Use
the Create Backup button in the backup section of the Database Details page to
take an On Demand backup.
(Correct)
Connect
to Exadata Database Service as oracle user first and then take an On-Demand
backup.
Explanation
✅ The correct answer is: Use the Create Backup button in the
backup section of the Database Details page to take an On-Demand backup. To
take an On-Demand backup of a database on Exadata Database Service on Dedicated
Infrastructure in the public cloud, you can use the Create Backup button in the
backup section of the Database Details page. This allows you to initiate a
backup manually whenever you need it, in addition to the automatic backups that
are already enabled for the database. By clicking on the Create Backup button,
you can specify the backup type, retention period, and other relevant
parameters to perform an On-Demand backup. This provides you with more control
over the backup process and allows you to take backups at specific points in
time as per your requirements.
Question
43: Correct
4>3
When you created your development database on Exadata Cloud@Customer, you
selected "None" for backup location. You now need to enable Automatic
backups on the development database with a retention period of 60 days. Which
action should you perform?
Change
the database backup location to a local storage and set the retention period to
60 days.
Change
the database backup location to an NFS backup location and set the retention
period to 60 days.
Change
the database backup location to Object storage with the default retention
period set.
(Correct)
No
action can be taken, because a new backup location cannot be set after
creation.
Explanation
✅ The correct action to perform is: "Change the database
backup location to Object storage with the default retention period set."
When you initially created the development database on Exadata Cloud@Customer
and selected "None" for the backup location, it means that no backup
location was configured. In order to enable automatic backups on the
development database with a retention period of 60 days, you need to set a
backup location. In this case, the recommended action is to change the database
backup location to Object storage. Object storage provides a reliable and
scalable solution for storing backups in the cloud. You can configure the
database to automatically back up to Object storage and set the desired
retention period of 60 days. By selecting the Object storage backup location
with the appropriate retention period, you ensure that regular automatic
backups are performed and retained for 60 days. Therefore, the correct action
is to change the database backup location to Object storage with the default
retention period set. Since the backup location was not selected during the
creation of the development database, it must be changed to enable automatic
backups. For Exadata Cloud@Customer, Oracle recommends using Object storage as
the backup location. Therefore, changing the database backup location to Object
storage with the default retention period set is the correct action to perform.
Question
44: Correct
.You
used the "Stop" option from the Console of an Exadata Database Service
virtual machine within a VM cluster. Which two statements are true? (Choose
two.)
All
the VMs in the cluster are stopped.
All
the databases in the VM cluster are stopped.
The
stopped VM is not available to any other database deployment.
(Correct)
Billing
for the OCPU stops but billing for the Exadata Infrastructure continues.
Billing
for the OCPU and Infrastructure are stopped until the VM restarts.
(Correct)
Explanation
✅ The correct statements are: Billing for the OCPU and
Infrastructure are stopped until the VM restarts. When you stop a VM within an
Exadata Database Service VM cluster, the billing for the OCPU (processing
power) and Infrastructure stops until the VM is restarted. The stopped VM is
not available to any other database deployment. The stopped VM is not
accessible or available for use by any other database deployment. It is
reserved for the specific deployment it belongs to. The other statements are
not true: All the VMs in the cluster are stopped. Only the specific VM that was
stopped will be affected. Other VMs in the cluster will continue running.
Billing for the OCPU stops but billing for the Exadata Infrastructure
continues. When a VM is stopped, billing for both OCPU and Exadata
Infrastructure stops until the VM is restarted. All the databases in the VM
cluster are stopped. Stopping a VM does not automatically stop all the
databases within it. Databases can continue running even if the VM is stopped.
Question
45: Correct
(DUP)
You used the "Stop" option from the Console of an Exadata Cloud
Service virtual machine within a VM cluster. What impact does this have?
(Choose the best answer.)
All
the virtual machines in the VM cluster are stopped.
All
the databases and infrastructure associated with the Exadata Cloud Service are
stopped.
The
Exadata Cloud Service is stopped.
The
Stopped virtual machine is not available to any other database deployment.
(Correct)
Explanation
✅ The correct answer is: "The Stopped virtual machine is
not available to any other database deployment." When you use the
"Stop" option from the Console on an Exadata Cloud Service virtual
machine (VM) within a VM cluster, it impacts only the specific VM that you
stopped. The other VMs in the VM cluster and the Exadata Cloud Service
infrastructure continue to run unaffected. The "Stop" operation on a
virtual machine makes it unavailable for any other database deployment or
usage. It essentially shuts down the VM, causing it to stop running and
disconnect from the network. This means that any databases or applications
hosted on that particular virtual machine will also be inaccessible until the
VM is started again. It's important to note that stopping a single VM in an
Exadata Cloud Service VM cluster does not affect the other virtual machines or
the overall Exadata Cloud Service. The remaining VMs and the Exadata
infrastructure continue to function normally.
Question
46: Correct
.Which
is NOT a prerequisite for patching the Grid Infrastructure or Database Homes
when using the console?
Ensuring
that all the database compute servers are of the VM Cluster type and are up and
running.
Ensuring
that the /u01 (GI Home) directory on the database host file system has at least
15 GB of free space before executing the Grid Infrastructure update.
Ensuring
that the Clusterware is down on the VM Cluster.
(Correct)
Ensuring
that the /u02 (DB Home) directory on the database host file system has 15 GB
free space before a DB Home update.
Explanation
✅ The statement that is NOT a prerequisite for patching the
Grid Infrastructure or Database Homes when using the console is: "Ensuring
that the Clusterware is down on the VM Cluster." Ensuring that the
Clusterware is down on the VM Cluster is not a prerequisite for patching the
Grid Infrastructure or Database Homes using the console. In fact, the
Clusterware needs to be up and running for the patching process to be
performed. The other three statements are valid prerequisites for patching:
Ensuring that the /u01 (GI Home) directory on the database host file system has
at least 15 GB of free space before executing the Grid Infrastructure update.
Sufficient free space is required in the GI Home directory to accommodate the
patch files and perform the update. Ensuring that the /u02 (DB Home) directory
on the database host file system has 15 GB of free space before a DB Home
update. Adequate free space is necessary in the DB Home directory to accommodate
the patch files and carry out the update. Ensuring that all the database
compute servers are of the VM Cluster type and are up and running. The patching
process should be performed when the database compute servers are running and
operational. Therefore, the correct statement is: "Ensuring that the
Clusterware is down on the VM Cluster."
Question
47: Correct
.In
Exadata Cloud Service, you use Oracle Data Guard for disaster recovery. What is
the minimum egress requirement needed to enable Data Guard between Exadata
Database Services?
Enable
egress for TCP traffic only for port 1521.
(Correct)
Enable
egress for TCP traffic only for port 1521 and port 22.
Enable
egress for TCP traffic only for port 22.
Enable
egress for TCP traffic for all outbound ports.
Enable
ingress for TCP traffic only for port 1521.
Explanation
✅ The correct answer is: Enable egress for TCP traffic only
for port 1521. To enable Data Guard between Exadata Database Services in
Exadata Cloud Service, you need to configure the appropriate network
connectivity. In this case, you should enable egress (outbound) traffic for TCP
traffic specifically on port 1521. Port 1521 is the default port used by Oracle
Database for communication, including Data Guard replication. Enabling egress
for TCP traffic only for port 1521 ensures that the necessary network communication
between the primary and standby databases is allowed, allowing Data Guard to
function properly for disaster recovery purposes.
Question
48: Correct
.The
/u02 directory containing Oracle Homes (OH) is 80% utilized, and you need to
free up space in it. You own two Oracle Homes, OH193_A and OH193_B with test
databases 193A and 1938, respectively. You decide to consolidate both databases
into a single Oracle Home (OH193_A) to free up space. Which two actions should
you perform? (Choose two.)
Copy
the sqlnet.ora and spfile from OH193 B to OH193_A and restart PDBs.
Schedule
a downtime window with the team using the 193B database.
(Correct)
Use
the Move Database option from the console to relocate the database to the target
Oracle Home.
(Correct)
Create
a new container database under OH193B and migrate the Pluggable Databases
(PDBs) from 1938 to 193A
Explanation
✅ The two actions you should perform to consolidate the
databases and free up space in the /u02 directory are: Use the Move Database
option from the console to relocate the database to the target Oracle Home
(OH193_A): This option allows you to move the database from OH193_B to OH193_A.
By selecting this option, you can specify the target Oracle Home and initiate
the relocation process. This will move the database files from the source
Oracle Home to the target Oracle Home, freeing up space in OH193_B. Schedule a
downtime window with the team using the 193B database: Before performing the
move operation, it is recommended to schedule a downtime window with the team
responsible for the 193B database. During the downtime, the database will be
unavailable while the move operation is executed. This ensures that the
database is not accessed or modified during the relocation process, minimizing
the risk of data inconsistencies. Creating a new container database and
migrating Pluggable Databases (PDBs) or copying configuration files like
sqlnet.ora and spfile are not necessary steps for consolidating the databases
into a single Oracle Home and freeing up space in the /u02 directory.
Question
49: Correct
.Which
method must you use to patch databases on Exadata Database Service with the
least amount of downtime?
Move
the database to a new Home with the desired patch level.
Leverage
Patchmgr to execute patching the database Home.
Create
a Data Guard standby and execute standby first patching.
(Correct)
Leverage
Opatch to execute patching the database Home.
Conduct
in place patching of the database Home.
Explanation
✅ The correct answer is: Create a Data Guard standby and
execute standby first patching. To patch databases on Exadata Database Service
with the least amount of downtime, one of the recommended methods is to create
a Data Guard standby database and execute standby first patching. This approach
involves setting up a standby database that replicates the primary database and
applying patches to the standby database first. By applying patches to the
standby database first, you can validate the patching process and ensure its
compatibility with your specific database workload. Once the patches are
successfully applied and tested on the standby database, you can perform a fast
switchover or failover to make the standby database the new primary database.
This method minimizes downtime because the primary database is not directly
patched but rather switched over or failed over to the already patched standby
database. This allows for a seamless transition with minimal impact on the
availability of the database. The other options mentioned, such as leveraging
Opatch, Patchmgr, conducting in-place patching of the database Home, or moving
the database to a new Home with the desired patch level, may involve more
downtime or complexity compared to using a Data Guard standby and executing
standby first patching.
Question
50: Correct
.Which
characteristic is NOT a factor that impacts the capacity units for provisioning
a NoSQL Database Cloud Service table?
Data
model
Record
size
Query
pattern
Durability
level
(Correct)
Explanation
✅ The characteristic that is NOT a factor impacting the
capacity units for provisioning a NoSQL Database Cloud Service table is the
durability level. Durability level refers to the level of data durability or
persistence in the database system. It is not directly related to the capacity
units needed for provisioning a table in the NoSQL Database Cloud Service.
Capacity units are primarily determined by factors such as the data model,
record size, and query pattern. The durability level determines how durable and
persistent the data is in the database system, but it does not directly affect
the capacity units required for provisioning a table.
Question
51: Correct
.Which
set of data types is supported by the NoSQL Database Cloud Service tables?
boolean,
date stamp, float
long,
double, triple
XML,
JSON, array
enum,
map, record
(Correct)
Explanation
✅ The set of data types supported by the NoSQL Database Cloud
Service tables are: enum: A data type that represents a set of predefined
values. map: A data type that represents an unordered collection of key-value
pairs. record: A data type that represents a collection of fields with their
corresponding values. Therefore, the correct set of data types supported by the
NoSQL Database Cloud Service tables is: enum, map, record.
Question
52: Correct
Which
statement is FALSE about using a compartment?
It
can be used to secure resources.
It
allows you to isolate resources.
It
can be organized in a hierarchical fashion.
It
is a physical concept that separates users.
(Correct)
Explanation
✅ The false statement about using a compartment is: "It
is a physical concept that separates users." Compartments in Oracle Cloud
Infrastructure (OCI) are logical entities used to organize and manage resources
within a tenancy. They are not a physical concept that separates users.
Instead, compartments provide a way to organize and isolate resources based on
specific criteria, such as projects, departments, or environments. Compartments
help in managing and securing resources by providing granular access control,
resource separation, and policy-based management.
Question
53: Correct
What
information is required to connect to the NoSQL Database Cloud Service?
signing
key fingerprint. API signing key, tenancy OCID
(Correct)
tenancy
ID, passphrase, handshake key
API
signing key, admin ID, user ID
user
ID. tenancy ID, component ID
Explanation
✅ The correct information required to connect to the NoSQL
Database Cloud Service is: Signing key fingerprint API signing key Tenancy OCID
(Oracle Cloud Identifier) These are the necessary credentials and identifiers
needed to authenticate and establish a connection with the NoSQL Database Cloud
Service. The signing key fingerprint is used for authentication and security
purposes, the API signing key is used to sign API requests, and the tenancy
OCID is a unique identifier for the Oracle Cloud tenancy associated with the
NoSQL Database Cloud Service.
Question
54: Incorrect
.What
three steps must you perform to connect to a MySQL database in the database
system by using SSH and MySQL Shell? (Choose three.)
Connect
to the MySQL Database Service instance.
(Correct)
Start
MySQL Shell on the compute instance.
(Correct)
Add
an ingress rule for port 20.
Install
MySQL Shell on the MySQL database system instance.
SSH
into the compute instance from your local machine.
(Correct)
Explanation
✅ To connect to a MySQL database in the database system using
SSH and MySQL Shell, you need to perform the following three steps: SSH into
the compute instance from your local machine. This step allows you to establish
a secure connection to the compute instance where MySQL Shell will be run.
Start MySQL Shell on the compute instance. Once connected to the compute
instance, you need to launch MySQL Shell, which provides an interactive
command-line interface to interact with the MySQL Database Service. Connect to
the MySQL Database Service instance. With MySQL Shell running, you can
establish a connection to the MySQL Database Service instance by providing the
necessary connection details, such as hostname, port, username, and password.
Installing MySQL Shell on the MySQL database system instance is not necessary
as it is typically installed on the compute instance from where you establish
the SSH connection. Adding an ingress rule for port 20 is also not directly
related to connecting to the MySQL database using SSH and MySQL Shell.
Question
55: Correct
You
want to move your VM Cluster to a different Oracle Cloud Infrastructure (OCI)
compartment for increased isolation from other teams that use the Exadata
Database Service in your tenancy. What happens if you do this?
The
VM Cluster and its dependent resources will move to the new compartment. The
dependent resources for a VM Cluster are the database homes, the databases, and
their automatic backups. All other resources will remain in the existing
compartment.
The
VM Cluster and associated databases will move to the new compartments. All
other resources will remain in the existing compartment.
(Correct)
The
VM Cluster and the underlying Exadata Infrastructure will move to the new
compartments. All other resources will remain in the existing compartment.
The
VM Cluster cannot change compartments, after it is deployed.
Explanation
✅ The correct statement is: The VM Cluster and associated
databases will move to the new compartments. All other resources will remain in
the existing compartment. When you move a VM Cluster to a different compartment
in Oracle Cloud Infrastructure (OCI), the VM Cluster and its associated
databases will be moved to the new compartment. However, other resources such
as the Exadata Infrastructure and any other resources not directly associated
with the VM Cluster will remain in the existing compartment. Moving the VM
Cluster to a different compartment allows for increased isolation and separation
from other teams using the Exadata Database Service in your tenancy.
Question
56: Incorrect
(DUP)
You want to move an Exadata Cloud@Customer VM cluster to a different OCI
compartment for increased isolation from other teams that use Exadata. What
happens when you use the console to do this? (Choose the best answer.)
The
VM cluster and associated databases will move to the new compartment. All other
resources will remain in the existing compartment.
(Incorrect)
The
VM cluster, compute nodes, and associated databases will move compartments. All
other resources will remain in the existing compartment.
(Correct)
The
VM cluster, compute nodes, and underlying Exadata infrastructure will move to
the new compartment. All other resources remain the same.
After
it is deployed, a VM cluster cannot change compartments.
Explanation
✅ The correct answer is: The VM cluster, compute nodes, and
associated databases will move compartments. All other resources will remain in
the existing compartment. When you use the console to move an Exadata
Cloud@Customer VM cluster to a different OCI (Oracle Cloud Infrastructure)
compartment, the VM cluster, compute nodes, and associated databases will be
moved to the new compartment. This allows you to achieve increased isolation
from other teams that use Exadata. It's important to note that only the specific
resources related to the VM cluster, compute nodes, and associated databases
will be moved to the new compartment. All other resources, such as networking
components, storage, and other infrastructure elements, will remain in the
existing compartment. This compartment move feature provides flexibility in
organizing and isolating resources within your OCI tenancy while ensuring that
the necessary dependencies and relationships between resources are maintained.
Question
57: Correct
.Which
NoSQL Database Cloud Service API statement can be used to adjust table
capacity?
TableProvision
TableUnits
TableLimits
TableRequest
(Correct)
Explanation
✅ The correct statement is: "TableRequest." To
adjust the table capacity in a NoSQL Database Cloud Service, you can use the
"TableRequest" API. This API allows you to modify various aspects of
a table, including its capacity. By issuing a TableRequest API call, you can
specify the desired changes to the table's capacity, such as increasing or
decreasing the number of read or write units. This allows you to dynamically
adjust the capacity to meet the changing workload demands of your application.
Therefore, "TableRequest" is the correct API statement for adjusting
table capacity in a NoSQL Database Cloud Service.
Question
58: Correct
.You
enable automatic backups on your Exadata Cloud@Customer? (Choose the best
answer.)
Database
archivelog files
Database
control files
Transparent
Data Encryption (TDE) keystore (wallet)
(Correct)
Server
parameter file (SP file)
Explanation
✅ The best answer is "Transparent Data Encryption (TDE)
keystore (wallet)". When you enable automatic backups on your Exadata
Cloud@Customer, the backups are encrypted using Transparent Data Encryption
(TDE). The TDE keystore, also known as the wallet, is used to store the
encryption keys and certificates required for encrypting and decrypting the
backup data. By utilizing TDE, the backups are encrypted at rest and provide an
additional layer of security for your data. The TDE keystore ensures that the
encryption keys are securely managed and protected. The other options mentioned
(database archivelog files, server parameter file (SP file), and database
control files) are not directly related to enabling automatic backups on
Exadata Cloud@Customer. Note:The backup and recovery facilities described in
this topic cater only for database backup and recovery, which includes Oracle
Database data files, log files, control files, and the server parameter (SP)
file. You are responsible for backing up other files on your virtual machines.
In particular, Oracle strongly recommends that you back up the Transparent Data
Encryption (TDE) keystore (wallet). Without the TDE keystore, the Oracle
Database backups are effectively useless, because you cannot read the data
contained in the backup.
Question
59: Correct
You
can manage and monitor performance of an autonomous database running on
autonomous Exadata Cloud @ Customer using the Performance Hub. Which two
actions can be undertaken by Performance Hub? (Choose two.)
Configure
auto indexing.
Kill
a running SQL session.
(Correct)
View
ASH Analytics.
(Correct)
scale
OCPUs for an autonomous database.
Configure
IO resource management (IORM).
Explanation
✅ The two actions that can be undertaken by Performance Hub
to manage and monitor the performance of an autonomous database running on
autonomous Exadata Cloud @ Customer are: View ASH Analytics: ASH (Active
Session History) Analytics provides detailed information about the active
sessions and their activity within the database. It allows you to analyze and
troubleshoot performance issues by providing insights into session activity,
wait events, and performance metrics. Kill a running SQL session: Performance
Hub allows you to identify and terminate a running SQL session that may be
causing performance issues or consuming excessive resources. Killing a running
SQL session can help address performance bottlenecks and improve overall system
performance. The other actions mentioned are not directly available in
Performance Hub: Scaling OCPUs for an autonomous database can be performed
through the Oracle Cloud Infrastructure Console or using the Autonomous
Database APIs, but it is not a functionality of Performance Hub. Configuring IO
resource management (IORM) is a configuration that is specific to Exadata
infrastructure and is managed outside of Performance Hub. Auto Indexing is a
feature available for autonomous databases but is not managed through
Performance Hub. Therefore, the two actions that can be undertaken by
Performance Hub are viewing ASH Analytics and killing a running SQL session.
Question
60: Correct
.Which
FOUR storage options are available in Oracle Cloud Infrastructure (OCI)?
(Choose four.)
Local
storage
(Correct)
Object
Storage
(Correct)
EFS
Storage
Block
Storage
(Correct)
File
Storage
(Correct)
Explanation
✅ The correct options are: Object Storage (Correct) File
Storage (Correct) EFS Storage Local storage (Correct) Block Storage (Correct)
Oracle Cloud Infrastructure (OCI) offers a variety of storage options to meet
different application requirements. The available options include Object
Storage, which is a scalable and durable storage service for storing
unstructured data; File Storage, which provides a fully managed, scalable, and
highly available network file system; EFS Storage, which is an NFS-based file
storage service; Local storage, which refers to the temporary storage available
on compute instances; and Block Storage, which offers persistent block storage
volumes that can be attached to compute instances.
Question
61: Correct
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?
(Choose two.)
The
DB system has no access to the Oracle Cloud Infrastructure Object Storage
service location where the backup is stored.
(Correct)
You
want to restore to an existing System Change Number (SCN).
Data
Guard must be disabled, or you must first remove the Data Guard association by
terminating the standby database before you can restore the database.
Restore
the database from an unmanaged backup in Object Storage created directly by
using RMAN.
(Correct)
Restore
the database from a backup in Object Storage that was created by using the
Console or the API.
Explanation
✅ The two false circumstances when using the Console to
recover a DB system database from a backup stored in Oracle Cloud
Infrastructure Object Storage are: The DB system has no access to the Oracle
Cloud Infrastructure Object Storage service location where the backup is
stored. This would prevent the DB system from accessing and retrieving the
backup for recovery. Restoring the database from an unmanaged backup in Object
Storage created directly by using RMAN. The Console does not support restoring
unmanaged backups created directly with RMAN. It only supports restoring
backups created through the Console or the API. The other two statements are
true: You can restore the database from a backup in Object Storage that was
created by using the Console or the API. If Data Guard is enabled, you may need
to disable it or remove the Data Guard association before restoring the
database.
Question
62: Correct
Patching
requires role permissions. However, since roles are not granted by default,
which role needs to be added to someone patching the DB system? (Choose the
best answer.)
Let
security admins manage vaults, keys, and secrets.
Let
database and fleet admins manage Autonomous Databases.
Let
database administrator's manage DB systems.
(Correct)
Let
users manage compute instance configurations, instance pools, and cluster
networks.
Explanation
✅ The role that needs to be added to someone patching the DB
system is "Let database administrators manage DB systems." This role
provides the necessary permissions to manage and perform various operations on
DB systems, including patching. By granting this role to a user or group, they
will have the required privileges to initiate and manage patching activities
for the DB systems within the Oracle Cloud Infrastructure (OCI) environment.
Question
63: Correct
Which
TWO statements are true about Interface for Exadata I/O Resource Management
(IORM)? (Choose two.)
IORM
allows workloads and databases to share I/O resources automatically according
to admin-defined policies.
(Correct)
IORM
can be enabled across multiple Exadata Racks using the Cloud interface of
Exadata Cloud Service.
IORM
can be enabled across multiple databases using the Cloud interface of Exadata
Cloud Service.
(Correct)
IORM
allows workloads and databases to share I/O resources automatically according
to user requests.
Explanation
✅ The two statements that are true about Interface for
Exadata I/O Resource Management (IORM) are: IORM allows workloads and databases
to share I/O resources automatically according to admin-defined policies. With
IORM, administrators can define policies that allocate and prioritize I/O
resources based on workload requirements. This ensures that different workloads
and databases on the Exadata system can effectively share and utilize the
available I/O resources in a controlled and optimized manner. IORM can be
enabled across multiple databases using the Cloud interface of Exadata Cloud
Service. The Cloud interface of Exadata Cloud Service provides the capability
to enable and configure IORM across multiple databases on the Exadata system.
This allows for fine-grained control over I/O resource allocation and
prioritization among different databases, ensuring that each database receives
its fair share of I/O resources based on the defined policies. It's important
to note that IORM is primarily focused on managing and optimizing I/O resources
among different workloads and databases on an Exadata system. It does not
directly involve the Cloud interface of Exadata Cloud Service in enabling IORM
across multiple Exadata Racks.
Question
64: Incorrect
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.)
32
14
4
(Incorrect)
18
(Correct)
8
Explanation
✅ ((3 address * 2 nodes) +3 for SCANs +3 reserved in subnet )
Question
65: Incorrect
You
want to scale within Exadata System. Which of the following two statements are
true? (Choose two.)
The
setting of database parameter CPU_COUNT is affected by modifying the number of
enabled OCPU cores.
(Incorrect)
The
setting of database parameter CPU_COUNT is not affected by modifying the number
of enabled OCPU cores.
(Correct)
Modifying
the number of enabled OCPU cores requires database downtime.
Modifying
the number of enabled OCPU cores does not require database downtime.
(Correct)
Explanation
✅ The two statements that are true when scaling within an
Exadata system are: The setting of database parameter CPU_COUNT is not affected
by modifying the number of enabled OCPU cores: When you modify the number of
enabled OCPU cores, it does not impact the value of the CPU_COUNT parameter in
the database. The CPU_COUNT parameter represents the number of CPUs available
to the database, and it is typically set based on the initial hardware
configuration. Modifying the number of enabled OCPU cores does not require
database downtime: Scaling the number of enabled OCPU cores can be done online
without requiring database downtime. This allows for dynamic adjustment of CPU
resources to meet changing workload demands without interrupting the database
operations. It's important to note that while modifying the number of enabled
OCPU cores does not require database downtime, other resource scaling
operations, such as adding or removing database nodes, may require database
downtime or interruption.
Question
66: Correct
.Which
two statements regarding private endpoints are true? (Choose two.)
You
can create a maximum of five Database Management private endpoints in your
tenancy (per region) to connect to single instance Oracle Cloud Databases in
the Bare Metal and Virtual Machine DB systems.
(Correct)
You
can create only one Database Management private endpoint in your tenancy (per
region) to connect to single instance Oracle Cloud Databases in the Bare Metal
and Virtual Machine DB systems.
You
can create a maximum of five Database Management private endpoints in your
tenancy (per region) to connect to RAC Oracle Cloud Databases.
You
can create only one Database Management private endpoint in your tenancy (per
region) to connect to RAC Oracle Cloud Databases.
(Correct)
Explanation
✅ The two statements that are true regarding private
endpoints are: You can create only one Database Management private endpoint in
your tenancy (per region) to connect to RAC Oracle Cloud Databases: This means
that you can have a single private endpoint specifically for connecting to RAC
(Real Application Clusters) Oracle Cloud Databases. A private endpoint allows
for a private network connection between your resources and the target
database. You can create a maximum of five Database Management private
endpoints in your tenancy (per region) to connect to single instance Oracle
Cloud Databases in the Bare Metal and Virtual Machine DB systems: This means
that you can create up to five private endpoints for connecting to single
instance Oracle Cloud Databases in the Bare Metal and Virtual Machine DB
systems. Each private endpoint provides a secure and isolated connection for
managing the respective databases. It's important to note that the number of
private endpoints allowed may vary based on the specific Oracle Cloud
Infrastructure service and its associated limitations and restrictions.
Question
67: Correct
.Which
statement regarding Data Regions is false?
A
Data Region can have only one Region Identifier with its respective Oracle
NoSQL Database Cloud Service endpoint.
(Correct)
A
Data Region for Oracle NoSQL Database Cloud Service is a localized geographic
area.
A
Default Data Region is configured for the user based on the Oracle Cloud
Account.
The
Oracle NoSQL Database Cloud Service can be accessed based on Data Regions using
the service endpoints.
Explanation
✅ The false statement regarding Data Regions is: "A Data
Region can have only one Region Identifier with its respective Oracle NoSQL
Database Cloud Service endpoint." In Oracle Cloud Infrastructure (OCI), a
Data Region represents a localized geographic area where OCI services are
available. Each Data Region is identified by a unique Region Identifier.
However, a Data Region can have multiple service endpoints associated with it,
including endpoints for Oracle NoSQL Database Cloud Service. The availability of
multiple service endpoints allows users to access services from different
network domains or for specific purposes (e.g., public endpoint, private
endpoint). Therefore, the correct statement is that a Data Region can have
multiple service endpoints, not just one.
Question
68: Correct
.Which
statement regarding MySQL HeatWave is false?
All
existing applications work without any changes.
You
cannot delete a HeatWave Cluster.
(Correct)
It
is the only MySQL service with a massively scalable, integrated analytics
engine.
Extreme
performance: Accelerates MySQL by orders of magnitude, scales to thousands of
cores.
Explanation
✅ The false statement regarding MySQL HeatWave is: "You
cannot delete a HeatWave Cluster." In reality, it is possible to delete a
HeatWave Cluster. In Oracle Cloud Infrastructure, you have the ability to
create, manage, and delete HeatWave Clusters as needed. Deleting a HeatWave
Cluster will remove the associated resources and configurations from your
environment. The other statements mentioned are true. MySQL HeatWave allows
existing applications to work without modifications, provides extreme
performance by accelerating MySQL queries significantly, and is the only MySQL
service with an integrated analytics engine that can scale to thousands of
cores.
Question
69: Correct
.Which
of the following is false about the automatic backup configuration settings?
Automatic
backups are scheduled daily.
For
database deployments with Oracle Data Guard, automatic backups can be executed
only on the primary site.
Archived
redo log files are backed up every 3 hours.
(Correct)
There
is a 7-day backup cycle with one full backup of the database taken every
Sunday, followed by daily incremental backups.
Explanation
✅ The false statement about automatic backup configuration
settings is: "Archived redo log files are backed up every 3 hours."
In Oracle Database, archived redo log files are not part of the automatic
backup process. Archived redo log files are typically used for recovery
purposes and are managed separately. Automatic backups in Oracle Database focus
on backing up the database data files, control files, and other necessary
components to ensure data protection and recovery.
Question
70: Incorrect
.Which
two are best practices for updating Virtual Machine DB system databases?
(Choose two.)
For
single-instance, provision a Data Guard standby and update it first to maintain
system availability.
(Correct)
Back
up your databases after you apply any updates to your system.
(Incorrect)
Before
you apply any update, run the precheck operation.
(Correct)
Patch
the DB System after updating a database for DB Systems with Grid
Infrastructure/ASM storage management.
Explanation
✅ The two best practices for updating Virtual Machine DB
system databases are as follows: Before you apply any update, run the precheck
operation. Running the precheck operation helps ensure that the system and
databases are in a suitable state for the update. It checks for any potential
issues or conflicts that may arise during the update process. For
single-instance, provision a Data Guard standby and update it first to maintain
system availability. In a single-instance configuration, having a Data Guard
standby database allows you to update the standby first and switch over to it
during the update process. This helps minimize downtime and maintain system
availability. Patch the DB system after updating a database for DB systems with
Grid Infrastructure/ASM storage management is not a best practice. It is
generally recommended to update the databases before patching the DB system to
ensure compatibility and avoid any potential issues. Backing up your databases
after applying any updates is a good practice, but it is not specific to
updating Virtual Machine DB system databases.
Question
71: Correct
.When
you create your VCN, subnets, and Exadata VM Cluster, which three identifiers
must you carefully set that are related to DNS in the VCN? (Choose three.)
Gateway
domain label
Hostname
prefix for the Exadata VM cluster.
(Correct)
VCN
domain label
(Correct)
Subnet
domain label
(Correct)
Explanation
✅ The three identifiers related to DNS that must be carefully
set when creating your VCN, subnets, and Exadata VM Cluster are: Hostname
prefix for the Exadata VM cluster: When creating the Exadata VM Cluster, you
need to specify a hostname prefix. This prefix will be used to generate the
hostnames for the VMs within the cluster. The hostname prefix is important for
DNS resolution and helps identify the VMs within the cluster. VCN domain label:
The VCN domain label is a domain name suffix that is used for DNS resolution
within the Virtual Cloud Network (VCN). It is appended to hostnames to form
fully qualified domain names (FQDNs) for the resources within the VCN. Subnet
domain label: Each subnet within the VCN can have its own domain label. The
subnet domain label is used for DNS resolution within that specific subnet. It
is appended to hostnames to form FQDNs for the resources within the subnet.
Therefore, the three identifiers that must be carefully set and are related to
DNS in the VCN are the Hostname prefix for the Exadata VM cluster, VCN domain
label, and Subnet domain label.
Question
72: Correct
.When
it comes to connecting to the NoSQL Database Cloud service, you are going to
need a series of connection credentials. Which connection credential is
optional when it comes to connecting to the cloud service?
User
ID
API
Signing Key
Signing
Key Pass Phrase
(Correct)
Signing
Key Fingerprint
Tenancy
ID
Explanation
✅ The connection credential that is optional when connecting
to the NoSQL Database Cloud service is the "Signing Key Pass Phrase."
This passphrase is used to protect the private key associated with the signing
key used for authentication. While it is generally recommended to use a
passphrase for added security, it is not mandatory, and you can choose to leave
it empty if desired. The other connection credentials, including the Tenancy
ID, Signing Key Fingerprint, API Signing Key, and User ID, are typically required
for establishing a connection to the service.
Question
73: Correct
.Which
three are true of the Bring Your Own Licensing model? (Choose three.)
Utilize
existing on-premises licenses and pay software support for them
(Correct)
Very-low,
compute-only consumption pricing, paid for with Universal Credits
(Correct)
Includes
Oracle Database Enterprise Edition with all options and management packs at one
low price
Consumption-based
pricing for software and OCPUs, includes software support and paid for with
Universal Credits
Includes
Transparent Data Encryption, Data Safe, Oracle Machine Learning, and select
management packs at no additional cost
(Correct)
Question
74: Correct
.Which
statement regarding Exadata Database Service on Dedicated Infrastructure
(Public Cloud) is false?
Custom
Route Tables are required for each subnet along with the Security List rules to
control the traffic to and from the client network and backup network.
The
Virtual Cloud Network must be in the same region where you want to launch
Exadata Database Service.
Before
you can configure the required Networks for the Exadata Database Service, you
must first use the OCI console or APIs to configure the VCN you plan to use
along with networking components such as subnets, route tables, security list
rules, gateways.
One
subnet is required in the VCN for the Client Subnet and Backup Subnet.
(Correct)
Explanation
✅ The correct answer is: "One subnet is required in the
VCN for the Client Subnet and Backup Subnet." This statement is false. In
the context of Exadata Database Service on Dedicated Infrastructure in the
Public Cloud, you typically require more than one subnet in the Virtual Cloud
Network (VCN). The VCN is the networking foundation that allows you to connect
and configure your resources. For the Exadata Database Service, you would
typically need at least three subnets in the VCN: Client Access Subnet: This subnet
is used for client connections to the database. It provides network
connectivity for applications or clients accessing the database service. Backup
Subnet: This subnet is used for the backup network. It is dedicated to
Exadata-specific backup traffic and is used for backup and recovery operations.
VIP Subnet: This subnet is used for the virtual IP (VIP) addresses associated
with the Exadata Database Service. Therefore, the false statement is that
"One subnet is required in the VCN for the Client Subnet and Backup
Subnet." In reality, you would need multiple subnets to support the
different networking requirements of the Exadata Database Service.
Question
75: Correct
.Oracle
NoSQL Database Cloud Service supports many common data types. Which three are
data types that are supported by Oracle NoSQL Database Cloud Service? (Choose
three.)
Date
Char
Long
(Correct)
Double
(Correct)
Binary
(Correct)
Explanation
✅ The three supported data types in Oracle NoSQL Database
Cloud Service are: Double (Correct): Represents a double-precision
floating-point number. Long (Correct): Represents a 64-bit signed integer.
Binary (Correct): Represents binary data or arbitrary byte arrays. Date and
Char are not explicitly supported data types in Oracle NoSQL Database Cloud
Service. However, you can store date values as strings or in a suitable format
and use the provided APIs for date manipulation and querying. Similarly,
character data can be stored as strings using the appropriate data type.
Question
76: Correct
.MySQL
HeatWave offers three flexible deployment options. Which deployment option uses
an innovative in-memory analytics engine to provide 400x query acceleration for
MySQL at a very compelling price and can be used for high volume with analytic
processing?
The
HeatWave option
(Correct)
The
High Availability option
The
Standalone option
Explanation
✅ The correct answer is: "The HeatWave option."
MySQL HeatWave is a feature of MySQL Database Service that provides accelerated
in-memory analytics for MySQL workloads. It offers significant query
acceleration, up to 400 times faster, by utilizing an innovative in-memory
analytics engine. This option is specifically designed for high-volume analytic
processing, allowing you to perform complex queries and analytics on large
datasets efficiently. The Standalone and High Availability options do not
specifically refer to the deployment options for MySQL HeatWave. They are more
generic terms used in the context of database deployment configurations,
indicating different levels of redundancy and fault tolerance. Therefore, the
correct option that uses the innovative in-memory analytics engine and provides
query acceleration for MySQL is the "HeatWave option."
Question
77: Correct
.What
is a collection of related resources (such as cloud networks, DB Systems, or
block volumes) that can be accessed only by those groups that have been given
permission by an administrator in your organization?
Policies
Compartment
(Correct)
Principals
Region
Explanation
✅ The correct answer is: "Compartment." In Oracle
Cloud Infrastructure (OCI), a compartment is a logical container or grouping of
related resources. It is a fundamental organizational unit that helps you
organize and isolate resources within your OCI tenancy. A compartment can
include various resources such as cloud networks, DB Systems, block volumes,
and more. One of the key features of a compartment is that access to its
resources is controlled by permissions. Only groups or users who have been
granted permission by an administrator can access and manage the resources
within a compartment. This provides a level of security and access control
within your OCI environment. Policies are a separate concept in OCI and are
used to define rules and permissions that govern access to resources. Region
refers to a specific geographic location where OCI resources are deployed.
Principals generally refer to the users, groups, or entities that can be
granted permissions to access resources. Therefore, the correct term for a
collection of related resources that can be accessed only by those groups with
permission is a "Compartment."
Question
78: Correct
.Which
two are required in order to create and manage Exadata Database Service?
(Choose two.)
The
appropriate IAM policies must be granted.
(Correct)
Security
Lists
The
tenancy needs to have appropriate service limits.
(Correct)
Use
the Dynamic Routing Gateway (DRG) to establish a connection with your
on-premises network via IPSec VPN or FastConnect.
Explanation
✅ To create and manage Exadata Database Service, you need to
ensure the following: The appropriate IAM (Identity and Access Management)
policies must be granted. IAM policies control access to Oracle Cloud
Infrastructure resources, and they define who can perform specific actions on
which resources. The tenancy needs to have appropriate service limits. Service
limits determine the maximum resources you can provision or use in Oracle Cloud
Infrastructure. You need to ensure that your tenancy has sufficient service
limits to create and manage Exadata Database Service. While establishing a
connection with your on-premises network using the Dynamic Routing Gateway
(DRG) via IPSec VPN or FastConnect can be beneficial for network connectivity,
it is not specifically required for creating and managing Exadata Database
Service. Security Lists, although important for network security and access
control, are not explicitly required for the creation and management of Exadata
Database Service.
Question
79: Correct
.Oracle
Cloud Infrastructure Object Storage is used to back up Virtual Machine DB
System databases. Which statement regarding backups is false?
You
can use the Console or API to enable automatic incremental backups and create
full backups on demand.
Full
(on-demand) backups remain in object storage as standalone backups after a DB
System or database is terminated.
All
backups are encrypted with the same master key used for Transparent Data
Encryption (TDE) wallet encryption.
You
cannot delete manual (on-demand) backups.
(Correct)
Explanation
✅ The statement that is false regarding backups in Oracle
Cloud Infrastructure Object Storage is: "You cannot delete manual
(on-demand) backups." In Oracle Cloud Infrastructure, you have the ability
to delete manual (on-demand) backups. Manual backups are created on-demand by
the user and can be deleted when they are no longer needed. This gives users
the flexibility to manage their backups and remove them as necessary. The other
statements are true: You can use the Console or API to enable automatic
incremental backups and create full backups on demand. This allows you to
schedule automatic backups and also manually trigger full backups as needed.
All backups are encrypted with the same master key used for Transparent Data
Encryption (TDE) wallet encryption. This ensures that backups are encrypted and
secure. Full (on-demand) backups remain in object storage as standalone backups
after a DB System or database is terminated. Even if the DB System or database
is terminated, the full backups remain intact in object storage and can be
accessed if needed. Therefore, the false statement is that "You cannot
delete manual (on-demand) backups."
Question
80: Correct
.Which
two are true about the Cloud Exadata Infrastructure resource required to
provision Exadata Database Service? (Choose two.)
It
enables the expansion of Exadata Database Service database and storage servers.
(Correct)
It
schedules infrastructure maintenance.
(Correct)
It
enables scale up and down of OCPUs.
It
manages networking, grid infrastructure, OS, database homes, databases, and
IORM.
Explanation
✅ The correct statements about the Cloud Exadata
Infrastructure resource required to provision Exadata Database Service are: It
schedules infrastructure maintenance. It enables the expansion of Exadata
Database Service database and storage servers. The Cloud Exadata Infrastructure
resource is responsible for managing networking, grid infrastructure, OS,
database homes, databases, and IORM. It also enables scaling up and down of
OCPUs, but this statement was not listed as one of the options. Therefore, the correct
answers are the statements related to scheduling infrastructure maintenance and
enabling the expansion of database and storage servers.
No comments:
Post a Comment