Latest 1Z0-902 Pass Guaranteed Exam Dumps with Accurate & Updated Questions [Q28-Q46]

Latest 1Z0-902 Pass Guaranteed Exam Dumps with Accurate & Updated Questions

1Z0-902 Exam Brain Dumps - Study Notes and Theory

Oracle 1z1-902 exam, also known as the Oracle Exadata Database Machine X8M Implementation Essentials exam, is designed for professionals who want to demonstrate their expertise in implementing and managing Oracle Exadata Database Machine X8M systems. Oracle Exadata Database Machine X8M is a high-performance database appliance that is engineered for running mission-critical workloads, delivering unprecedented levels of performance, availability, and scalability. The Oracle 1z1-902 exam is an essential step towards becoming an Oracle Exadata Database Machine X8M Implementation Specialist.

 

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

• A. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• B. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• C. Run the appropriate patchmgr preqequisite check step for each component being updated.
• D. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• 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 # 29
Which three statements are true about the CELLCLI command?

• A. It requires root privileges to create CELLDISKS and GRIDDISKS.
• B. It can be executed using the DCLI utility.
• C. It has command-line history.
• D. It can be executed on storage servers.
• E. It can execute commands on multiple storage servers in parallel.

Answer: B,C,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 # 30
Which statement is true about the Persistent Memory Commit Accelerator?

• A. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
• B. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
• C. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
• D. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
• E. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.

Answer: A

NEW QUESTION # 31
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. Call Oracle Support and make an appointment so that the drive can be replaced.
• C. Ask the system administrator to replace the broken disk with a spare.
• D. Wait for the email of the failure that Exadata or Enterprise Manager will send.
• E. Download and run the latest exadiag tool.
• F. Check the database to see if any rebalance operations are active.

Answer: C

NEW QUESTION # 32
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

• A. 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.
• B. 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.
• C. 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.
• 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: B

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.
According to Oracle's documentation1, Exadata Secure RDMA Fabric Isolation is a feature that enables strict network isolation for Oracle Real Application Clusters (Oracle RAC) clusters on Exadata Database Machine systems that use RDMA over Converged Ethernet (RoCE). Exadata Secure RDMA Fabric Isolation uses RoCE VLANs to ensure that network packets from one VM cluster cannot be seen by another VM cluster. VLAN tag enforcement is done at the KVM host level, which means that security cannot be bypassed by any software exploits or misconfiguration on the database server VMs1.
Therefore, the statement that is true about how Exadata Secure RDMA Fabric isolation is used in X9M-2 with virtualization enabled is:
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.

NEW QUESTION # 33
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

• A. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
• B. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
• C. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
• D. ZFS Snapshots can provide rapid cloning of development and test environment.

Answer: B,C

Explanation:
1. ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells. C. When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure.

NEW QUESTION # 34
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A. Exadata storage realms using database-scoped security mode
• B. File permissions on the griddisks in each storage server
• C. Using EXADCLI instead of CELLCLI to create the griddisks
• D. File permissions on the griddisks in each database server
• E. Exadata storage realms using ASM-scoped security mode

Answer: A,E

Explanation:
Exadata storage realms using ASM-scoped security mode allows you to control which database can access which griddisks by creating realms at the ASM level, thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.2 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
Exadata storage realms using database-scoped security mode allows you to control which database can access which griddisks by creating realms at the database level [1], thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.3 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [2].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf [2] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf

NEW QUESTION # 35
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. Call Oracle Support and make an appointment so that the drive can be replaced.
• C. Ask the system administrator to replace the broken disk with a spare.
• D. Wait for the email of the failure that Exadata or Enterprise Manager will send.
  E Download and run the latest exadiag tool.
• E. Check the database to see if any rebalance operations are active.

Answer: C

NEW QUESTION # 36
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. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
• D. ifconfig -a legrep "re0| re1"

Answer: A

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 # 37
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A. File permissions on the griddisks in each storage server
• B. Using EXADCLI instead of CELLCLI to create the griddisks
• C. Exadata storage realms using database-scoped security mode
• D. File permissions on the griddisks in each database server
• E. Exadata storage realms using ASM-scoped security mode

Answer: A,E

Explanation:
When multiple databases share space on the storage servers in an unpartitioned storage grid, two Exadata security features can be configured to control which databases can access which griddisks.
Exadata storage realms using ASM-scoped security mode: This feature allows you to create storage realms and assign them to specific databases. This allows you to control which databases have access to which griddisks. The ASM-scoped security mode applies to all griddisks within an ASM disk group, which means that all griddisks in a disk group will be accessible only to the databases that belong to the assigned storage realm.
File permissions on the griddisks in each storage server: This feature allows you to configure file permissions on the griddisks at the storage server level. You can assign specific permissions to specific users or groups, allowing you to control which databases can access which griddisks.

NEW QUESTION # 38
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. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -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. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

Answer: A

Explanation:
AccordingtoOraclesdocumentationoneoftheutilitiesfordiagnosticsand
Explanation:
repair of Oracle Exadata Storage Server is ExaWatcher, which collects operating system and network metrics on database servers and storage servers. The utility is located in the /opt/oracle.ExaWatcher directory1.
To investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend, you can use the GetExaWatcherResults.sh script to collect and analyze ExaWatcher data for a specified time range1.
Therefore, the command that you should use to investigate this is:
/opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

NEW QUESTION # 39
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 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup 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 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network

Answer: A,B

Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf

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

Answer: A,D

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 # 41
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 12x 32GB DIMMs.
• B. Add 32x 64GB DIMMs.
• C. Shutdown the Database Server if running.
• D. Add 24x 32GB DIMMs.
• E. Add 12x 64GB DIMMs.
• F. Add 16x 32GB DIMMs.
• G. Add 16x 64GB DIMMs.
• H. Remove existing memory modules.
• I. Memory cannot be expanded on Exadata X9M-2 Database Servers.

Answer: C,G,H

Explanation:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".

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

Answer: B,C

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 # 43
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?

• A. to the CELLADMIN account using cellcli interactively on each storage server
• B. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
• C. to the CELLMONITOR account using cellcli interactively on each storage server
• D. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
• E. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
• F. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli

Answer: B,C,F

NEW QUESTION # 44
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. Cell Offload Quarantine
• C. SQL Plan Quarantine
• D. Database Quarantine
• E. Manually created Quarantine

Answer: D,E

NEW QUESTION # 45
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 physicaldisk attributes name, deviceName, diskType, physicalFirmware
• B. list cell attributes name, deviceName, diskType, physicalFirmware
• C. list celldisk attributes name, deviceName, diskType, physicalFirmware
• D. list devices attributes name, deviceName, diskType, physicalFirmware

Answer: C

NEW QUESTION # 46
......

Pass Oracle 1Z0-902 Test Practice Test Questions Exam Dumps: https://www.dumps4pdf.com/1Z0-902-valid-braindumps.html

The Best Oracle Engineered Systems Study Guide for the 1Z0-902 Exam: https://drive.google.com/open?id=11lxt3folkJgwdAjE670WmGtm5jptCmkZ