[2023年更新]1z1-902.PDFの問題回答PDFサンプル問題現実的 [Q29-Q46]

[2023年更新]1z1-902.PDFの問題回答PDFサンプル問題現実的

Oracle 1z1-902問題集PDFはまもなく最高のベストスコア

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

A. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
B. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
C. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
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.

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

正解：E

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

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

正解：A、B

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

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

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

正解：F、G

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

質問 # 33
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. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
C. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
D. Failed storage server updates are automatically rolled back to a previous release.
E. Failed database server updates are rolled back to a working state on a previous release automatically.
F. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.

正解：C、D

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

質問 # 34
Which three statements are true about the CELLCLI command?

A. It requires root privileges to create CELLDISKS and GRIDDISKS.
B. It can be executed using the DCLI utility.
C. It has command-line history.
D. It can be executed on storage servers.
E. It can execute commands on multiple storage servers in parallel.

正解：B、C、E

解説：
The CELLCLI utility is a command line interface to Exadata that enables the execution of commands across multiple storage servers in parallel. It also has command-line history, so users can easily recall previously entered commands. Furthermore, the CELLCLI utility can be executed using the DCLI utility, which provides a convenient way to execute commands on multiple storage servers simultaneously.
However, CELLCLI does not require root privileges to create CELLDISKS and GRIDDISKS, and it cannot be executed on storage servers. This is because CELLCLI is used to manage the Exadata database machine from the database server [1]. For more information about CELLCLI, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

質問 # 35
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. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
D. 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

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

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

質問 # 37
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. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
D. 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

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

正解：A

解説：
According to Oracle documentation12, patchmgr is the utility used to update software for Exadata infrastructure components. It can apply patches in a rolling or non-rolling manner depending on the argument and input file provided.

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

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

正解：A、C

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

A. Backing up Exadata Storage Server Software is critical for restoration.
B. For high availability, system area can be on the first two disks and M.2 devices.
C. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
D. 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.
E. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.

正解：D、E

質問 # 42
An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical disk?

A. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
B. Create a new celldisk and new griddisks on the replaced physical disk.
C. Replace the failed physical disk.
D. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
E. Rebalance the data on the effected griddisks before performing a manual drop command.
F. Add the griddisks back into the ASM diskgroup they used to be a member of.

正解：A、C

解説：
Once the physical disk has been replaced, you will need to create a new celldisk and griddisks on the replaced physical disk. After the griddisks have been dropped from the associated ASM diskgroups, you can then add the griddisks back into the ASM diskgroup they used to be a member of and rebalance the data on the effected griddisks. Finally, you should verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

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

正解：C、E、F

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

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

正解：C、E、F

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

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

質問 # 46
......

Oracle Exadata Database Machine X8Mは、現代ビジネスの要求に応えるために設計された高性能でスケーラブルなデータベースシステムです。Oracleデータベースワークロードに特化したハードウェアとソフトウェアを組み合わせ、Oracle Cloud Infrastructureでの使用に最適化されています。Oracle 1z1-902認定を取得することで、専門家はこの強力なデータベースシステムを実装および管理する能力を証明し、この分野の専門知識を認識されます。

1z1-902試験問題集（2023年最新のPDF問題集)現実的な1z1-902テストエンジン：https://jp.fast2test.com/1z1-902-premium-file.html

Oracle Engineered Systems 1z1-902試験と認証テストエンジン：https://drive.google.com/open?id=1FhkD29THtXzvjQhNuIm8YkG8sIerq40m

関するブログ

もっと

Oracle認証 1z1-902試験問題集

弊社を連絡する

我々は１２時間以内ですべてのお問い合わせを答えます。

我々の働いている時間： ( GMT 0:00-15:00 )
月曜日から土曜日まで

サポート： 現在連絡

English Deutsch 繁体中文 한국어

[2023年更新]1z1-902.PDFの問題回答PDFサンプル問題現実的 [Q29-Q46]

関するブログ

弊社を連絡する

フレンドリーリンク

トップ試験