1Z0-902 Updated Exam Dumps [2023] Practice Valid Exam Dumps Question [Q27-Q48]

1Z0-902 Updated Exam Dumps [2023] Practice Valid Exam Dumps Question

1Z0-902 Sample with Accurate & Updated Questions

The Oracle 1Z0-902 exam is designed for professionals who are seeking to validate their knowledge and skills in implementing and managing Oracle Exadata Database Machine X8M. This exam is a certification program offered by Oracle and is intended for individuals who have experience in designing, deploying, and managing Exadata Database Machine X8M systems. The exam measures the candidate's ability to configure and manage Exadata Database Machine X8M, monitor and troubleshoot its performance, and implement security and backup solutions.

The Oracle 1Z0-902 exam is an essential certification for professionals who want to implement and maintain the Exadata X8M system. The exam covers various topics, including the architecture of the Exadata system, database deployment, configuration, and management, backup and recovery, and performance tuning. Upon passing the exam, candidates will receive the Oracle Exadata Database Machine X8M Implementation Essentials certification, which is recognized by employers worldwide.

 

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

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

Answer: A,C

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 # 28
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: 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 # 29
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 database servers
• B. Cisco management switch
• C. power supplies in the database servers
• D. fans in the storage servers
• E. power distribution units
• F. Cisco RDMA over Converged Ethernet (RoCE) switches
• G. RoCE network interface cards in the storage servers

Answer: C,D,E,G

Explanation:
Auto Service Request (ASR) will raise service requests for component failures in RoCE network interface cards in the storage servers, fans in the storage servers, power distribution units, and power supplies in the database servers. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book , which states "ASR will raise service requests for component failures in RoCE network interface cards in the storage servers [1], fans in the storage servers, power distribution units, and power supplies in the database servers" (page 5-11).

NEW QUESTION # 30
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

• A. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
• B. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
• C. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
• D. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.

Answer: A,D

Explanation:
1. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine2.
2. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA2.

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

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

Answer: F

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

Answer: B,D

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 # 33
Which three of the following options are available for database consolidation on Exadata?

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

Answer: B,D,F

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

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

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.
According to Oracle's documentation1, Exadata Secure RDMA Fabric Isolation is a feature that enables strict network isolation for Oracle Real Application Clusters (Oracle RAC) clusters on Exadata Database Machine systems that use RDMA over Converged Ethernet (RoCE). Exadata Secure RDMA Fabric Isolation uses RoCE VLANs to ensure that network packets from one VM cluster cannot be seen by another VM cluster. VLAN tag enforcement is done at the KVM host level, which means that security cannot be bypassed by any software exploits or misconfiguration on the database server VMs1.
Therefore, the statement that is true about how Exadata Secure RDMA Fabric isolation is used in X9M-2 with virtualization enabled is:
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.

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

• A. ZFS Snapshots can provide rapid cloning of development and test environment.
• B. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
• 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: B,C

Explanation:
1. ZFS Storage Appliance (ZFSSA) can't connect directly to the Exadata 100Gb RoCE network switches. ZFSSA uses Fibre Channel protocol to connect to the Exadata storage cells. C. When backing up multi-rack systems, sharing Exadata X9M switches is not recommended. Each rack should have its own switches to minimize the risk of data loss due to switch failure.
Review the safety guidelines.
Unpack Oracle Exadata Rack.
Let the Exadata acclimatize for 24 hours.
Place Exadata in its allocated space.
Stabilize the Exadata Rack.
Power on Exadata PDU A.
Power on Exadata PDU B.
This order ensures that the necessary safety precautions are taken before installing the Exadata Database Machine, and that the machine is allowed to acclimate to its new environment before being powered on.

NEW QUESTION # 36
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. External
• B. High
• C. Extended
• D. Normal
• E. Sparse

Answer: B

Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the customer should use the High redundancy level for their ASM storage in order to ensure that their data is available on the Exadata machine during updates. The High redundancy level provides the most protection against single-node server failure, as it stores three copies of each data file on separate nodes. This is the same redundancy level used for the Oracle Database's Control Files and Redo Logs. Instructions for configuring the ASM redundancy level can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_asm_overview.html.

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

Answer: C,E

NEW QUESTION # 38
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. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• C. Run the appropriate patchmgr preqequisite check step for each component being updated.
• D. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• E. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• F. Run exachk and resolve only WARNINGS that you have not seen before.

Answer: A,B,C,D

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

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

Answer: B,D

Explanation:
The "cell PMEM cache Read Hits" in the "Database IOs" portion of the "Performance Summary" will show the number of reads that have been satisfied from the Persistent Memory Cache. The "PMEM Cache" section within "Memory Statistics" will give detailed information about the usage of the Persistent Memory Cache, such as cache size, used size, hit rate, etc. This information can help to identify if the Persistent Memory Cache is being used effectively and if there are any issues with it.

NEW QUESTION # 40
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. 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. OS I/O metrics using Enterprise Manager host pages for the storage servers

Answer: C,E

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 # 41
Which three statements are true about the CELLCLI command?

• A. It can execute commands on multiple storage servers in parallel.
• B. It requires root privileges to create CELLDISKS and GRIDDISKS.
• C. It can be executed using the DCLI utility.
• D. It can be executed on storage servers.
• E. It has command-line history.

Answer: C,D,E

Explanation:
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.

NEW QUESTION # 42
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. Install in Oracle Virtual Machine with required hardware.
• C. Install on Exadata Engineered System.
• D. Install on Oracle Database Appliance.
• E. Provide individual x86 64-Bit gateway hardware.

Answer: A,D,E

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 # 43
An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA 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 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. The installation cannot proceed until two power feeds are available per PDU.

Answer: D

Explanation:
In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack, and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will be able to provide sufficient power for the system. Therefore, the installation cannot proceed until two power feeds are available per PDU.
For more information about power requirements for Exadata X9M-2 Elastic Racks, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.
Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation - Oracle Docs [2] Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/exadata-site-requirements.html

NEW QUESTION # 44
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/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• C. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -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: D

Explanation:
AccordingtoOraclesdocumentationoneoftheutilitiesfordiagnosticsand
Explanation:
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 # 45
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

• A. OECA extends the hardware for the elastic configuration only.
• B. OECA facilitates PDU power selection initially and after equipment addition.
• C. OECA allows one XT storage server in the configuration.
• D. OECA reconfigures the size of disk groups and recreates grid disks.
• E. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.

Answer: C,E

NEW QUESTION # 46
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 power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
• B. The installation cannot proceed until two power feeds are available per PDU.
• C. A splitter cable can be used to provide power to all PDU cables.
• D. The installation can go ahead, no change is required.

Answer: A

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

Answer: F

Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB

NEW QUESTION # 48
......

Certification Topics of Oracle 1Z0-902 Exam

• Exadata Database Machine Configuration and Administration

• Exadata Database Machine Updates

• Exadata Database Machine Architecture and Key Capabilities

• Exadata Database Machine Security

• Exadata Database Machine Installation

 

Pass Oracle 1Z0-902 Premium Files Test Engine pdf - Free Dumps Collection: https://www.passtorrent.com/1Z0-902-latest-torrent.html

1Z0-902 Exam Info and Free Practice Test | PassTorrent: https://drive.google.com/open?id=1Ru9AANo_BMe0Kf_hnJFVeuq6IpFs-nMT