Oracle Oracle Exadata 1Z0-902 Questions & Answers

• Question 1:

  Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

  A. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

  B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.

  C. Run exachk and resolve only WARNINGS that you have not seen before.

  D. Run the appropriate patchmgr preqequisite check step for each component being updated.

  E. Run patchmgr --all_comp --autofix --autobackup --upgrade --rolling.

  F. For database servers, perform a server backup using patchmgr --dbnodes db_list_file --backup --rolling.

  Correct Answer: ABCD

  Explanation: According to Oracle.com documents or resources, the four actions that you should take before proceeding with applying updates to your Exadata Database Machine are:

  A. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.

  B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453. C. Run exachk and resolve only WARNINGS that you have not seen before3. D. Run the appropriate patchmgr preqequisite check step for each component being updated3.

• Question 2:

  You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.

  1.

  Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.

  2.

  Use drop down to add ZFS Storage Appliance Controllers.

  3.

  You cannot add ZFS Storage Appliance to an Exadata Rack.

  4.

  Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.

  5.

  Use drop down to add ZFS Storage Trays.

  6.

  Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.

  7.

  Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.

  8.

  Use drop down to add Exadata X9M EF Storage Servers.

  9.

  Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.

  10.

  Use drop down to add Exadata X9M Database Servers.

  11.

  Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31. Which of these steps are correct and what is their correct order?

  A. 10, 8, 2, 5

  B. 4,1, 6, 9

  C. 3

  D. 10, 8, 9, 11

  E. 7,6,9,11

  Correct Answer: D

  Explanation: The correct order of steps is 10, 8, 9, 11. The 10th step is to use the drop down to add Exadata X9M Database Servers, the 8th step is to use the drop down to add Exadata X9M EF Storage Servers, the 9th step is to use "Add Equipment" to add the ZFS Storage Controllers, and the 11th step is to use "Add Equipment" to add the ZFS Storage Trays. These steps are referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html. https://docs.oracle.com/en/engineered-systems/exadata-database- machine/dbmin/configuring-exadata.html

• Question 3:

  You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance. Which ILOM command starts the storage server?

  A. -> start /System

  B. -> start /SP/console

  C. -> set /SYS power_state=ON

  D. You must be physically present in the data center to start an Exadata Storage Server.

  E. -> start /SYSTEM/power

  F. -> start /SYS/power

  Correct Answer: C

  Explanation: This command is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. This command sets the power state of the system to ON and starts the storage server. It is the only command that is able to start the storage server remotely. All the other commands are incorrect or require the user to be physically present in the data center.

• Question 4:

  How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

  A. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.

  B. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.

  C. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.

  D. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.

  Correct Answer: D

  Explanation: Exadata Secure RDMA Fabric isolation is a feature that allows you to use virtualization on the X9M-2 platform while maintaining security and isolation between multiple tenants or VM clusters. Secure Fabric isolation works by creating a dedicated network partition and VLAN ID for each Database VM cluster, which is used for cluster networking between the database servers in the VM Cluster. This ensures that the network traffic of each VM cluster is isolated from the others, and it prevents unauthorized access to the data or resources of other VM clusters. Secure Fabric isolation can also be used for other purposes such as client networking, Data Guard traffic, but it's mainly used to provide security and isolation between multiple tenants or VM clusters.

  According to Oracle's documentation1, Exadata Secure RDMA Fabric Isolation is a feature that enables strict network isolation for Oracle Real Application Clusters (Oracle RAC) clusters on Exadata Database Machine systems that use RDMA over Converged Ethernet (RoCE). Exadata Secure RDMA Fabric Isolation uses RoCE VLANs to ensure that network packets from one VM cluster cannot be seen by another VM cluster. VLAN tag enforcement is done at the KVM host level, which means that security cannot be bypassed by any software exploits or misconfiguration on the database server VMs1. Therefore, the statement that is true about how Exadata Secure RDMA Fabric isolation is used in X9M-2 with virtualization enabled is: With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.

• Question 5:

  You are updating your Exadata X9M-2 Elastic Database Machine with 6 database servers and 12 High Capacity Storage Servers. You will be using patchmgr to apply updates across the entire machine while still maintaining database availability.

  Assuming you are driving patchmgr from an external server, which statement is true about the execution phase?

  A. patchmgr must be invoked with the --rolling argument. Each component type must be upgraded independently of the other.

  B. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

  C. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

  D. patchmgr must be invoked with the --rolling argument with all database and storage servers listed in a single input file.

  Correct Answer: D

  According to Oracle documentation12, patchmgr is the utility used to update software for Exadata infrastructure components. It can apply patches in a rolling or non-rolling manner depending on the argument and input file provided.

• Question 6:

  I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category. Which two monitoring tools might be useful in examining I/O performance for the prod database?

  A. OS I/O metrics using Enterprise Manager host pages for the storage servers

  B. OS I/O metrics using OS tools such as iostat on the database servers

  C. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us

  D. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

  E. OS I/O metrics using OS tools such as iostat on the storage servers

  Correct Answer: CD

  Explanation: According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:

  cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the

  storage layer.

  I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us ? These views can help you monitor the I/O activity and latency at the file,

  function, and consumer group level.

• Question 7:

  Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

  A. the failure of physical disk 1

  B. corruption in the / (root) filesystem

  C. the failure of both physical M.2 disks

  D. the failure of physical disk 0 and 11

  E. moving all disks from one cell to another as part of a chassis-level component failure

  F. accidental loss of all data from all griddisks in a storage server

  G. corruption in a normal or high redundancy ASM diskgroup

  Correct Answer: BC

  Explanation: The two valid reasons are:

  corruption in the / (root) filesystem . According to 1, this is one of the scenarios that requires a storage server rescue procedure , because it prevents the storage server from booting up normally . The rescue procedure will re-image the root

  filesystem with a fresh copy of the operating system and restore the configuration files from a backup1.

  the failure of both physical M.2 disks . According to 2, each Exadata Storage Server X9M-2 has two physical M.2 disks that store the operating system and configuration files for the storage server . If both M.2 disks fail , then the storage

  server cannot boot up or function properly . The rescue procedure will replace the failed M.2 disks with new ones and re-image them with the operating system and configuration files2.

• Question 8:

  What are two recommended configuration best practices for backup and recovery on Exadata?

  A. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.

  B. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

  C. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.

  D. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.

  Correct Answer: AD

  According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:

  A. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.

  D. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.

• Question 9:

  What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

  A. Oracle Linux 7.5

  B. Oracle Linux 7.9

  C. Oracle Linux 8.0

  D. Oracle Linux 7.7

  Correct Answer: B

  Explanation: Oracle Linux 7.9 is the minimum version required to support RoCE and Persistent Memory. This is because Oracle Linux 7.9 includes kernel enhancements that enable RDMA over Converged Ethernet (RoCE) networking and Intel Optane DC Persistent Memory Modules (DCPMM) for Exadata X8M systems3. These features allow faster access latency and higher throughput for database workloads2.

• Question 10:

  Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?

  A. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.

  B. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.

  C. In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.

  D. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.

  E. It is required to install OEDA on the first new database server.

  Correct Answer: CD

  Explanation: https://docs.oracle.com/en/database/oracle/oracle-database/21/ladbi/db-on- exadata.html