[2023] Get Top-Rated Oracle 1Z0-902 Exam Dumps Now [Q18-Q39]

[2023] Get Top-Rated Oracle 1Z0-902 Exam Dumps Now

Passing Key To Getting 1Z0-902 Certified Exam Engine PDF

NEW QUESTION # 18
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

• A. PMEM Pool Misses in the Exadata Outlier Summary
• B. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
• C. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
• D. PMEM Cache section within Exadata Smart Statistics
• E. PMEM Cache section within Memory Statistics

Answer: D,E

Explanation:
The AWR report has two sections that show statistics for X9M Persistent Memory Cache: the PMEM Cache section within Memory Statistics and the PMEM Cache section within Exadata Smart Statistics. Both of these sections provide detailed information about the read and write hits and misses, as well as the total capacity and utilization of the PMEM cache. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 515)

NEW QUESTION # 19
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?

• A. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
• B. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
• C. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.
• D. Install Oracle Rest Data Services on each Database server and install the MS APEX application.

Answer: C

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

• A. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
• 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 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 helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).

Answer: A

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 # 21
Which two statements are true about applying updates on Exadata systems?

• A. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
• B. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
• C. Failed storage server updates are automatically rolled back to a previous release.
• D. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
• E. Failed database server updates are rolled back to a working state on a previous release automatically.
• F. When running a "yum update" for a new Exadata release, all other repositories should be disabled.

Answer: B,E

NEW QUESTION # 22
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 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.
• D. 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.

Answer: D

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

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

Answer: A,B,F

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 # 24
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. A splitter cable can be used to provide power to all PDU cables.
• 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. The installation can go ahead, no change is required.

Answer: D

Explanation:
According to the Oracle Exadata Database Machine X9M-2 Data Sheet1, each PDU has two power input cables that can be connected to separate power sources for redundancy. However, if only one power source is available per PDU, then a single cable can be used to provide sufficient power for normal operation.
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf

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

• A. Bare Metal deployment with one database per database server
• B. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
• C. Multiple Databases on a cluster
• D. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
• 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,D

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

NEW QUESTION # 27
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

• A. 512GB
• B. 384GB
• C. 1024GB
• D. 768GB
• E. 1536GB
• F. 2048GB

Answer: E

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 # 28
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?

• A. -> start /SYS/power
• B. -> start /SYSTEM/power
• C. -> set /SYS power_state=ON
• D. You must be physically present in the data center to start an Exadata Storage Server.
• E. -> start /System
• F. -> start /SP/console

Answer: A

Explanation:
ILOM (Integrated Lights Out Manager) is a remote management system that allows you to control and monitor Exadata Database Machine components, such as storage servers and database servers, from a remote location. The command "start /SYS/power" is used to power on the storage server in the Exadata Database Machine after hardware maintenance. This command can be executed remotely via ILOM.

NEW QUESTION # 29
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 celldisk attributes name, deviceName, diskType, physicalFirmware
• C. list physicaldisk attributes name, deviceName, diskType, physicalFirmware
• D. list cell attributes name, deviceName, diskType, physicalFirmware

Answer: C

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

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

Answer: B,C

Explanation:
A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-software-introduction.html

NEW QUESTION # 31
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?

• A. 0 because the new griddisks will be added to the existing faiigroups
• B. 12 consisting of seven griddisks each
• C. 1 consisting of all 96 griddisks
• D. 7 consisting of 12 griddisks each
• E. 96 consisting of one griddisk each

Answer: C

Explanation:
This SQL statement is adding the new griddisks to the existing diskgroup "DATA" and creating one new failgroup, consisting of all 96 griddisks. The "REBALANCE POWER 512" option tells the system to perform a rebalance operation with a power of 512. It means the system distributes the data evenly across all the disks in the diskgroup using a power of 512.

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 query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
• B. 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.
• 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$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

Answer: A,C

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
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 with all database and storage servers listed in a single input file.
• 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. Each component type must be upgraded independently of the other.

Answer: D

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

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

Answer: D,E

Explanation:
Exadata Database Machine is a preconfigured and optimized for database workloads. The storage servers in an Exadata Database Machine are used to store database data, and support activities such as upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure and upgrading the Storage Server software package using rpm. These activities are related to maintain the storage servers performance and security. Changing the root password, installing an alternative package manager, and configuring secure shell user equivalency for the cellmonitor user are activities that can be performed on any Linux machine, but they are not specific to Exadata Database Machine.

NEW QUESTION # 35
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. A splitter cable can be used to provide power to all PDU cables.
• C. The installation cannot proceed until two power feeds are available per PDU.
• D. 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.

Answer: D

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

Answer: A,B

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

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

Answer: C,D,E

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

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

Answer: C,D

NEW QUESTION # 39
......

Oracle Exadata Database Machine X8M is a high-performance, secure, and scalable database solution that is designed to handle large amounts of data. It is an integrated system that combines hardware and software components to provide a complete database solution. The Oracle Exadata Database Machine X8M is designed to deliver high availability, scalability, and performance, making it an ideal solution for organizations with large data centers.

Oracle 1z1-902 certification exam is a rigorous and comprehensive test of the candidate's ability to manage and implement the Oracle Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification is highly valued in the industry and is a must-have credential for professionals who want to demonstrate their expertise in managing complex database systems. With the right preparation and experience, candidates can pass the exam and earn this valuable certification.

 

1Z0-902 exam questions for practice in 2023 Updated 60 Questions: https://www.real4dumps.com/1Z0-902_examcollection.html

1Z0-902 Exam Dumps Pass with Updated Tests Dumps: https://drive.google.com/open?id=1c5kcLGOy24e7tKQ5nBkp3vN4a0kXKk10