1Z0-902事前に試験練習テストで使おう（最新60問題) [Q33-Q55]

1Z0-902事前に試験練習テストで使おう（最新60問題)

有効な1Z0-902試験解答PDF一年無料更新

Oracle Exadata Database Machine X8Mは、ハードウェアとソフトウェアコンポーネントを統合して、高性能で高度に利用可能なスケーラブルなデータベースプラットフォームを提供するエンジニアリングシステムです。マシンは、オンライントランザクション処理（OLTP）およびデータウェアハウジングワークロードに極端なパフォーマンスを提供するように設計されています。 Exadata Database Machine X8Mには、高速インフィニバンドネットワーキング、フラッシュストレージ、およびOracleデータベースソフトウェアが含まれており、高度に最適化された効率的なシステムを提供するために統合されています。

Oracle 1Z1-902試験は、Oracle Exadataの管理者または建築家としてキャリアを進めたいIT専門家にとって理想的な選択肢です。この試験は、業務をサポートするために高性能データベースを必要とする大企業または組織で働く人々に特に関連しています。この試験に合格することで、認定されたOracle Exadata Database Machine X8M実装スペシャリストになります。

Oracle 1z1-902 認定試験は、候補者が Oracle Exadata Database Machine X8M を管理し、実装する能力を厳密かつ包括的にテストするものです。この認定は業界で高く評価され、複雑なデータベースシステムを管理する専門家が専門知識を証明するために必要な資格です。適切な準備と経験を持っていれば、候補者はこの貴重な認定を取得することができます。

 

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

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

正解：A、D、E

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

• A. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• B. Run the appropriate patchmgr preqequisite check step for each component being updated.
• C. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• D. Run exachk and resolve only WARNINGS that you have not seen before.
• E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• F. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

正解：A、B、D、F

解説：
According to Oracle.com documents or resources, the four actions that you should take before proceeding with applying updates to your Exadata Database Machine are:
A) Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
B) Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
C) Run exachk and resolve only WARNINGS that you have not seen before3.
D) Run the appropriate patchmgr preqequisite check step for each component being updated3.

質問 # 35
Which statement is true about the Persistent Memory Commit Accelerator?

• A. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
• B. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
• C. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
• D. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
• E. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.

正解：B

質問 # 36
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?

• A. Oracle clusterware on the database server
• B. ASM instances
• C. the Power Distribution Units (PDUs)
• D. the RDMA over Converged Ethernet (RoCE) switches
• E. the storage server ILOM
• F. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers

正解：A、B、E

解説：
1. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor ASM instances.
2. Additionally, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor the storage server ILOM.
3. The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 6-25) also recommends using the Exadata-specific Enterprise Manager Plug-Ins to monitor Oracle clusterware on the database server.

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

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

正解：B

解説：
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.
The correct statement about the patching features provided in Platinum Services is that patching services are available for the full software stack up to twice per year. Oracle Platinum Service covers Exadata storage software and firmware patching, and customers must also perform the database patching. The rolling and complete down time approaches are two options for patching, and patching should be scheduled for times when the system is not being heavily used. Patching is not done automatically during business hours. This is covered in section 4.13 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf Search results: [1] Oracle Exadata Storage Server Patching [1][2]. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest Oracle... [2] Patching and Upgrades. Oracle Database Machine provides automated patching and upgrades for the full Exadata software stack, up to twice a year, with... [3] Virtualized Exadata. Oracle Database Machine X9M-2 comes with a choice of two patching approaches to accommodate different customer needs: Rolling... [4] Jan 10, 2017 ... Exadata Patching Process. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest...

質問 # 38
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

• A. PMEM Cache section within Exadata Smart Statistics
• B. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
• C. PMEM Cache section within Memory Statistics
• D. PMEM Pool Misses in the Exadata Outlier Summary
• E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary

正解：A、E

解説：
Option C shows the number of read hits from PMEM cache on storage servers which indicates how much data was served from PMEM instead of flash or disk1.
Option E shows detailed information about PMEM cache such as size, utilization, hit ratio, read latency and write latency2.

質問 # 39
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. Failed database server updates are rolled back to a working state on a previous release automatically.
• C. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
• D. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
• E. Failed storage server updates are automatically rolled back to a previous release.
• F. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.

正解：B、C

質問 # 40
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A. Using EXADCLI instead of CELLCLI to create the griddisks
• B. Exadata storage realms using ASM-scoped security mode
• C. Exadata storage realms using database-scoped security mode
• D. File permissions on the griddisks in each storage server
• E. File permissions on the griddisks in each database server

