Latest Oracle 1z1-902 PDF and Dumps (2023) Free Exam Questions Answers [Q20-Q43]

Latest Oracle 1z1-902 PDF and Dumps (2023) Free Exam Questions Answers

Pass Your Oracle Engineered Systems 1z1-902 Exam on Nov 21, 2023 with 60 Questions

NEW QUESTION # 20
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?

A. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.
B. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
C. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.

Answer: C

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

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

A. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
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 allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.

Answer: A,C

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

A. A splitter cable can be used to provide power to all PDU cables.
B. The installation cannot proceed until two power feeds are available per PDU.
C. The installation can go ahead, no change is required.
D. 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.

Answer: C

Explanation:
According to the Oracle Exadata Database Machine X9M-2 Data Sheet1, each PDU has two power input cables that can be connected to separate power sources for redundancy. However, if only one power source is available per PDU, then a single cable can be used to provide sufficient power for normal operation.
https://www.oracle.com/a/ocom/docs/engineered-systems/exadata/exadata-x9m-2-ds.pdf

NEW QUESTION # 23
You are hardening the security posture of your Exadata Database Machine. Before disabling ssh access to the storage servers, what should you do to enable REST access to the MS process?

A. The MS Process on the storage servers is natively endowed with REST services and are enabled by default, however, appropriate roles and users should be created to ensure security.
B. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
C. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
D. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.

Answer: C

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

Answer: D

NEW QUESTION # 25
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. using the CELLCLI list LUN DETAIL command as the celladmin user
B. using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
C. hardware monitoring using the storage server ILOM
D. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user

Answer: A,B

NEW QUESTION # 26
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. the storage server ILOM
B. the Power Distribution Units (PDUs)
C. ASM instances
D. the RDMA over Converged Ethernet (RoCE) switches
E. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
F. Oracle clusterware on the database server

Answer: C,E,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 # 27
Which two statements are true about the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers?

A. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
B. The sparse_<DBM_NAME> diskgroup is created automatically.
C. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
D. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
E. The DATA_<DBM_Name> and RECO_<DBM_NAME> ASM diskgroups are built on with DATA on the outer-most tracks and RECO on the inner-most tracks of the physical disk.

Answer: D,E

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

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

Answer: C,D

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 # 29
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.
Which two actions are NOT appropriate for that purpose?

A. You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.
B. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
D. You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

Answer: B,C

Explanation:
1. Querying VSSYSTEM_EVENTS for the event 'cell physical IO interconnect bytes returned by smart scan' will not be appropriate for monitoring the access on a particular table. The V$SYSTEM_EVENT view is used to monitor system-wide performance statistics, not specific table access. C. Querying v$SYSTAT for the statistic 'cell smart table scan' will not be appropriate for monitoring the access on a particular table as well. The v$SYSTAT view contains system-wide performance statistics, not specific table access.

NEW QUESTION # 30
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?

A. 0
B. 7,6,9,11
C. 10, 8, 2, 5
D. 4,1, 6, 9
E. 10, 8, 9, 11

Answer: E

Explanation:
The correct order of steps is 10, 8, 9, 11. The 10th step is to use the drop down to add Exadata X9M Database Servers, the 8th step is to use the drop down to add Exadata X9M EF Storage Servers, the 9th step is to use "Add Equipment" to add the ZFS Storage Controllers, and the 11th step is to use "Add Equipment" to add the ZFS Storage Trays. These steps are 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.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/configuring-exadata.html

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

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

Answer: C

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

A. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
B. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
C. ZFS Snapshots can provide rapid cloning of development and test environment.
D. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.

Answer: A,D

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 # 33
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

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

Answer: A,D

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

NEW QUESTION # 34
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 Virtual Machine clusters supporting a single database for greatest resource isolation
C. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
D. A single database with one or more schema per application
E. Bare Metal deployment with one database per database server
F. Multiple Databases on a cluster

Answer: C,D,F

Explanation:
According to Oracle.com documents or resources, the three options that are available for database consolidation on Exadata are:
A) Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster123.
C) A single database with one or more schema per application12.
E) Multiple Databases on a cluster12.
https://blogs.oracle.com/exadata/post/database-consolidation-why-and-how

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

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

Answer: D

Explanation:
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors

NEW QUESTION # 36
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

A. PMEM Cache section within Exadata Smart Statistics
B. PMEM Cache section within Memory Statistics
C. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
D. PMEM Pool Misses in the Exadata Outlier Summary
E. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary

Answer: B,C

Explanation:
The "cell PMEM cache Read Hits" in the "Database IOs" portion of the "Performance Summary" will show the number of reads that have been satisfied from the Persistent Memory Cache. The "PMEM Cache" section within "Memory Statistics" will give detailed information about the usage of the Persistent Memory Cache, such as cache size, used size, hit rate, etc. This information can help to identify if the Persistent Memory Cache is being used effectively and if there are any issues with it.

NEW QUESTION # 37
You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?

A. on all storage servers in both racks
B. on only one database server in both racks
C. on all database servers in the first rack
D. on at least two storage servers in both racks
E. on all database servers in the second rack
F. on all database servers in both racks and one storage server in each rack
G. on all database servers and at least two storage servers in both racks

Answer: D,G

Explanation:
In order to monitor all components of this multirack configuration, Enterprise Manager agents must be deployed on at least two storage servers in both racks and all database servers in both racks. This is according to the Oracle Exadata Database Machine X9M Implementation Essentials official text book [1], in which it states "To monitor all components of the multirack configuration, you must deploy agents on all database servers and at least two storage servers in each rack" (page 6-15).

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

Answer: B

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 # 39
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. Failed database server updates are rolled back to a working state on a previous release automatically.
C. Failed storage server updates are automatically rolled back to a previous release.
D. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
E. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
F. When running a "yum update" for a new Exadata release, all other repositories should be disabled.

Answer: A,B

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

Answer: A,C,D

NEW QUESTION # 41
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?

A. Manually created Quarantine
B. SQL Plan Quarantine
C. Disk Region Quarantine
D. Database Quarantine
E. Cell Offload Quarantine

Answer: B,E

Explanation:
A and E are the two correct quarantine types that can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine. A is correct because SQL Plan Quarantine will disable Smart Scan for all queries related to the SQL plan that was placed in the SQL Plan Quarantine [1]. E is correct because the Cell Offload Quarantine will disable Smart Scan for all queries offloaded to Oracle Database Exadata Storage Server Software [2]. The other statements (B, C, and D) are incorrect.
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 13 [1][2]: Oracle Database Exadata Storage Server Software [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book , Chapter 15 [1][2]: Oracle Database Exadata Storage Server Configuration

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

A. 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.
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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.

Answer: A,D

NEW QUESTION # 43
......

1z1-902 Dumps for Oracle Engineered Systems Certified Exam Questions and Answer: https://certlibrary.itpassleader.com/Oracle/1z1-902-dumps-pass-exam.html

Oracle 1z1-902 Certification Practice Exam

0 Happy Clients

0 Shares

0 Downloads

0 Years in Business

Latest Oracle 1z1-902 PDF and Dumps (2023) Free Exam Questions Answers [Q20-Q43]

Related Articles