[2024年01月] 確実合格する有効な方法 Oracle 試験問題集 1Z0-902 試験学習ガイド [Q19-Q36]

[2024年01月] 確実合格する有効な方法Oracle試験問題集で1Z0-902試験学習ガイド

1Z0-902問題集とOracle Exadata Database Machine X8M Implementation Essentialsトレーニングコースでお客様の合格を楽にさせる学習合格試験問題！

Oracle Exadata Database Machine X8Mは、ミッションクリティカルなデータベースのための極端なパフォーマンス、スケーラビリティ、可用性を提供する高性能データベースアプライアンスです。OLTP、データウェアハウジング、アナリティクスなどのOracleデータベースワークロードに最適化されたパフォーマンスを提供するように設計されています。このアプライアンスは、最適なパフォーマンスとスケーラビリティを提供するために共にエンジニアリングされたハードウェアとソフトウェアの構成要素を組み合わせています。

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

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

正解：D、E

解説：
A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration

質問 # 20
Which three statements are true about the CELLCLI command?

A. It requires root privileges to create CELLDISKS and GRIDDISKS.
B. It can be executed using the DCLI utility.
C. It can be executed on storage servers.
D. It can execute commands on multiple storage servers in parallel.
E. It has command-line history.

正解：B、D、E

解説：
The CELLCLI utility is a command line interface to Exadata that enables the execution of commands across multiple storage servers in parallel. It also has command-line history, so users can easily recall previously entered commands. Furthermore, the CELLCLI utility can be executed using the DCLI utility, which provides a convenient way to execute commands on multiple storage servers simultaneously.
However, CELLCLI does not require root privileges to create CELLDISKS and GRIDDISKS, and it cannot be executed on storage servers. This is because CELLCLI is used to manage the Exadata database machine from the database server [1]. For more information about CELLCLI, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

質問 # 21
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?

A. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
B. Copy and execute the script on all storage servers using the EXACLI command.
C. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
D. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
E. Copy and execute the script on all storage servers using the dcli command.

正解：E

質問 # 22
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 installation cannot proceed until two power feeds are available per PDU.
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.

正解：C

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

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

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

正解：E、F、G

解説：
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.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".

質問 # 24
Which two statements are true about applying updates on Exadata systems?

A. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
B. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
C. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
D. Failed database server updates are rolled back to a working state on a previous release automatically.
E. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
F. Failed storage server updates are automatically rolled back to a previous release.

正解：E、F

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

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

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

正解：C

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

質問 # 26
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. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
D. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
E. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.

正解：B、C

質問 # 27
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 CELLADMIN account by calling CELLCLI on all cells using DCLI
B. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
C. to the CELLADMIN account using cellcli interactively on each storage server
D. to the CELLMONITOR account using cellcli interactively on each storage server
E. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
F. to the CELLMONITOR account calling CELLCLI on all cells using DCLI

正解：A、B、C

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

質問 # 28
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. 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. Call Oracle Support and make an appointment so that the drive can be replaced.
F. Check the database to see if any rebalance operations are active.

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

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

正解：F

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

質問 # 30
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 power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
C. The installation cannot proceed until two power feeds are available per PDU.
D. The installation can go ahead, no change is required.

正解：B

質問 # 31
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?

A. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
B. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
C. The sparse_<DBM_NAME> diskgroup is created automatically.
D. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
E. The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.

正解：A、B

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

正解：B、C

解説：
The execute /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.

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

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

解説：
According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
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.
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.

質問 # 34
Which statement is true about the patching features provided in Platinum Services?

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

正解：A

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

質問 # 35
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 24x 32GB DIMMs.
C. Add 32x 64GB DIMMs.
D. Add 16x 32GB DIMMs.
E. Remove existing memory modules.
F. Shutdown the Database Server if running.
G. Add 16x 64GB DIMMs.
H. Add 12x 64GB DIMMs.
I. Add 12x 32GB DIMMs.

正解：E、F、G

質問 # 36
......

Oracle 1Z0-902認定試験に備えるには、Oracleの推奨トレーニングコース、Oracle Exadataデータベースマシン：概要を利用できます。このコースでは、Oracle Exadata Database Machine X8Mの主要な機能、アーキテクチャ、および構成、およびデータ管理、高可用性、バックアップとリカバリ、パフォーマンスチューニングについて説明します。また、試験の準備に役立つ学習資料、練習試験、およびその他のリソースをオンラインで見つけることもできます。

Oracle 1Z0-902試験は、Exadata X8Mシステムを実装および維持したいプロフェッショナルを対象としています。この試験は、Exadataシステムのアーキテクチャ、データベース展開、構成および管理、バックアップおよびリカバリ、パフォーマンスチューニングなど、さまざまなトピックをカバーしています。試験には、候補者がExadata X8Mのコンポーネントとその相互作用について強い理解を持っていることが必要です。

リアル試験問題と解答Oracle 1Z0-902問題集はここに：https://drive.google.com/open?id=13wgPg0P9B18gfzyi-gyhgawuAAPwozuY

最新 [2024年01月] 効果的な学習法で試験合格できる1Z0-902：https://www.goshiken.com/Oracle/1Z0-902-mondaishu.html

関するブログ

もっと

1Z0-902無料問題集