正解：B、C

解説：
Exadata storage realms using ASM-scoped security mode allows you to control which database can access which griddisks by creating realms at the ASM level, thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.2 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
Exadata storage realms using database-scoped security mode allows you to control which database can access which griddisks by creating realms at the database level [1], thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.3 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [2].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf [2] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf

質問 # 41
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, but are not enabled by default.
• B. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
• C. 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.
• D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.

正解：C

質問 # 42
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 Exadata Storage Server Grid home page
• B. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
• C. alert logs for the ASM instances
• D. alert logs for the prod database instances
• E. alert logs for Enterprise Manager

正解：A、B

質問 # 43
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 Exadata Storage Server Grid home page
• B. alert logs for the ASM instances
• C. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
• D. alert logs for Enterprise Manager
• E. alert logs for the prod database instances

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

質問 # 44
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

• A. Configuring ASR is mandatory for all Database Machine assets.
• B. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• C. ASR Manager must be installed and configured on one of the database servers.
• D. ASR can upload configuration metadata to support problem resolution.
• E. ASR communicates with Oracle support services using HTTPS.
• F. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.

正解：B、D

解説：
1. ASR can upload configuration metadata to support problem resolution1.
2. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm

質問 # 45
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.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• D. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

正解：C

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

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

正解：C、E

解説：
According to Oracle's documentation12, some of the statements that are true about applying updates on Exadata systems are:
Failed storage server updates are automatically rolled back to a previous release1.
When running a "yum update" for a new Exadata release, all other repositories should be disabled1.

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

• A. 2,6,1,4,3,7,5
• B. 4,3,2,6,1,7,5
• C. 3,2,6,1,4,7,5
• D. 3,2,6,4,1,7,5
• E. 2,3,4,6,1,7,5

正解：E

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

• A. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
• B. # resize2fs +20G /dev/VGExaDb/LVDbOral
• C. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
• D. # xfs_growfs /uOl +20G

正解：A

解説：
After running the commands above, the filesystem mounted on /u01 is on the logical volume /dev/mapper/VGExaDb-LVDbOral. So, to add 20G of space to the filesystem mounted on /u01, the command that needs to be run is:
lvextend -L +20G --verbose /dev/mapper/VGExaDb-LVDbOral
This command will extend the logical volume /dev/mapper/VGExaDb-LVDbOral by 20 GB of space. It is important to note that the option --verbose is used to display the progress of the operation.

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

正解：E

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

正解：B、D

解説：
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.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/index.html

質問 # 51
Which two statements are true in regards to starting the Exadata Virtual Machine?

• A. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
• B. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
• C. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
• D. Use vm_maker -start-domain to start a virtual machine manually.
• E. Use vm_maker boot-from-iso command to boot a virtual machine.

正解：C、E

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

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

正解：B、D、E

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

質問 # 53
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. 1, 8, 7, 3 and 6
• B. 2, 8, 7, 3, and 6
• C. 4, 7, 8, 3, and 6
• D. 2, 7, 8, and 6
• E. 5, 8, 7, and 6

正解：D

解説：
In order to completely power off an Exadata Database Machine in an orderly fashion, it's important to properly shut down the cluster first. The command "crscti stop cluster" as root should be executed from one of the database servers.
Once the cluster has been stopped, the next step is to shut down the database servers by executing the command "shutdown -h now" on all database servers.
Next, shut down the Exadata storage servers by executing the command "shutdown -h now" on all Exadata storage servers.
Finally, power off the rack using the power switches on the PDUs.

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

• A. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• B. Run exachk and resolve only WARNINGS that you have not seen before.
• C. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• D. Run the appropriate patchmgr preqequisite check step for each component being updated.
• E. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• F. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

正解：A、C、D、F

解説：
For database servers, perform a server backup using patchmgr -dbnodes dblistfile -backup -rolling. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book . The other statement is false as exachk should not be used to resolve warnings or errors [1], but rather to identify them so that they can be addressed. Additionally, patchmgr should not be used with the --autofix, --autobackup, --upgrade, or --rolling flags as this could cause unexpected issues.

質問 # 55
......

Oracle Exadata Database Machine X8M Implementation Essentials無料更新認定サンプル問題：https://jp.fast2test.com/1Z0-902-premium-file.html

試験本場前にトレンドなOracle 1Z0-902のPDF問題集を試そう：https://drive.google.com/open?id=1X9v58C7eNs10oL4--DFf0ACzO7Wdxpgw