Download Oracle 1z1-902 Mock Test Study Material [Q15-Q39]

Download Oracle 1z1-902 Mock Test Study Material

1z1-902 Questions Prepare with Learning Information

Oracle Exadata Database Machine X8M Implementation Essentials (1Z0-902) exam is designed for individuals who want to become certified Exadata Database Machine implementation experts. 1z1-902 exam tests the candidate's knowledge and skills regarding the implementation of Oracle Exadata Database Machine X8M, including its architecture, configuration, and administration. 1z1-902 exam is designed for administrators, architects, and technical consultants who work with the Exadata Database Machine.

 

NEW QUESTION # 15
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

• A. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• B. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• C. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• D. Run the appropriate patchmgr preqequisite check step for each component being updated.
• 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,C,D,F

NEW QUESTION # 16
You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?

• A. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
• B. dbmcli -e "set alert ds_temp> 30" on each database server
• C. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
• D. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server

Answer: A

Explanation:
According to Oracle's documentation1, to set a threshold for a metric on a database server, you need to use the create threshold command with the appropriate parameters. The set threshold command is used to modify an existing threshold2.
Therefore, the command that you should use to generate alerts for such an event is:
dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server1

NEW QUESTION # 17
What are two recommended configuration best practices for backup and recovery on Exadata?

• A. 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.
• B. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
• C. 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.
• D. 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.

Answer: A,C

Explanation:
A recommended configuration best practice for backup and recovery on Exadata is to place the backup network on dedicated switches installed in the top of the rack (ToR). This provides a greater level of control and isolates the backup network from other workloads. Additionally, even if the backup is limited to writing to four tape drives, it is recommended to specify eight channels to expedite the restore process.
Another best practice is to set the RMAN FILESPERSET parameter to 1 for the level 1 incremental backup set. This will optimize the internal Recovery Appliance backup and restore processing. Finally, if off-site long-term backup retention is needed, Oracle Database Backup Cloud Service should be used as a low-cost, offsite scalable storage solution for a disaster recovery solution.

NEW QUESTION # 18
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

• A. Configuring ASR is mandatory for all Database Machine assets.
• B. ASR can upload configuration metadata to support problem resolution.
• C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• D. ASR communicates with Oracle support services using HTTPS.
• E. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
• F. ASR Manager must be installed and configured on one of the database servers.

Answer: D,E

Explanation:
A and F are true statements about Auto Service Request (ASR) with an Exadata Database Machine [1][2]. In order to use the ASR feature, ASR Manager must be installed and configured on a dedicated server which is external to the Database Machine, and it communicates with Oracle support services using HTTPS. Additionally, ASR can upload configuration metadata to support problem resolution, and it can open a service request (SR) automatically after sensors detect hardware faults.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2].

NEW QUESTION # 19
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

• A. Oracle Linux 6.9
• B. Oracle Linux 7.5
• C. Oracle Linux 8.0
• D. Oracle Linux 7.7

Answer: B

NEW QUESTION # 20
Which statement is true about the patching features provided in Platinum Services?

• A. Patching is done automatically during business hours.
• B. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
• C. The rolling and complete down time approaches are two options to patching.
• D. Patching services are available for the full software stack up to twice per year.

Answer: D

Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
The correct statement about the patching features provided in Platinum Services is that patching services are available for the full software stack up to twice per year. Oracle Platinum Service covers Exadata storage software and firmware patching, and customers must also perform the database patching. The rolling and complete down time approaches are two options for patching, and patching should be scheduled for times when the system is not being heavily used. Patching is not done automatically during business hours. This is covered in section 4.13 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf Search results: [1] Oracle Exadata Storage Server Patching [1][2]. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest Oracle... [2] Patching and Upgrades. Oracle Database Machine provides automated patching and upgrades for the full Exadata software stack, up to twice a year, with... [3] Virtualized Exadata. Oracle Database Machine X9M-2 comes with a choice of two patching approaches to accommodate different customer needs: Rolling... [4] Jan 10, 2017 ... Exadata Patching Process. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest...

NEW QUESTION # 21
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. A splitter cable can be used to provide power to all PDU cables.
• B. The installation can go ahead, no change is required.
• C. 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.
• D. The installation cannot proceed until two power feeds are available per PDU.

Answer: D

Explanation:
In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack, and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will be able to provide sufficient power for the system. Therefore, the installation cannot proceed until two power feeds are available per PDU.
For more information about power requirements for Exadata X9M-2 Elastic Racks, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs

NEW QUESTION # 22
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?

• A. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
• B. to the CELLADMIN account using cellcli interactively on each storage server
• C. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
• D. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
• E. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
• F. to the CELLMONITOR account using cellcli interactively on each storage server

Answer: B,D,E

Explanation:
To drop all celldisks on all the storage servers in an X9M-2 quarter rack, you should use the CELLADMIN account, which has the necessary privileges to perform this task. You can use the CELLCLI command-line interface to drop the celldisks. The best way to do this is by calling CELLCLI on all cells using DCLI (Oracle Database Command Line Interface) which allows you to run commands on multiple servers at once. Alternatively, you can use an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli. It is not recommended to use the CELLMONITOR account, as it has a more limited set of privileges. It is also important to note that EXACLI is not a valid tool for this task
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html

