Get Dec-2023 updated Exam 1Z0-902 Dumps with New Questions [Q27-Q48]

Get Dec-2023 updated Exam 1Z0-902 Dumps with New Questions

100% Pass Guarantee for 1Z0-902 Exam Dumps with Actual Exam Questions

To take the Oracle 1z1-902 exam, candidates must have a solid understanding of database concepts and architecture, as well as experience with Oracle database administration and management. They should also be familiar with the Exadata Database Machine X8M hardware and software components, including the storage servers, database servers, InfiniBand network, and Exadata software. Additionally, candidates should be familiar with backup and recovery strategies, as well as performance tuning techniques.

The 1Z0-902 exam covers a wide range of topics, including Exadata architecture, software installation and configuration, database migration, backup and recovery, performance tuning, and troubleshooting. Candidates are expected to have a deep understanding of Oracle databases and Exadata technology, as well as hands-on experience with installation, configuration, and maintenance of Exadata systems. Passing 1Z0-902 exam will demonstrate their ability to implement and manage Exadata systems, and will help them advance their careers in the field of database administration.

 

NEW QUESTION # 27
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

• A. ASR communicates with Oracle support services using HTTPS.
• B. ASR can upload configuration metadata to support problem resolution.
• C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• D. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
• E. Configuring ASR is mandatory for all Database Machine assets.
• F. ASR Manager must be installed and configured on one of the database servers.

Answer: D,F

NEW QUESTION # 28
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. Add 32x 64GB DIMMs.
• B. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• C. Add 12x 64GB DIMMs.
• D. Add 12x 32GB DIMMs.
• E. Add 16x 64GB DIMMs.
• F. Add 24x 32GB DIMMs.
• G. Add 16x 32GB DIMMs.
• H. Shutdown the Database Server if running.
• I. Remove existing memory modules.

Answer: A,H,I

Explanation:
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf
https://chriscraftoracle.wordpress.com/2022/11/09/what-makes-exadata-faster/

NEW QUESTION # 29
Which are two correct statements about backing up Exadata Database Machine?

• A. For high availability, system area can be on the first two disks and M.2 devices.
• B. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
• C. The M.2 disk is hot pluggable and can be replaced when the power is on, but you will have to restore the system data manually.
• D. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
• E. Backing up Exadata Storage Server Software is critical for restoration.

Answer: D,E

