• ホーム
  • ブログ
  • [Q26-Q50] PassTest 1Z0-902リアル試験問題解答は更新された[2024年01月16日]

[Q26-Q50] PassTest 1Z0-902リアル試験問題解答は更新された[2024年01月16日]

Share

PassTest 1Z0-902リアル試験問題解答は更新された[2024年01月16日]

お手軽に合格させる 最新Oracle 1Z0-902問題集には60問があります


Oracle 1z1-902試験は、Oracle Exadata Database Machine X8Mに関連するさまざまなトピックをカバーする包括的なテストです。システムアーキテクチャ、インストールと設定、管理と監視、パフォーマンスチューニング、バックアップとリカバリ、セキュリティに関する知識をテストされます。試験は60の多肢選択問題から構成され、受験者は2時間で完了する必要があります。


Oracle 1Z0-902は、Exadata Database Machine X8Mを最高水準で実装および運用するスキルを検証したいプロフェッショナルを対象として設計されています。試験に合格することにより、マシンのインストール、ソフトウェアの設定、バックアップ、パフォーマンス監視などの重要なタスクを実行できることが証明されます。

 

質問 # 26
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. Extended
  • B. External
  • C. Sparse
  • D. High
  • E. Normal

正解：E

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


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

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

正解：B、D


質問 # 28
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

  • A. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod
    database instances using SQL *p1us
  • B. OS I/O metrics using OS tools such as iostat on the database servers
  • C. OS I/O metrics using Enterprise Manager host pages for the storage servers
  • D. OS I/O metrics using OS tools such as iostat on the storage servers
  • E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

正解：B、E


質問 # 29
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

  • A. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us
  • B. OS I/O metrics using OS tools such as iostat on the database servers
  • C. OS I/O metrics using Enterprise Manager host pages for the storage servers
  • D. OS I/O metrics using OS tools such as iostat on the storage servers
  • E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

正解：A、E

解説：
According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.
I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us . These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.


質問 # 30
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 Storage 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 Database server and install the MS APEX application.

正解：A

解説：
To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e "ALTER CELL ENABLE REST" and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).


質問 # 31
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 root user
  • C. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
  • D. hardware monitoring using the storage server ILOM

正解：A、C


質問 # 32
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. Exadata storage realms using database-scoped security mode
  • B. File permissions on the griddisks in each database server
  • C. File permissions on the griddisks in each storage server
  • D. Exadata storage realms using ASM-scoped security mode
  • E. Using EXADCLI instead of CELLCLI to create the griddisks

正解：C、E


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

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

正解：B、C、E

解説：
According to Oracle's documentation1, the customer options for hosting the Platinum Services Advanced Support Gateway are:
Provide individual x86 64-Bit gateway hardware1
Purchase the recommended x86 64-Bit gateway hardware from Oracle1
Install on Oracle Database Appliance2


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

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

正解：A、B


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

  • A. the failure of both physical M.2 disks
  • B. accidental loss of all data from all griddisks in a storage server
  • C. corruption in a normal or high redundancy ASM diskgroup
  • D. corruption in the / (root) filesystem
  • E. moving all disks from one cell to another as part of a chassis-level component failure
  • F. the failure of physical disk 1
  • G. the failure of physical disk 0 and 11

正解：A、D

解説：
The two valid reasons are:
corruption in the / (root) filesystem . According to 1, this is one of the scenarios that requires a storage server rescue procedure , because it prevents the storage server from booting up normally . The rescue procedure will re-image the root filesystem with a fresh copy of the operating system and restore the configuration files from a backup1.
the failure of both physical M.2 disks . According to 2, each Exadata Storage Server X9M-2 has two physical M.2 disks that store the operating system and configuration files for the storage server . If both M.2 disks fail , then the storage server cannot boot up or function properly . The rescue procedure will replace the failed M.2 disks with new ones and re-image them with the operating system and configuration files2.


質問 # 36
Which three of the following options are available for database consolidation on Exadata?

  • A. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
  • B. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
  • C. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
  • D. A single database with one or more schema per application
  • E. Bare Metal deployment with one database per database server
  • F. Multiple Databases on a cluster

正解：A、D、F

解説：
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
A) Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
C) A single database with one or more schema per application12.
E) Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how