NEW QUESTION # 23
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?

• A. Check the database to see if any rebalance operations are active.
• B. Wait for a blue light to appear on the disk if the rebalance operation is running.
• C. Download and run the latest exadiag tool.
• D. Call Oracle Support and make an appointment so that the drive can be replaced.
• E. Ask the system administrator to replace the broken disk with a spare.
• F. Wait for the email of the failure that Exadata or Enterprise Manager will send.

Answer: E

NEW QUESTION # 24
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Install on Exadata Engineered System.
• B. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
• C. Install in Oracle Virtual Machine with required hardware.
• D. Provide individual x86 64-Bit gateway hardware.
• E. Install on Oracle Database Appliance.

Answer: B,D,E

Explanation:
According to Oracle's documentation1, the customer options for hosting the Platinum Services Advanced Support Gateway are:
Provide individual x86 64-Bit gateway hardware1
Purchase the recommended x86 64-Bit gateway hardware from Oracle1
Install on Oracle Database Appliance2

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

• A. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
• B. It is required to install OEDA on the first new database server.
• C. 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.
• D. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
• E. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.

Answer: A,D

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

• A. It is mandatory to install OCM on all database servers.
• B. Collected configuration information can be uploaded manually to Oracle.
• C. It is mandatory to install OCM on at least one database server.
• D. It collects configuration information on demand.
• E. Collected configuration information can be uploaded automatically to Oracle.
• F. It collects configuration information automatically.

Answer: B,C,F

NEW QUESTION # 27
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. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
• B. OS I/O metrics using OS tools such as iostat on the storage servers
• C. OS I/O metrics using OS tools such as iostat on the database servers
• D. OS I/O metrics using Enterprise Manager host pages for the storage servers
• E. 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

Answer: A,C

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

• A. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
• B. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
• C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
• D. Oracle Exadata Rack may only be installed on raised floor environments.
• E. The incline of any access route ramp must be less than or equal to 6 degrees.
• F. 914mm of space required above the rack height is required for maintenance access.

Answer: C

NEW QUESTION # 29
Which two statements are true about enabling write-back flash cache?

• A. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
• B. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
• C. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
• D. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
• E. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.

Answer: D,E

NEW QUESTION # 30
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

• A. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
• B. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
• C. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
• D. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.

Answer: A,D

Explanation:
C) OEDA deployment steps include calibrate cells, create cell disks, and resecure machine2.
D) OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA2.

NEW QUESTION # 31
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

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

Answer: C,D

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

Answer: C

Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the customer should use the High redundancy level for their ASM storage in order to ensure that their data is available on the Exadata machine during updates. The High redundancy level provides the most protection against single-node server failure, as it stores three copies of each data file on separate nodes. This is the same redundancy level used for the Oracle Database's Control Files and Redo Logs. Instructions for configuring the ASM redundancy level can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_asm_overview.html.

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

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

Answer: B,C

Explanation:
B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.
References for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.
Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Add Equipment: This input option allows you to allocate RU slots for ... [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Power Selection [1][2]: This input option allows you to select PDU power initially ... [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ...

NEW QUESTION # 34
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?

• A. list cell attributes name, deviceName, diskType, physicalFirmware
• B. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
• C. list celldisk attributes name, deviceName, diskType, physicalFirmware
• D. list devices attributes name, deviceName, diskType, physicalFirmware

Answer: B

Explanation:
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).

NEW QUESTION # 35
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?

• A. 4,3,2,6,1,7,5
• B. 2,3,4,6,1,7,5
• C. 2,6,1,4,3,7,5
• D. 3,2,6,1,4,7,5
• E. 3,2,6,4,1,7,5

Answer: D

NEW QUESTION # 36
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. Cell Offload Quarantine
• C. Disk Region Quarantine
• D. Database Quarantine
• E. Manually created Quarantine

Answer: D,E

NEW QUESTION # 37
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. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
• C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
• D. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.

Answer: B,C

NEW QUESTION # 38
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. You must be physically present in the data center to start an Exadata Storage Server.
• B. -> start /SYSTEM/power
• C. -> set /SYS power_state=ON
• D. -> start /System
• E. -> start /SP/console
• F. -> start /SYS/power

Answer: C

Explanation:
This command is based on the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and other resources. This command sets the power state of the system to ON and starts the storage server. It is the only command that is able to start the storage server remotely. All the other commands are incorrect or require the user to be physically present in the data center.

NEW QUESTION # 39
......

Oracle 1Z0-902 certification exam covers various topics related to the Exadata Database Machine X8M, including hardware and software architecture, installation and configuration, storage management, network configuration, database administration, and backup and recovery. Candidates are expected to have a good understanding of these topics to pass the exam and earn the certification.

 

Most Reliable Oracle 1z1-902 Training Materials: https://passleader.bootcamppdf.com/1z1-902-exam-actual-tests.html