2023 Valid 1Z0-902 Real Exam Questions, practice Oracle Engineered Systems
Latest Success Metrics For Actual 1Z0-902 Exam (Updated 62 Questions)
Oracle 1z1-902 certification exam is a popular certification for IT professionals who are interested in implementing the Oracle Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification is designed to test the knowledge and skills of the candidates in the areas of Exadata architecture, storage server configuration, network configuration, database administration, and performance tuning.
Oracle Exadata Database Machine X8M is a high-end database machine designed for large-scale enterprise data management. It offers a unique combination of hardware and software technologies that deliver high performance, scalability, and reliability. The machine is optimized for running Oracle Database and other Oracle software, and it offers a complete solution for database consolidation and cloud computing. The Exadata Database Machine X8M is a complex system that requires specialized skills and knowledge to install, configure, and manage effectively.
NEW QUESTION # 25
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?
- A. cat /proc/net/bonding/bondeth0
- B. netstat -rn
- C. ifconfig -a legrep "re0| re1"
- D. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
Answer: D
Explanation:
The checkbadlinks.pl script is a tool provided with the Exadata X9M-2 Database Server that allows you to verify the status of the InfiniBand links between the Database Server and the client switches. This script checks for bad links, and it can be used to identify any issues with the client network connectivity. To use the script, you can navigate to the directory where it is located, which is /opt/oracle.SupportTools/ibdiagtools/ and execute the command ./checkbadlinks.pl -all. This will give you a summary of the status of the links and it will indicate if there are any bad links. This command will check the client network on your Exadata X9M-2 Database Server is available via both client switches. Other commands like ifconfig, netstat and cat are not relevant to check the client network on Exadata X9M-2 Database Server
NEW QUESTION # 26
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?
- A. 2, 7, 8, and 6
- B. 4, 7, 8, 3, and 6
- C. 2, 8, 7, 3, and 6
- D. 5, 8, 7, and 6
- E. 1, 8, 7, 3 and 6
Answer: A
Explanation:
In order to completely power off an Exadata Database Machine in an orderly fashion, it's important to properly shut down the cluster first. The command "crscti stop cluster" as root should be executed from one of the database servers.
Once the cluster has been stopped, the next step is to shut down the database servers by executing the command "shutdown -h now" on all database servers.
Next, shut down the Exadata storage servers by executing the command "shutdown -h now" on all Exadata storage servers.
Finally, power off the rack using the power switches on the PDUs.
NEW QUESTION # 27
Which two statements are true about applying updates on Exadata systems?
- A. Failed storage server updates are automatically rolled back to a previous release.
- B. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- C. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- D. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- E. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- F. Failed database server updates are rolled back to a working state on a previous release automatically.
Answer: A,D
Explanation:
1. Exadata updates have a rollback feature in case the update fails, this means that the system will roll back to a previous release automatically, this applies to storage servers updates. D. Yum, the package manager used in Exadata, automatically installs a non-UEK kernel when running a regular update, this kernel can be selected to boot from grub.
NEW QUESTION # 28
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 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.
- C. 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.
- D. 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.
Answer: C
NEW QUESTION # 29
You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?
- A. on at least two storage servers in both racks
- B. on all database servers in the first rack
- C. on all database servers in the second rack
- D. on only one database server in both racks
- E. on all storage servers in both racks
- F. on all database servers in both racks and one storage server in each rack
- G. on all database servers and at least two storage servers in both racks
Answer: B,E
NEW QUESTION # 30
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 threshold ds_temp comparison=' >', critical=30" on each database server
- B. dbmcli -e "set alert ds_temp> 30" on each database server
- C. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
- D. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
Answer: A
Explanation:
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 5-54) recommends using the dbmcli command to set thresholds on metrics, such as temperature. To do this, you should use the following command:
dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server.
This will generate an alert if the temperature exceeds 30C.
NEW QUESTION # 31
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 and execute the script on all storage servers using the EXACLI command.
- B. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
- C. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
- D. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- E. Copy and execute the script on all storage servers using the dcli command.
Answer: E
NEW QUESTION # 32
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?
- A. 2, 7, 8, and 6
- B. 4, 7, 8, 3, and 6
- C. 2, 8, 7, 3, and 6
- D. 5, 8, 7, and 6
- E. 1, 8, 7, 3 and 6
Answer: A
NEW QUESTION # 33
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. 0
- B. 7,6,9,11
- C. 4,1, 6, 9
- D. 10, 8, 2, 5
- E. 10, 8, 9, 11
Answer: C
NEW QUESTION # 34
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- B. 914mm of space required above the rack height is required for maintenance access.
- C. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- D. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- E. The incline of any access route ramp must be less than or equal to 6 degrees.
- F. Oracle Exadata Rack may only be installed on raised floor environments.
Answer: D
NEW QUESTION # 35
Which two statements are true about enabling write-back flash cache?
- A. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
- B. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
- C. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
- D. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
- E. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
Answer: D,E
Explanation:
According to the Oracle documentation1, two statements that are true about enabling write-back flash cache are:
Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations (A). This is because write-back flash cache provides better performance and reliability for data file writes than write-through flash cache.
Before write-back flash cache is enabled, you need to drop the Flash Cache first (D). This is because changing the flash cache mode requires recreating the flash cache with a different configuration.
NEW QUESTION # 36
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?
- A. Wait for a blue light to appear on the disk if the rebalance operation is running.
- B. Check the database to see if any rebalance operations are active.
- C. Call Oracle Support and make an appointment so that the drive can be replaced.
- D. Download and run the latest exadiag tool.
- E. Ask the system administrator to replace the broken disk with a spare.
- F. Wait for the email of the failure that Exadata or Enterprise Manager will send.
Answer: C
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], before doing anything else you should call Oracle Support and make an appointment so that the drive can be replaced. If Platinum Support is enabled, then you can call Oracle Support and they will arrange for the disk to be replaced. If Platinum Support is not enabled, then you can arrange for the disk to be replaced through Enterprise Manager Cloud Control.
NEW QUESTION # 37
Which statement is true about the patching features provided in Platinum Services?
- A. The rolling and complete down time approaches are two options to patching.
- B. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
- C. Patching is done automatically during business hours.
- D. Patching services are available for the full software stack up to twice per year.
Answer: D
Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
The correct statement about the patching features provided in Platinum Services is that patching services are available for the full software stack up to twice per year. Oracle Platinum Service covers Exadata storage software and firmware patching, and customers must also perform the database patching. The rolling and complete down time approaches are two options for patching, and patching should be scheduled for times when the system is not being heavily used. Patching is not done automatically during business hours. This is covered in section 4.13 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf Search results: [1] Oracle Exadata Storage Server Patching [1][2]. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest Oracle... [2] Patching and Upgrades. Oracle Database Machine provides automated patching and upgrades for the full Exadata software stack, up to twice a year, with... [3] Virtualized Exadata. Oracle Database Machine X9M-2 comes with a choice of two patching approaches to accommodate different customer needs: Rolling... [4] Jan 10, 2017 ... Exadata Patching Process. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest...
NEW QUESTION # 38
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 can go ahead, no change is required.
- C. A splitter cable can be used to provide power to all PDU cables.
- D. The installation cannot proceed until two power feeds are available per PDU.
Answer: B
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 # 39
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?
- A. High
- B. Extended
- C. Normal
- D. External
- E. Sparse
Answer: C
Explanation:
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure. This means that they need a redundancy level that can tolerate at least one disk failure without losing data availability or performance. Therefore, the best option for them is normal redundancy . Normal redundancy provides two-way mirroring by default, which means that each data extent has a primary copy and a mirror copy on different disks in different failure groups1. A failure group is a subset of disks within a disk group that are likely to fail at the same time due to common dependencies2. On Exadata Database Machine , each Storage Server is considered as a failure group by default2. This means that if one Storage Server fails or needs to be updated , the data on its disks can still be accessed from another Storage Server that has the mirror copies of the same data extents2. Therefore, normal redundancy ensures data availability and performance during updates or single-node server failures.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html
NEW QUESTION # 40
......
Genuine 1Z0-902 Exam Dumps Free Demo Valid QA's: https://www.trainingdump.com/Oracle/1Z0-902-practice-exam-dumps.html
Printable & Easy to Use Oracle Engineered Systems 1Z0-902 Dumps 100% Same Q&A In Your Real Exam: https://drive.google.com/open?id=1LlQhwPBXNAP9xjY3iqafrQoTYwBaasPB