[Q19-Q44] Ultimate Guide to Prepare 1Z0-902 with Accurate PDF Questions [Dec 24, 2023]

Ultimate Guide to Prepare 1Z0-902 with Accurate PDF Questions [Dec 24, 2023]

Pass Oracle With ExamsReviews Exam Dumps

Oracle Exadata is a high-performance engineered system that is designed for running the Oracle Database. It provides a unique combination of hardware and software, which is optimized for Oracle Database workloads. Oracle Exadata Database Machine X8M is the latest version of this engineered system, which offers enhanced performance, scalability, and reliability. To implement Exadata X8M, Oracle offers the 1Z0-902 exam, which validates the candidate's knowledge and skills in Exadata X8M implementation.

 

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

Answer: E

Explanation:
In order to completely power off an Exadata Database Machine in an orderly fashion, it's important to properly shut down the cluster first. The command "crscti stop cluster" as root should be executed from one of the database servers.
Once the cluster has been stopped, the next step is to shut down the database servers by executing the command "shutdown -h now" on all database servers.
Next, shut down the Exadata storage servers by executing the command "shutdown -h now" on all Exadata storage servers.
Finally, power off the rack using the power switches on the PDUs.

NEW QUESTION # 20
Which two statements are true about applying updates on Exadata systems?

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

Answer: E,F

Explanation:
1. Exadata updates have a rollback feature in case the update fails, this means that the system will roll back to a previous release automatically, this applies to storage servers updates. D. Yum, the package manager used in Exadata, automatically installs a non-UEK kernel when running a regular update, this kernel can be selected to boot from grub.

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

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

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

Answer: A,C

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 # 23
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?

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

Answer: C

Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book, the maximum DRAM capacity you can expand an X9M-2 DB Server is 1024GB. This is the maximum amount of DRAM that can be installed in the server. The specific steps for adding DRAM are outlined in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_hardware_memory.html.

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

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

Answer: A,C,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 # 25
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

• A. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
• 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. ZFS Snapshots can provide rapid cloning of development and test environment.

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 # 26
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

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

Answer: A,C

Explanation:
D) ASR can upload configuration metadata to support problem resolution1.
E) ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1
https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm

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

• A. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
• 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. ZFS Snapshots can provide rapid cloning of development and test environment.

Answer: B,C

Explanation:
A) 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 # 28
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

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

Answer: A,D,F

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

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

Answer: A,B,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 # 30
What are two recommended configuration best practices for backup and recovery on Exadata?

• A. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
• B. 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.
• 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: B,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 # 31
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A. File permissions on the griddisks in each storage server
• B. Exadata storage realms using database-scoped security mode
• C. Exadata storage realms using ASM-scoped security mode
• D. Using EXADCLI instead of CELLCLI to create the griddisks
• E. File permissions on the griddisks in each database server

Answer: A,D

NEW QUESTION # 32
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

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

Answer: A,B,E,F

Explanation:
According to Oracle.com documents or resources, the four actions that you should take before proceeding with applying updates to your Exadata Database Machine are:
A) Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
B) Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
C) Run exachk and resolve only WARNINGS that you have not seen before3.
D) Run the appropriate patchmgr preqequisite check step for each component being updated3.

NEW QUESTION # 33
Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?

• A. It is required to install OEDA on the first new database server.
• B. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.
• C. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
• D. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
• E. In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.

Answer: C,D

NEW QUESTION # 34
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 # 35
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. Before write-back flash cache is enabled, you need to drop the Flash Cache 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. 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,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 # 36
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 physicaldisk attributes name, deviceName, diskType, physicalFirmware
• B. list celldisk attributes name, deviceName, diskType, physicalFirmware
• C. list devices attributes name, deviceName, diskType, physicalFirmware
• D. list cell attributes name, deviceName, diskType, physicalFirmware

Answer: A

NEW QUESTION # 37
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 must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
• B. patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
• C. patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.
• D. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

Answer: C

Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], patchmgr can be used to apply updates in a rolling manner while still maintaining database availability. It will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption. This is done by invoking patchmgr with the -rolling argument and specifying the component groups in the input file.

NEW QUESTION # 38
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.

NEW QUESTION # 39
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 on Exadata Engineered System.
• D. Install in Oracle Virtual Machine with required hardware.
• E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Answer: A,D,E

NEW QUESTION # 40
Which two statements are true in regards to starting the Exadata Virtual Machine?

• A. Use vm_maker -start-domain to start a virtual machine manually.
• B. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
• C. Use vm_maker boot-from-iso command to boot a virtual machine.
• D. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
• E. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.

Answer: C,D

NEW QUESTION # 41
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:
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 # 42
Which statement is true about the patching features provided in Platinum Services?

• A. Patching services are available for the full software stack up to twice per year.
• B. Patching is done automatically during business hours.
• C. The rolling and complete down time approaches are two options to patching.
• D. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

Answer: A

Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
The correct statement about the patching features provided in Platinum Services is that patching services are available for the full software stack up to twice per year. Oracle Platinum Service covers Exadata storage software and firmware patching, and customers must also perform the database patching. The rolling and complete down time approaches are two options for patching, and patching should be scheduled for times when the system is not being heavily used. Patching is not done automatically during business hours. This is covered in section 4.13 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1].
[1] https://docs.oracle.com/en/engineered-systems/exadata-database-machine/x9m/exad-implementing-database-machine-x9m.pdf Search results: [1] Oracle Exadata Storage Server Patching [1][2]. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest Oracle... [2] Patching and Upgrades. Oracle Database Machine provides automated patching and upgrades for the full Exadata software stack, up to twice a year, with... [3] Virtualized Exadata. Oracle Database Machine X9M-2 comes with a choice of two patching approaches to accommodate different customer needs: Rolling... [4] Jan 10, 2017 ... Exadata Patching Process. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest...

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

• A. Backing up Exadata Storage Server Software is critical for restoration.
• B. For high availability, system area can be on the first two disks and M.2 devices.
• C. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
• D. 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.
• E. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.

Answer: D,E

NEW QUESTION # 44
......

Latest 1Z0-902 Exam Dumps - Valid and Updated Dumps: https://easypass.examsreviews.com/1Z0-902-pass4sure-exam-review.html