Give Push to your Success with Oracle Engineered Systems 1Z0-902 Exam Questions [Q20-Q41]

Rate this post

Give Push to your Success with Oracle Engineered Systems 1Z0-902 Exam Questions

1Z0-902 100% Guarantee Download 1Z0-902 Exam PDF Q&A

What is the exam cost of the Oracle 1Z0-902 Exam

Oracle 1Z0-902 Exam price varies greatly depending on the vendor. The average cost of a bundle is 244.09 USD, which includes the exam and all other materials.

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

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

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

Q23. What are two recommended configuration best practices for backup and recovery on Exadata?

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.

Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

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.

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.

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

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

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

Q27. You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?

4,3,2,6,1,7,5

3,2,6,4,1,7,5

2,3,4,6,1,7,5

3,2,6,1,4,7,5

2,6,1,4,3,7,5

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

Q29. 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?

OS I/O metrics using Enterprise Manager host pages for the storage servers

OS I/O metrics using OS tools such as iostat on the database servers

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

cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

OS I/O metrics using OS tools such as iostat on the storage servers

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

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

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

Q33. You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

6, 2, 1, 8, 4, 5

6, 8, 3, 4, 2, 1

6, 3, 1, 9, 7, 8

6, 1, 2, 7, 5, 8

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

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

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

Q37. Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?

2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.

1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.

1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.

3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.

1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.

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

Q39. 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?

to the CELLADMIN account by calling CELLCLI on all cells using DCLI

to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli

to the CELLMONITOR account using cellcli interactively on each storage server

to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli

to the CELLMONITOR account calling CELLCLI on all cells using DCLI

to the CELLADMIN account using cellcli interactively on each storage server

Q40. You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

CeLLCLI> list GRIDDISK where status != ‘inactive’ on the affected storage server

‘crsct1 stop cluster -all’ on one of the database servers

CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != ‘Yes’ on the affected Storage server

CellCLI alter GRIDDISK all inactive on the affected storage server

shutdown -h now’ on the affected storage server

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