2023 Easily pass 1Z0-902 Exam with our Dumps & PDF Test Engine [Q30-Q50]

2023 Easily pass 1Z0-902 Exam with our Dumps & PDF Test Engine

1Z0-902 PDF Pass Leader, 1Z0-902 Latest Real Test

Oracle Exadata Database Machine X8M is a high-performance database system that is designed to provide faster data processing and storage capabilities. The system is built with advanced hardware and software components that work together to deliver unmatched performance and scalability. The Oracle 1z1-902 certification exam is an industry-recognized credential that verifies an individual's skill and knowledge in implementing and managing the Exadata database machine X8M.

 

NEW QUESTION # 30
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. 1, 8, 7, 3 and 6
• B. 2, 7, 8, and 6
• C. 5, 8, 7, and 6
• D. 4, 7, 8, 3, and 6
• E. 2, 8, 7, 3, and 6

Answer: C

Explanation:
Option 5 stops the clusterware on all database servers as the grid user3.
Option 8 shuts down all Exadata storage servers using their ILOM interfaces1.
Option 7 shuts down all database servers using their ILOM interfaces1.
Option 6 powers off the rack using the power switches on the PDUs2.

NEW QUESTION # 31
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 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. 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: D

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
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/exadata-site-requirements.html

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

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

Answer: B

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

Answer: B

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

Answer: A,B

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

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. Cisco management switch
• E. Cisco RDMA over Converged Ethernet (RoCE) switches
• F. power supplies in the database servers
• G. power distribution units

Answer: B,E,F,G

Explanation:
According to the Oracle Auto Service Request (ASR) documentation1, ASR raises service requests for qualified Oracle products that are detected with specific faults. The qualified Exadata products include2:
Database servers
Storage servers
InfiniBand switches
Cisco switches (X8M and later systems)
Power distribution units (PDUs)

NEW QUESTION # 36
Which two activities are supported on the storage servers in an Exadata Database Machine?

• A. changing the root password
• B. configuring secure shell user equivalency for the cellmonitor user
• C. upgrading the Storage Server software package using rpm
• D. installing an alternative package manager
• E. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

Answer: C,E

Explanation:
Exadata Database Machine is a preconfigured and optimized for database workloads. The storage servers in an Exadata Database Machine are used to store database data, and support activities such as upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure and upgrading the Storage Server software package using rpm. These activities are related to maintain the storage servers performance and security. Changing the root password, installing an alternative package manager, and configuring secure shell user equivalency for the cellmonitor user are activities that can be performed on any Linux machine, but they are not specific to Exadata Database Machine.

NEW QUESTION # 37
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,B

NEW QUESTION # 38
Which two statements are true about applying updates on Exadata systems?

• A. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
• B. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
• C. Failed database server updates are rolled back to a working state on a previous release automatically.
• D. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
• E. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
• F. Failed storage server updates are automatically rolled back to a previous release.

Answer: C,F

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 # 39
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

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

Answer: B

Explanation:
According to 1, Exadata X9M-2 Database Servers are based on Intel Xeon Platinum 8368Y processors with 32 cores and 768 GB of DRAM memory per server. This memory can be expanded up to 1.5 TB per server by adding 24 x 32 GB DIMMs. The DRAM memory is used for buffer cache, PGA, and other database purposes1. Exadata X9M-2 Database Servers also have 25.6 TB of Persistent Memory Acceleration (PMEM) per server, which is used for log writes and columnar data caching1. PMEM is a new type of memory that combines the speed of DRAM with the persistence of flash2. Exadata X9M-2 Database Servers are designed to run Oracle Database workloads with high performance, scalability, and reliability2

NEW QUESTION # 40
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. the Power Distribution Units (PDUs)
• B. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
• C. the RDMA over Converged Ethernet (RoCE) switches
• D. the storage server ILOM
• E. Oracle clusterware on the database server
• F. ASM instances

Answer: D,E,F

Explanation:
1. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor ASM instances.
2. Additionally, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor the storage server ILOM.
3. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) also recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor Oracle clusterware on the database server.

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

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

Answer: C

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.

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

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

Answer: B,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 # 43
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

• A. 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.
• 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 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 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.

Answer: C

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.

NEW QUESTION # 44
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. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• 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. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.

Answer: A,B,C,D

NEW QUESTION # 45
Which dbmcli command is NOT valid on Exadata X9M?

• A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
• B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
• C. dbmcli -e "LIST IBPORT DETAIL"
• D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"

Answer: C

Explanation:
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.
https://forums.oracle.com/ords/apexds/map/tech/apps-infra/discussion/4342715/monitoring-roce-performance

NEW QUESTION # 46
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
• B. Install in Oracle Virtual Machine with required hardware.
• C. Install on Exadata Engineered System.
• D. Install on Oracle Database Appliance.
• E. Provide individual x86 64-Bit gateway hardware.

Answer: A,D,E

Explanation:
According to Oracle's documentation1, the customer options for hosting the Platinum Services Advanced Support Gateway are:
Provide individual x86 64-Bit gateway hardware1
Purchase the recommended x86 64-Bit gateway hardware from Oracle1
Install on Oracle Database Appliance2

NEW QUESTION # 47
Which dbmcli command is NOT valid on Exadata X9M?

• A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
• B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
• C. dbmcli -e "LIST IBPORT DETAIL"
• D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"

Answer: C

Explanation:
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.

NEW QUESTION # 48
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

• A. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
• B. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
• C. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
• D. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.

Answer: B,C

Explanation:
C) OEDA deployment steps include calibrate cells, create cell disks, and resecure machine2.
D) OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA2.

NEW QUESTION # 49
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. Cisco management switch
• E. Cisco RDMA over Converged Ethernet (RoCE) switches
• F. power supplies in the database servers
• G. power distribution units

Answer: A,B,F,G

NEW QUESTION # 50
......

1Z0-902 Dumps Ensure Your Passing: https://www.testsdumps.com/1Z0-902_real-exam-dumps.html

Valid 1Z0-902 Test Answers & 1Z0-902 Exam PDF: https://drive.google.com/open?id=1AAbD-_7a59JHOdFkhpkybYt0IULfUyhR