Which two activities are supported on the storage servers in an Exadata Database Machine?
A. changing the root password
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. upgrading the Storage Server software package using rpm
E. configuring secure shell user equivalency for the cellmonitor user
Correct Answer: AE
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:
A. changing the root password
E. configuring secure shell user equivalency for the cellmonitor user
Which statement is true about the patching features provided in Platinum Services?
A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
B. Patching services are available for the full software stack up to twice per year.
C. The rolling and complete down time approaches are two options to patching.
D. Patching is done automatically during business hours.
Correct Answer: B
Explanation: Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.
The correct statement about the patching features provided in Platinum Services is that patching services are available for the full software stack up to twice per year. Oracle Platinum Service covers Exadata storage software and firmware patching, and customers must also perform the database patching. The rolling and complete down time approaches are two options for patching, and patching should be scheduled for times when the system is not being heavily used. Patching is not done automatically during business hours. This is covered in section 4.13 of the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1]. [1] https://docs.oracle.com/en/ engineered-systems/exadata-database-machine/x9m/exad- implementing-database-machine-x9m.pdf Search results: [1] Oracle Exadata Storage Server Patching [1][2]. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest Oracle... [2] Patching and Upgrades. Oracle Database Machine provides automated patching and upgrades for the full Exadata software stack, up to twice a year, with... [3] Virtualized Exadata. Oracle Database Machine X9M-2 comes with a choice of two patching approaches to accommodate different customer needs: Rolling... [4] Jan 10, 2017 ... Exadata Patching Process. Oracle Exadata Storage Server patching is performed by a team of Oracle engineers [3][2], and includes the latest...
Question 13:
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. 4,3,2,6,1,7,5
B. 3,2,6,4,1,7,5
C. 2,3,4,6,1,7,5
D. 3,2,6,1,4,7,5
E. 2,6,1,4,3,7,5
Correct Answer: B
Explanation: The correct sequence is: uk.co.certification.simulator.questionpool.PList@da89390 uk.co.certification.simulator.questionpool.PList@da893e0 uk.co.certification.simulator.questionpool.PList@da89430 uk.co.certification.simulator.questionpool.PList@da894b0 uk.co.certification.simulator.questionpool.PList@da89500
Question 14:
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, 2, 1, 8, 4, 5
B. 6, 8, 3, 4, 2, 1
C. 6, 3, 1, 9, 7, 8
D. 6, 1, 2, 7, 5, 8
Correct Answer: A
Explanation: The steps and the order in which they should be executed to create an ACFS Filesystem for use as a staging area for data loads are: asmcrad volcreate -G data -s 1024G acfs_dataload_vol : This command creates a new volume in the data diskgroup, with a size of 1024 GB, and named acfs_dataload_vol. asmcmd vol info -G data acfs_dataload_vol | grep Device: This command will show the device name of the newly created volume /usr/sbin/mkfs -t acfs /dev/asm/ac:fs_dataload_vol-123: This command creates a new ACFS filesystem on the volume created in step 1 sudo /u01/app/19.0.0.0/grid/bin/srvctl start filesystem -device /dev/asn/acfs_dataload_vol-123: This command starts the filesystem created in step 3 sudo chovn -R oracle:dba /mnt/acfs_dataload_vol: This command changes the ownership of the /mnt/acfs_dataload_vol to the oracle:dba user. /sbin/acfsutil snap create -v data_load /mnt/acfs_dataload_vol: This command creates a snapshot of the filesystem to be used as a staging area. acfsutil size +2S0G -d /dev/asm/acfs_dataload_vol-123 /mnt/acfs_dataload_vol/ : This command increases the size of the filesystem by 2GB /u01/app/19-G.O-Q7grid/bin/srvctl add filesystem -device /dev/asm/acfs_dataload_vol-
What is the correct location where these software components can run in the standard Exadata Database Machine deployment?
A. 2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.
B. 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.
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. 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, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers.
Correct Answer: C
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 diskgroups 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
Question 16:
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' "
C. dbmcli -e "LIST IBPORT DETAIL"
D. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
Correct Answer: C
Explanation: The dbmcli -e "LIST IBPORT DETAIL" command is not valid on Exadata X9M. According to the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book [1][2], this command is only valid on Exadata X3 and X4 models. The other three commands are valid on Exadata X9M. https://forums.oracle.com/ords/apexds/map/tech/apps- infra/discussion/4342715/monitoring-roce-performance
Question 17:
You are concerned about the operating temperature of the database servers in your Exadata Full Rack and want to be alerted if the server exceeds 30C. What command should use use to generate alerts for such an event?
A. dbmcli -e "set alert ds_temp> 30" on each database server
B. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
C. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
D. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
Correct Answer: D
Explanation: According to Oracle's documentation1, to set a threshold for a metric on a database server, you need to use the create threshold command with the appropriate parameters. The set threshold command is used to modify an existing threshold2. Therefore, the command that you should use to generate alerts for such an event is: dbmcli -e "create threshold ds_temp comparison=`>', critical=30" on each database server1
Question 18:
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. Replace the failed physical disk.
B. Add the griddisks back into the ASM diskgroup they used to be a member of.
C. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
D. Rebalance the data on the effected griddisks before performing a manual drop command.
E. Create a new celldisk and new griddisks on the replaced physical disk.
F. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
Correct Answer: AC
Explanation: Once the physical disk has been replaced, you will need to create a new celldisk and griddisks on the replaced physical disk. After the griddisks have been dropped from the associated ASM diskgroups, you can then add the griddisks back into the ASM diskgroup they used to be a member of and rebalance the data on the effected griddisks. Finally, you should verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
Question 19:
Which three of the following options are available for database consolidation on Exadata?
A. Multiple pluggable databases in one or more container databases on a Virtual Machine or Bare Metal cluster
B. Bare Metal deployment with one database per database server
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 Databases on a cluster
F. Multiple Virtual Machine clusters supporting a single database for greatest resource isolation
Correct Answer: ACE
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
Question 20:
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?
A. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 --from _17:00:00 --to _23:59:00
B. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm --from _17:00:00 --to _23:59:00
C. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh --from _17:00:00 --to _23:59:00
D. # /opt/oracle.SupportTools/exachk/exachk --from _17:00:00 --to _23:59:00
Correct Answer: ABCD
Explanation: To investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend, you can use the GetExaWatcherResults.sh script to collect and analyze ExaWatcher data for
a specified time range1.
Therefore, the command that you should use to investigate this is:
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-902 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.
