[2024年01月]更新の1z1-902試験問題と有効な1z1-902問題集PDF [Q27-Q46]

[2024年01月]更新の1z1-902試験問題と有効な1z1-902問題集PDF

1z1-902ブレーン問題集学習ガイドにはヒントとコツで試験合格を目指そう

Oracle Exadata Database Machine X8Mは、極端なパフォーマンス、拡張性、信頼性を提供する高性能なデータベースアプライアンスです。最新のハードウェアとソフトウェア技術を備え、大量のデータを迅速かつ効率的に処理することができます。Oracle 1z1-902認定試験は、この強力なデータベースマシンを構成、実装、管理する能力を候補者がテストするものです。

 

質問 # 27
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

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

正解：B、C、F

質問 # 28
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 devices attributes name, deviceName, diskType, physicalFirmware
• B. list celldisk attributes name, deviceName, diskType, physicalFirmware
• C. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
• D. list cell attributes name, deviceName, diskType, physicalFirmware

正解：C

解説：
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).
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-cellcli.html

質問 # 29
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?

• A. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
• B. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
• C. alert logs for Enterprise Manager
• D. alert logs for the ASM instances
• E. alert logs for the prod database instances

正解：D、E

解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not.

質問 # 30
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 "set alert ds_temp> 30" on each database server
• B. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
• C. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
• D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server

正解：C

解説：
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 5-54) recommends using the dbmcli command to set thresholds on metrics, such as temperature. To do this, you should use the following command:
dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server.
This will generate an alert if the temperature exceeds 30C.

質問 # 31
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

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

正解：B

解説：
Oracle Linux 7.9 is the minimum version required to support RoCE and Persistent Memory. This is because Oracle Linux 7.9 includes kernel enhancements that enable RDMA over Converged Ethernet (RoCE) networking and Intel Optane DC Persistent Memory Modules (DCPMM) for Exadata X8M systems3. These features allow faster access latency and higher throughput for database workloads2.

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

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

正解：D

解説：
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)

質問 # 33
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?

• A. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
• B. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
• C. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
• D. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

正解：C

質問 # 34
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

• A. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• B. Add 16x 64GB DIMMs.
• C. Add 12x 64GB DIMMs.
• D. Add 12x 32GB DIMMs.
• E. Add 24x 32GB DIMMs.
• F. Add 32x 64GB DIMMs.
• G. Add 16x 32GB DIMMs.
• H. Shutdown the Database Server if running.
• I. Remove existing memory modules.

正解：B、H、I

解説：
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.

質問 # 35
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?

• A. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• B. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• C. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• D. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

正解：C

解説：
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-database-servers.html According to Oracle's documentation1, one of the utilities for diagnostics and repair of Oracle Exadata Storage Server is ExaWatcher, which collects operating system and network metrics on database servers and storage servers. The utility is located in the /opt/oracle.ExaWatcher directory1.
To investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend, you can use the GetExaWatcherResults.sh script to collect and analyze ExaWatcher data for a specified time range1.
Therefore, the command that you should use to investigate this is:
/opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

質問 # 36
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

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

正解：D

解説：
RoCE, or Remote Direct Memory Access over Converged Ethernet, is a high-speed networking technology that allows data to be transferred between servers, storage, and other devices over Ethernet. Persistent Memory is a form of non-volatile memory that can be used to store data without losing it when power is lost.
Oracle Linux 8.0 supports both RoCE and Persistent Memory, allowing Exadata systems to leverage the benefits of both technologies. For more information on Oracle Linux 8.0 and its features, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.

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

正解：A

解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], before doing anything else you should call Oracle Support and make an appointment so that the drive can be replaced. If Platinum Support is enabled, then you can call Oracle Support and they will arrange for the disk to be replaced. If Platinum Support is not enabled, then you can arrange for the disk to be replaced through Enterprise Manager Cloud Control.

質問 # 38
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

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

正解：A、C、D、F

質問 # 39
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?

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

正解：B

解説：
An Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs would typically require two power feeds per PDU, one for each of the two power distribution units (PDUs) in the rack. A single power feed per PDU is not sufficient to provide the necessary power to the servers and storage in the rack.

質問 # 40
What are two recommended configuration best practices for backup and recovery on Exadata?

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

正解：A、C

解説：
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.

質問 # 41
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

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

正解：D、E

質問 # 42
Which two statements are true about enabling write-back flash cache?

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

正解：A、E

解説：
The two statements that are true about enabling write-back flash cache are:
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.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "when enabling write-back flash cache in a rolling manner [1], grid disks need to be inactivated on all cells before enabling write-back flash cache". It also states that "before write-back flash cache can be enabled, the existing flash cache must be dropped".

質問 # 43
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

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

正解：B、D、F

解説：
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, OCM is mandatory to install on at least one database server and can be used to collect configuration information on demand. The collected information can then be uploaded either manually or automatically to Oracle.

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

正解：A

解説：
According to Oracle documentation1, Exadata Storage software has a complete set of automated operations for hard disk maintenance, when a hard disk has failed or has been flagged as a problematic disk. It will initiate a rebalance operation to redistribute data across other disks and mark the failed disk with an amber light.

質問 # 45
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?

• A. 10, 8, 9, 11
• B. 7,6,9,11
• C. 0
• D. 10, 8, 2, 5
• E. 4,1, 6, 9

正解：A

解説：
The correct order of steps is 10, 8, 9, 11. The 10th step is to use the drop down to add Exadata X9M Database Servers, the 8th step is to use the drop down to add Exadata X9M EF Storage Servers, the 9th step is to use "Add Equipment" to add the ZFS Storage Controllers, and the 11th step is to use "Add Equipment" to add the ZFS Storage Trays. These steps are referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/configuring-exadata.html

質問 # 46
......

1z1-902試験問題無料PDFダウンロード 最近更新された問題です：https://jp.fast2test.com/1z1-902-premium-file.html

1z1-902認定試験問題集には60練習テスト問題：https://drive.google.com/open?id=1FhkD29THtXzvjQhNuIm8YkG8sIerq40m