1z1-902 Dumps Updated Feb 11, 2023 Practice Test and 62 unique questions [Q19-Q43]

11Feb 2023 by admin No Comments

4/5 - (2 votes)

1z1-902 Dumps Updated Feb 11, 2023 Practice Test and 62 unique questions

2023 Latest 100% Exam Passing Ratio – 1z1-902 Dumps PDF

What is the importance of the Oracle Exadata Database Machine X9M Implementation Essentials Certification?

We all know that the Oracle Exadata Database Machine X9M is a powerful database machine which is designed to manage large-scale data. And the Oracle Exadata Database Machine X9M Implementation Essentials Certification is the latest Oracle certification. It is one of the most popular certifications. Oracle 1Z0-902 exam dumps will help you to get certified. In contrast, if you don’t have this certification, then you will not be able to get a high-paying job.

In this certification, you will learn the implementation details of the Exadata Database Machine X9M and you will be given the practical knowledge to implement the Oracle Exadata Database Machine X9M.

You will learn how to configure, deploy, and manage the Oracle Exadata Database Machine X9M.

You will also understand the architecture of the Oracle Exadata Database Machine X9M and the related components.

As the title says, the Oracle Exadata Database Machine X9M Implementation Essentials Certification is one of the most important certifications.

It is widely regarded as the most comprehensive and detailed Oracle certification. There are no other Oracle certifications that cover the same amount of topics.

The main reason is that the Exadata Database Machine X9M Implementation Essentials Certification covers all the latest Oracle Exadata Database Machine X9M features.

Learn about the Need for Oracle 1Z0-902 Exam

Oracle 1Z0-902 Exam is a very popular certification. If you want to make a career in the field of Oracle, you have to prepare for this certification.

As we all know, there are many people who are interested in this certification, but they do not have any idea about the preparation process for this certification. So, we are here to help you.

This is the guide which has been written for you. We have collected many resources from the internet and added some of our own.

You will find the things you need to know about this certification, including the test format, the questions and answers, the required preparation time, the required materials, etc. We hope this guide could help you. Oracle 1Z0-902 exam dumps will help you to get certified in your first attempt.

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

Add 12x 32GB DIMMs.

Add 12x 64GB DIMMs.

Shutdown the Database Server if running.

Add 16x 32GB DIMMs.

Add 16x 64GB DIMMs.

Memory cannot be expanded on Exadata X9M-2 Database Servers.

Remove existing memory modules.

Add 32x 64GB DIMMs.

Add 24x 32GB DIMMs.

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

Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.

Backing up Exadata Storage Server Software is critical for restoration.

For high availability, system area can be on the first two disks and M.2 devices.

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.

Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.

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

PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary

PMEM Pool Misses in the Exadata Outlier Summary

cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary

PMEM Cache section within Memory Statistics

PMEM Cache section within Exadata Smart Statistics

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

It is mandatory to install OCM on all database servers.

It collects configuration information automatically.

It collects configuration information on demand.

It is mandatory to install OCM on at least one database server.

Collected configuration information can be uploaded automatically to Oracle.

Collected configuration information can be uploaded manually to Oracle.

NEW QUESTION 23
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.

914mm of space required above the rack height is required for maintenance access.

The incline of any access route ramp must be less than or equal to 6 degrees.

All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.

Oracle Exadata Rack may only be installed on raised floor environments.

A conditioned space is required to remove the packaging material to reduce particles before entering the data center.

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

dbmcli -e “LIST METRICHISTORY WHERE name LIKE ‘DS_.*'”
B) dbmcli -e “LIST METRICCURRENT WHERE name = ‘DS_TEMP’ “

dbmcli -e “LIST IBPORT DETAIL”

dbmcli -e “LIST ALERTHISTORY WHERE agelnMinutes < 15”

NEW QUESTION 25
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.

NEW QUESTION 26
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.

NEW QUESTION 27
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

NEW QUESTION 28
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.

NEW QUESTION 29
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

NEW QUESTION 30
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

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

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.

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.

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.

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

NEW QUESTION 33
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.

NEW QUESTION 34
How do ASM failure groups provide redundancy?

Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.

Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

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?

5, 8, 7, and 6

4, 7, 8, 3, and 6

2, 8, 7, 3, and 6

2, 7, 8, and 6

1, 8, 7, 3 and 6

NEW QUESTION 36
Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?

Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.

Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.

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.

The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.

It is required to install OEDA on the first new database server.

NEW QUESTION 37
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?

Normal

Sparse

High

External

Extended

NEW QUESTION 38
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.

NEW QUESTION 39
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?

The sparse_<DBM_NAME> diskgroup is created automatically.

There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.

The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.

There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.

There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.

NEW QUESTION 40
Which two statements are true in regards to starting the Exadata Virtual Machine?

To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.

Use vm_maker -start-domain to start a virtual machine manually.

Use vm_maker boot-from-iso command to boot a virtual machine.

To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.

Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.

NEW QUESTION 41
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 splitter cable can be used to provide power to all PDU cables.

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.

The installation cannot proceed until two power feeds are available per PDU.

The installation can go ahead, no change is required.

NEW QUESTION 42
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?

ASM instances

Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers

the storage server ILOM

the Power Distribution Units (PDUs)

Oracle clusterware on the database server

the RDMA over Converged Ethernet (RoCE) switches

Verified 1z1-902 dumps Q&As – 100% Pass from PracticeMaterial: https://www.practicematerial.com/1z1-902-exam-materials.html

What is the importance of the Oracle Exadata Database Machine X9M Implementation Essentials Certification?

Learn about the Need for Oracle 1Z0-902 Exam

Leave a Reply Cancel reply