[Full-Version] 2024 New Preparation Guide of Oracle 1Z0-902 Exam [Q28-Q49]

[Full-Version] 2024 New Preparation Guide of Oracle 1Z0-902 Exam

1Z0-902 Practice Exam - 60 Unique Questions

To prepare for the Oracle 1z1-902 exam, candidates should have a good understanding of Oracle Exadata Database Machine X8M architecture and its components, such as database servers, storage servers, and InfiniBand switches. They should also have knowledge of Oracle database administration and management, including backup and recovery, performance tuning, and security. Candidates should also have experience in installing and configuring Exadata Database Machine X8M and be familiar with the tools and techniques used for troubleshooting common issues.

Certification Topics of Oracle 1Z0-902 Exam

• Exadata Database Machine Integration

• Exadata Database Machine Installation

• Exadata Database Machine Troubleshooting

• Exadata Database Machine Architecture and Key Capabilities

• Exadata Database Machine Monitoring

• Exadata Database Machine Updates

• Exadata Database Machine Security

• Exadata Database Maintenance Tasks

Oracle 1Z0-902 certification exam is an excellent opportunity for professionals to validate their skills and knowledge in implementing Oracle Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification exam is designed for professionals who work with Oracle Exadata Database Machine X8M and want to enhance their expertise in developing solutions for database systems. It is a prerequisite for the Oracle Certified Expert, Oracle Exadata X8M Solutions certification and makes the candidate more marketable in the industry.

 

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

Answer: B,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 # 29
You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:

After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

• A. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
• B. # xfs_growfs /uOl +20G
• C. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
• D. # resize2fs +20G /dev/VGExaDb/LVDbOral

Answer: C

Explanation:
After running the commands above, the filesystem mounted on /u01 is on the logical volume /dev/mapper/VGExaDb-LVDbOral. So, to add 20G of space to the filesystem mounted on /u01, the command that needs to be run is:
lvextend -L +20G --verbose /dev/mapper/VGExaDb-LVDbOral
This command will extend the logical volume /dev/mapper/VGExaDb-LVDbOral by 20 GB of space. It is important to note that the option --verbose is used to display the progress of the operation.

NEW QUESTION # 30
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. SQL Plan Quarantine
• C. Cell Offload Quarantine
• D. Database Quarantine
• E. Disk Region Quarantine

Answer: A,D

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

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 # 32
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 all database servers and at least two storage servers in both racks
• B. on at least two storage servers in both racks
• C. on all database servers in both racks and one storage server in each rack
• D. on all database servers in the first rack
• E. on all storage servers in both racks
• F. on only one database server in both racks
• G. on all database servers in the second rack

Answer: A,B

Explanation:
In order to monitor all components of this multirack configuration, Enterprise Manager agents must be deployed on at least two storage servers in both racks and all database servers in both racks. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book [1], in which it states "To monitor all components of the multirack configuration, you must deploy agents on all database servers and at least two storage servers in each rack" (page 6-15).

NEW QUESTION # 33
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?

• A. 0 because the new griddisks will be added to the existing faiigroups
• B. 1 consisting of all 96 griddisks
• C. 96 consisting of one griddisk each
• D. 7 consisting of 12 griddisks each
• E. 12 consisting of seven griddisks each

Answer: E

NEW QUESTION # 34
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?

• A. -> start /System
• B. -> start /SP/console
• C. -> set /SYS power_state=ON
• D. -> start /SYS/power
• E. You must be physically present in the data center to start an Exadata Storage Server.
• F. -> start /SYSTEM/power

Answer: A

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

Answer: C

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 # 36
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

• A. Oracle Exadata Rack may only be installed on raised floor environments.
• B. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
• C. 914mm of space required above the rack height is required for maintenance access.
• 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. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.

Answer: D

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

Answer: B,F,G

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.

NEW QUESTION # 38
Which three statements are true about the CELLCLI command?

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

Answer: C,D,E

Explanation:
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm

NEW QUESTION # 39
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

• A. OS I/O metrics using Enterprise Manager host pages for the storage servers
• B. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us
• C. OS I/O metrics using OS tools such as iostat on the database servers
• D. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
• E. OS I/O metrics using OS tools such as iostat on the storage servers

Answer: B,D

Explanation:
According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.
I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us . These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.

NEW QUESTION # 40
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 the appropriate patchmgr preqequisite check step for each component being updated.
• C. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• 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,D,F

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

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

Answer: B,D

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.
Review the safety guidelines.
Unpack Oracle Exadata Rack.
Let the Exadata acclimatize for 24 hours.
Place Exadata in its allocated space.
Stabilize the Exadata Rack.
Power on Exadata PDU A.
Power on Exadata PDU B.
This order ensures that the necessary safety precautions are taken before installing the Exadata Database Machine, and that the machine is allowed to acclimate to its new environment before being powered on.

NEW QUESTION # 42
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

• A. OECA allows one XT storage server in the configuration.
• B. OECA reconfigures the size of disk groups and recreates grid disks.
• C. OECA facilitates PDU power selection initially and after equipment addition.
• D. OECA extends the hardware for the elastic configuration only.
• E. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.

Answer: B,E

Explanation:
The correct answers are Options A and D. Option A is correct because OECA reconfigures the size of disk groups and recreates grid disks. Option D is correct because OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.

NEW QUESTION # 43
Which are two correct statements about backing up Exadata Database Machine?

• A. The M.2 disk is hot pluggable and can be replaced when the power is on, but you will have to restore the system data manually.
• B. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
• C. Backing up Exadata Storage Server Software is critical for restoration.
• D. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
• E. For high availability, system area can be on the first two disks and M.2 devices.

Answer: A,D

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

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

Answer: B,D,E,F

Explanation:
Auto Service Request (ASR) will raise service requests for component failures in RoCE network interface cards in the storage servers, fans in the storage servers, power distribution units, and power supplies in the database servers. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book , which states "ASR will raise service requests for component failures in RoCE network interface cards in the storage servers [1], fans in the storage servers, power distribution units, and power supplies in the database servers" (page 5-11).

NEW QUESTION # 45
An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical disk?

• A. Rebalance the data on the effected griddisks before performing a manual drop command.
• B. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
• C. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
• D. Add the griddisks back into the ASM diskgroup they used to be a member of.
• E. Replace the failed physical disk.
• F. Create a new celldisk and new griddisks on the replaced physical disk.

Answer: A,E

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

Answer: B

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 # 47
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

• A. SQL Plan Quarantine
• B. Manually created Quarantine
• C. Cell Offload Quarantine
• D. Database Quarantine
• E. Disk Region Quarantine

Answer: A,D

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

Answer: A

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 # 49
......

Latest Questions 1Z0-902 Guide to Prepare Free Practice Tests: https://pdfexamfiles.actualtestsquiz.com/1Z0-902-test-torrent.html