Pass Your 1z1-902 Exam Easily - Real 1z1-902 Practice Dump Updated Jan 29, 2023
2023 Realistic Verified Free Oracle 1z1-902 Exam Questions
What are the benefits of obtaining Oracle Exadata Database Machine X9M Implementation Essentials Certification
When you work in a company, you need to have the Oracle 1Z0-902 certification to enhance your career prospects.
It shows you have the ability to solve problems. You can communicate with the customers and work closely with them.
The training of the Oracle 1Z0-902 certification is very convenient. You can take the training online, in a classroom, or at home. Oracle 1Z0-902 exam dumps will help you to save your time.
After taking the training, you can immediately test yourself. You can choose to test yourself via the practice test.
After passing the test, you can immediately receive the certificate. This is very easy to get.
NEW QUESTION 31
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- B. PMEM Pool Misses in the Exadata Outlier Summary
- C. PMEM Cache section within Exadata Smart Statistics
- D. PMEM Cache section within Memory Statistics
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
Answer: C,D
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 32
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?
- A. Add 24x 32GB DIMMs.
- B. Add 16x 64GB DIMMs.
- C. Add 12x 32GB DIMMs.
- D. Add 16x 32GB DIMMs.
- E. Add 12x 64GB DIMMs.
- F. Add 32x 64GB DIMMs.
- G. Remove existing memory modules.
- H. Shutdown the Database Server if running.
- I. Memory cannot be expanded on Exadata X9M-2 Database Servers.
Answer: B,D,G
NEW QUESTION 33
Which two statements are true about applying updates on Exadata systems?
- A. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- B. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
- C. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- D. Failed storage server updates are automatically rolled back to a previous release.
- E. Failed database server updates are rolled back to a working state on a previous release automatically.
- F. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
Answer: B,E
NEW QUESTION 34
Which two statements are true in regards to starting the Exadata Virtual Machine?
- A. Use vm_maker boot-from-iso command to boot a virtual machine.
- B. Use vm_maker -start-domain to start a virtual machine manually.
- C. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
- D. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
- E. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
Answer: A,D
NEW QUESTION 35
Which two statements are true about enabling write-back flash cache?
- A. Before write-back flash cache is enabled, you need to drop the Flash Cache 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. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.
- D. Write-back Flash Cache cannot be used on Extreme Flash Storage Servers.
- E. Write-back flash cache is on by default for High Capacity Storage Servers in High Redundancy configurations.
Answer: B,C
Explanation:
When enabling write-back flash cache in a rolling manner, it is important to use DBCLI to inactivate the grid disks on all cells first so that all the cells are in the same state before the process is started. In a non-rolling manner, you must drop the Persistent Memory Commit Accelerator (PMEMLog) first. Write-back flash cache is not on by default for High Capacity Storage Servers in High Redundancy configurations and can be used on Extreme Flash Storage Servers. It's also important to check if it's necessary to drop the flash cache before enabling write-back flash cache.
NEW QUESTION 36
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. The sparse_<DBM_NAME> diskgroup is created automatically.
- C. 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.
- D. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
- E. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
Answer: B,C
Explanation:
This is according to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1]. The other statements are false as there is no free space available on the hard disks inside the database servers for possible extension of the /uoi file system, and there is no free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes or to configure Exadata Smart Flash Logs [2][3].
NEW QUESTION 37
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. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- C. 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.
- D. 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.
Answer: B,D
NEW QUESTION 38
How do ASM failure groups provide redundancy?
- A. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
- B. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- C. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- D. 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.
Answer: D
Explanation:
Failure groups provide redundancy in Oracle Exadata Database Machine X9M by ensuring that mirror copies of the data are written to different storage servers [1][2]. This prevents the potential for mirror copies to be written to the same server, which would cause a data loss if that server were to experience a physical disk failure. Furthermore, failure groups help to ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster, providing an extra layer of data protection. Additionally, Extended Redundancy mirrors data across data centers, providing the highest levels of data protection. Reference: Oracle Exadata Database Machine X9M Implementation Essentials [1][2], Chapter 5: Configuring Oracle ASM.
NEW QUESTION 39
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. The sparse_<DBM_NAME> diskgroup is created automatically.
- B. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.
- C. There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
- 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 the hard disks inside the database servers for possible extension of the /uoi file system.
Answer: C,D
NEW QUESTION 40
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR can upload configuration metadata to support problem resolution.
- B. ASR Manager must be installed and configured on one of the database servers.
- C. Configuring ASR is mandatory for all Database Machine assets.
- D. ASR communicates with Oracle support services using HTTPS.
- E. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- F. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
Answer: D,F
Explanation:
A and F are true statements about Auto Service Request (ASR) with an Exadata Database Machine [1][2]. In order to use the ASR feature, ASR Manager must be installed and configured on a dedicated server which is external to the Database Machine, and it communicates with Oracle support services using HTTPS. Additionally, ASR can upload configuration metadata to support problem resolution, and it can open a service request (SR) automatically after sensors detect hardware faults.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2].
NEW QUESTION 41
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. It is mandatory to install OCM on all database servers.
- B. Collected configuration information can be uploaded manually to Oracle.
- C. It is mandatory to install OCM on at least one database server.
- D. It collects configuration information on demand.
- E. Collected configuration information can be uploaded automatically to Oracle.
- F. It collects configuration information automatically.
Answer: B,C,F
NEW QUESTION 42
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?
- A. Add 24x 32GB DIMMs.
- B. Add 16x 64GB DIMMs.
- C. Add 12x 32GB DIMMs.
- D. Shutdown the Database Server if running.
- E. Add 12x 64GB DIMMs.
- F. Add 32x 64GB DIMMs.
- G. Remove existing memory modules.
- H. Memory cannot be expanded on Exadata X9M-2 Database Servers.
- I. Add 16x 32GB DIMMs.
Answer: B,D,G
Explanation:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
NEW QUESTION 43
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 44
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- C. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
- D. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
Answer: B
Explanation:
1. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'" is valid command and it is used to list the historical values for metrics where the name starts with "DS_."
2. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " is valid command and it is used to list the current value of the metric named "DS_TEMP"
3. dbmcli -e "LIST IBPORT DETAIL" is valid command and it is used to list the InfiniBand ports and details of the Exadata X9M.
"dbmcli" is a command-line tool that is used to manage and monitor the Exadata Database Machine. It allows you to perform various tasks such as managing the database, storage, and network components, and monitoring the performance and health of the machine. The command "dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15" is not a valid command, it is not supported on Exadata X9M.
NEW QUESTION 45
You have been notified by your Network Administrator that an upstream switch has been replaced due to a hardware fault. Which command verifies that the client network on your Exadata X9M-2 Database Server is available via both client switches?
- A. /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all
- B. netstat -rn
- C. cat /proc/net/bonding/bondeth0
- D. ifconfig -a legrep "re0| re1"
Answer: A
Explanation:
The checkbadlinks.pl script is a tool provided with the Exadata X9M-2 Database Server that allows you to verify the status of the InfiniBand links between the Database Server and the client switches. This script checks for bad links, and it can be used to identify any issues with the client network connectivity. To use the script, you can navigate to the directory where it is located, which is /opt/oracle.SupportTools/ibdiagtools/ and execute the command ./checkbadlinks.pl -all. This will give you a summary of the status of the links and it will indicate if there are any bad links. This command will check the client network on your Exadata X9M-2 Database Server is available via both client switches. Other commands like ifconfig, netstat and cat are not relevant to check the client network on Exadata X9M-2 Database Server
NEW QUESTION 46
Which statement is true about the Persistent Memory Commit Accelerator?
- A. Persistent Memory Commit Accelerator contains logging information from all tiers of the software stack for rapid triage and diagnostics.
- B. Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk.
- C. Persistent Memory Commit Accelerator copies redo log data from disk for faster redo apply on Data Guard Standby Databases.
- D. Persistent Memory Commit Accelerator helps to further reduce redo log write latency by using Persistent Memory and Remote Direct Memory Access (RDMA).
- E. Persistent Memory Commit Accelerator tracks changes to Persistent Memory Data Accelerator to ensure duplicate blocks are not written to Flash.
Answer: B
Explanation:
Persistent Memory Commit Accelerator reduces redo log write latency by using Persistent Memory and RDMA before flushing to Flash then disk. This helps to further reduce redo log write latency by utilizing the speed and low latency of Persistent Memory, along with the Remote Direct Memory Access (RDMA) protocol, to commit changes to disk faster. This allows the system to quickly commit changes to disk, resulting in improved performance and reduced latency.
NEW QUESTION 47
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. changing the root password
- C. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
- D. installing an alternative package manager
- E. upgrading the Storage Server software package using rpm
Answer: B,D
NEW QUESTION 48
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?
- A. Install on Exadata Engineered System.
- B. Install on Oracle Database Appliance.
- C. Install in Oracle Virtual Machine with required hardware.
- D. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
- 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 49
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. OS I/O metrics using OS tools such as iostat on the database servers
- B. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
- C. 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 - D. OS I/O metrics using Enterprise Manager host pages for the storage servers
- E. OS I/O metrics using OS tools such as iostat on the storage servers
Answer: A,B
NEW QUESTION 50
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 CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
- C. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
- D. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
- E. Copy and execute the script on all storage servers using the EXACLI command.
Answer: A
NEW QUESTION 51
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. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
- B. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
- C. CellCLI alter GRIDDISK all inactive on the affected storage server
- D. shutdown -h now' 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: D
Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB
NEW QUESTION 52
Which are two correct statements about backing up Exadata Database Machine?
- A. For high availability, system area can be on the first two disks and M.2 devices.
- B. 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.
- C. Backup of the Oracle Cluster Registry, which also contains Voting Disk information, is automatically maintained on the file system of the first database server.
- D. Backing up Exadata Storage Server Software is critical for restoration.
- E. Use a snapshot-based backup of an Oracle Exadata Database Machine database server software.
Answer: C,D
Explanation:
[1] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 4: Oracle Clusterware [2] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 8: Oracle Exadata Storage Server Software [3] Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], Chapter 9: Oracle Exadata Storage Server Infrastructure
NEW QUESTION 53
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: C,D
Explanation:
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.
OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack, and it sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], OEDA deployment steps include setup, configure, deploy, and manage. The number of VMs in an Exadata rack is limited by the available resources in the rack, such as CPU, Memory, and Storage.
NEW QUESTION 54
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 must be invoked with the -rolling argument with all database and storage servers listed in a single input file.
- C. patchmgr cannot apply updates in a rolling manner, you must manually apply patches with the dbnodeudpate and cellupdate tools if high availability is required.
- D. patchmgr must be invoked with the -rolling argument. Each component type must be upgraded independently of the other.
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 55
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. The sparse_<DBM_NAME> diskgroup is created automatically.
- B. 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.
- 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. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
Answer: D,E
NEW QUESTION 56
......
1z1-902 Real Exam Questions and Answers FREE: https://www.vceprep.com/1z1-902-latest-vce-prep.html
1z1-902 Exam Questions | Real 1z1-902 Practice Dumps: https://drive.google.com/open?id=1nDF6bR54dxUCe9Mr7GnDJJURiajsIIbn