Pass Your Oracle Exam with 1Z0-902 Exam Dumps (Updated 87 Questions) [Q17-Q36]

Pass Your Oracle Exam with 1Z0-902 Exam Dumps (Updated 87 Questions)

1Z0-902 Exam Dumps - Oracle Practice Test Questions

To pass the Oracle 1Z0-902 exam, candidates must have a deep understanding of the Exadata Database Machine X8M architecture and its components, including the hardware, software, and networking components. They must also be proficient in database administration, performance tuning, backup and recovery, and security. 1Z0-902 exam consists of 70 multiple-choice questions, and candidates have 105 minutes to complete it. Upon passing the exam, candidates will be awarded the Oracle Exadata Database Machine X8M Implementation Specialist certification, which is highly respected in the industry and recognized by top employers around the world.

Oracle 1Z0-902 exam is a multiple-choice exam consisting of 60 questions. 1Z0-902 exam duration is 105 minutes, and candidates must score at least 63% to pass the exam. 1Z0-902 exam can be taken online or at an authorized testing center. Candidates can register for the exam on the Oracle website and pay the exam fee.

Oracle 1Z0-902 exam is designed to test the knowledge and skills of professionals who implement and manage the Oracle Exadata Database Machine X8M. Oracle Exadata Database Machine X8M Implementation Essentials certification exam is part of the Oracle Certified Specialist program and is a requirement for individuals who want to become Oracle Exadata Database Machine X8M Implementation Specialists.

 

NEW QUESTION # 17
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?

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

Answer: D

Explanation:
The correct sequence is:
Review the safety guidelines. This is important to ensure a safe and successful installation1.
Unpack Oracle Exadata Rack. This involves removing the packaging materials and inspecting the rack for damage or missing components1.
Place Exadata in its allocated space. This involves moving the rack to its final location and securing it with bolts and brackets1.
Let the Exadata acclimatize for 24 hours. This is recommended to allow the rack components to adjust to the ambient temperature and humidity before powering on1.
Stabilize the Exadata Rack. This involves leveling the rack and adjusting its height if needed1.
Power on Exadata PDU B. This involves connecting PDU B to a power source and turning it on1.
Power on Exadata PDU A. This involves connecting PDU A to a power source and turning it on1

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

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

Answer: B,C

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

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

Answer: B,C,E

NEW QUESTION # 20
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 query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
• 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$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
• D. 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.

Answer: A,B

Explanation:
A) YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan12.
C) You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session12.
https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/

NEW QUESTION # 21
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?

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

Answer: E

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

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

Answer: A,C,F

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

• A. power distribution units
• B. RoCE network interface cards in the database servers
• C. Cisco management switch
• D. Cisco RDMA over Converged Ethernet (RoCE) switches
• E. fans in the storage servers
• F. RoCE network interface cards in the storage servers
• G. power supplies in the database servers

Answer: A,D,F,G

Explanation:
According to the Oracle Auto Service Request (ASR) documentation1, ASR raises service requests for qualified Oracle products that are detected with specific faults. The qualified Exadata products include2:
Database servers
Storage servers
InfiniBand switches
Cisco switches (X8M and later systems)
Power distribution units (PDUs)

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

• A. Collected configuration information can be uploaded automatically to Oracle.
• B. It collects configuration information automatically.
• C. It is mandatory to install OCM on all database servers.
• D. It collects configuration information on demand.
• 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,E,F

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

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

Answer: C

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

NEW QUESTION # 26
Which statement is true about the disks that are used in ASM diskgroups on the Exadata platform?

• A. Sparse diskgroups are virtual objects allocated from the DATA diskgroup.
• B. Extreme Flash (EF) and High Capacity (HC) disks can be mixed to any capacity within the same diskgroup.
• C. If High redundancy is selected, grid disks from the primary and secondary Exadata Database Machine must be specified.
• D. In an Exadata storage server, each disk is placed into a separate failure group.
• E. The grid disks in ASM diskgroups must have similar performance characteristics in addition lo having the same size.

