[Jan-2024] Oracle Engineered Systems 1Z0-902 Exam Practice Test Questions Dumps Bundle! [Q29-Q43]

[Jan-2024】Oracle Engineered Systems 1Z0-902試験練習問題集バンドル！[Q29-Q43］

1月 22, 2024 管理者 0 コメント

4.5/5 - (2 投票)

[Jan-2024] Oracle Engineered Systems 1Z0-902 Exam Practice Test Questions Dumps Bundle!

2024 Updated 1Z0-902 PDF for the 1Z0-902 Tests Free Updated Today!

Oracle 1Z0-902 certification exam is designed to test the skills and knowledge of professionals who are responsible for the implementation and administration of the Oracle Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification exam is intended for professionals who are seeking to validate their expertise in designing, implementing, and managing Oracle Exadata Database Machine X8M solutions. 1Z0-902 exam covers a range of topics including Exadata hardware components, software features, security, backup and recovery, and performance tuning.

Oracle 1Z0-902 certification exam, also known as the Oracle Exadata Database Machine X8M Implementation Essentials, is designed for professionals who specialize in implementing and administering Oracle Exadata Database Machine X8M systems. Oracle Exadata Database Machine X8M Implementation Essentials certification validates your skills and knowledge of Exadata architecture, configuration, and management, as well as your ability to troubleshoot and resolve common issues. 1Z0-902 exam is ideal for database administrators, system administrators, and technical consultants who want to enhance their expertise in Oracle Exadata.

質問29
お客様は、アップデート中もExadataマシンでデータが利用可能であることを保証する必要があります。一度に1台のサーバーをアップデートできるようにしたいが、シングルノードのサーバー障害から保護されたい。
ASMの冗長レベルはどの程度にすべきでしょうか？

ノーマル

疎

高い

外部

拡張

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. This means that they need a redundancy level that can tolerate at least one disk failure without losing data availability or performance. Therefore, the best option for them is normal redundancy . Normal redundancy provides two-way mirroring by default, which means that each data extent has a primary copy and a mirror copy on different disks in different failure groups1. A failure group is a subset of disks within a disk group that are likely to fail at the same time due to common dependencies2. On Exadata Database Machine , each Storage Server is considered as a failure group by default2. This means that if one Storage Server fails or needs to be updated , the data on its disks can still be accessed from another Storage Server that has the mirror copies of the same data extents2. Therefore, normal redundancy ensures data availability and performance during updates or single-node server failures.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html

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

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.

Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

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.

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.

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

質問31
You are adding a disk expansion kit to a running Exadata X8M Database Machine’s Database Servers, and have a filesystem layout that includes:

After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

# lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral

# xfs_growfs /uOl +20G

# resize2fs +20G /dev/VGExaDb/LVDbOral

# lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral

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

OECA reconfigures the size of disk groups and recreates grid disks.

OECA extends the hardware for the elastic configuration only.

OECA allows one XT storage server in the configuration.

OECA’s “Add Equipment” input option allows allocation of RU slots for customer equipment.

OECA facilitates PDU power selection initially and after equipment addition.

The correct answers are Options A and D. Option A is correct because OECA reconfigures the size of disk groups and recreates grid disks. Option D is correct because OECA’s “Add Equipment” input option allows allocation of RU slots for customer equipment.

質問33
Exadataデータベースマシンの検証、受け取り、開梱、アクセスルートとスペース要件の計画時に必要でないものはどれですか？

設置場所へのアクセスルート全体には、振動の原因となるような盛り上がった模様の床材を敷かないこと。

ラックの高さより914mm上のスペースは、メンテナンスアクセスに必要です。

アクセスルートの傾斜は6度以下でなければならない。

ラックを移動させる前に、4つのレベリングフットとスタビライジングフィートをすべて上げ、邪魔にならないようにしてください。

Oracle Exadata Rackは、高床式の環境にのみ設置できます。

データセンターに入る前に梱包材を取り除き、パーティクルを減らすためには、調整された空間が必要である。

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

質問34
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.

質問35
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?

using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

using the CELLCLI CALIBRATE command on the storage server after logging in as the root user

hardware monitoring using the storage server ILOM

using the CELLCLI list LUN DETAIL command as the celladmin user

The CELLCLI CALIBRATE command can be used to check the health of all flash cards in the storage server, and it should be run after logging in as the celladmin user. The hardware monitoring using the storage server ILOM should also be used to check for errors and other potential issues with the flash cards. The CELLCLI list LUN DETAIL command should not be used to identify a damaged or failing flash card, since it will not provide any information about the health of the flash card.

質問36
Exadataシステムでのアップデートの適用について、正しい記述はどれか。

失敗したストレージサーバーのアップデートは、自動的に以前のリリースにロールバックされる。

ストレージサーバーの更新をローリング方式で迅速に適用するには、2台のストレージサーバーを同時に更新することを推奨する。

ストレージセル上のカーネルパッケージとRDMAパッケージの更新は、yum -excludeオプションでそれらを除外することによって防ぐ必要があります。

通常のExadataアップデートの場合、yumは自動的に非UEKカーネルをインストールし、grubから起動するように選択できる。

失敗したデータベースサーバーの更新は、自動的に以前のリリースの動作状態にロールバックされます。

新しいExadataリリースの "yum update "を実行する場合、他のすべてのリポジトリを無効にする必要があります。

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

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

Oracle Linux 7.5

Oracle Linux 7.9

Oracle Linux 8.0

Oracle Linux 7.7

RoCE (RDMA over Converged Ethernet) and Persistent Memory are features that are supported by Oracle Linux. The minimum version of Oracle Linux required to support RoCE and Persistent Memory is Oracle Linux 7.9.
RoCE is a low-latency, high-bandwidth networking technology that enables fast data transfer between servers using converged Ethernet networks. It is supported by Oracle Linux 7.9 and later versions, which includes the necessary kernel modules and user-space libraries to enable RoCE.
Persistent Memory is a technology that allows data to be stored in non-volatile memory (NVM) devices, such as NVDIMMs (Non-Volatile Dual In-line Memory Modules), which can be accessed at near-DRAM speeds. Oracle Linux 7.9 and later versions include support for Persistent Memory, which includes kernel modules and user-space libraries to enable Persistent Memory.

質問38
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

According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
1. changing the root password
2. configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html

質問39
Exadataデータベース・マシンのセルにSQLステートメントをオフロードする複数のデータベースのスマート・スキャンを無効にできる2つの検疫タイプはどれですか？

SQLプランの隔離

手動で隔離を作成

データベースの隔離

ディスク領域の隔離

セル・オフロード検疫

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

質問40
Exadataデータベース・マシンにアップデートを適用する前に行うべき4つのアクションはどれですか？

現在推奨されているExadataソフトウェアのリリースについては、My Oracle Support note 888828.1を参照してください。

exachk の最新バージョンに追加されていない問題については、Exadata Critical Issues My Oracle Support note 1270094.1 を確認してください。

exachkを実行し、見たことのないWARNINGSだけを解決する。

更新される各コンポーネントについて、適切な patchmgr preqequisite チェックステップを実行します。

patchmgr -all_comp -autofix -autobackup -upgrade -rolling を実行する。

データベース・サーバについては、patchmgr -dbnodes db_list_file -backup -rollingを使用してサーバのバックアップを実行してください。

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

Ask the system administrator to replace the broken disk with a spare.

Check the database to see if any rebalance operations are active.

Call Oracle Support and make an appointment so that the drive can be replaced.

Wait for the email of the failure that Exadata or Enterprise Manager will send.

Download and run the latest exadiag tool.

Wait for a blue light to appear on the disk if the rebalance operation is running.

質問42
あなたは新しいExadata Database Machineのデリバリーを監督しています。
1.Exadata ラックを安定させます。
2.Oracle Exadata Rackを解凍します。
3.安全ガイドラインを確認する。
4.Exadataを24時間順応させる。
5.Exadata PDU A の電源を入れます。
6.Exadataを割り当てられたスペースに配置する。
7.Exadata PDU B の電源を入れます。
これらのステップの正しい順序は？

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

The correct sequence is:
Review the safety guidelines. This is important to ensure a safe and successful installation1.
Unpack Oracle Exadata Rack. This involves removing the packaging materials and inspecting the rack for damage or missing components1.
Place Exadata in its allocated space. This involves moving the rack to its final location and securing it with bolts and brackets1.
Let the Exadata acclimatize for 24 hours. This is recommended to allow the rack components to adjust to the ambient temperature and humidity before powering on1.
Stabilize the Exadata Rack. This involves leveling the rack and adjusting its height if needed1.
Power on Exadata PDU B. This involves connecting PDU B to a power source and turning it on1.
Power on Exadata PDU A. This involves connecting PDU A to a power source and turning it on1

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

Oracle Linux 7.5

Oracle Linux 6.9

Oracle Linux 8.0

Oracle Linux 7.7

ローディング …