更新済みの2023年06月 1Z0-902試験練習テスト問題
検証済み1Z0-902問題集と解答100%一発合格保証で更新された問題集
Oracle 1z1-902認定試験は、Oracle Exadata Database Machine X8Mシステムの実装および管理スキルを検証したい専門家向けに設計されています。試験は、Oracleデータベース技術に精通し、Exadata Database Machine X8Mシステムの設計、展開、および管理の経験がある個人を対象としています。認定試験では、候補者のOracle Exadataアーキテクチャ、パフォーマンスチューニング、バックアップおよびリカバリ、高可用性の知識がテストされます。
質問 # 36
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. 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. The installation cannot proceed until two power feeds are available per PDU.
- C. The installation can go ahead, no change is required.
- D. A splitter cable can be used to provide power to all PDU cables.
正解：A
質問 # 37
Which two statements are true about applying updates on Exadata systems?
- A. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- B. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- C. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- D. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- E. Failed storage server updates are automatically rolled back to a previous release.
- F. Failed database server updates are rolled back to a working state on a previous release automatically.
正解：E、F
解説：
When applying updates on Exadata systems, database server updates are automatically rolled back to a working state on a previous release if the update fails. This ensures that the system can be restored to a working state in the event of a failed update. Additionally, storage server updates are also automatically rolled back to a previous release in the event of a failed update.
This is documented in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and more information can be found on the Oracle support website [1][2].
質問 # 38
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 will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
- B. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
- C. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- D. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
正解：B
質問 # 39
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?
- A. 2, 8, 7, 3, and 6
- B. 4, 7, 8, 3, and 6
- C. 1, 8, 7, 3 and 6
- D. 5, 8, 7, and 6
- E. 2, 7, 8, and 6
正解：C
解説：
In order to power off an Exadata Database Machine in an orderly fashion, the commands should be executed in the following order: 1) Execute "crscti stop cluster -all" as the grid user from one database server; 2) Execute "shutdown -h now" on all database servers; 3) Power off all network switches; 4) Execute "shutdown -h now" on all Exadata storage servers; and 5) Power off the rack using the power switches on the PDUs. This sequence of commands ensures that all services running on the Exadata Database Machine are in a clean state before powering off the system. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 543)
質問 # 40
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?
- A. 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.
- B. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
- C. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
正解：B
解説：
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).
質問 # 41
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- B. A single database with one or more schema per application
- C. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- D. Multiple Databases on a cluster
- E. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- F. Bare Metal deployment with one database per database server
正解：B、C、D
解説：
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
1. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
2. A single database with one or more schema per application12.
3. Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how
質問 # 42
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. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
- B. It is required to install OEDA on the first new database server.
- C. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
- D. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
- E. 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.
正解：A、C
質問 # 43
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. -> start /SYSTEM/power
- B. -> start /SYS/power
- C. -> set /SYS power_state=ON
- D. -> start /System
- E. -> start /SP/console
- F. You must be physically present in the data center to start an Exadata Storage Server.
正解：B
解説：
ILOM (Integrated Lights Out Manager) is a remote management system that allows you to control and monitor Exadata Database Machine components, such as storage servers and database servers, from a remote location. The command "start /SYS/power" is used to power on the storage server in the Exadata Database Machine after hardware maintenance. This command can be executed remotely via ILOM.
質問 # 44
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
- D. dbmcli -e "LIST IBPORT DETAIL"
正解：B
解説：
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.
質問 # 45
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 the email of the failure that Exadata or Enterprise Manager will send.
- B. Check the database to see if any rebalance operations are active.
- 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. Call Oracle Support and make an appointment so that the drive can be replaced.
- F. Ask the system administrator to replace the broken disk with a spare.
正解：E
解説：
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.
質問 # 46
Which two statements are true about enabling write-back flash cache?
- A. Before write-back flash cache is enabled, you need to drop the Flash Cache 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. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
正解：B、E
解説：
When enabling write-back flash cache in a rolling manner, it is important to use DBCLI to inactivate the grid disks on all cells first so that all the cells are in the same state before the process is started. In a non-rolling manner, you must drop the Persistent Memory Commit Accelerator (PMEMLog) first. Write-back flash cache is not on by default for High Capacity Storage Servers in High Redundancy configurations and can be used on Extreme Flash Storage Servers. It's also important to check if it's necessary to drop the flash cache before enabling write-back flash cache.
質問 # 47
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?
- A. moving all disks from one cell to another as part of a chassis-level component failure
- B. corruption in the / (root) filesystem
- C. the failure of physical disk 0 and 11
- D. the failure of physical disk 1
- E. the failure of both physical M.2 disks
- F. accidental loss of all data from all griddisks in a storage server
- G. corruption in a normal or high redundancy ASM diskgroup
正解：B、C
解説：
The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.
質問 # 48
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?
- A. 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
- B. 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
- C. 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
- D. 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
正解：A、C
質問 # 49
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?
- A. using the CELLCLI list LUN DETAIL command as the celladmin user
- B. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
- C. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
- D. hardware monitoring using the storage server ILOM
正解：A、D
質問 # 50
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 the CELLMONITOR account using cellcli interactively on each storage server
- B. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
- C. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
- D. to the CELLADMIN account using cellcli interactively on each storage server
- 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 CELLADMIN account by calling CELLCLI on all cells using DCLI
正解：A、B、E
質問 # 51
......
Oracle Exadata Database Machine X8Mは、大規模なミッションクリティカルなデータベースを実行するために特別に設計された高性能コンピューティングプラットフォームです。Oracleのデータベース技術をストレージサーバーとネットワークコンポーネントと組み合わせた統合ハードウェアおよびソフトウェアシステムです。Exadata Database Machine X8Mは高速なデータ処理およびストレージ機能を提供し、組織が複雑なワークロードを簡単に実行できるようにします。Oracle 1Z0-902試験は、この強力なプラットフォームを実装および管理する専門家が自分の専門知識を証明するための必須ツールであり、IT業界の雇用主に高く評価されています。
究極の準備用無料ガイド1Z0-902試験問題と解答：https://drive.google.com/open?id=1v7ZOVlZ_KPOQtPe4kQtY5UUxQIdzJA3y
合格できるOracle Engineered Systems 1Z0-902試験問題集には62問があります：https://www.jpntest.com/shiken/1Z0-902-mondaishu