• Home
  • Blogs
  • Use 1z1-902 Exam Dumps (2024 PDF Dumps) To Have Reliable 1z1-902 Test Engine [Q17-Q39]

Use 1z1-902 Exam Dumps (2024 PDF Dumps) To Have Reliable 1z1-902 Test Engine [Q17-Q39]

Share

Use 1z1-902 Exam Dumps (2024 PDF Dumps) To Have Reliable 1z1-902 Test Engine

1z1-902 PDF Recently Updated Questions Dumps to Improve Exam Score


Oracle 1Z0-902 exam, also known as the Oracle Exadata Database Machine X8M Implementation Essentials exam, is a certification exam that is designed for IT professionals who are responsible for implementing and managing Oracle Exadata Database Machine X8M systems. 1z1-902 exam measures the candidate's knowledge and skills in configuring, deploying, and managing Oracle Exadata Database Machine X8M systems. 1z1-902 exam also tests the candidate's ability to troubleshoot issues that may arise in the system.

 

NEW QUESTION # 17
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

  • A. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
  • B. CellCLI alter GRIDDISK all inactive on the affected storage server
  • C. shutdown -h now' on the affected storage server
  • D. 'crsct1 stop cluster -all' on one of the database servers
  • E. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
  • F. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

Answer: B,C

Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB The two commands that must be executed to safely power off the storage server in an Exadata X9M Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage server is completely powered off and no data is lost.
For more information on how to properly power off an Exadata Storage Server, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1188080_1.html


NEW QUESTION # 18
What are two recommended configuration best practices for backup and recovery on Exadata?

  • A. 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.
  • B. 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.
  • C. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
  • 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.

Answer: A,C


NEW QUESTION # 19
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

  • A. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
  • B. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
  • C. PMEM Cache section within Exadata Smart Statistics
  • D. PMEM Pool Misses in the Exadata Outlier Summary
  • E. PMEM Cache section within Memory Statistics

Answer: A,E

Explanation:
The "cell PMEM cache Read Hits" in the "Database IOs" portion of the "Performance Summary" will show the number of reads that have been satisfied from the Persistent Memory Cache. The "PMEM Cache" section within "Memory Statistics" will give detailed information about the usage of the Persistent Memory Cache, such as cache size, used size, hit rate, etc. This information can help to identify if the Persistent Memory Cache is being used effectively and if there are any issues with it.


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

  • A. the failure of both physical M.2 disks
  • B. corruption in the / (root) filesystem
  • C. the failure of physical disk 1
  • D. corruption in a normal or high redundancy ASM diskgroup
  • E. the failure of physical disk 0 and 11
  • F. moving all disks from one cell to another as part of a chassis-level component failure
  • G. accidental loss of all data from all griddisks in a storage server

Answer: B,G

Explanation:
Reason B, corruption in the / (root) filesystem, is a valid reason for executing a storage server rescue procedure. If the root filesystem is corrupted, the storage server will no longer be able to boot and will need to be rescued.
Reason F, accidental loss of all data from all griddisks in a storage server, is also a valid reason for executing a storage server rescue procedure. If all data is accidentally lost from the griddisks in a storage server, the server will need to be rescued in order to recover the data.
For more information about the Exadata X9M-2 storage server rescue procedure, 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] Oracle Exadata Database Machine X9M-2 Storage Server Rescue Procedure - Oracle Docs [3] Oracle Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs [4] Oracle Exadata Database Machine X8M-2 Storage Server Rescue Procedure - Oracle Docs [5] Oracle Exadata Database Machine X9M-2 Storage Server Update Procedure - Oracle Docs [6] Oracle Exadata Database Machine X8M-2 Storage Server Update Procedure - Oracle Docs


NEW QUESTION # 21
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 celldisk attributes name, deviceName, diskType, physicalFirmware
  • D. list cell attributes name, deviceName, diskType, physicalFirmware

Answer: C


NEW QUESTION # 22
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?

  • A. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
  • B. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
  • C. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
  • D. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
  • E. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.

Answer: D


NEW QUESTION # 23
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

  • A. Oracle Linux 7.9
  • B. Oracle Linux 7.7
  • C. Oracle Linux 7.5
  • D. Oracle Linux 8.0

Answer: A

Explanation:
RoCE (RDMA over Converged Ethernet) and Persistent Memory are features that are supported by Oracle Linux. The minimum version of Oracle Linux required to support RoCE and Persistent Memory is Oracle Linux 7.9.
RoCE is a low-latency, high-bandwidth networking technology that enables fast data transfer between servers using converged Ethernet networks. It is supported by Oracle Linux 7.9 and later versions, which includes the necessary kernel modules and user-space libraries to enable RoCE.
Persistent Memory is a technology that allows data to be stored in non-volatile memory (NVM) devices, such as NVDIMMs (Non-Volatile Dual In-line Memory Modules), which can be accessed at near-DRAM speeds. Oracle Linux 7.9 and later versions include support for Persistent Memory, which includes kernel modules and user-space libraries to enable Persistent Memory.


