Pass Exam With Full Sureness – 1z1-902 Dumps with 62 Questions [Q27-Q51]

Published date September 13, 2023

Rate this post

Pass Exam With Full Sureness – 1z1-902 Dumps with 62 Questions

Verified 1z1-902 dumps Q&As – 100% Pass from PassTestking

NEW QUESTION 27
What are two recommended configuration best practices for backup and recovery on Exadata?

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.

Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

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.

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.

According to the Oracle Exadata Database Machine documentation12, two recommended configuration best practices for backup and recovery on Exadata are:
1. 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.
2. 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 28
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?

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

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

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

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

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

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.

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.

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.

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.

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 30
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?

OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.

There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.

OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.

OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.

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 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?

Exadata storage realms using ASM-scoped security mode

File permissions on the griddisks in each database server

Using EXADCLI instead of CELLCLI to create the griddisks

File permissions on the griddisks in each storage server

Exadata storage realms using database-scoped security mode

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 32
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

the failure of physical disk 1

corruption in the / (root) filesystem

the failure of both physical M.2 disks

the failure of physical disk 0 and 11

moving all disks from one cell to another as part of a chassis-level component failure

accidental loss of all data from all griddisks in a storage server

corruption in a normal or high redundancy ASM diskgroup

The two valid reasons are:
corruption in the / (root) filesystem . According to 1, this is one of the scenarios that requires a storage server rescue procedure , because it prevents the storage server from booting up normally . The rescue procedure will re-image the root filesystem with a fresh copy of the operating system and restore the configuration files from a backup1.
the failure of both physical M.2 disks . According to 2, each Exadata Storage Server X9M-2 has two physical M.2 disks that store the operating system and configuration files for the storage server . If both M.2 disks fail , then the storage server cannot boot up or function properly . The rescue procedure will replace the failed M.2 disks with new ones and re-image them with the operating system and configuration files2.

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

1536GB

512GB

2048GB

768GB

1024GB

384GB

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 34
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?

list celldisk attributes name, deviceName, diskType, physicalFirmware

list cell attributes name, deviceName, diskType, physicalFirmware

list physicaldisk attributes name, deviceName, diskType, physicalFirmware

list devices attributes name, deviceName, diskType, physicalFirmware

NEW QUESTION 35
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?

RoCE network interface cards in the storage servers

fans in the storage servers

Cisco RDMA over Converged Ethernet (RoCE) switches

RoCE network interface cards in the database servers

power distribution units

Cisco management switch

power supplies in the database servers

NEW QUESTION 36
Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?

using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user

using the CELLCLI CALIBRATE command on the storage server after logging in as the root user

hardware monitoring using the storage server ILOM

using the CELLCLI list LUN DETAIL command as the celladmin user

The CELLCLI CALIBRATE command can be used to check the health of all flash cards in the storage server, and it should be run after logging in as the celladmin user. The hardware monitoring using the storage server ILOM should also be used to check for errors and other potential issues with the flash cards. The CELLCLI list LUN DETAIL command should not be used to identify a damaged or failing flash card, since it will not provide any information about the health of the flash card.

NEW QUESTION 37
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?

The installation can go ahead, no change is required.

The installation cannot proceed until two power feeds are available per PDU.

A splitter cable can be used to provide power to all PDU cables.

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.

An Exadata Quarter Rack with 2 Database Servers and 3 HC Storage Servers and 3-phase 15kVA PDUs would typically require two power feeds per PDU, one for each of the two power distribution units (PDUs) in the rack. A single power feed per PDU is not sufficient to provide the necessary power to the servers and storage in the rack.
The installation cannot proceed until two power feeds are available per PDU. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], it is recommended that each PDU should have at least two power feeds from different power sources in the data center. This is to ensure redundancy and avoid any power interruption due to power failure on one of the power sources. Splitter cables are not recommended, as they can reduce efficiency and increase the risk of overheating. Rearranging the power cables within the rack is not recommended either, as it does not provide the necessary redundancy for the PDU.

NEW QUESTION 38
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?

CeLLCLI> alter cell shutdown SERVICES all on the affected storage server

CeLLCLI> list GRIDDISK where status != ‘inactive’ on the affected storage server

‘crsct1 stop cluster -all’ on one of the database servers

CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != ‘Yes’ on the affected Storage server

CellCLI alter GRIDDISK all inactive on the affected storage server

shutdown -h now’ on the affected storage server

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

It can execute commands on multiple storage servers in parallel.

It has command-line history.

It requires root privileges to create CELLDISKS and GRIDDISKS.

It can be executed on storage servers.

It can be executed using the DCLI utility.

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.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm

NEW QUESTION 40
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?

ASM instances

Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers

the storage server ILOM

the Power Distribution Units (PDUs)

Oracle clusterware on the database server

the RDMA over Converged Ethernet (RoCE) switches

According to Oracle’s documentation12, the components that are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins are:
The storage server ILOM2
The Power Distribution Units (PDUs)2
The RDMA over Converged Ethernet (RoCE) switches3

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

Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster

