1z1-902 Exam Questions Dumps, Selling Oracle Products
1z1-902 Cert Guide PDF 100% Cover Real Exam Questions
Oracle 1z1-902, also known as the Oracle Exadata Database Machine X8M Implementation Essentials exam, is a certification exam offered by Oracle. 1z1-902 exam is designed for IT professionals who want to demonstrate their knowledge and expertise in implementing and managing Oracle Exadata Database Machine technology. 1z1-902 exam covers a wide range of topics, including hardware components, software configuration, performance tuning, security, and backup and recovery.
NEW QUESTION # 29
How do ASM failure groups provide redundancy?
- A. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.
- B. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
- C. 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.
- D. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
Answer: B
Explanation:
According to Oracle's documentation12, ASM failure groups provide redundancy by storing mirror copies of data on different disks or storage servers. When ASM allocates an extent for a normal redundancy file, ASM allocates a primary copy and a secondary copy. ASM chooses the disk on which to store the secondary copy so that it is in a different failure group than the primary copy1. This way, if one disk or storage server fails, ASM can still access the data from another failure group2.
Therefore, the statement that is true about how ASM failure groups provide redundancy is:
Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
NEW QUESTION # 30
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,6,1,4,3,7,5
- B. 3,2,6,1,4,7,5
- C. 2,3,4,6,1,7,5
- D. 4,3,2,6,1,7,5
- E. 3,2,6,4,1,7,5
Answer: E
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 # 31
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
- A. PMEM Cache section within Exadata Smart Statistics
- B. PMEM Pool Misses in the Exadata Outlier Summary
- C. PMEM Cache section within Memory Statistics
- D. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
- E. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
Answer: A,C
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 two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?
- A. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
- B. Configuring ASR is mandatory for all Database Machine assets.
- C. ASR can upload configuration metadata to support problem resolution.
- D. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- E. ASR communicates with Oracle support services using HTTPS.
- F. ASR Manager must be installed and configured on one of the database servers.
Answer: A,D
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. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.
- C. Run the appropriate patchmgr preqequisite check step for each component being updated.
- D. Run patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- E. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- F. Run exachk and resolve only WARNINGS that you have not seen before.
Answer: A,C,D,E
NEW QUESTION # 34
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. 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
- B. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
- C. OS I/O metrics using OS tools such as iostat on the storage servers
- 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 database servers
Answer: A,B
Explanation:
According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:
cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.
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 . These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.
NEW QUESTION # 35
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 LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server
- B. 'crsct1 stop cluster -all' on one of the database servers
- C. shutdown -h now' on the affected storage server
- D. CellCLI alter GRIDDISK all inactive on the affected storage server
- E. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
- F. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
Answer: C,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 # 36
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. Install Oracle Rest Data Services on each Storage server and install the MS APEX application.
- B. 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.
- 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 Database 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 # 37
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 entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- C. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- D. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- E. The incline of any access route ramp must be less than or equal to 6 degrees.
- F. Oracle Exadata Rack may only be installed on raised floor environments.
Answer: C
NEW QUESTION # 38
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, 8 and 9 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, 5, 8, 9 and 10 run on the database servers; 5, 6,7, 9 and 10 run on the Exadata storage servers.
- D. 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.
- E. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.
Answer: C
Explanation:
Oracle KVM Guest: This is a virtual machine that runs on top of Oracle Linux KVM hypervisor. It can be used to run Oracle Database or other applications on Exadata Database Machine2. Therefore, it runs on the Database Servers.
Oracle Enterprise Manager Agent (OMA): This is a software agent that communicates with Oracle Enterprise Manager Cloud Control and provides monitoring and management capabilities for Exadata Database Machine2. Therefore, it runs on both Database Servers and Storage Servers.
ASM instance: This is an instance of Oracle Automatic Storage Management (ASM), which is a volume manager and a file system for Oracle Database files. It manages disk groups that span across multiple Storage Servers2. Therefore, it runs on the Database Servers.
RDBMS instance: This is an instance of Oracle Database that processes SQL statements and executes transactions. It uses ASM disk groups to store data files, control files, redo log files, etc2. Therefore, it runs on the Database Servers.
Automatic Diagnostic Repository Command Interpreter (ADRCI): This is a command-line tool that enables you to view diagnostic data stored in the Automatic Diagnostic Repository (ADR). ADR is a file-based repository for database diagnostic data such as trace files, alert logs, etc2. Therefore, ADRCI runs on both Database Servers and Storage Servers, depending on where the ADR is located.
CELLCLI: This is a command-line interface that enables you to configure and manage Exadata Storage Server Software. It allows you to perform tasks such as creating disk groups, monitoring cell health, applying patches, etc2. Therefore, it runs on the Storage Servers.
Cell Server(CELLSRV): This is a process that runs on each Storage Server and handles I/O requests from the Database Servers. It implements Exadata Smart Scan , which offloads data-intensive SQL operations from the Database Servers to the Storage Servers2. Therefore, it runs on the Storage Servers.
diskmon: This is a process that monitors the status of disks and flash devices on each Storage Server. It reports disk failures and performs automatic disk reclamation2. Therefore, it runs on the Storage Servers.
Restart Server (RS): This is a process that manages automatic restarts of critical processes such as CELLSRV , MS , or OMA in case of failures. It also handles graceful shutdowns and startups of all processes on each server2. Therefore, it runs on both Database Servers and Storage Servers.
Management Server (MS): This is a process that provides management services for each server such as collecting metrics , logging events , executing commands from CELLCLI , etc2. Therefore, it runs on both Database Servers and Storage Servers
NEW QUESTION # 39
An Exadata storage server physical disk on an X9M-2 high-capacity full rack entered the predictive failure state. Which two steps must you perform to replace this failed physical disk?
- A. Rebalance the data on the effected griddisks before performing a manual drop command.
- B. Create a new celldisk and new griddisks on the replaced physical disk.
- C. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- D. Replace the failed physical disk.
- E. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- F. Add the griddisks back into the ASM diskgroup they used to be a member of.
Answer: A,D
NEW QUESTION # 40
Which two statements are true in regards to starting the Exadata Virtual Machine?
- A. To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.
- B. Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started.
- C. Use vm_maker -start-domain to start a virtual machine manually.
- D. Use vm_maker boot-from-iso command to boot a virtual machine.
- E. To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.
Answer: B,C
Explanation:
Statement B is true as the vm_maker -start-domain command can be used to start a virtual machine manually, as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 65).
Statement E is also true as the vm_maker -auto-start command can be used to configure a virtual machine to start automatically when the KVM host is started [1][2], as stated in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 66).
NEW QUESTION # 41
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. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
- C. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
- D. ZFS Snapshots can provide rapid cloning of development and test environment.
Answer: A,B
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.
NEW QUESTION # 42
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 flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs.
- C. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
- 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. The sparse_<DBM_NAME> diskgroup is created automatically.
Answer: D,E
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 # 43
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 512GB
- B. 1024GB
- C. 768GB
- D. 384GB
- E. 2048GB
- F. 1536GB
Answer: E
Explanation:
The Exadata X9M-2 Database Machine uses powerful database servers, each with two 32-core x86 processors and 512 GB of memory (expandable up to 2 TB).
NEW QUESTION # 44
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 CALIBRATE command on the storage server after logging in as the celladmin user
- B. hardware monitoring using the storage server ILOM
- C. using the CELLCLI list LUN DETAIL command as the celladmin user
- D. using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
Answer: A,B
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.
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/index.html
NEW QUESTION # 45
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
- B. dbmcli -e "LIST IBPORT DETAIL"
- C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
- D. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
Answer: A
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 # 46
Which three of the following options are available for database consolidation on Exadata?
- A. Multiple Databases on a cluster
- B. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
- C. A single database with one or more schema per application
- D. Multiple databases spanning a Bare Metal and Virtual Machine cluster to provide resource isolation and consolidation concurrently
- E. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
- F. Bare Metal deployment with one database per database server
Answer: A,B,C
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 # 47
You are going to create an ACFS Filesystem for use as a staging area for data loads. Examine the following commands:
What steps and in which order should they be executed?
- A. 6, 1, 2, 7, 5, 8
- B. 6, 8, 3, 4, 2, 1
- C. 6, 3, 1, 9, 7, 8
- D. 6, 2, 1, 8, 4, 5
Answer: C
NEW QUESTION # 48
......
Oracle 1z1-902 exam consists of 60 multiple-choice questions that must be completed within 105 minutes. To pass the exam, candidates must achieve a score of 63% or higher. 1z1-902 exam is available in multiple languages and can be taken at authorized testing centers or online.
Pass 1z1-902 Exam - Real Questions and Answers: https://www.testvalid.com/1z1-902-exam-collection.html
Pass 1z1-902 Review Guide, Reliable 1z1-902 Test Engine: https://drive.google.com/open?id=1GWY-fm9vfvFG7ofhKuJAC9bvc5AyMshj