(Jul-2023) 1z1-902 Exam Dumps Contains FREE Real Quesions from the Actual Exam [Q22-Q42]

(Jul-2023) 1z1-902 Exam Dumps Contains FREE Real Quesions from the Actual Exam

Free Test Engine Verified By Oracle Engineered Systems Certified Experts

NEW QUESTION # 22
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. 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.
• C. 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. 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: A,D

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

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

Answer: A,C,D

Explanation:
It collects configuration information automatically (B). OCM gathers detailed configuration information about a variety of designated Oracle products and components across an enterprise on a regular basis2.
It collects configuration information on demand . OCM can also collect configuration information manually when requested by the user or by Oracle Support2.
Collected configuration information can be uploaded automatically to Oracle (E). OCM can upload the collected configuration information to My Oracle Support automatically for analysis and support purposes3.

NEW QUESTION # 24
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 the appropriate patchmgr preqequisite check step for each component being updated.
• C. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• D. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• 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,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:
1. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
2. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
3. Run exachk and resolve only WARNINGS that you have not seen before3.
4. Run the appropriate patchmgr preqequisite check step for each component being updated3.

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

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 # 26
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?

• A. 1, 2, 3, 4, 9 and 10 run on the database servers; 5, 6, 7, 8, 9, and 10 run on the Exadata storage servers.
• B. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
• C. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
• D. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
• E. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.

Answer: C

Explanation:
Oracle KVM Guest, Oracle Enterprise Manager Agent (OMA), RDBMS instance, Automatic Diagnostic Repository Command Interpreter (ADRCI), CELLCLI, diskmon, and Restart Server (RS) can all run on the database servers. The Cell Server (CELLSRV) and Management Server (MS) can both run on the Exadata storage servers. Specific instructions for installing and configuring these software components can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_software_components.html.

NEW QUESTION # 27
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 storage servers
• C. OS I/O metrics using Enterprise Manager host pages for the storage servers
• D. OS I/O metrics using OS tools such as iostat on the database servers
• E. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

Answer: D,E

Explanation:
The two monitoring tools that might be useful in examining I/O performance for the prod database are:
OS I/O metrics using OS tools such as iostat on the database servers.
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "I/O metrics can be collected from the database server using OS tools such as iostat [1], as well as from the storage servers using cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk". It also suggests using Enterprise Manager host pages for the storage servers to view OS I/O metrics.

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

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

Answer: C,D

Explanation:
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
1. changing the root password
2. configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html

NEW QUESTION # 29
Which statement is true about the patching features provided in Platinum Services?

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

Answer: C

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 # 30
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 databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
• C. A single database with one or more schema per application
• D. Multiple Databases on a cluster
• E. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
• F. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation

Answer: D,E,F

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

• A. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
• B. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
• C. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
• 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. Failed storage server updates are automatically rolled back to a previous release.

Answer: A,F

Explanation:
According to Oracle's documentation12, some of the statements that are true about applying updates on Exadata systems are:
Failed storage server updates are automatically rolled back to a previous release1.
When running a "yum update" for a new Exadata release, all other repositories should be disabled1.

NEW QUESTION # 32
Which statement is true about the patching features provided in Platinum Services?

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

Answer: A

NEW QUESTION # 33
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: B

NEW QUESTION # 34
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:

What steps and in which order should they be executed?

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

Answer: B

