100%無料1z1-902試験問題集で試験を簡単に合格させます [Q26-Q47]

100%無料1z1-902試験問題集で試験を簡単に合格させるFast2test

無料1z1-902試験問題1z1-902実際のリアル試験問題

Oracle 1Z0-902（Oracle Exadata Database Machine X8M実装エッセンシャル）認定試験は、Oracle Exadata Database Machine X8Mを実装および維持する候補者の知識とスキルをテストするために設計された技術認定試験です。この認定試験は、エンタープライズ環境でOracle Exadata Database Machine X8Mの実装と管理を担当する専門家を対象としています。

Oracle 1Z0-902（Oracle Exadata Database Machine X8M実装エッセンシャル）認定試験は、Oracle Exadata Database Machine X8Mの実装と管理に関与している専門家にとって不可欠な資格です。この試験では、マシンに関連する幅広いトピックの候補者のスキルと知識をテストし、試験に合格すると、キャリアの進歩の機会と収益の可能性が高まります。

 

質問 # 26
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 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.
• B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
• C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
• D. 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、C

解説：
A . YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/

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

正解：A、D、F

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

正解：A、C、E

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

質問 # 29
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. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
• 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. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
• F. Failed database server updates are rolled back to a working state on a previous release automatically.

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

質問 # 30
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 dcli command and manually execute it on each storage server using the DCLI 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 CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
• E. Copy and execute the script on all storage servers using the dcli command.

正解：E

質問 # 31
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. ZFS Snapshots can provide rapid cloning of development and test environment.
• C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
• D. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.

正解：A、D

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

質問 # 32
How do ASM failure groups provide redundancy?

• A. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
• B. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
• C. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
• D. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

正解：B

解説：
Failure groups provide redundancy in Oracle Exadata Database Machine X9M by ensuring that mirror copies of the data are written to different storage servers [1][2]. This prevents the potential for mirror copies to be written to the same server, which would cause a data loss if that server were to experience a physical disk failure. Furthermore, failure groups help to ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster, providing an extra layer of data protection. Additionally, Extended Redundancy mirrors data across data centers, providing the highest levels of data protection. Reference: Oracle Exadata Database Machine X9M Implementation Essentials [1][2], Chapter 5: Configuring Oracle ASM.

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

正解：C

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

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

正解：C

解説：
Exachk is an Oracle-provided diagnostic tool that allows you to check various components of an Exadata Database Server, including the client network. The tool is located in the /opt/oracle.SupportTools/exachk/ directory and can be run with the command: exachk. This command can be run with the option -from <Fridays_Date>_17:00:00 and -to <Sundays_Date>_23:59:00 to specify a time range of interest, this way you can check the client network status between the specified time range. The tool checks the status of various components such as network interfaces, InfiniBand fabric, and storage servers. It also analyzes log files, configuration files, and system settings to detect any issues. The tool generates a report, which can be used to identify the root cause of the issue and provide recommendations for resolution.
Tfact1 is a tool to collect diagnostic information from Exadata and non-Exadata systems and it is not related to client network status.
Netcheck and GetExaWatcherResults.sh are not tools provided with the Exadata Database Server and they are not related to client network status.

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

正解：F

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

正解：A、D

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

質問 # 37
How many 128GB Persistent Memory DIMMS are included in Exadata X9M-2 Extended (XT) Storage Servers?

• A. 0
• B. 1
• C. 2
• D. 3

正解：D

解説：
The Exadata X9M-2 Extended (XT) Storage Server does not include any Persistent Memory (PMEM) DIMMs. The XT server configuration primarily serves as a cost-effective archival storage option and lacks the performance features available in the HC (High Capacity) and EF (Extreme Flash) storage servers. This configuration does not include Persistent Memory, which is leveraged in other models for accelerating OLTP workloads and providing extremely low-latency data access.

質問 # 38
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?

• A. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
• B. netstat -rn
• C. ifconfig -a legrep "re0| re1"
• D. cat /proc/net/bonding/bondeth0

正解：D

