100% Pass Top-selling 1z1-902 Exams - New 2024 Oracle Pratice Exam
Oracle Engineered Systems Dumps 1z1-902 Exam for Full Questions - Exam Study Guide
NEW QUESTION # 16
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 cell attributes name, deviceName, diskType, physicalFirmware
- C. list celldisk attributes name, deviceName, diskType, physicalFirmware
- D. list devices attributes name, deviceName, diskType, physicalFirmware
Answer: A
Explanation:
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).
NEW QUESTION # 17
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 cell attributes name, deviceName, diskType, physicalFirmware
- C. list celldisk attributes name, deviceName, diskType, physicalFirmware
- D. list devices attributes name, deviceName, diskType, physicalFirmware
Answer: C
NEW QUESTION # 18
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 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 query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- D. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
Answer: B,C
Explanation:
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).
NEW QUESTION # 19
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?
- A. The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.
- B. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
- C. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
- D. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
- E. The sparse_<DBM_NAME> diskgroup is created automatically.
Answer: C,D
Explanation:
According to the Oracle Exadata Database Machine Technical Architecture1, the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers includes two ASM disk groups: DATA_<DBM_Name> and RECO_<DBM_NAME>. These disk groups are built on hard disks and flash disks inside the Exadata Storage Servers1.
The correct statements about this configuration are:
Option D: There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes. Storage indexes are a feature of Exadata Storage Software that can improve query performance by avoiding unnecessary I/O operations. Storage indexes use a small amount of flash memory to store metadata about data blocks stored on disk1.
Option E: There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs. Exadata Smart Flash Logs are another feature of Exadata Storage Software that can improve database performance by using flash memory as an extension of the database redo log buffer. This can reduce latency and increase throughput for redo log writes1.
NEW QUESTION # 20
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. 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.
- B. 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.
- C. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- D. 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.
Answer: A,C
NEW QUESTION # 21
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?
- A. corruption in the / (root) filesystem
- B. the failure of both physical M.2 disks
- C. corruption in a normal or high redundancy ASM diskgroup
- D. moving all disks from one cell to another as part of a chassis-level component failure
- E. accidental loss of all data from all griddisks in a storage server
- F. the failure of physical disk 1
- G. the failure of physical disk 0 and 11
Answer: A,G
Explanation:
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.
NEW QUESTION # 22
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. # xfs_growfs /uOl +20G
- B. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
- C. # resize2fs +20G /dev/VGExaDb/LVDbOral
- D. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral
Answer: B
NEW QUESTION # 23
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 OS tools such as iostat on the database 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 Enterprise Manager host pages for the storage servers
Answer: A,C
NEW QUESTION # 24
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. Add the griddisks back into the ASM diskgroup they used to be a member of.
- B. Rebalance the data on the effected griddisks before performing a manual drop command.
- C. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- D. Replace the failed physical disk.
- E. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- F. Create a new celldisk and new griddisks on the replaced physical disk.
Answer: D,E
Explanation:
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.
NEW QUESTION # 25
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?
- A. 1, 8, 7, 3 and 6
- B. 2, 7, 8, and 6
- C. 4, 7, 8, 3, and 6
- D. 2, 8, 7, 3, and 6
- E. 5, 8, 7, and 6
Answer: A
Explanation:
In order to power off an Exadata Database Machine in an orderly fashion, the commands should be executed in the following order: 1) Execute "crscti stop cluster -all" as the grid user from one database server; 2) Execute "shutdown -h now" on all database servers; 3) Power off all network switches; 4) Execute "shutdown -h now" on all Exadata storage servers; and 5) Power off the rack using the power switches on the PDUs. This sequence of commands ensures that all services running on the Exadata Database Machine are in a clean state before powering off the system. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 543)
NEW QUESTION # 26
Which statement is true about the patching features provided in Platinum Services?
- A. The rolling and complete down time approaches are two options to patching.
- B. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
- C. Patching is done automatically during business hours.
- D. Patching services are available for the full software stack up to twice per year.
Answer: B
NEW QUESTION # 27
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Install on Oracle Database Appliance.
- B. Provide individual x86 64-Bit gateway hardware.
- C. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- D. Install in Oracle Virtual Machine with required hardware.
- E. Install on Exadata Engineered System.
Answer: B,C,E
Explanation:
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.
NEW QUESTION # 28
Which three statements are true about the CELLCLI command?
- A. It can be executed on storage servers.
- B. It can be executed using the DCLI utility.
- C. It can execute commands on multiple storage servers in parallel.
- D. It has command-line history.
- E. It requires root privileges to create CELLDISKS and GRIDDISKS.
Answer: A,B,D
Explanation:
The statements that are true about the CellCLI command are:
It has command-line history . According to 1, you can use the up and down arrow keys to scroll through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a previous command by entering part of it .
It can be executed on storage servers . According to 1, you can invoke CellCLI by logging in to the Exadata cell as cellmonitor , celladmin , or root user and typing "cellcli" . Within CellCLI , you can perform various management and monitoring tasks for the cell134.
It can be executed using the DCLI utility . According to 5, DCLI (distributed CLI) is another utility that can be used to execute scripts and commands across multiple storage cells from a single interface. You can use DCLI to run CellCLI commands on multiple cells at once54.
NEW QUESTION # 29
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 CALIBRATE command on the storage server after logging in as the root user
- B. hardware monitoring using the storage server ILOM
- C. using the CELLCLI list LUN DETAIL command as the celladmin user
- D. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
Answer: B,D
Explanation:
The CELLCLI CALIBRATE command can be used to check the health of all flash cards in the storage server, and it should be run after logging in as the celladmin user. The hardware monitoring using the storage server ILOM should also be used to check for errors and other potential issues with the flash cards. The CELLCLI list LUN DETAIL command should not be used to identify a damaged or failing flash card, since it will not provide any information about the health of the flash card.
NEW QUESTION # 30
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 databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- C. Multiple Databases on a cluster
- D. A single database with one or more schema per application
- E. Bare Metal deployment with one database per database server
- F. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
Answer: A,B,C
Explanation:
A Exadata supports multiple pluggable databases in one or more container databases, which enables database consolidation by allowing multiple databases to be consolidated into a single container database. This can be deployed on a Virtual Machine or Bare Metal cluster.
D Multiple databases spanning a Bare Metal and Virtual Machine cluster provide resource isolation and consolidation concurrently. It allows multiple databases to be deployed on both Bare Metal and Virtual Machine clusters, providing isolation and consolidation at the same time.
E Multiple Databases on a cluster allows multiple databases to be deployed on a single cluster, which enables consolidation of databases by reducing the number of clusters required.
NEW QUESTION # 31
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- B. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
- C. PMEM Pool Misses in the Exadata Outlier Summary
- D. PMEM Cache section within Memory Statistics
- E. PMEM Cache section within Exadata Smart Statistics
Answer: D
NEW QUESTION # 32
Which two statements are true about enabling write-back flash cache?
- A. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
- B. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
- C. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
- D. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
- E. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
Answer: C,D
NEW QUESTION # 33
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 7.5
- B. Oracle Linux 7.7
- C. Oracle Linux 8.0
- D. Oracle Linux 7.9
Answer: C
Explanation:
RoCE, or Remote Direct Memory Access over Converged Ethernet, is a high-speed networking technology that allows data to be transferred between servers, storage, and other devices over Ethernet. Persistent Memory is a form of non-volatile memory that can be used to store data without losing it when power is lost.
Oracle Linux 8.0 supports both RoCE and Persistent Memory, allowing Exadata systems to leverage the benefits of both technologies. For more information on Oracle Linux 8.0 and its features, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
NEW QUESTION # 34
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. 7,6,9,11
- B. 10, 8, 9, 11
- C. 10, 8, 2, 5
- D. 4,1, 6, 9
- E. 0
Answer: B
Explanation:
The correct order of steps is 10, 8, 9, 11. The 10th step is to use the drop down to add Exadata X9M Database Servers, the 8th step is to use the drop down to add Exadata X9M EF Storage Servers, the 9th step is to use "Add Equipment" to add the ZFS Storage Controllers, and the 11th step is to use "Add Equipment" to add the ZFS Storage Trays. These steps are referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/configuring-exadata.html
NEW QUESTION # 35
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Install on Oracle Database Appliance.
- B. Install on Exadata Engineered System.
- C. Provide individual x86 64-Bit gateway hardware.
- D. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- E. Install in Oracle Virtual Machine with required hardware.
Answer: A,C,D
Explanation:
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
NEW QUESTION # 36
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 768GB
- B. 384GB
- C. 1536GB
- D. 1024GB
- E. 2048GB
- F. 512GB
Answer: C
Explanation:
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
NEW QUESTION # 37
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 an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
- C. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
- D. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
- E. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
- F. to the CELLADMIN account using cellcli interactively on each storage server
Answer: B,D,F
Explanation:
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
NEW QUESTION # 38
......
Authentic Best resources for 1z1-902 Online Practice Exam: https://www.testvalid.com/1z1-902-exam-collection.html
1z1-902 Test Engine Practice Exam: https://drive.google.com/open?id=1__2pFtDZtxnMEb70nusZy576NrWuooYq