[Jan 08, 2024] Reliable 1z1-902 Exam Tips Test Pdf Exam Material [Q32-Q55]

Rate this post

[Jan 08, 2024] Reliable 1z1-902 Exam Tips Test Pdf Exam Material

New 2024 1z1-902 Test Tutorial (Updated 60 Questions)

Oracle Exadata Database Machine is a pre-configured, pre-tuned and pre-tested data center appliance that is optimized for database workloads. It offers high-performance, scalability, and reliability for both OLTP and data warehousing workloads. Oracle Exadata X8M is the latest version of the Oracle Exadata Database Machine, which includes enhanced hardware and software features to further improve performance and availability.

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

NEW QUESTION 33
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 34
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 35
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 36
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 37
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?

alert logs for Enterprise Manager

alert logs for the ASM instances

Enterprise Manager Alerts on the Exadata Storage Server Grid home page

Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances

alert logs for the prod database instances

NEW QUESTION 38
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 39
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 40
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.

Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.

When backing up multi-rack systems, sharing Exadata X9M switches is recommended.

ZFS Snapshots can provide rapid cloning of development and test environment.

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

on at least two storage servers in both racks

on only one database server in both racks

on all database servers in the first rack

on all storage servers in both racks

on all database servers and at least two storage servers in both racks

on all database servers in the second rack

on all database servers in both racks and one storage server in each rack

NEW QUESTION 42
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

1536GB

512GB

2048GB

768GB

1024GB

384GB

NEW QUESTION 43
You are updating your Exadata X9M-2 Elastic Database Machine with 6 database servers and 12 High Capacity Storage Servers. You will be using patchmgr to apply updates across the entire machine while still maintaining database availability.
Assuming you are driving patchmgr from an external server, which statement is true about the execution phase?

patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.

patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.

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?

SQL Plan Quarantine

Manually created Quarantine

Database Quarantine

Disk Region Quarantine

Cell Offload Quarantine

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

Install Oracle Rest Data Services on each Database server and install the MS APEX application.

The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.

Install Oracle Rest Data Services on each Storage server and install the MS APEX application.

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.

NEW QUESTION 46
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 47
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 48
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 49
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.

Run exachk and resolve only WARNINGS that you have not seen before.

Run the appropriate patchmgr preqequisite check step for each component being updated.

Run patchmgr –all_comp -autofix -autobackup -upgrade -rolling.

For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.

NEW QUESTION 50
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 51
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 52
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

NEW QUESTION 53
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 54
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 55
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.