NEW QUESTION # 24
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

  • A. Collected configuration information can be uploaded automatically to Oracle.
  • B. Collected configuration information can be uploaded manually to Oracle.
  • C. It collects configuration information on demand.
  • D. It collects configuration information automatically.
  • E. It is mandatory to install OCM on at least one database server.
  • F. It is mandatory to install OCM on all database servers.

Answer: B,D,E


NEW QUESTION # 25
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 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
  • C. 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
  • D. 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

Answer: A,D


NEW QUESTION # 26
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. Normal
  • B. Extended
  • C. Sparse
  • D. High
  • E. External

Answer: D

Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf


NEW QUESTION # 27
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. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
  • B. netstat -rn
  • C. cat /proc/net/bonding/bondeth0
  • D. ifconfig -a legrep "re0| re1"

Answer: C

Explanation:
According to Oracle's documentation1, the client network on Exadata X9M-2 Database Server is used for client access to the database servers using Single Client Access Name (SCAN) and Oracle RAC Virtual IP (VIP) addresses. To verify that the client network is available via both client switches, you can use the command:
cat /proc/net/bonding/bondeth0
This command displays information about the bondeth0 interface, which is used for the client network on Exadata X9M-2 Database Server2. You can check if both interfaces (eth0 and eth1) are active and connected to different switches3.


NEW QUESTION # 28
What are two recommended configuration best practices for backup and recovery on Exadata?

  • A. 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.
  • B. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
  • C. 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.

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 # 29
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. A splitter cable can be used to provide power to all PDU cables.
  • B. The installation can go ahead, no change is required.
  • C. The installation cannot proceed until two power feeds are available per PDU.
  • D. 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.

Answer: C

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 # 30
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. It is required to install OEDA on the first new database server.
  • B. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
  • C. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
  • D. 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.
  • E. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.

Answer: B,D

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


NEW QUESTION # 31
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. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
  • B. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
  • C. 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.
  • D. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.

Answer: C

Explanation:
The MS process on Exadata storage servers is natively endowed with REST services and these services are enabled by default. However, it is important to create appropriate roles and users to ensure security when accessing these services. This way, it is possible to disable ssh access to the storage servers, and still enable REST access to the MS process. It's not necessary to install Oracle Rest Data Services on each Database or Storage server or install the MS APEX application, the MS process on the storage servers already have REST services by default.


NEW QUESTION # 32
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 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'.
  • B. 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.
  • C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
  • D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

Answer: C,D

Explanation:
1. Querying VSSYSTEM_EVENTS for the event 'cell physical IO interconnect bytes returned by smart scan' will not be appropriate for monitoring the access on a particular table. The V$SYSTEM_EVENT view is used to monitor system-wide performance statistics, not specific table access. C. Querying v$SYSTAT for the statistic 'cell smart table scan' will not be appropriate for monitoring the access on a particular table as well. The v$SYSTAT view contains system-wide performance statistics, not specific table access.


NEW QUESTION # 33
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

  • A. Add 24x 32GB DIMMs.
  • B. Add 12x 32GB DIMMs.
  • C. Add 16x 64GB DIMMs.
  • D. Add 16x 32GB DIMMs.
  • E. Add 12x 64GB DIMMs.
  • F. Memory cannot be expanded on Exadata X9M-2 Database Servers.
  • G. Remove existing memory modules.
  • H. Add 32x 64GB DIMMs.
  • I. Shutdown the Database Server if running.

Answer: G,H,I

Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
https://chriscraftoracle.wordpress.com/2022/11/09/what-makes-exadata-faster/


NEW QUESTION # 34
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

  • A. 512GB
  • B. 1536GB
  • C. 768GB
  • D. 384GB
  • E. 2048GB
  • F. 1024GB

Answer: E


NEW QUESTION # 35
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

  • A. fans in the storage servers
  • B. RoCE network interface cards in the storage servers
  • C. RoCE network interface cards in the database servers
  • D. power supplies in the database servers
  • E. Cisco management switch
  • F. power distribution units
  • G. Cisco RDMA over Converged Ethernet (RoCE) switches

Answer: A,B,D,F


NEW QUESTION # 36
Which two statements are true about enabling write-back flash cache?

  • A. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
  • B. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
  • C. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
  • D. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
  • E. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.

Answer: B,D


NEW QUESTION # 37
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, but are not enabled by default.
  • B. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
  • C. 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.
  • D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.

Answer: A

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).


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

  • A. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
  • B. Run exachk and resolve only WARNINGS that you have not seen before.
  • C. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
  • D. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
  • E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
  • F. Run the appropriate patchmgr preqequisite check step for each component being updated.

Answer: C,D,E,F


NEW QUESTION # 39
......

1z1-902 Dumps Full Questions with Free PDF Questions to Pass: https://www.testkingit.com/Oracle/latest-1z1-902-exam-dumps.html

Free Oracle Engineered Systems 1z1-902 Official Cert Guide PDF Download: https://drive.google.com/open?id=1opX79Y-1j6Yp2IeyTY1IutwlG6p4BPlW 

Related Blogs

more
Oracle 1z1-902 Certification Practice Exam