Explanation:
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 4: Oracle Clusterware [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 8: Oracle Exadata Storage Server Software [3] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 9: Oracle Exadata Storage Server Infrastructure
https://www.oracle.com/technetwork/database/availability/exadata-backup-recovery-bp-3633870.pdf

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

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

Answer: D

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 Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/index.html

NEW QUESTION # 31
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 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
• 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 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 using SFP28 transceivers and OM4 fiber cable for client network
• D. 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

Answer: B,D

NEW QUESTION # 32
You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?

• A. 2,3,4,6,1,7,5
• B. 2,6,1,4,3,7,5
• C. 3,2,6,1,4,7,5
• D. 3,2,6,4,1,7,5
• E. 4,3,2,6,1,7,5

Answer: D

Explanation:
The correct sequence is:
Review the safety guidelines. This is important to ensure a safe and successful installation1.
Unpack Oracle Exadata Rack. This involves removing the packaging materials and inspecting the rack for damage or missing components1.
Place Exadata in its allocated space. This involves moving the rack to its final location and securing it with bolts and brackets1.
Let the Exadata acclimatize for 24 hours. This is recommended to allow the rack components to adjust to the ambient temperature and humidity before powering on1.
Stabilize the Exadata Rack. This involves leveling the rack and adjusting its height if needed1.
Power on Exadata PDU B. This involves connecting PDU B to a power source and turning it on1.
Power on Exadata PDU A. This involves connecting PDU A to a power source and turning it on1

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

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

Answer: C,D

Explanation:
Oracle Exadata Deployment Assistant (OEDA) enables customers to deploy Oracle Exadata Database Machine in virtualized environments and it support both bare metal and virtual machine deployment in an Exadata X9M Quarter Rack.

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

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

Answer: B,D

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

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

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

Answer: B

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 # 36
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

• A. Run the appropriate patchmgr preqequisite check step for each component being updated.
• B. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• C. Run exachk and resolve only WARNINGS that you have not seen before.
• D. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• E. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• F. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.

Answer: A,B,D,F

NEW QUESTION # 37
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: A,B,C

Explanation:
The CELLCLI utility is a command line interface to Exadata that enables the execution of commands across multiple storage servers in parallel. It also has command-line history, so users can easily recall previously entered commands. Furthermore, the CELLCLI utility can be executed using the DCLI utility, which provides a convenient way to execute commands on multiple storage servers simultaneously.
However, CELLCLI does not require root privileges to create CELLDISKS and GRIDDISKS, and it cannot be executed on storage servers. This is because CELLCLI is used to manage the Exadata database machine from the database server [1]. For more information about CELLCLI, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

NEW QUESTION # 38
Which two statements are true about enabling write-back flash cache?

• A. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
• B. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
• C. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
• D. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
• E. Before write-back flash cache is enabled, you need to drop the Flash Cache first.

Answer: A,E

NEW QUESTION # 39
Which two statements are true about enabling write-back flash cache?

• A. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
• B. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
• C. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
• D. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
• E. Before write-back flash cache is enabled, you need to drop the Flash Cache first.

Answer: A,E

Explanation:
The two statements that are true about enabling write-back flash cache are:
When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
Before write-back flash cache is enabled, you need to drop the Flash Cache first.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "when enabling write-back flash cache in a rolling manner [1], grid disks need to be inactivated on all cells before enabling write-back flash cache". It also states that "before write-back flash cache can be enabled, the existing flash cache must be dropped".

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

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

Answer: F

Explanation:
The Exadata X9M-2 Database Machine uses powerful database servers, each with two 32-core x86 processors and 512 GB of memory (expandable up to 2 TB).

NEW QUESTION # 41
You are providing oversight for the delivery of a new Exadata Database Machine.
1. Stabilize the Exadata Rack.
2. Unpack Oracle Exadata Rack.
3. Review the safety guidelines.
4. Let the Exadata acclimatize for 24 hours.
5. Power on Exadata PDU A.
6. Place Exadata in its allocated space.
7. Power on Exadata PDU B.
What is the correct order of these steps?

• A. 2,6,1,4,3,7,5
• B. 3,2,6,1,4,7,5
• C. 3,2,6,4,1,7,5
• D. 2,3,4,6,1,7,5
• E. 4,3,2,6,1,7,5

Answer: D

NEW QUESTION # 42
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

• A. ASR Manager must be installed and configured on one of the database servers.
• B. ASR communicates with Oracle support services using HTTPS.
• C. ASR can upload configuration metadata to support problem resolution.
• D. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• E. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
• F. Configuring ASR is mandatory for all Database Machine assets.

Answer: B,E

Explanation:
A and F are true statements about Auto Service Request (ASR) with an Exadata Database Machine [1][2]. In order to use the ASR feature, ASR Manager must be installed and configured on a dedicated server which is external to the Database Machine, and it communicates with Oracle support services using HTTPS. Additionally, ASR can upload configuration metadata to support problem resolution, and it can open a service request (SR) automatically after sensors detect hardware faults.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2].

NEW QUESTION # 43
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 and execute the script on all storage servers using the dcli command.
• B. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
• C. Copy and execute the script on all storage servers using the EXACLI command.
• D. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
• E. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.

Answer: A

NEW QUESTION # 44
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. PMEM Cache section within Memory Statistics
• D. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
• E. PMEM Cache section within Exadata Smart Statistics

Answer: C

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

Answer: D

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

Answer: A,D

Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB The two commands that must be executed to safely power off the storage server in an Exadata X9M Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage server is completely powered off and no data is lost.
For more information on how to properly power off an Exadata Storage Server, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].
https://support.oracle.com/knowledge/Oracle%20Database%20Products/1188080_1.html

NEW QUESTION # 47
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 Database server and install the MS APEX application.
• B. 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.
• C. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
• D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.

Answer: C

Explanation:
To enable REST access to the MS process, you need to manually enable the REST services on each storage server by running the command cellcli -e "ALTER CELL ENABLE REST" and then configure authentication and authorization to ensure secure access. This is described in detail in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Securing the Exadata Database Machine).

NEW QUESTION # 48
......

Earning the Oracle Exadata Database Machine X8M Implementation Essentials certification by passing the Oracle 1z1-902 exam can help IT professionals enhance their career opportunities and demonstrate their expertise in implementing and managing Oracle Exadata Database Machine X8M systems. With this certification, candidates will have a competitive advantage in the job market and will be able to take on more challenging roles in their organizations.

 

1Z0-902 exam dumps with real Oracle questions and answers: https://www.pass4leader.com/Oracle/1Z0-902-exam.html

Today Updated 1Z0-902 Exam Dumps Actual Questions: https://drive.google.com/open?id=1BX6BWrCP21LDahYGTxmKW7ZwGu-WzLji