[Jul 17, 2023] Fully Updated Oracle Engineered Systems (1z1-902) Certification Sample Questions [Q19-Q43]

[Jul 17, 2023] Fully Updated Oracle Engineered Systems (1z1-902) Certification Sample Questions

Latest Oracle 1z1-902 Real Exam Dumps PDF

NEW QUESTION # 19
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, 8, 3, 4, 2, 1
• D. 6, 1, 2, 7, 5, 8

Answer: B

Explanation:
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-

NEW QUESTION # 20
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. Replace the failed physical disk.
• B. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
• C. Create a new celldisk and new griddisks on the replaced physical disk.
• D. Rebalance the data on the effected griddisks before performing a manual drop command.
• E. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
• F. Add the griddisks back into the ASM diskgroup they used to be a member of.

Answer: A,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 # 21
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

• A. Cisco management switch
• B. RoCE network interface cards in the database servers
• C. RoCE network interface cards in the storage servers
• D. power distribution units
• E. Cisco RDMA over Converged Ethernet (RoCE) switches
• F. power supplies in the database servers
• G. fans in the storage servers

Answer: A,C,E,F

NEW QUESTION # 22
What are two recommended configuration best practices for backup and recovery on Exadata?

• A. 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.
• 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. 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.
• D. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

Answer: A,B

Explanation:
According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
1. 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.
2. 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.

NEW QUESTION # 23
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

• A. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
• B. CellCLI alter GRIDDISK all inactive on the affected storage server
• C. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
• D. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
• E. shutdown -h now' on the affected storage server
• F. 'crsct1 stop cluster -all' on one of the database servers

Answer: B,E

Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB The two commands that must be executed to safely power off the storage server in an Exadata X9M Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage server is completely powered off and no data is lost.
For more information on how to properly power off an Exadata Storage Server, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

NEW QUESTION # 24
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?

• A. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using
  SFP28 transceivers and OM4 fiber cable for client network
• B. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network
• C. 2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network
• D. 2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network

Answer: C,D

NEW QUESTION # 25
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. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 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. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
• D. 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.
• E. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.

Answer: B

Explanation:
Oracle KVM Guest: This is a virtual machine that runs on top of Oracle Linux KVM hypervisor. It can be used to run Oracle Database or other applications on Exadata Database Machine2. Therefore, it runs on the Database Servers.
Oracle Enterprise Manager Agent (OMA): This is a software agent that communicates with Oracle Enterprise Manager Cloud Control and provides monitoring and management capabilities for Exadata Database Machine2. Therefore, it runs on both Database Servers and Storage Servers.
ASM instance: This is an instance of Oracle Automatic Storage Management (ASM), which is a volume manager and a file system for Oracle Database files. It manages disk groups that span across multiple Storage Servers2. Therefore, it runs on the Database Servers.
RDBMS instance: This is an instance of Oracle Database that processes SQL statements and executes transactions. It uses ASM disk groups to store data files, control files, redo log files, etc2. Therefore, it runs on the Database Servers.
Automatic Diagnostic Repository Command Interpreter (ADRCI): This is a command-line tool that enables you to view diagnostic data stored in the Automatic Diagnostic Repository (ADR). ADR is a file-based repository for database diagnostic data such as trace files, alert logs, etc2. Therefore, ADRCI runs on both Database Servers and Storage Servers, depending on where the ADR is located.
CELLCLI: This is a command-line interface that enables you to configure and manage Exadata Storage Server Software. It allows you to perform tasks such as creating disk groups, monitoring cell health, applying patches, etc2. Therefore, it runs on the Storage Servers.
Cell Server(CELLSRV): This is a process that runs on each Storage Server and handles I/O requests from the Database Servers. It implements Exadata Smart Scan , which offloads data-intensive SQL operations from the Database Servers to the Storage Servers2. Therefore, it runs on the Storage Servers.
diskmon: This is a process that monitors the status of disks and flash devices on each Storage Server. It reports disk failures and performs automatic disk reclamation2. Therefore, it runs on the Storage Servers.
Restart Server (RS): This is a process that manages automatic restarts of critical processes such as CELLSRV , MS , or OMA in case of failures. It also handles graceful shutdowns and startups of all processes on each server2. Therefore, it runs on both Database Servers and Storage Servers.
Management Server (MS): This is a process that provides management services for each server such as collecting metrics , logging events , executing commands from CELLCLI , etc2. Therefore, it runs on both Database Servers and Storage Servers

NEW QUESTION # 26
What are two recommended configuration best practices for backup and recovery on Exadata?

• A. 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.
• 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. 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.
• D. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

Answer: A,B

NEW QUESTION # 27
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

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

Answer: A,C,D

Explanation:
The Platinum Services Advanced Support Gateway is a component of Oracle's Platinum Services offering that enables customers to access advanced support features and tools, such as automated problem diagnosis and resolution. Customers have the option to host the Advanced Support Gateway on an Oracle Database Appliance, Oracle Virtual Machine with required hardware, or an Exadata Engineered System. These options allow customers to leverage existing infrastructure and resources to host the gateway, rather than needing to purchase and install new hardware. Providing individual x86 64-Bit gateway hardware or purchase the recommended x86 64-Bit gateway hardware from Oracle are also options but it depends on the customer's infrastructure and resources.

NEW QUESTION # 28
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

• A. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• B. Run the appropriate patchmgr preqequisite check step for each component being updated.
• C. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• 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 exachk and resolve only WARNINGS that you have not seen before.
• F. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

Answer: A,B,D,F

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

Answer: B,E

