1z1-902事前に試験練習テストで使おう（最新60問題)
有効な1z1-902試験解答PDF一年無料更新
Oracle 1z1-902 (Oracle Exadata Database Machine X8M Implementation Essentials) 資格試験は、Oracle Exadata Database Machineの導入と保守における専門知識を示したいデータベース管理者向けに設計された専門的なテストです。この試験は、Oracleデータベースアーキテクチャに強い知識を持ち、Oracle Exadata Database Machineを展開および管理するためのベストプラクティスに精通しているプロフェッショナル向けに設計されています。この試験に合格することは、キャリアを進め、この専門分野における専門知識を示したいデータベース管理者にとって貴重な資格です。
Oracle 1Z0-902認定試験は、Oracle Exadata Database Machine X8Mに関連するさまざまなトピックについてカバーしています。これには、システムのアーキテクチャとコンポーネントの理解、ストレージ要件の構成と管理、データベース環境のセキュリティ、システムの監視とトラブルシューティングなどが含まれます。候補者は、バックアップおよびリカバリソリューションの実装能力、およびOracle Exadataのパフォーマンスチューニング機能の理解もテストされます。
質問 # 32
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
正解：A
解説：
This SQL statement is adding the new griddisks to the existing diskgroup "DATA" and creating one new failgroup, consisting of all 96 griddisks. The "REBALANCE POWER 512" option tells the system to perform a rebalance operation with a power of 512. It means the system distributes the data evenly across all the disks in the diskgroup using a power of 512.
質問 # 33
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 in Oracle Virtual Machine with required hardware.
- D. Provide individual x86 64-Bit gateway hardware.
- E. Install on Exadata Engineered System.
正解：A、B、D
解説：
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 three statements are true about the CELLCLI command?
- A. It has command-line history.
- B. It can be executed using the DCLI utility.
- C. It can be executed on storage servers.
- D. It can execute commands on multiple storage servers in parallel.
- E. It requires root privileges to create CELLDISKS and GRIDDISKS.
正解：A、B、D
解説：
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
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. Backing up Exadata Storage Server Software is critical for restoration.
- 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. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
正解：A、D
質問 # 36
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. Wait for a blue light to appear on the disk if the rebalance operation is running.
- B. Wait for the email of the failure that Exadata or Enterprise Manager will send.
E Download and run the latest exadiag tool. - C. Ask the system administrator to replace the broken disk with a spare.
- D. Call Oracle Support and make an appointment so that the drive can be replaced.
- E. Check the database to see if any rebalance operations are active.
正解：C
質問 # 37
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?
- A. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
- B. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
- 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.
質問 # 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, 3, 1, 9, 7, 8
- B. 6, 2, 1, 8, 4, 5
- C. 6, 1, 2, 7, 5, 8
- D. 6, 8, 3, 4, 2, 1
正解：A
質問 # 39
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 6.9
- B. Oracle Linux 7.5
- C. Oracle Linux 7.7
- D. Oracle Linux 8.0
正解：B
質問 # 40
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Manually created Quarantine
- B. Disk Region Quarantine
- C. Database Quarantine
- D. Cell Offload Quarantine
- E. SQL Plan Quarantine
正解：D、E
解説：
A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-software-introduction.html
質問 # 41
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 and execute the script on all storage servers using the dcli command.
- B. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- C. Copy and execute the script on all storage servers using the EXACLI command.
- D. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
- E. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
正解：A
質問 # 42
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. Failed database server updates are rolled back to a working state on a previous release automatically.
- C. Failed storage server updates are automatically rolled back to a previous release.
- D. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- E. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- F. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
正解：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.
質問 # 43
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. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -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. # /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
正解：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
質問 # 44
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 "create threshold ds_temp comparison='>', critical=30" on each database server
- C. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- D. dbmcli -e "set alert ds_temp> 30" on each database server
正解：B
解説：
The correct command to generate alerts for an event when the temperature of the database servers in an Exadata Full Rack exceeds 30C is "dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server". The dbmcli is the command-line interface for the Oracle Database Management Agent (DMA), which allows you to perform various management tasks on the Exadata servers. This command creates a threshold for the ds_temp metric with a comparison operator of ">" (greater than), and a critical value of 30. The threshold is set on all database servers in the Exadata Full Rack, so when the server temperature exceeds 30C, an alert will be generated.
質問 # 45
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- B. installing an alternative package manager
- C. upgrading the Storage Server software package using rpm
- D. configuring secure shell user equivalency for the cellmonitor user
- E. changing the root password
正解：A、C
解説：
Exadata Database Machine is a preconfigured and optimized for database workloads. The storage servers in an Exadata Database Machine are used to store database data, and support activities such as upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure and upgrading the Storage Server software package using rpm. These activities are related to maintain the storage servers performance and security. Changing the root password, installing an alternative package manager, and configuring secure shell user equivalency for the cellmonitor user are activities that can be performed on any Linux machine, but they are not specific to Exadata Database Machine.
質問 # 46
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Run exachk and resolve only WARNINGS that you have not seen before.
- B. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- C. Run the appropriate patchmgr preqequisite check step for each component being updated.
- D. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- E. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- F. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
正解：A、B、C、D
解説：
According to Oracle.com documents or resources, the four actions that you should take before proceeding with applying updates to your Exadata Database Machine are:
A) Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
B) Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
C) Run exachk and resolve only WARNINGS that you have not seen before3.
D) Run the appropriate patchmgr preqequisite check step for each component being updated3.
質問 # 47
......
Oracle Exadata Database Machine X8M Implementation Essentials無料更新認定サンプル問題：https://jp.fast2test.com/1z1-902-premium-file.html
試験本場前にトレンドなOracle 1z1-902のPDF問題集を試そう：https://drive.google.com/open?id=1FhkD29THtXzvjQhNuIm8YkG8sIerq40m