Bare Metal deployment with one database per database server

A single database with one or more schema per application

Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently

Multiple Databases on a cluster

Multiple Virtual Machine clusters supporting a single database for greatest resource isolation

Options A, D, and F are available for database consolidation on Exadata. Option A refers to the use of multiple pluggable databases in one or more container databases on either a Virtual Machine or Bare Metal cluster. Option D refers to the use of multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently. And finally, Option F refers to the use of multiple Virtual Machine clusters supporting a single database for greatest resource isolation. This is referenced in the Oracle Exadata Database Machine X9M Implementation Essentials Official Textbook, which is available online at https://docs.oracle.com/cd/E80437_01/E80437/html/index.html.

NEW QUESTION 42
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?

patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.

patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.

According to Oracle documentation12, patchmgr is the utility used to update software for Exadata infrastructure components. It can apply patches in a rolling or non-rolling manner depending on the argument and input file provided.

NEW QUESTION 43
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?

OS I/O metrics using Enterprise Manager host pages for the storage servers

OS I/O metrics using OS tools such as iostat on the database servers

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

cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk

OS I/O metrics using OS tools such as iostat on the storage servers

According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.
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 . These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.

NEW QUESTION 44
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?

4,3,2,6,1,7,5

3,2,6,4,1,7,5

2,3,4,6,1,7,5

3,2,6,1,4,7,5

2,6,1,4,3,7,5

NEW QUESTION 45
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?

6, 2, 1, 8, 4, 5

6, 8, 3, 4, 2, 1

6, 3, 1, 9, 7, 8

6, 1, 2, 7, 5, 8

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 46
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?

Replace the failed physical disk.

Add the griddisks back into the ASM diskgroup they used to be a member of.

Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.

Rebalance the data on the effected griddisks before performing a manual drop command.

Create a new celldisk and new griddisks on the replaced physical disk.

Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.

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 47
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?

list celldisk attributes name, deviceName, diskType, physicalFirmware

list cell attributes name, deviceName, diskType, physicalFirmware

list physicaldisk attributes name, deviceName, diskType, physicalFirmware

list devices attributes name, deviceName, diskType, physicalFirmware

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

NEW QUESTION 49
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?

patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.

patchmgr must be invoked with the -rolling argument with all database and storage servers listed in a single input file.

patchmgr will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption.

patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.

NEW QUESTION 50
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?

2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.

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.

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.

3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.

1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.

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 51
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?

5, 8, 7, and 6

4, 7, 8, 3, and 6

2, 8, 7, 3, and 6

2, 7, 8, and 6

1, 8, 7, 3 and 6

In order to power off an Exadata Database Machine in an orderly fashion, the commands should be executed in the following order: 1) Execute “crscti stop cluster -all” as the grid user from one database server; 2) Execute “shutdown -h now” on all database servers; 3) Power off all network switches; 4) Execute “shutdown -h now” on all Exadata storage servers; and 5) Power off the rack using the power switches on the PDUs. This sequence of commands ensures that all services running on the Exadata Database Machine are in a clean state before powering off the system. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 543)

Loading …

What are the objectives of the Oracle 1Z0-902 Exam?

The objectives of the Oracle 1Z0-902 Exam are to test the candidates’ abilities in designing and developing Oracle databases and most importantly, the Oracle1Z0-902 Exam is designed to evaluate the candidate’s skills in understanding and applying the Oracle Database Architecture.

This Oracle 1Z0-902 Exam is the most challenging certification for the Oracle Database developers. In addition, the Oracle 1Z0-902 Exam contains the highest demand and the most competitive market among other certifications. Oracle 1Z0-902 exam dumps are only way to pass the exam.

1z1-902 Dumps Full Questions – Exam Study Guide: https://www.passtestking.com/Oracle/1z1-902-practice-exam-dumps.html

Categories:1z1-902Oracle

Tags:1z1-902 guaranteed questions answers 1z1-902 high quality 1z1-902 latest exam questions pdf 1z1-902 reliable exam sample questions 1z1-902 reliable real test answer 1z1-902 Training Kit 1z1-902 valid test objectives pdf

admin

1z0-1106-2 / Oracle

Released Oracle 1z0-1106-2 Updated Questions PDF [Q11-Q28]
1z0-1003-22 / Oracle

1z0-1003-22 Exam Practice Questions prepared by Oracle Professionals [Q15-Q30]
1Z0-819 / Oracle

[Apr 01, 2022] Get New 1Z0-819 Certification – Valid Exam Dumps Questions [Q121-Q141]
1Z0-1064-21 / Oracle

[2022] Pass Oracle 1Z0-1064-21 Test Practice Test Questions Exam Dumps [Q20-Q44]
1Z0-819 / Oracle

Practice Examples and Dumps & Tips for 2023 Latest 1Z0-819 Valid Tests Dumps [Q20-Q42]
1Z0-340-21 / Oracle

Dumps Moneyack Guarantee – 1Z0-340-21 Dumps UpTo 50% Off [Q26-Q41]