Explanation:
The steps and the order in which they should be executed to create an ACFS Filesystem for use as a staging area for data loads are:
asmcrad volcreate -G data -s 1024G acfs_dataload_vol : This command creates a new volume in the data diskgroup, with a size of 1024 GB, and named acfs_dataload_vol.
asmcmd vol info -G data acfs_dataload_vol | grep Device: This command will show the device name of the newly created volume
/usr/sbin/mkfs -t acfs /dev/asm/ac:fs_dataload_vol-123: This command creates a new ACFS filesystem on the volume created in step 1 sudo /u01/app/19.0.0.0/grid/bin/srvctl start filesystem -device /dev/asn/acfs_dataload_vol-123: This command starts the filesystem created in step 3 sudo chovn -R oracle:dba /mnt/acfs_dataload_vol: This command changes the ownership of the /mnt/acfs_dataload_vol to the oracle:dba user.
/sbin/acfsutil snap create -v data_load /mnt/acfs_dataload_vol: This command creates a snapshot of the filesystem to be used as a staging area.
acfsutil size +2S0G -d /dev/asm/acfs_dataload_vol-123 /mnt/acfs_dataload_vol/ : This command increases the size of the filesystem by 2GB
/u01/app/19-G.O-Q7grid/bin/srvctl add filesystem -device /dev/asm/acfs_dataload_vol-

NEW QUESTION # 35
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. Exadata storage realms using ASM-scoped security mode
• B. Exadata storage realms using database-scoped security mode
• C. File permissions on the griddisks in each database server
• D. Using EXADCLI instead of CELLCLI to create the griddisks
• E. File permissions on the griddisks in each storage server

Answer: A,E

Explanation:
When multiple databases share space on the storage servers in an unpartitioned storage grid, two Exadata security features can be configured to control which databases can access which griddisks.
Exadata storage realms using ASM-scoped security mode: This feature allows you to create storage realms and assign them to specific databases. This allows you to control which databases have access to which griddisks. The ASM-scoped security mode applies to all griddisks within an ASM disk group, which means that all griddisks in a disk group will be accessible only to the databases that belong to the assigned storage realm.
File permissions on the griddisks in each storage server: This feature allows you to configure file permissions on the griddisks at the storage server level. You can assign specific permissions to specific users or groups, allowing you to control which databases can access which griddisks.

NEW QUESTION # 36
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 helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
• C. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
• D. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
• E. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.

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 # 37
Which two statements are true in regards to starting the Exadata Virtual Machine?

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

Answer: D,E

Explanation:
Statement B is true as the vm_maker -start-domain command can be used to start a virtual machine manually, as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 65).
Statement E is also true as the vm_maker -auto-start command can be used to configure a virtual machine to start automatically when the KVM host is started [1][2], as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 66).

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

• A. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• B. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• C. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• D. Run the appropriate patchmgr preqequisite check step for each component being updated.
• E. Run exachk and resolve only WARNINGS that you have not seen before.
• 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,C,D

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

Answer: C

NEW QUESTION # 40
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 cannot proceed until two power feeds are available per PDU.
• D. The installation can go ahead, no change is required.

Answer: B

NEW QUESTION # 41
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?

• A. ASM instances
• B. the Power Distribution Units (PDUs)
• C. the RDMA over Converged Ethernet (RoCE) switches
• D. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
• E. the storage server ILOM
• F. Oracle clusterware on the database server

Answer: A,D,F

Explanation:
Exadata-specific Enterprise Manager Plug-Ins are used to monitor different components of the Exadata Database Machine.
1. ASM instances: The Automatic Storage Management (ASM) instances can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the storage space, disk usage, and performance of the ASM instances.
2. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers: The HCC ratios on Extended (XT) storage servers can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the compression ratios and performance of the storage servers.
3. Oracle clusterware on the database server: The Oracle clusterware on the database server can be monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins. This allows you to monitor the health and performance of the clusterware.

NEW QUESTION # 42
......

Upon passing the Oracle 1Z0-902 exam, candidates will receive the Oracle Exadata Database Machine X8M Implementation Essentials certification. This certification validates the candidate's knowledge and skills in implementing Exadata X8M and is recognized by employers worldwide. The certification holders can also access Oracle's Exadata support resources and participate in Oracle user groups.

 

Use Real Oracle Achieve the 1z1-902 Dumps - 100% Exam Passing Guarantee: https://troytec.test4engine.com/1z1-902-real-exam-questions.html