Actual 1Z0-902 Exam Recently Updated Questions with Free Demo
Free Oracle 1Z0-902 Exam Questions Self-Assess Preparation
Oracle 1z1-902 certification exam is an excellent way for IT professionals to demonstrate their knowledge and skills in implementing and managing the Oracle Exadata Database Machine X8M. Passing 1Z0-902 exam not only validates their expertise but also opens up new career opportunities and helps them stay competitive in the ever-evolving IT industry.
NEW QUESTION # 30
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. 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.
- 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. 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.
- 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,B
Explanation:
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 # 31
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- B. A single database with one or more schema per application
- C. Multiple Databases on a cluster
- D. Bare Metal deployment with one database per database server
- E. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- F. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
Answer: C,E,F
Explanation:
A Exadata supports multiple pluggable databases in one or more container databases, which enables database consolidation by allowing multiple databases to be consolidated into a single container database. This can be deployed on a Virtual Machine or Bare Metal cluster.
D Multiple databases spanning a Bare Metal and Virtual Machine cluster provide resource isolation and consolidation concurrently. It allows multiple databases to be deployed on both Bare Metal and Virtual Machine clusters, providing isolation and consolidation at the same time.
E Multiple Databases on a cluster allows multiple databases to be deployed on a single cluster, which enables consolidation of databases by reducing the number of clusters required.
NEW QUESTION # 32
Which two statements are true about enabling write-back flash cache?
- A. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
- B. When enabling write-back flash cache in a non-rolling manner, you need to drop the Persistent Memory Commit Accelerator (PMEMLog) first.
- C. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
- D. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
- E. Before write-back flash cache is enabled, you need to drop the Flash Cache first.
Answer: A,E
Explanation:
The two statements that are true about enabling write-back flash cache are:
When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
Before write-back flash cache is enabled, you need to drop the Flash Cache first.
The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "when enabling write-back flash cache in a rolling manner [1], grid disks need to be inactivated on all cells before enabling write-back flash cache". It also states that "before write-back flash cache can be enabled, the existing flash cache must be dropped".
NEW QUESTION # 33
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?
- A. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
- B. ZFS Snapshots can provide rapid cloning of development and test environment.
- C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
- D. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
Answer: C,D
NEW QUESTION # 34
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Disk Region Quarantine
- B. Cell Offload Quarantine
- C. Database Quarantine
- D. Manually created Quarantine
- E. SQL Plan Quarantine
Answer: C,E
NEW QUESTION # 35
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: A
Explanation:
According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1], patchmgr can be used to apply updates in a rolling manner while still maintaining database availability. It will apply patches in component groups consisting of 1 database server and 2 storage servers to minimize disruption. This is done by invoking patchmgr with the -rolling argument and specifying the component groups in the input file.
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. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- D. PMEM Pool Misses in the Exadata Outlier Summary
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
Answer: A,B
Explanation:
The AWR report has two sections that show statistics for X9M Persistent Memory Cache: the PMEM Cache section within Memory Statistics and the PMEM Cache section within Exadata Smart Statistics. Both of these sections provide detailed information about the read and write hits and misses, as well as the total capacity and utilization of the PMEM cache. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 515)
NEW QUESTION # 37
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. Run exachk and resolve only WARNINGS that you have not seen before.
- C. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- D. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- F. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
Answer: A,B,C,D
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:
A) Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
B) Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
C) Run exachk and resolve only WARNINGS that you have not seen before3.
D) Run the appropriate patchmgr preqequisite check step for each component being updated3.
NEW QUESTION # 38
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. The installation can go ahead, no change is required.
- B. The power cables from the servers to the PDUs can be rearranged inside the rack following OECA guidance to utilize a single PDU power cable.
- C. A splitter cable can be used to provide power to all PDU cables.
- D. The installation cannot proceed until two power feeds are available per PDU.
Answer: B
NEW QUESTION # 39
Examine this list of software components:
1. Oracle KVM Guest
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server(CELLSRV)
8. diskmon
9. Restart Server (RS)
10. Management Server (MS)
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?
- A. 1, 2, 3, 4, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
- B. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
- C. 1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
- D. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
- E. 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.
Answer: A
NEW QUESTION # 40
Which two activities are supported on the storage servers in an Exadata Database Machine?
- A. configuring secure shell user equivalency for the cellmonitor user
- B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- C. installing an alternative package manager
- D. changing the root password
- E. upgrading the Storage Server software package using rpm
Answer: A,D
Explanation:
According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:
1. changing the root password
2. configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html
NEW QUESTION # 41
You are planning the monitoring configuration for your Exadata X9M Database Machine.
Which three components are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins?
- A. Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers
- B. the Power Distribution Units (PDUs)
- C. the RDMA over Converged Ethernet (RoCE) switches
- D. the storage server ILOM
- E. Oracle clusterware on the database server
- F. ASM instances
Answer: A,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 # 42
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. Run exachk and resolve only WARNINGS that you have not seen before.
- C. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- D. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- F. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
Answer: A,B,C,D
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 # 43
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- B. Install in Oracle Virtual Machine with required hardware.
- C. Install on Oracle Database Appliance.
- D. Install on Exadata Engineered System.
- E. Provide individual x86 64-Bit gateway hardware.
Answer: A,D,E
Explanation:
These options are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources. The customer can choose to either provide their own x86 64-Bit gateway hardware or purchase the recommended hardware from Oracle, or they can install the gateway on an Exadata Engineered System.
NEW QUESTION # 44
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Provide individual x86 64-Bit gateway hardware.
- B. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- C. Install in Oracle Virtual Machine with required hardware.
- D. Install on Exadata Engineered System.
- E. Install on Oracle Database Appliance.
Answer: B,C,E
NEW QUESTION # 45
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 Storage server and install the MS APEX application.
- C. Install Oracle Rest Data Services on each Database server and install the MS APEX application.
- D. The MS Process on the storage servers is natively endowed with REST services, but are not enabled by default.
Answer: A
Explanation:
The MS process on Exadata storage servers is natively endowed with REST services and these services are enabled by default. However, it is important to create appropriate roles and users to ensure security when accessing these services. This way, it is possible to disable ssh access to the storage servers, and still enable REST access to the MS process. It's not necessary to install Oracle Rest Data Services on each Database or Storage server or install the MS APEX application, the MS process on the storage servers already have REST services by default.
NEW QUESTION # 46
......
Oracle Exadata Database Machine X8M is a high-performance database appliance that is designed to deliver superior performance, scalability, and availability for mission-critical databases. It combines the power of hardware and software to provide a complete solution for database management. The machine comes with a range of features, including high-speed networking, flash technology, and intelligent algorithms, which make it the ideal choice for organizations that require high-performance databases. The Oracle 1z1-902 exam is designed to test the candidate's knowledge and skills in working with the Oracle Exadata Database Machine X8M.
1Z0-902 Free Sample Questions to Practice One Year Update: https://www.dumps4pdf.com/1Z0-902-valid-braindumps.html
Download 1Z0-902 exam with Oracle 1Z0-902 Real Exam Questions: https://drive.google.com/open?id=11lxt3folkJgwdAjE670WmGtm5jptCmkZ