1z1-902 Training & Certification Get Latest Oracle Engineered Systems Updated on May 16, 2024
Certification Training for 1z1-902 Exam Dumps Test Engine
Passing the Oracle 1Z0-902 certification exam not only validates your expertise in Oracle Exadata but also demonstrates to potential employers that you are a skilled and knowledgeable professional in the field. Certified professionals are highly sought-after in the industry and can expect to earn higher salaries and enjoy better job prospects. Whether you are looking to advance your career or enhance your technical skills, the Oracle 1Z0-902 certification exam is a valuable investment in your future.
NEW QUESTION # 24
Which two statements are true about applying updates on Exadata systems?
- A. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- B. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- C. Failed storage server updates are automatically rolled back to a previous release.
- D. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- E. Failed database server updates are rolled back to a working state on a previous release automatically.
- F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
Answer: B,C
Explanation:
According to Oracle's documentation12, some of the statements that are true about applying updates on Exadata systems are:
Failed storage server updates are automatically rolled back to a previous release1.
When running a "yum update" for a new Exadata release, all other repositories should be disabled1.
NEW QUESTION # 25
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. 0
- D. 10, 8, 9, 11
- E. 7,6,9,11
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.
NEW QUESTION # 26
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?
- A. OECA extends the hardware for the elastic configuration only.
- B. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
- C. OECA reconfigures the size of disk groups and recreates grid disks.
- D. OECA facilitates PDU power selection initially and after equipment addition.
- E. OECA allows one XT storage server in the configuration.
Answer: A,D
Explanation:
B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.
Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Add Equipment: This input option allows you to allocate RU slots for ... [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Power Selection [1][2]: This input option allows you to select PDU power initially ... [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ...
NEW QUESTION # 27
Which two statements are true about applying updates on Exadata systems?
- A. Failed database server updates are rolled back to a working state on a previous release automatically.
- B. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- C. Failed storage server updates are automatically rolled back to a previous release.
- D. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- E. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
Answer: A,C
Explanation:
When applying updates on Exadata systems, database server updates are automatically rolled back to a working state on a previous release if the update fails. This ensures that the system can be restored to a working state in the event of a failed update. Additionally, storage server updates are also automatically rolled back to a previous release in the event of a failed update.
This is documented in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and more information can be found on the Oracle support website [1][2].
NEW QUESTION # 28
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?
- A. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
- B. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
- C. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- D. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
Answer: B,C
Explanation:
The two actions that are not appropriate for monitoring how a large production table is accessed in order to leverage the benefits of the Exadata Platform are A) querying VSSYSTEMEVENTS and filtering for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table; and B) querying v$segmentstatistics and filtering for the Object ID of your table from dbaobjects and the the column STATISTICNAME='optimized physical reads'. Instead, you should query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table (C), or run the CellCli-command list activerequest, filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS (D). These two methods are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Monitoring the Exadata Database Machine).
NEW QUESTION # 29
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 devices attributes name, deviceName, diskType, physicalFirmware
- B. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
- C. list cell attributes name, deviceName, diskType, physicalFirmware
- D. list celldisk attributes name, deviceName, diskType, physicalFirmware
Answer: B
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 # 30
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. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- C. Ask the system administrator to replace the broken disk with a spare.
- D. Call Oracle Support and make an appointment so that the drive can be replaced.
- E. Download and run the latest exadiag tool.
- F. Check the database to see if any rebalance operations are active.
Answer: C
NEW QUESTION # 31
Which two statements are true in regards to starting the Exadata Virtual Machine?
- A. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
- B. Use vm_maker -start-domain to start a virtual machine manually.
- C. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
- D. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
- E. Use vm_maker boot-from-iso command to boot a virtual machine.
Answer: D,E
NEW QUESTION # 32
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Run the appropriate patchmgr preqequisite check step for each component being updated.
- 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 patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- D. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- E. Run exachk and resolve only WARNINGS that you have not seen before.
- F. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
Answer: A,B,E,F
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.
NEW QUESTION # 33
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Cache section within Memory Statistics
- B. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- C. PMEM Pool Misses in the Exadata Outlier Summary
- D. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- E. PMEM Cache section within Exadata Smart Statistics
Answer: A
NEW QUESTION # 34
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. Collected configuration information can be uploaded manually to Oracle.
- B. It is mandatory to install OCM on at least one database server.
- C. It collects configuration information on demand.
- D. It is mandatory to install OCM on all database servers.
- E. It collects configuration information automatically.
- F. Collected configuration information can be uploaded automatically to Oracle.
Answer: C,E,F
Explanation:
It collects configuration information automatically (B). OCM gathers detailed configuration information about a variety of designated Oracle products and components across an enterprise on a regular basis2.
It collects configuration information on demand . OCM can also collect configuration information manually when requested by the user or by Oracle Support2.
Collected configuration information can be uploaded automatically to Oracle (E). OCM can upload the collected configuration information to My Oracle Support automatically for analysis and support purposes3.
NEW QUESTION # 35
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Manually created Quarantine
- B. Disk Region Quarantine
- C. SQL Plan Quarantine
- D. Cell Offload Quarantine
- E. Database Quarantine
Answer: A,E
NEW QUESTION # 36
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?
- A. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- B. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- C. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- D. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
Answer: B
NEW QUESTION # 37
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. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- C. Ask the system administrator to replace the broken disk with a spare.
- D. Download and run the latest exadiag tool.
- E. Call Oracle Support and make an appointment so that the drive can be replaced.
- F. Check the database to see if any rebalance operations are active.
Answer: E
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 # 38
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Disk Region Quarantine
- B. Manually created Quarantine
- C. Cell Offload Quarantine
- D. SQL Plan Quarantine
- E. Database Quarantine
Answer: D,E
NEW QUESTION # 39
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 Memory Statistics
- D. PMEM Cache section within Exadata Smart Statistics
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
Answer: D,E
Explanation:
Option C shows the number of read hits from PMEM cache on storage servers which indicates how much data was served from PMEM instead of flash or disk1.
Option E shows detailed information about PMEM cache such as size, utilization, hit ratio, read latency and write latency2.
NEW QUESTION # 40
......
Step by Step Guide to Prepare for 1z1-902 Exam: https://www.actualtests4sure.com/1z1-902-test-questions.html
Oracle Engineered Systems 1z1-902 Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=1-JuQ2mUDUcpZmffzjTg-jlKsek_49CeT
