[2024年08月06日]1Z0-902試験問題集、1Z0-902練習テスト問題 [Q36-Q60]

[2024年08月06日]1Z0-902試験問題集、1Z0-902練習テスト問題

無料で使える1Z0-902学習ガイド試験問題と解答

Oracle 1z1-902 認定試験は、Oracle Exadata Database Machine X8M の実装に関連する幅広いトピックをカバーしています。Exadataデータベースマシンのハードウェアおよびソフトウェアの設定、Exadataストレージサーバーの実装、データベースのパフォーマンス最適化、およびExadataデータベースマシンのセキュリティ管理など、様々なトピックが含まれます。

Oracle Exadata Database Machine X8Mは、ハードウェアとソフトウェアコンポーネントを組み合わせて完全なデータベースソリューションを提供する高性能でスケーラブルなデータベースプラットフォームです。大規模なデータ処理と分析のワークロードを処理するように設計されており、あらゆるサイズの組織でミッションクリティカルなアプリケーションを強化するために使用されています。 1Z0-902試験は、ExadataデータベースマシンX8Mに関する候補者の知識と、プラットフォームを実装、管理、トラブルシューティングする能力をテストする挑戦的な認証試験です。

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

正解：C

解説：
According to Oracle's documentation1, to set a threshold for a metric on a database server, you need to use the create threshold command with the appropriate parameters. The set threshold command is used to modify an existing threshold2.
Therefore, the command that you should use to generate alerts for such an event is:
dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server1

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

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

正解：A、B

解説：
The AWR report has two sections that show statistics for X9M Persistent Memory Cache: the PMEM Cache section within Memory Statistics and the PMEM Cache section within Exadata Smart Statistics. Both of these sections provide detailed information about the read and write hits and misses, as well as the total capacity and utilization of the PMEM cache. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 515)

質問 # 38
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, 2, 1, 8, 4, 5
B. 6, 8, 3, 4, 2, 1
C. 6, 1, 2, 7, 5, 8
D. 6, 3, 1, 9, 7, 8

正解：A

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

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

正解：E、G

解説：
In order to monitor all components of this multirack configuration, Enterprise Manager agents must be deployed on at least two storage servers in both racks and all database servers in both racks. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book [1], in which it states "To monitor all components of the multirack configuration, you must deploy agents on all database servers and at least two storage servers in each rack" (page 6-15).

質問 # 40
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

A. The incline of any access route ramp must be less than or equal to 6 degrees.
B. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
D. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
E. 914mm of space required above the rack height is required for maintenance access.
F. Oracle Exadata Rack may only be installed on raised floor environments.

正解：F

解説：
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 Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)

質問 # 41
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?

A. 0
B. 10, 8, 9, 11
C. 10, 8, 2, 5
D. 7,6,9,11
E. 4,1, 6, 9

正解：E

質問 # 42
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. ifconfig -a legrep "re0| re1"
B. cat /proc/net/bonding/bondeth0
C. netstat -rn
D. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all

正解：B

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

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

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

正解：B、C、E

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

質問 # 44
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. the RDMA over Converged Ethernet (RoCE) switches
B. the storage server ILOM
C. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
D. Oracle clusterware on the database server
E. ASM instances
F. the Power Distribution Units (PDUs)

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

質問 # 45
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 Enterprise Manager
E. alert logs for the ASM instances

正解：B、C

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

解説：
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/new-features-exadata-system-software-release-23.html

質問 # 47
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. OS I/O metrics using Enterprise Manager host pages for the storage servers
B. OS I/O metrics using OS tools such as iostat on the storage servers
C. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
D. 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
E. OS I/O metrics using OS tools such as iostat on the database servers

正解：C、E

質問 # 48
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. OS I/O metrics using Enterprise Manager host pages for the storage servers
B. OS I/O metrics using OS tools such as iostat on the storage servers
C. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
D. 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
E. OS I/O metrics using OS tools such as iostat on the database servers

正解：C、D

解説：
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 *plus. These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.

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

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