Answer: E

Explanation:
On Exadata systems, ASM disk group configurations require that:
Grid Disks Must Have Similar Performance Characteristics: Within a disk group, grid disks must not only be of the same size but also need to exhibit similar performance traits. This consistency ensures balanced I/O operations and optimizes the performance for ASM mirroring and striping across disks.
Sparse Diskgroups: These are specialized virtual objects that reside within the DATA disk group. Sparse diskgroups are used to support snapshots and other space-efficient storage solutions by creating virtual representations of grid disks within an existing disk group without consuming additional physical space.
These characteristics are fundamental to ensuring that ASM maintains optimal performance and storage efficiency on Exadata platforms.

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 flashdisks inside the Exadata storage servers for possible use for storage indexes.
• B. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
• C. The sparse_<DBM_NAME> diskgroup is created automatically.
• D. 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.
• E. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.

Answer: A,E

Explanation:
According to the Oracle Exadata Database Machine Technical Architecture1, the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers includes two ASM disk groups: DATA_<DBM_Name> and RECO_<DBM_NAME>. These disk groups are built on hard disks and flash disks inside the Exadata Storage Servers1.
The correct statements about this configuration are:
Option D: There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes. Storage indexes are a feature of Exadata Storage Software that can improve query performance by avoiding unnecessary I/O operations. Storage indexes use a small amount of flash memory to store metadata about data blocks stored on disk1.
Option E: There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs. Exadata Smart Flash Logs are another feature of Exadata Storage Software that can improve database performance by using flash memory as an extension of the database redo log buffer. This can reduce latency and increase throughput for redo log writes1.

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

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

Answer: A,B,C,E

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

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

Answer: A,B

Explanation:
Exadata Database Machine is a preconfigured and optimized for database workloads. The storage servers in an Exadata Database Machine are used to store database data, and support activities such as upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure and upgrading the Storage Server software package using rpm. These activities are related to maintain the storage servers performance and security. Changing the root password, installing an alternative package manager, and configuring secure shell user equivalency for the cellmonitor user are activities that can be performed on any Linux machine, but they are not specific to Exadata Database Machine.

NEW QUESTION # 30
You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

• A. No thresholds need to be set because they are preset in the ILOM and in Enterprise Manager
• B. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.
• C. Set thresholds in ILOM and in Enterprise Manager because they are not preset anywhere and must be set in both places.
• D. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.

Answer: A

Explanation:
For Exadata systems, hardware monitoring for components like the motherboard, memory, power, fans, and network cards on the database nodes is managed through the Integrated Lights Out Manager (ILOM). The ILOM provides built-in thresholds and sensor readings that are automatically recognized by Oracle Enterprise Manager.
These thresholds and alerts are already configured within ILOM for Exadata components, ensuring seamless integration with Enterprise Manager for alerting and monitoring purposes.
Enterprise Manager uses these pre-set ILOM thresholds and does not require additional configuration for monitoring hardware components. Therefore, administrators benefit from preset alerting mechanisms that are sufficient for comprehensive hardware status visibility.

NEW QUESTION # 31
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:
1. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine2.
2. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA2.

NEW QUESTION # 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. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
• C. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
• D. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
• E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
• F. Run exachk and resolve only WARNINGS that you have not seen before.

Answer: A,B,D,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 # 33
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?

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

Answer: A,B,C,E

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 # 34
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 query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
• 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$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.
• D. 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.

Answer: A,B

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 # 35
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?

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

Answer: C,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 # 36
......

New Real 1Z0-902 Exam Dumps Questions: https://drive.google.com/open?id=1IxPmVvrA9mGIGLqfHtvAPnLpjlTcPfL-

Pass Your 1Z0-902 Exam Easily with Accurate PDF Questions: https://www.prep4sureexam.com/1Z0-902-dumps-torrent.html