Latest Success Metrics For Actual 1Z0-902 Exam (Updated 62 Questions)
Genuine 1Z0-902 Exam Dumps Free Demo Valid QA's
NEW QUESTION # 23
How do ASM failure groups provide redundancy?
- A. 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.
- B. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
- C. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- D. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
Answer: C
Explanation:
In an Automatic Storage Management (ASM) environment, failure groups are used to provide redundancy for the storage disks. Failure groups are used to group together a set of disks and ensure that no two copies of the same data are stored on the same physical disk or storage server. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
For example, if the disks in a failure group are mirrored, one copy of the data is stored on one set of disks, and the other copy is stored on another set of disks. This way, if a disk or storage server fails, the data can still be accessed from the other copy.
ASM failure groups also provide the option to spread the data across different storage servers, this way, even if a storage server fails, data can still be accessed from the other storage servers in the group. This will improve the availability of the data.
NEW QUESTION # 24
Which statement is true about the Persistent Memory Commit Accelerator?
- A. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
- B. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
- C. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
- D. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
- 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 # 25
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 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network
- C. 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
- D. 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
Answer: B,D
NEW QUESTION # 26
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- B. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- C. Multiple Databases on a cluster
- D. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- E. A single database with one or more schema per application
- F. Bare Metal deployment with one database per database server
Answer: C,D,E
Explanation:
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
1. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
2. A single database with one or more schema per application12.
3. Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how
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. 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,C,D
NEW QUESTION # 28
Which two statements are true in regards to starting the Exadata Virtual Machine?
- A. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
- B. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
- C. Use vm_maker boot-from-iso command to boot a virtual machine.
- D. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
- E. Use vm_maker -start-domain to start a virtual machine manually.
Answer: B,C
NEW QUESTION # 29
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. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
- B. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
- C. 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.
- D. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
- E. 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.
Answer: B
Explanation:
Oracle KVM Guest, Oracle Enterprise Manager Agent (OMA), RDBMS instance, Automatic Diagnostic Repository Command Interpreter (ADRCI), CELLCLI, diskmon, and Restart Server (RS) can all run on the database servers. The Cell Server (CELLSRV) and Management Server (MS) can both run on the Exadata storage servers. Specific instructions for installing and configuring these software components can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_software_components.html.
NEW QUESTION # 30
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. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- B. Add 12x 32GB DIMMs.
- C. Add 16x 64GB DIMMs.
- D. Add 16x 32GB DIMMs.
- E. Add 24x 32GB DIMMs.
- F. Remove existing memory modules.
- G. Add 12x 64GB DIMMs.
- H. Shutdown the Database Server if running.
- I. Add 32x 64GB DIMMs.
Answer: C,F,H
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 # 31
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. RoCE network interface cards in the storage servers
- B. Cisco management switch
- C. fans in the storage servers
- D. power supplies in the database servers
- E. power distribution units
- F. RoCE network interface cards in the database servers
- G. Cisco RDMA over Converged Ethernet (RoCE) switches
Answer: A,D,E,G
Explanation:
According to the Oracle Auto Service Request (ASR) documentation1, ASR raises service requests for qualified Oracle products that are detected with specific faults. The qualified Exadata products include2:
Database servers
Storage servers
InfiniBand switches
Cisco switches (X8M and later systems)
Power distribution units (PDUs)
NEW QUESTION # 32
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 VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart 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 v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
Answer: B,D
Explanation:
1. Querying VSSYSTEM_EVENTS for the event 'cell physical IO interconnect bytes returned by smart scan' will not be appropriate for monitoring the access on a particular table. The V$SYSTEM_EVENT view is used to monitor system-wide performance statistics, not specific table access. C. Querying v$SYSTAT for the statistic 'cell smart table scan' will not be appropriate for monitoring the access on a particular table as well. The v$SYSTAT view contains system-wide performance statistics, not specific table access.
NEW QUESTION # 33
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?
- A. Wait for the email of the failure that Exadata or Enterprise Manager will send.
- B. Download and run the latest exadiag tool.
- C. Check the database to see if any rebalance operations are active.
- D. Call Oracle Support and make an appointment so that the drive can be replaced.
- E. Wait for a blue light to appear on the disk if the rebalance operation is running.
- F. Ask the system administrator to replace the broken disk with a spare.
Answer: D
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], before doing anything else you should call Oracle Support and make an appointment so that the drive can be replaced. If Platinum Support is enabled, then you can call Oracle Support and they will arrange for the disk to be replaced. If Platinum Support is not enabled, then you can arrange for the disk to be replaced through Enterprise Manager Cloud Control.
NEW QUESTION # 34
You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C.
What command should use use to generate alerts for such an event?
- A. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
- B. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- C. dbmcli -e "set alert ds_temp> 30" on each database server
- D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
Answer: C
NEW QUESTION # 35
Which two statements are true about enabling write-back flash cache?
- A. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
- 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. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
Answer: B,D
Explanation:
According to the Oracle documentation1, two statements that are true about enabling write-back flash cache are:
Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations (A). This is because write-back flash cache provides better performance and reliability for data file writes than write-through flash cache.
Before write-back flash cache is enabled, you need to drop the Flash Cache first (D). This is because changing the flash cache mode requires recreating the flash cache with a different configuration.
NEW QUESTION # 36
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?
- A. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
- B. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- C. Copy and execute the script on all storage servers using the EXACLI command.
- D. Copy and execute the script on all storage servers using the dcli command.
- E. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
Answer: C
NEW QUESTION # 37
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 can go ahead, no change is required.
- B. The installation cannot proceed until two power feeds are available per PDU.
- C. 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.
- D. A splitter cable can be used to provide power to all PDU cables.
Answer: C
NEW QUESTION # 38
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 VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart 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 v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
Answer: B,D
Explanation:
1. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
2. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/
NEW QUESTION # 39
......
1Z0-902 Practice Test Give You First Time Success with 100% Money Back Guarantee!: https://www.testkingit.com/Oracle/latest-1Z0-902-exam-dumps.html
Printable & Easy to Use Oracle Engineered Systems 1Z0-902 Dumps 100% Same Q&A In Your Real Exam: https://drive.google.com/open?id=18JO-pobZbgyYaj96lDU_xlfqNp6Qszot