(2024) PASS 1z1-902 Exam Free Practice Test with 100% Accurate Answers [Q36-Q52]

(2024) PASS 1z1-902 Exam Free Practice Test with 100% Accurate Answers

1z1-902 dumps Free Test Engine Verified By It Certified Experts

NEW QUESTION # 36
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. OS I/O metrics using OS tools such as iostat on the database servers
C. OS I/O metrics using Enterprise Manager host pages for the storage servers
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 storage servers

Answer: B,D

Explanation:
The two monitoring tools that might be useful in examining I/O performance for the prod database are:
OS I/O metrics using OS tools such as iostat on the database servers.
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "I/O metrics can be collected from the database server using OS tools such as iostat [1], as well as from the storage servers using cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk". It also suggests using Enterprise Manager host pages for the storage servers to view OS I/O metrics.

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

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

Answer: A,D,E

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 # 38
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

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

Answer: E

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

Answer: A,C

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

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

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

Answer: A,B,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 # 41
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. 0
B. 10, 8, 9, 11
C. 4,1, 6, 9
D. 7,6,9,11
E. 10, 8, 2, 5

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 # 42
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. 2, 7, 8, and 6
B. 4, 7, 8, 3, and 6
C. 5, 8, 7, and 6
D. 1, 8, 7, 3 and 6
E. 2, 8, 7, 3, and 6

Answer: C

Explanation:
Option 5 stops the clusterware on all database servers as the grid user3.
Option 8 shuts down all Exadata storage servers using their ILOM interfaces1.
Option 7 shuts down all database servers using their ILOM interfaces1.
Option 6 powers off the rack using the power switches on the PDUs2.

NEW QUESTION # 43
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$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
C. 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'.
D. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

Answer: C,D

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 # 44
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 devices attributes name, deviceName, diskType, physicalFirmware
B. list cell attributes name, deviceName, diskType, physicalFirmware
C. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
D. list celldisk attributes name, deviceName, diskType, physicalFirmware

Answer: D

NEW QUESTION # 45
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?

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

Answer: E

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

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

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

Answer: D,E,F

Explanation:
Options A, D, and F are available for database consolidation on Exadata. Option A refers to the use of multiple pluggable databases in one or more container databases on either a Virtual Machine or Bare Metal cluster. Option D refers to the use of multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently. And finally, Option F refers to the use of multiple Virtual Machine clusters supporting a single database for greatest resource isolation. This is 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.

NEW QUESTION # 47
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 list LUN DETAIL command as the celladmin user
B. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
C. hardware monitoring using the storage server ILOM
D. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

Answer: A,D

NEW QUESTION # 48
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

Answer: B

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

NEW QUESTION # 49
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

A. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
B. ZFS Snapshots can provide rapid cloning of development and test environment.
C. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
D. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.

Answer: C,D

NEW QUESTION # 50
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 10Gb ports on eth3 and eth4 using RJ45 cat6 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 25Gb ports on eth5 and eth6 using
SFP28 transceivers and OM4 fiber cable for client network

Answer: A,C

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

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

Answer: B,E

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:
A) changing the root password
E) 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 # 52
......

Latest Oracle 1z1-902 Practice Test Questions: https://www.testkingit.com/Oracle/latest-1z1-902-exam-dumps.html

Realistic 1z1-902 Accurate & Verified Answers As Experienced in the Actual Test!: https://drive.google.com/open?id=1opX79Y-1j6Yp2IeyTY1IutwlG6p4BPlW

(2024) PASS 1z1-902 Exam Free Practice Test with 100% Accurate Answers [Q36-Q52]

Related Blogs