Explanation:
Exadata storage realms using ASM-scoped security mode allows you to control which database can access which griddisks by creating realms at the ASM level, thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.2 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
Exadata storage realms using database-scoped security mode allows you to control which database can access which griddisks by creating realms at the database level [1], thereby allowing you to limit the access of each database to the griddisks that it needs to access. This is covered in section 3.15.3 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [2].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf [2] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf

NEW QUESTION # 30
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. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
• C. cat /proc/net/bonding/bondeth0
• D. netstat -rn

Answer: B

Explanation:
The checkbadlinks.pl script is a tool provided with the Exadata X9M-2 Database Server that allows you to verify the status of the InfiniBand links between the Database Server and the client switches. This script checks for bad links, and it can be used to identify any issues with the client network connectivity. To use the script, you can navigate to the directory where it is located, which is /opt/oracle.SupportTools/ibdiagtools/ and execute the command ./checkbadlinks.pl -all. This will give you a summary of the status of the links and it will indicate if there are any bad links. This command will check the client network on your Exadata X9M-2 Database Server is available via both client switches. Other commands like ifconfig, netstat and cat are not relevant to check the client network on Exadata X9M-2 Database Server

NEW QUESTION # 31
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.

Answer: B

NEW QUESTION # 32
Which two activities are supported on the storage servers in an Exadata Database Machine?

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

Answer: A,D

Explanation:
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
1. changing the root password
2. configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html

NEW QUESTION # 33
Which dbmcli command is NOT valid on Exadata X9M?

• A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
• B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
• C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
• D. dbmcli -e "LIST IBPORT DETAIL"

Answer: B

Explanation:
1. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'" is valid command and it is used to list the historical values for metrics where the name starts with "DS_."
2. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " is valid command and it is used to list the current value of the metric named "DS_TEMP"
3. dbmcli -e "LIST IBPORT DETAIL" is valid command and it is used to list the InfiniBand ports and details of the Exadata X9M.
"dbmcli" is a command-line tool that is used to manage and monitor the Exadata Database Machine. It allows you to perform various tasks such as managing the database, storage, and network components, and monitoring the performance and health of the machine. The command "dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15" is not a valid command, it is not supported on Exadata X9M.

NEW QUESTION # 34
Which two statements are true about applying updates on Exadata systems?

• A. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
• 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. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
• F. When running a "yum update" for a new Exadata release, all other repositories should be disabled.

Answer: C,F

Explanation:
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.

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

Answer: B,D,E

Explanation:
According to Oracle's documentation12, the components that are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins are:
The storage server ILOM2
The Power Distribution Units (PDUs)2
The RDMA over Converged Ethernet (RoCE) switches3

NEW QUESTION # 36
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?

• A. 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.
• B. 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.
• 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.

Answer: C

Explanation:
Exadata Secure RDMA Fabric isolation is a feature that allows you to use virtualization on the X9M-2 platform while maintaining security and isolation between multiple tenants or VM clusters. Secure Fabric isolation works by creating a dedicated network partition and VLAN ID for each Database VM cluster, which is used for cluster networking between the database servers in the VM Cluster. This ensures that the network traffic of each VM cluster is isolated from the others, and it prevents unauthorized access to the data or resources of other VM clusters. Secure Fabric isolation can also be used for other purposes such as client networking, Data Guard traffic, but it's mainly used to provide security and isolation between multiple tenants or VM clusters.

NEW QUESTION # 37
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. Install on Oracle Database Appliance.
• E. Provide individual x86 64-Bit gateway hardware.

Answer: A,C,D

NEW QUESTION # 38
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

• A. Add 24x 32GB DIMMs.
• B. Add 12x 64GB DIMMs.
• C. Add 16x 32GB DIMMs.
• D. Add 16x 64GB DIMMs.
• E. Add 32x 64GB DIMMs.
• F. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• G. Add 12x 32GB DIMMs.
• H. Shutdown the Database Server if running.
• I. Remove existing memory modules.

Answer: D,H,I

Explanation:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".

NEW QUESTION # 39
A new Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA 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. The installation cannot proceed until two power feeds are available per PDU.
• B. 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.
• C. The installation can go ahead, no change is required.
• D. A splitter cable can be used to provide power to all PDU cables.

Answer: A

Explanation:
An Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs would typically require two power feeds per PDU, one for each of the two power distribution units (PDUs) in the rack. A single power feed per PDU is not sufficient to provide the necessary power to the servers and storage in the rack.

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

Answer: A

Explanation:
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)
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/index.html

NEW QUESTION # 41
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 database servers
• C. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
• D. OS I/O metrics using OS tools such as iostat on the storage servers
• E. 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

Answer: A,C

Explanation:
1. OS I/O metrics using Enterprise Manager host pages for the storage servers: Enterprise Manager provides a detailed view of the storage server's performance including I/O metrics and statistics. You can use these metrics to analyze I/O performance and identify any bottlenecks.
2. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk: These commands are used to gather information about storage server performance, including I/O statistics, disk usage, and resource allocation.

NEW QUESTION # 42
Which statement is true about the Persistent Memory Commit Accelerator?

• A. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
• B. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
• C. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
• 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 reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.

Answer: E

Explanation:
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.

NEW QUESTION # 43
......

Oracle Exadata Database Machine X8M is a high-performance database appliance that is designed to deliver extreme performance, scalability, and reliability. It is built with cutting-edge hardware and software technologies that enable it to process massive amounts of data quickly and efficiently. The Oracle 1z1-902 certification exam tests the candidate's ability to configure, implement, and manage this powerful database machine.

 

Oracle 1z1-902 Dumps - Secret To Pass in First Attempt: https://braindumps.exam4docs.com/1z1-902-study-questions.html