1Z0-902 Dumps (2024) Prepare Your Exam With 60 Questions [Q34-Q53]

1Z0-902 Dumps (2024) Prepare Your Exam With 60 Questions

New 1Z0-902 Dumps - Real Oracle Exam Questions

NEW QUESTION # 34
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 only one database server in both racks
• C. on at least two storage servers in both racks
• D. on all database servers and at least two storage servers in both racks
• E. on all database servers in both racks and one storage server in each rack
• F. on all database servers in the first rack
• G. on all storage servers in both racks

Answer: C,D

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

NEW QUESTION # 35
Which three statements are true about the CELLCLI command?

• A. It can execute commands on multiple storage servers in parallel.
• 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 requires root privileges to create CELLDISKS and GRIDDISKS.

Answer: B,C,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 # 36
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

• A. Database Quarantine
• B. Cell Offload Quarantine
• C. SQL Plan Quarantine
• D. Manually created Quarantine
• E. Disk Region Quarantine

Answer: A,C

NEW QUESTION # 37
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 contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
• C. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
• D. 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.

Answer: D

Explanation:
Failure groups provide redundancy in Oracle Exadata Database Machine X9M by ensuring that mirror copies of the data are written to different storage servers [1][2]. This prevents the potential for mirror copies to be written to the same server, which would cause a data loss if that server were to experience a physical disk failure. Furthermore, failure groups help to ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster, providing an extra layer of data protection. Additionally, Extended Redundancy mirrors data across data centers, providing the highest levels of data protection. Reference: Oracle Exadata Database Machine X9M Implementation Essentials [1][2], Chapter 5: Configuring Oracle ASM.

NEW QUESTION # 38
Which three of the following options are available for database consolidation on Exadata?

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

Answer: B,C,F

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

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

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

Answer: C,D

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 # 40
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?

• A. Extended
• B. High
• C. External
• D. Sparse
• E. Normal

Answer: B

Explanation:
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure. This means that they need a redundancy level that can tolerate at least one disk failure without losing data availability or performance. Therefore, the best option for them is normal redundancy . Normal redundancy provides two-way mirroring by default, which means that each data extent has a primary copy and a mirror copy on different disks in different failure groups1. A failure group is a subset of disks within a disk group that are likely to fail at the same time due to common dependencies2. On Exadata Database Machine , each Storage Server is considered as a failure group by default2. This means that if one Storage Server fails or needs to be updated , the data on its disks can still be accessed from another Storage Server that has the mirror copies of the same data extents2. Therefore, normal redundancy ensures data availability and performance during updates or single-node server failures.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-administering-asm.html

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

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

Answer: C

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

Answer: C

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

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

Answer: D,E

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

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

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

Answer: A

Explanation:
The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M.

NEW QUESTION # 45
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 ASM-scoped security mode
• B. Exadata storage realms using database-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

Answer: A,E

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

NEW QUESTION # 46
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

• A. Collected configuration information can be uploaded manually to Oracle.
• B. Collected configuration information can be uploaded automatically to Oracle.
• C. It is mandatory to install OCM on at least one database server.
• D. It is mandatory to install OCM on all database servers.
• E. It collects configuration information on demand.
• F. It collects configuration information automatically.

Answer: A,C,D

Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, OCM is mandatory to install on at least one database server and can be used to collect configuration information on demand. The collected information can then be uploaded either manually or automatically to Oracle.

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

Answer: A

NEW QUESTION # 48
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. 44, 6, 9
• E. 0

Answer: B

NEW QUESTION # 49
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.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -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.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

Answer: C

Explanation:
Exachk is an Oracle-provided diagnostic tool that allows you to check various components of an Exadata Database Server, including the client network. The tool is located in the /opt/oracle.SupportTools/exachk/ directory and can be run with the command: exachk. This command can be run with the option -from <Fridays_Date>_17:00:00 and -to <Sundays_Date>_23:59:00 to specify a time range of interest, this way you can check the client network status between the specified time range. The tool checks the status of various components such as network interfaces, InfiniBand fabric, and storage servers. It also analyzes log files, configuration files, and system settings to detect any issues. The tool generates a report, which can be used to identify the root cause of the issue and provide recommendations for resolution.
Tfact1 is a tool to collect diagnostic information from Exadata and non-Exadata systems and it is not related to client network status.
Netcheck and GetExaWatcherResults.sh are not tools provided with the Exadata Database Server and they are not related to client network status.

NEW QUESTION # 50
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

• A. Oracle Linux 8.0
• B. Oracle Linux 7.7
• C. Oracle Linux 7.5
• D. Oracle Linux 7.9

Answer: D

Explanation:
Oracle Linux 7.9 is the minimum version required to support RoCE and Persistent Memory. This is because Oracle Linux 7.9 includes kernel enhancements that enable RDMA over Converged Ethernet (RoCE) networking and Intel Optane DC Persistent Memory Modules (DCPMM) for Exadata X8M systems3. These features allow faster access latency and higher throughput for database workloads2.

NEW QUESTION # 51
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?

• A. Oracle Linux 7.9
• B. Oracle Linux 7.7
• C. Oracle Linux 7.5
• D. Oracle Linux 8.0

Answer: D

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

Answer: D,E

NEW QUESTION # 53
......

Get Ready with 1Z0-902 Exam Dumps: https://testking.itexamsimulator.com/1Z0-902-brain-dumps.html