2023 Easily pass 1z1-902 Exam with our Dumps & PDF Test Engine [Q22-Q44]

2023 Easily pass 1z1-902 Exam with our Dumps & PDF Test Engine

1z1-902 PDF Pass Leader, 1z1-902 Latest Real Test

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

A. Patching is done automatically during business hours.
B. Patching services are available for the full software stack up to twice per year.
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: B

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

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

Answer: B,C,D

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 # 24
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?

A. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
B. alert logs for the prod database instances
C. alert logs for the ASM instances
D. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
E. alert logs for Enterprise Manager

Answer: B,C

Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources, you can find diagnostic messages related to this problem in the alert logs for the ASM instances and the alert logs for the prod database instances. The alert logs for the ASM instances will provide information related to the offline asm disks, while the alert logs for the prod database instances will provide information related to whether the prod database instances are connected to the ASM instance or not.

NEW QUESTION # 25
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

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

Answer: A,E

Explanation:
B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.
References for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.
Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Add Equipment: This input option allows you to allocate RU slots for ... [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Power Selection [1][2]: This input option allows you to select PDU power initially ... [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ...

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

A. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
B. Run the appropriate patchmgr preqequisite check step for each component being updated.
C. Run exachk and resolve only WARNINGS that you have not seen before.
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. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

Answer: A,B,D,F

Explanation:
For database servers, perform a server backup using patchmgr -dbnodes dblistfile -backup -rolling. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book . The other statement is false as exachk should not be used to resolve warnings or errors [1], but rather to identify them so that they can be addressed. Additionally, patchmgr should not be used with the --autofix, --autobackup, --upgrade, or --rolling flags as this could cause unexpected issues.

NEW QUESTION # 27
How do ASM failure groups provide redundancy?

A. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
B. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
C. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
D. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

Answer: B

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

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

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

Answer: A,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 # 30
Which three statements are true about the CELLCLI command?

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

Answer: B,C,E

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

NEW QUESTION # 31
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?

A. Download and run the latest exadiag tool.
B. Wait for a blue light to appear on the disk if the rebalance operation is running.
C. Ask the system administrator to replace the broken disk with a spare.
D. Call Oracle Support and make an appointment so that the drive can be replaced.
E. Wait for the email of the failure that Exadata or Enterprise Manager will send.
F. Check the database to see if any rebalance operations are active.

Answer: B

Explanation:
According to Oracle documentation1, Exadata Storage software has a complete set of automated operations for hard disk maintenance, when a hard disk has failed or has been flagged as a problematic disk. It will initiate a rebalance operation to redistribute data across other disks and mark the failed disk with an amber light.

NEW QUESTION # 32
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. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
C. Run exachk and resolve only WARNINGS that you have not seen before.
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. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.

Answer: A,D,E,F

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

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

Answer: A,C

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

A. hardware monitoring using the storage server ILOM
B. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
C. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
D. using the CELLCLI list LUN DETAIL command as the celladmin user

Answer: A,C

Explanation:
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 # 35
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 automatically to Oracle.
C. It is mandatory to install OCM on all database servers.
D. It collects configuration information automatically.
E. Collected configuration information can be uploaded manually to Oracle.
F. It is mandatory to install OCM on at least one database server.

Answer: B,C,F

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

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

Answer: A,D

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

Answer: A

Explanation:
According to Oracle's documentation1, the Cell Control Command-Line Interface (CellCLI) utility is the command-line administration tool for Oracle Exadata System Software. It can be used to perform various tasks on Exadata Storage Servers, such as creating and managing objects, monitoring performance, and configuring alerts.
To run CELLCLI commands on multiple cells simultaneously, you can use the Distributed Command-Line Interface (dcli) utility2. The dcli utility allows you to execute commands or scripts on a group of cells or hosts in parallel. You can use the dcli utility to copy files from one cell or host to multiple cells or hosts using the -f option3. You can also use the dcli utility to execute commands or scripts on multiple cells or hosts using the -l option to specify a user name and the -g option to specify a file containing a list of cells or hosts3.
Therefore, to achieve your requirement of running a script with several CELLCLI commands on each cell in your Exadata full rack simultaneously, you must:
Copy and execute the script on all storage servers using the dcli command.

NEW QUESTION # 38
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 with all database and storage servers listed in a single input file.
B. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
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: A

Explanation:
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 # 39
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 celldisk attributes name, deviceName, diskType, physicalFirmware
B. list cell attributes name, deviceName, diskType, physicalFirmware
C. list devices attributes name, deviceName, diskType, physicalFirmware
D. list physicaldisk attributes name, deviceName, diskType, physicalFirmware

Answer: A

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

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

Answer: D

NEW QUESTION # 41
Which three statements are true about the CELLCLI command?

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

Answer: B,C,E

Explanation:
The statements that are true about the CellCLI command are:
It has command-line history . According to 1, you can use the up and down arrow keys to scroll through previous commands that you entered in CellCLI . You can also use Ctrl+R to search for a previous command by entering part of it .
It can be executed on storage servers . According to 1, you can invoke CellCLI by logging in to the Exadata cell as cellmonitor , celladmin , or root user and typing "cellcli" . Within CellCLI , you can perform various management and monitoring tasks for the cell134.
It can be executed using the DCLI utility . According to 5, DCLI (distributed CLI) is another utility that can be used to execute scripts and commands across multiple storage cells from a single interface. You can use DCLI to run CellCLI commands on multiple cells at once54.

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

A. hardware monitoring using the storage server ILOM
B. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
C. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
D. using the CELLCLI list LUN DETAIL command as the celladmin user

Answer: A,C

NEW QUESTION # 43
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?

A. to the CELLADMIN account using cellcli interactively on each storage server
B. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
C. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
D. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
E. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
F. to the CELLMONITOR account using cellcli interactively on each storage server

Answer: B,E,F

NEW QUESTION # 44
......

Oracle Exadata Database Machine is a high-performance database appliance that is designed to run Oracle Database workloads. The machine combines hardware and software components to provide a fully integrated and optimized system for database processing. The Oracle Exadata Database Machine X8M Implementation Essentials exam, also known as the 1Z0-902 exam, is designed to test the knowledge and skills of professionals who are involved in the implementation of the Exadata Database Machine X8M.

1z1-902 Dumps Ensure Your Passing: https://www.practicevce.com/Oracle/1z1-902-practice-exam-dumps.html

Valid 1z1-902 Test Answers & 1z1-902 Exam PDF: https://drive.google.com/open?id=1oWDoyqMr5XoVv8EpUO2IEBgunIo0_RIj

Oracle 1z1-902 Certification Practice Exam

2023 Easily pass 1z1-902 Exam with our Dumps & PDF Test Engine [Q22-Q44]

Related Articles