• ホーム
  • ブログ
  • [Q29-Q45] テスト資料1Z0-902テストエンジン試験問題はここにある[2023年11月]

[Q29-Q45] テスト資料1Z0-902テストエンジン試験問題はここにある[2023年11月]

Share

テスト資料1Z0-902テストエンジン試験問題はここにある[2023年11月]

合格突破受験者シミュレーションされた1Z0-902試験PDF問題を試そう


Oracle 1Z0-902（Oracle Exadata Database Machine X8M実装エッセンシャル）認定試験は、Oracle ExadataデータベースマシンX8Mの実装と管理に関与している専門家のスキルと知識をテストするために設計されています。この試験は、Oracleデータベース管理の経験があり、Exadataの実装のスキルを向上させようとしている人向けです。


Oracle Exadata Database Machine X8Mは、大規模なミッションクリティカルなデータベースを実行するために特別に設計された高性能コンピューティングプラットフォームです。Oracleのデータベース技術をストレージサーバーとネットワークコンポーネントと組み合わせた統合ハードウェアおよびソフトウェアシステムです。Exadata Database Machine X8Mは高速なデータ処理およびストレージ機能を提供し、組織が複雑なワークロードを簡単に実行できるようにします。Oracle 1Z0-902試験は、この強力なプラットフォームを実装および管理する専門家が自分の専門知識を証明するための必須ツールであり、IT業界の雇用主に高く評価されています。

 

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

正解：A


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

  • A. 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.
  • 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. 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.

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


質問 # 31
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?

  • A. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
  • B. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
  • C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
  • D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

正解：A、D


質問 # 32
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

  • A. Install on Oracle Database Appliance.
  • B. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
  • C. Install on Exadata Engineered System.
  • D. Install in Oracle Virtual Machine with required hardware.
  • E. Provide individual x86 64-Bit gateway hardware.

正解：B、C、E

解説：
These options are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources. The customer can choose to either provide their own x86 64-Bit gateway hardware or purchase the recommended hardware from Oracle, or they can install the gateway on an Exadata Engineered System.


質問 # 33
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 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
  • B. 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
  • C. 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
  • D. 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

正解：A、B


質問 # 34
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

  • A. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
  • B. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
  • C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
  • D. ZFS Snapshots can provide rapid cloning of development and test environment.

正解：A、B

解説：
1. ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells. C. When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure.
Review the safety guidelines.
Unpack Oracle Exadata Rack.
Let the Exadata acclimatize for 24 hours.
Place Exadata in its allocated space.
Stabilize the Exadata Rack.
Power on Exadata PDU A.
Power on Exadata PDU B.
This order ensures that the necessary safety precautions are taken before installing the Exadata Database Machine, and that the machine is allowed to acclimate to its new environment before being powered on.


質問 # 35
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

  • A. 512GB
  • B. 1024GB
  • C. 768GB
  • D. 384GB
  • E. 2048GB
  • F. 1536GB

正解：E

解説：
The Exadata X9M-2 Database Machine uses powerful database servers, each with two 32-core x86 processors and 512 GB of memory (expandable up to 2 TB).


質問 # 36
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 flashdisks inside the Exadata storage servers for possible use for storage indexes.
  • B. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
  • C. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
  • D. 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.
  • E. The sparse_<DBM_NAME> diskgroup is created automatically.

正解：D、E

解説：
This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1]. The other statements are false as there is no free space available on the hard disks inside the database servers for possible extension of the /uoi file system, and there is no free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes or to configure Exadata Smart Flash Logs [2][3].


質問 # 37
Which two activities are supported on the storage servers in an Exadata Database Machine?

  • A. changing the root password
  • B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
  • C. configuring secure shell user equivalency for the cellmonitor user
  • D. installing an alternative package manager
  • E. upgrading the Storage Server software package using rpm

正解：A、C

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


質問 # 38
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

  • A. Install in Oracle Virtual Machine with required hardware.
  • B. Provide individual x86 64-Bit gateway hardware.
  • C. Install on Oracle Database Appliance.
  • D. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
  • E. Install on Exadata Engineered System.

正解：A、C、E

解説：
The Platinum Services Advanced Support Gateway is a component of Oracle's Platinum Services offering that enables customers to access advanced support features and tools, such as automated problem diagnosis and resolution. Customers have the option to host the Advanced Support Gateway on an Oracle Database Appliance, Oracle Virtual Machine with required hardware, or an Exadata Engineered System. These options allow customers to leverage existing infrastructure and resources to host the gateway, rather than needing to purchase and install new hardware. Providing individual x86 64-Bit gateway hardware or purchase the recommended x86 64-Bit gateway hardware from Oracle are also options but it depends on the customer's infrastructure and resources.


質問 # 39
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. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
  • B. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
  • C. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -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

正解：B

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


質問 # 40
You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?

  • A. on at least two storage servers in both racks
  • B. on all storage servers in both racks
  • C. on all database servers and at least two storage servers in both racks
  • D. on all database servers in the first rack
  • E. on only one database server in both racks
  • F. on all database servers in both racks and one storage server in each rack
  • G. on all database servers in the second rack

正解：B、D


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

正解：A

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


質問 # 42
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.
What ASM redundancy level should they use?

  • A. Sparse
  • B. Normal
  • C. External
  • D. High
  • E. Extended

正解：D

解説：
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the customer should use the High redundancy level for their ASM storage in order to ensure that their data is available on the Exadata machine during updates. The High redundancy level provides the most protection against single-node server failure, as it stores three copies of each data file on separate nodes. This is the same redundancy level used for the Oracle Database's Control Files and Redo Logs. Instructions for configuring the ASM redundancy level can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_asm_overview.html.


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

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

正解：A、D


質問 # 44
Which dbmcli command is NOT valid on Exadata X9M?

  • A. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
  • B. dbmcli -e "LIST IBPORT DETAIL"
  • C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
    B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "

正解：A


質問 # 45
......


Oracle 1z1-902 試験は、Oracle Exadata Database Machine X8M の実装と管理を担当する IT プロフェッショナルを対象としたベンダー固有の認定です。この認定は、この強力で効率的なデータベースプラットフォームの実装と管理における専門知識を証明するための素晴らしい方法です。試験は、Exadata Database Machine X8M の実装と管理に関連する広範なトピックをカバーしており、これらの分野の専門家の知識とスキルをテストするように設計されています。

 

正真正銘で最適な1Z0-902オンライン練習試験資料：https://www.goshiken.com/Oracle/1Z0-902-mondaishu.html

優良な質を持つ1Z0-902問題集と解釈が待ってます。 今すぐゲット：https://drive.google.com/open?id=13wgPg0P9B18gfzyi-gyhgawuAAPwozuY

関するブログ

もっと
1Z0-902無料問題集