[Jul 16, 2023] Get Unlimited Access to 1z1-902 Certification Exam Cert Guide
Reliable Study Materials for 1z1-902 Exam Success For Sure
The 1Z0-902 exam covers a wide range of topics, including Exadata architecture, software installation and configuration, database migration, backup and recovery, performance tuning, and troubleshooting. Candidates are expected to have a deep understanding of Oracle databases and Exadata technology, as well as hands-on experience with installation, configuration, and maintenance of Exadata systems. Passing this exam will demonstrate their ability to implement and manage Exadata systems, and will help them advance their careers in the field of database administration.
NEW QUESTION # 16
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?
- A. list celldisk attributes name, deviceName, diskType, physicalFirmware
- B. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
- C. list cell attributes name, deviceName, diskType, physicalFirmware
- D. list devices attributes name, deviceName, diskType, physicalFirmware
Answer: A
NEW QUESTION # 17
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 1536GB
- B. 1024GB
- C. 768GB
- D. 384GB
- E. 2048GB
- F. 512GB
Answer: E
Explanation:
The Exadata X9M-2 Database Machine uses powerful database servers, each with two 32-core x86 processors and 512 GB of memory (expandable up to 2 TB).
NEW QUESTION # 18
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- B. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- C. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- D. The incline of any access route ramp must be less than or equal to 6 degrees.
- E. 914mm of space required above the rack height is required for maintenance access.
- F. Oracle Exadata Rack may only be installed on raised floor environments.
Answer: F
Explanation:
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/index.html
NEW QUESTION # 19
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. 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.
- 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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
Answer: A,C
Explanation:
A recommended configuration best practice for backup and recovery on Exadata is to place the backup network on dedicated switches installed in the top of the rack (ToR). This provides a greater level of control and isolates the backup network from other workloads. Additionally, even if the backup is limited to writing to four tape drives, it is recommended to specify eight channels to expedite the restore process.
Another best practice is to set the RMAN FILESPERSET parameter to 1 for the level 1 incremental backup set. This will optimize the internal Recovery Appliance backup and restore processing. Finally, if off-site long-term backup retention is needed, Oracle Database Backup Cloud Service should be used as a low-cost, offsite scalable storage solution for a disaster recovery solution.
NEW QUESTION # 20
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?
- A. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- B. the Power Distribution Units (PDUs)
- C. the storage server ILOM
- D. Oracle clusterware on the database server
- E. ASM instances
- F. the RDMA over Converged Ethernet (RoCE) switches
Answer: B,C,F
Explanation:
According to Oracle's documentation12, the components that are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins are:
The storage server ILOM2
The Power Distribution Units (PDUs)2
The RDMA over Converged Ethernet (RoCE) switches3
NEW QUESTION # 21
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU.
Which statement is correct?
- A. The installation can go ahead, no change is required.
- B. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
- C. The installation cannot proceed until two power feeds are available per PDU.
- D. A splitter cable can be used to provide power to all PDU cables.
Answer: A
Explanation:
According to the Oracle Exadata Database Machine X9M-2 Data Sheet1, each PDU has two power input cables that can be connected to separate power sources for redundancy. However, if only one power source is available per PDU, then a single cable can be used to provide sufficient power for normal operation.
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
NEW QUESTION # 22
How do ASM failure groups provide redundancy?
- A. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
- B. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- C. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
- D. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
Answer: D
Explanation:
According to Oracle's documentation12, ASM failure groups provide redundancy by storing mirror copies of data on different disks or storage servers. When ASM allocates an extent for a normal redundancy file, ASM allocates a primary copy and a secondary copy. ASM chooses the disk on which to store the secondary copy so that it is in a different failure group than the primary copy1. This way, if one disk or storage server fails, ASM can still access the data from another failure group2.
Therefore, the statement that is true about how ASM failure groups provide redundancy is:
Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
NEW QUESTION # 23
An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU. Which statement is correct?
- A. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
- B. The installation cannot proceed until two power feeds are available per PDU.
- C. The installation can go ahead, no change is required.
- D. A splitter cable can be used to provide power to all PDU cables.
Answer: B
Explanation:
In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack, and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will be able to provide sufficient power for the system. Therefore, the installation cannot proceed until two power feeds are available per PDU.
For more information about power requirements for Exadata X9M-2 Elastic Racks, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs
NEW QUESTION # 24
Which three statements are true about the CELLCLI command?
- A. It can be executed on storage servers.
- B. It has command-line history.
- C. It requires root privileges to create CELLDISKS and GRIDDISKS.
- D. It can execute commands on multiple storage servers in parallel.
- E. It can be executed using the DCLI utility.
Answer: A,B,E
Explanation:
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.
NEW QUESTION # 25
You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?
- A. 3,2,6,4,1,7,5
- B. 4,3,2,6,1,7,5
- C. 2,3,4,6,1,7,5
- D. 3,2,6,1,4,7,5
- E. 2,6,1,4,3,7,5
Answer: D
NEW QUESTION # 26
How do ASM failure groups provide redundancy?
- A. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
- B. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- C. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- D. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
Answer: A
NEW QUESTION # 27
Which three statements are true about the CELLCLI command?
- A. It has command-line history.
- B. It requires root privileges to create CELLDISKS and GRIDDISKS.
- C. It can be executed on storage servers.
- D. It can execute commands on multiple storage servers in parallel.
- E. It can be executed using the DCLI utility.
Answer: A,D,E
Explanation:
The CELLCLI utility is a command line interface to Exadata that enables the execution of commands across multiple storage servers in parallel. It also has command-line history, so users can easily recall previously entered commands. Furthermore, the CELLCLI utility can be executed using the DCLI utility, which provides a convenient way to execute commands on multiple storage servers simultaneously.
However, CELLCLI does not require root privileges to create CELLDISKS and GRIDDISKS, and it cannot be executed on storage servers. This is because CELLCLI is used to manage the Exadata database machine from the database server [1]. For more information about CELLCLI, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].
NEW QUESTION # 28
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?
- A. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.
- B. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
- C. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
Answer: B
Explanation:
To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e "ALTER CELL ENABLE REST" and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).
https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/access-rest-api.html
NEW QUESTION # 29
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?
- A. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
- B. Copy and execute the script on all storage servers using the dcli command.
- C. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- D. Copy and execute the script on all storage servers using the EXACLI command.
- E. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
Answer: D
NEW QUESTION # 30
Which statement is true about the Persistent Memory Commit Accelerator?
- A. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
- B. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
- C. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
- D. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
- E. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
Answer: E
Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/new-features-exadata-system-software-release-23.html
NEW QUESTION # 31
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU.
Which statement is correct?
- A. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
- B. The installation cannot proceed until two power feeds are available per PDU.
- C. The installation can go ahead, no change is required.
- D. A splitter cable can be used to provide power to all PDU cables.
Answer: B
Explanation:
An Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs would typically require two power feeds per PDU, one for each of the two power distribution units (PDUs) in the rack. A single power feed per PDU is not sufficient to provide the necessary power to the servers and storage in the rack.
The installation cannot proceed until two power feeds are available per PDU. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], it is recommended that each PDU should have at least two power feeds from different power sources in the data center. This is to ensure redundancy and avoid any power interruption due to power failure on one of the power sources. Splitter cables are not recommended, as they can reduce efficiency and increase the risk of overheating. Rearranging the power cables within the rack is not recommended either, as it does not provide the necessary redundancy for the PDU.
NEW QUESTION # 32
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- B. PMEM Pool Misses in the Exadata Outlier Summary
- C. PMEM Cache section within Exadata Smart Statistics
- D. PMEM Cache section within Memory Statistics
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
Answer: D
NEW QUESTION # 33
An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA PDUs is being installed in a Data Center. However, the Data Center is only providing enough power for a single cable from each PDU. Which statement is correct?
- A. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
- B. The installation cannot proceed until two power feeds are available per PDU.
- C. The installation can go ahead, no change is required.
- D. A splitter cable can be used to provide power to all PDU cables.
Answer: A
NEW QUESTION # 34
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?
- A. ASM instances
- B. Oracle clusterware on the database server
- C. the Power Distribution Units (PDUs)
- D. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- E. the RDMA over Converged Ethernet (RoCE) switches
- F. the storage server ILOM
Answer: A,B,F
NEW QUESTION # 35
You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?
- A. dbmcli -e "set alert ds_temp> 30" on each database server
- B. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- C. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
- D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
Answer: D
Explanation:
According to Oracle's documentation1, to set a threshold for a metric on a database server, you need to use the create threshold command with the appropriate parameters. The set threshold command is used to modify an existing threshold2.
Therefore, the command that you should use to generate alerts for such an event is:
dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server1
NEW QUESTION # 36
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?
- A. list celldisk attributes name, deviceName, diskType, physicalFirmware
- B. list cell attributes name, deviceName, diskType, physicalFirmware
- C. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
- D. list devices attributes name, deviceName, diskType, physicalFirmware
Answer: C
Explanation:
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html
NEW QUESTION # 37
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?
- A. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
- B. 2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network
- C. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network
- D. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using SFP28 transceivers and OM4 fiber cable for client network
Answer: C,D
Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
NEW QUESTION # 38
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. installing an alternative package manager
- B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- C. configuring secure shell user equivalency for the cellmonitor user
- D. upgrading the Storage Server software package using rpm
- E. changing the root password
Answer: A,E
NEW QUESTION # 39
......
New Oracle 1z1-902 Dumps & Questions: https://www.prepawaypdf.com/Oracle/1z1-902-practice-exam-dumps.html
100% Latest Most updated 1z1-902 Questions and Answers: https://drive.google.com/open?id=1CSxtbUO-Y7I3qjbsXZSeSWn_7YSKG-AM