正解：C、F

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

質問 # 50
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?

A. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
B. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
C. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
D. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
E. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.

正解：D

解説：
Oracle KVM Guest, Oracle Enterprise Manager Agent (OMA), RDBMS instance, Automatic Diagnostic Repository Command Interpreter (ADRCI), CELLCLI, diskmon, and Restart Server (RS) can all run on the database servers. The Cell Server (CELLSRV) and Management Server (MS) can both run on the Exadata storage servers. Specific instructions for installing and configuring these software components can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_software_components.html.

質問 # 51
You are updating your Exadata X9M-2 Elastic Database Machine with 6 database servers and 12 High Capacity Storage Servers. You will be using patchmgr to apply updates across the entire machine while still maintaining database availability.
Assuming you are driving patchmgr from an external server, which statement is true about the execution phase?

A. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
B. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
C. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
D. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.

正解：B

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

正解：B、E

解説：
When multiple databases share space on the storage servers in an unpartitioned storage grid, two Exadata security features can be configured to control which databases can access which griddisks.
Exadata storage realms using ASM-scoped security mode: This feature allows you to create storage realms and assign them to specific databases. This allows you to control which databases have access to which griddisks. The ASM-scoped security mode applies to all griddisks within an ASM disk group, which means that all griddisks in a disk group will be accessible only to the databases that belong to the assigned storage realm.
File permissions on the griddisks in each storage server: This feature allows you to configure file permissions on the griddisks at the storage server level. You can assign specific permissions to specific users or groups, allowing you to control which databases can access which griddisks.

質問 # 53
Which are two correct statements about backing up Exadata Database Machine?

A. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
B. For high availability, system area can be on the first two disks and M.2 devices.
C. The M.2 disk is hot pluggable and can be replaced when the power is on, but you will have to restore the system data manually.
D. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
E. Backing up Exadata Storage Server Software is critical for restoration.

正解：D、E

解説：
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 4: Oracle Clusterware [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 8: Oracle Exadata Storage Server Software [3] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 9: Oracle Exadata Storage Server Infrastructure
https://www.oracle.com/technetwork/database/availability/exadata-backup-recovery-bp-3633870.pdf

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

A. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
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. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
D. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.

正解：D

質問 # 55
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

A. The incline of any access route ramp must be less than or equal to 6 degrees.
B. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
D. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
E. 914mm of space required above the rack height is required for maintenance access.
F. Oracle Exadata Rack may only be installed on raised floor environments.

正解：F

質問 # 56
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. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
C. # xfs_growfs /uOl +20G
D. # resize2fs +20G /dev/VGExaDb/LVDbOral

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

質問 # 57
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?

A. 1 consisting of all 96 griddisks
B. 96 consisting of one griddisk each
C. 7 consisting of 12 griddisks each
D. 0 because the new griddisks will be added to the existing faiigroups
E. 12 consisting of seven griddisks each

正解：E

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

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

正解：B

解説：
According to 1, Exadata X9M-2 Database Servers are based on Intel Xeon Platinum 8368Y processors with 32 cores and 768 GB of DRAM memory per server. This memory can be expanded up to 1.5 TB per server by adding 24 x 32 GB DIMMs. The DRAM memory is used for buffer cache, PGA, and other database purposes1. Exadata X9M-2 Database Servers also have 25.6 TB of Persistent Memory Acceleration (PMEM) per server, which is used for log writes and columnar data caching1. PMEM is a new type of memory that combines the speed of DRAM with the persistence of flash2. Exadata X9M-2 Database Servers are designed to run Oracle Database workloads with high performance, scalability, and reliability2

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

正解：D

質問 # 60
......

1Z0-902試験問題集、1Z0-902練習テスト問題：https://www.jpntest.com/shiken/1Z0-902-mondaishu

検証済み1Z0-902問題集PDF資料 [2024年更新]：https://drive.google.com/open?id=1v7ZOVlZ_KPOQtPe4kQtY5UUxQIdzJA3y