解説：
According to Oracle's documentation1, the client network on Exadata X9M-2 Database Server is used for client access to the database servers using Single Client Access Name (SCAN) and Oracle RAC Virtual IP (VIP) addresses. To verify that the client network is available via both client switches, you can use the command:
cat /proc/net/bonding/bondeth0
This command displays information about the bondeth0 interface, which is used for the client network on Exadata X9M-2 Database Server2. You can check if both interfaces (eth0 and eth1) are active and connected to different switches3.

質問 # 39
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

• A. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
• B. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
• C. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
• D. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.

正解：A、C

解説：
Oracle Exadata Deployment Assistant (OEDA) enables customers to deploy Oracle Exadata Database Machine in virtualized environments and it support both bare metal and virtual machine deployment in an Exadata X9M Quarter Rack.
OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack, and it sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], OEDA deployment steps include setup, configure, deploy, and manage. The number of VMs in an Exadata rack is limited by the available resources in the rack, such as CPU, Memory, and Storage.

質問 # 40
Which two steps concise the path used to communicate with Enterprise Manager from an Exadata Database Machine?

• A. SNMP traps for alerts are sent by the storage server RS process to the Enterprise Manager agent.
• B. SNM? traps for alerts are sent by the storage server ILOM to the Enterprise Manager agent.
• C. SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.
• D. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.
• E. SNMP traps for alerts are sent by the storage server RS process to the storage server ILOM.
• F. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.
• G. SNMP traps for alerts are sent by the storage server ILOM to the storage server is process.

正解：B、C

解説：
In an Exadata environment, the path of communication for SNMP traps involves:
Management Server (MS) Process to EM Agent: Alerts related to the storage server are generated by the MS process, which then forwards SNMP traps directly to the Enterprise Manager agent, allowing centralized monitoring and alert management.
ILOM to EM Agent: The ILOM on each Exadata storage server can independently send SNMP traps to the EM agent, providing additional hardware-level monitoring and alerting capabilities .
These pathways ensure that alerts from both hardware and software layers reach Enterprise Manager efficiently, supporting proactive management and rapid response to system issues.

質問 # 41
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. 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.
• 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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

正解：B、D

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

• A. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• B. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• 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 exachk and resolve only WARNINGS that you have not seen before.
• E. Run the appropriate patchmgr preqequisite check step for each component being updated.
• F. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.

正解：B、C、E、F

質問 # 43
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 cannot proceed until two power feeds are available per PDU.
• C. The installation can go ahead, no change is required.
• 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.

正解：B

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

質問 # 44
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

• A. the failure of physical disk 1
• B. the failure of physical disk 0 and 11
• C. corruption in the / (root) filesystem
• D. the failure of both physical M.2 disks
• E. moving all disks from one cell to another as part of a chassis-level component failure
• 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.

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

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

正解：D

解説：
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.
https://forums.oracle.com/ords/apexds/map/tech/apps-infra/discussion/4342715/monitoring-roce-performance

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

• A. ASR Manager must be installed and configured on one of the database servers.
• B. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• 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. Configuring ASR is mandatory for all Database Machine assets.
• F. ASR communicates with Oracle support services using HTTPS.

正解：B、C

解説：
D) ASR can upload configuration metadata to support problem resolution1.
E) 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

質問 # 47
......

Oracle Exadata Database Machineは、高性能、スケーラブル、セキュアなデータベースソリューションを提供するために特別に設計された強力なハードウェアおよびソフトウェアソリューションです。このマシンは、Oracle DatabaseおよびOracle Exadataテクノロジーの組み合わせに基づいて構築され、データベース管理のための完全で統合されたソリューションを提供するように設計されています。Oracle Exadata Database Machineは、高いパフォーマンスとスケーラビリティで知られており、迅速かつ信頼性の高いデータベース処理が必要な組織にとって人気のある選択肢となっています。

 

最新100%合格率保証付きの素晴らしい1z1-902試験問題PDF：https://jp.fast2test.com/1z1-902-premium-file.html

検証済みの1z1-902問題集87格別な問題：https://drive.google.com/open?id=1FhkD29THtXzvjQhNuIm8YkG8sIerq40m