質問 # 37
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

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

正解：B

解説：
The steps and the order in which they should be executed to create an ACFS Filesystem for use as a staging area for data loads are:
asmcrad volcreate -G data -s 1024G acfs_dataload_vol : This command creates a new volume in the data diskgroup, with a size of 1024 GB, and named acfs_dataload_vol.
asmcmd vol info -G data acfs_dataload_vol | grep Device: This command will show the device name of the newly created volume
/usr/sbin/mkfs -t acfs /dev/asm/ac:fs_dataload_vol-123: This command creates a new ACFS filesystem on the volume created in step 1 sudo /u01/app/19.0.0.0/grid/bin/srvctl start filesystem -device /dev/asn/acfs_dataload_vol-123: This command starts the filesystem created in step 3 sudo chovn -R oracle:dba /mnt/acfs_dataload_vol: This command changes the ownership of the /mnt/acfs_dataload_vol to the oracle:dba user.
/sbin/acfsutil snap create -v data_load /mnt/acfs_dataload_vol: This command creates a snapshot of the filesystem to be used as a staging area.
acfsutil size +2S0G -d /dev/asm/acfs_dataload_vol-123 /mnt/acfs_dataload_vol/ : This command increases the size of the filesystem by 2GB
/u01/app/19-G.O-Q7grid/bin/srvctl add filesystem -device /dev/asm/acfs_dataload_vol-


質問 # 38
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. The rolling and complete down time approaches are two options to patching.
  • C. Patching services are available for the full software stack up to twice per year.
  • D. Patching is done automatically during business hours.

正解：A


質問 # 39
You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?

  • A. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
  • B. list devices attributes name, deviceName, diskType, physicalFirmware
  • C. list cell attributes name, deviceName, diskType, physicalFirmware
  • D. list celldisk attributes name, deviceName, diskType, physicalFirmware

正解：A

解説：
This command will display the name, deviceName, diskType and physicalFirmware attributes of the physicaldisks in a storage server, as explained in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 85).


質問 # 40
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

  • A. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
  • B. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
  • C. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.
  • D. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.

正解：C


質問 # 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. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
  • B. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
  • 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 Database server and install the MS APEX application.

正解：C

解説：
The MS process on Exadata storage servers is natively endowed with REST services and these services are enabled by default. However, it is important to create appropriate roles and users to ensure security when accessing these services. This way, it is possible to disable ssh access to the storage servers, and still enable REST access to the MS process. It's not necessary to install Oracle Rest Data Services on each Database or Storage server or install the MS APEX application, the MS process on the storage servers already have REST services by default.


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

正解：A、B

解説：
The two actions that are not appropriate for monitoring how a large production table is accessed in order to leverage the benefits of the Exadata Platform are A) querying VSSYSTEMEVENTS and filtering for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table; and B) querying v$segmentstatistics and filtering for the Object ID of your table from dbaobjects and the the column STATISTICNAME='optimized physical reads'. Instead, you should query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table (C), or 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 (D). These two methods are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Monitoring the Exadata Database Machine).


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

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

正解：D、E


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

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

正解：F


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

正解：D


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

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

正解：B、D

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


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

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

正解：B、C、D

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


質問 # 48
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 only one database server in both racks
  • B. on all database servers in both racks and one storage server in each rack
  • C. on all database servers in the second rack
  • D. on all database servers in the first rack
  • E. on at least two storage servers in both racks
  • F. on all storage servers in both racks
  • G. on all database servers and at least two storage servers in both racks

正解：D、F


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

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

正解：B

解説：
Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk. This helps to further reduce redo log write latency by utilizing the speed and low latency of Persistent Memory, along with the Remote Direct Memory Access (RDMA) protocol, to commit changes to disk faster. This allows the system to quickly commit changes to disk, resulting in improved performance and reduced latency.


質問 # 50
......

最新の1Z0-902学習ガイド2024年最新の- 提供するのはテストエンジンとPDF：https://www.passtest.jp/Oracle/1Z0-902-shiken.html

最新版を今すぐ試そう1Z0-902練習テスト問題解答：https://drive.google.com/open?id=1cGph66FBidb25JV4WgeDBdTwU0OVR7tS

関するブログ

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