[2023 年 11 月 14 日] 可靠的 1Z0-902 考试技巧测试 PDF 考试材料 [Q19-Q33]

出版日期 11 月 14, 2023

给本帖评分

[Nov 14, 2023] Reliable 1Z0-902 Exam Tips Test Pdf Exam Material

New 2023 1Z0-902 Test Tutorial (Updated 60 Questions)

Oracle 1z1-902 (Oracle Exadata Database Machine X8M Implementation Essentials) Exam is designed to test the knowledge and skills of IT professionals who are responsible for implementing and managing Oracle Exadata Database Machine X8M systems. Oracle Exadata Database Machine X8M Implementation Essentials certification exam is part of the Oracle Certified Implementation Specialist program and is a popular choice for IT professionals looking to demonstrate their expertise in this area.

Oracle 1z1-902 exam covers various topics related to Oracle Exadata Database Machine X8M, including architecture, installation, configuration, backup and recovery, performance tuning, and security. 1Z0-902 exam is intended for IT professionals, such as database administrators, system administrators, and technical consultants, who are responsible for implementing and managing Oracle Exadata Database Machine X8M systems.

新问题 19
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA 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?

The installation can go ahead, no change is required.

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

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.

新问题 20
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use “Add Equipment” to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use “Add Equipment” to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use “Add Equipment” to add the Exadata X9M Database Servers, starting from RU16.
7. Use “Add Equipment” to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use “Add Equipment” to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use “Add Equipment” to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?

10, 8, 2, 5

44, 6, 9

10, 8, 9, 11

7,6,9,11

新问题 21
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

新问题 22
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.

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

新问题 23
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.

https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
https://chriscraftoracle.wordpress.com/2022/11/09/what-makes-exadata-faster/

新问题 24
Which dbmcli command is NOT valid on Exadata X9M?

dbmcli -e “LIST METRICHISTORY WHERE name LIKE ‘DS_.*'”

dbmcli -e “LIST METRICCURRENT WHERE name = ‘DS_TEMP’ “

dbmcli -e “LIST IBPORT DETAIL”

dbmcli -e “LIST ALERTHISTORY WHERE agelnMinutes < 15”

1. dbmcli -e “LIST METRICHISTORY WHERE name LIKE ‘DS_.*'” is valid command and it is used to list the historical values for metrics where the name starts with “DS_.”
2. dbmcli -e “LIST METRICCURRENT WHERE name = ‘DS_TEMP’ ” is valid command and it is used to list the current value of the metric named “DS_TEMP”
3. dbmcli -e “LIST IBPORT DETAIL” is valid command and it is used to list the InfiniBand ports and details of the Exadata X9M.
“dbmcli” is a command-line tool that is used to manage and monitor the Exadata Database Machine. It allows you to perform various tasks such as managing the database, storage, and network components, and monitoring the performance and health of the machine. The command “dbmcli -e “LIST ALERTHISTORY WHERE agelnMinutes < 15” is not a valid command, it is not supported on Exadata X9M.

新问题 25
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

According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.
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 *plus. These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.

新问题 26
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.

Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk. This helps to further reduce redo log write latency by utilizing the speed and low latency of Persistent Memory, along with the Remote Direct Memory Access (RDMA) protocol, to commit changes to disk faster. This allows the system to quickly commit changes to disk, resulting in improved performance and reduced latency.
This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2]. The Persistent Memory Commit Accelerator uses Persistent Memory and Remote Direct Memory Access (RDMA) technology to write redo log data to Flash and disk, resulting in improved latency and higher throughput. Additionally, the Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash [1], further reducing latency.

新问题 27
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

新问题 28
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.

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.

新问题 29
Which two statements are true about applying updates on Exadata systems?

Failed storage server updates are automatically rolled back to a previous release.

To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.

Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.

For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.

Failed database server updates are rolled back to a working state on a previous release automatically.

When running a “yum update” for a new Exadata release, all other repositories should be disabled.

1. Exadata updates have a rollback feature in case the update fails, this means that the system will roll back to a previous release automatically, this applies to storage servers updates. D. Yum, the package manager used in Exadata, automatically installs a non-UEK kernel when running a regular update, this kernel can be selected to boot from grub.

新问题 30
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.

[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 4: Oracle Clusterware [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 8: Oracle Exadata Storage Server Software [3] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 9: Oracle Exadata Storage Server Infrastructure

新问题 31
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.

新问题 32
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.

新问题 33
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.

To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e “ALTER CELL ENABLE REST” and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).

加载中 …