2024 Easily pass 1Z0-902 Exam with our Dumps & PDF Test Engine [Q26-Q42]

02Aug 2024 by admin No Comments

5/5 - (2 votes)

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

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

Oracle 1Z0-902 is a certification exam designed for individuals who want to demonstrate their knowledge and skills in the implementation of Oracle Exadata Database Machine X8M. 1Z0-902 exam is essential for professionals who work with Oracle Exadata Database Machine X8M and are interested in validating their expertise in the field. Passing 1Z0-902 exam will allow professionals to earn the Oracle Exadata Database Machine X8M Implementation Specialist certification.

NO.26 Which statement is true about the patching features provided in Platinum Services?

Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

Patching services are available for the full software stack up to twice per year.

The rolling and complete down time approaches are two options to patching.

Patching is done automatically during business hours.

NO.27 Which two activities are supported on the storage servers in an Exadata Database Machine?

changing the root password

upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

installing an alternative package manager

upgrading the Storage Server software package using rpm

configuring secure shell user equivalency for the cellmonitor user

NO.28 Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

OECA reconfigures the size of disk groups and recreates grid disks.

OECA extends the hardware for the elastic configuration only.

OECA allows one XT storage server in the configuration.

OECA’s “Add Equipment” input option allows allocation of RU slots for customer equipment.

OECA facilitates PDU power selection initially and after equipment addition.

NO.29 Which two statements are true about enabling write-back flash cache?

Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.

Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.

When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

Before write-back flash cache is enabled, you need to drop the Flash Cache first.

When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.

NO.30 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?

# lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral

# xfs_growfs /uOl +20G

# resize2fs +20G /dev/VGExaDb/LVDbOral

# lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral

NO.31 Which three statements are true about the CELLCLI command?

It can execute commands on multiple storage servers in parallel.

It has command-line history.

It requires root privileges to create CELLDISKS and GRIDDISKS.

It can be executed on storage servers.

It can be executed using the DCLI utility.

NO.32 Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

ASR Manager must be installed and configured on a dedicated server external to the Database Machine.

Configuring ASR is mandatory for all Database Machine assets.

ASR Manager must be installed and configured on one of the database servers.

ASR can upload configuration metadata to support problem resolution.

ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.

ASR communicates with Oracle support services using HTTPS.

NO.33 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?

YOU query VSSYSTEM_EVENTS and filter for the event ‘cell physical IO interconnect bytes returned by smart scan’, associated to your table.

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

You query v$SYSTAT and filter for the statistic ‘cell smart table scan’, associated to your table.

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.

NO.34 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?

Replace the failed physical disk.

Add the griddisks back into the ASM diskgroup they used to be a member of.

Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.

Rebalance the data on the effected griddisks before performing a manual drop command.

Create a new celldisk and new griddisks on the replaced physical disk.

Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

NO.35 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?

list celldisk attributes name, deviceName, diskType, physicalFirmware

list cell attributes name, deviceName, diskType, physicalFirmware

list physicaldisk attributes name, deviceName, diskType, physicalFirmware

list devices attributes name, deviceName, diskType, physicalFirmware

NO.36 Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?

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

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

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

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

NO.37 Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

SQL Plan Quarantine

Manually created Quarantine

Database Quarantine

Disk Region Quarantine

Cell Offload Quarantine

NO.38 Which statement is true about the Persistent Memory Commit Accelerator?

Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.

Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).

Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.

Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.

Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.

NO.39 Which statement is true about the Persistent Memory Commit Accelerator?

Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.

Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).

Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.

Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.

Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.

NO.40 Which two statements are true about enabling write-back flash cache?

Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.

Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.

When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

Before write-back flash cache is enabled, you need to drop the Flash Cache first.

When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.

NO.41 Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

Install on Oracle Database Appliance.

Provide individual x86 64-Bit gateway hardware.

Install in Oracle Virtual Machine with required hardware.

Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Install on Exadata Engineered System.

NO.42 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?

Exadata storage realms using ASM-scoped security mode

File permissions on the griddisks in each database server

Using EXADCLI instead of CELLCLI to create the griddisks

File permissions on the griddisks in each storage server

Exadata storage realms using database-scoped security mode

To prepare for the Oracle 1Z0-902 certification exam, candidates can take advantage of a range of resources, including official Oracle training courses, study guides, and practice exams. Successful completion of the exam will demonstrate the candidate’s proficiency in implementing and managing Oracle Exadata systems, which can lead to career advancement opportunities and increased earning potential.

1Z0-902 Dumps Ensure Your Passing: https://www.practicematerial.com/1Z0-902-exam-materials.html

Leave a Reply Cancel reply