Updated Aug 27, 2022 Certification Exam 1Z0-902 Dumps - Practice Test Questions
Updated Verified 1Z0-902 dumps Q&As - Pass Guarantee or Full Refund
Target Audience of Oracle 1Z0-902 Exam
The target audience for this certification exam include:
Analyst/consultant: This candidate needs to have experience in business intelligence and data warehousing technologies and practices. These candidates will be expected to help other people with their careers by using these tools.
Information architect: This candidate needs to have experience designing enterprise portals and intranet sites, as well as designing web applications and databases for small businesses, medium-sized companies and large enterprises. They will also be expected to create custom applications based on these applications' specifications.
Database administrator: This candidate needs experience in administering large databases at various levels of scale (small-medium-large). They will be expected to manage these databases effectively according to deadlines set by their employers or clients within an organization's budget constraints.
NEW QUESTION 29
What are two recommended configuration best practices for backup and recovery on Exadata?
- A. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
- B. 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.
- C. 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.
- D. 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.
Answer: A,B
NEW QUESTION 30
You have configured a multirack Database Machine with two X9M-8 full racks all in a single cluster and storage grid comprising a total of 4 X9M-8 Database servers and 28 X9M-8 Storage servers.
Which two options are true regarding the servers on which Enterprise Manager agents must be deployed in order to monitor all components of this multirack configuration?
- A. on all database servers in both racks and one storage server in each rack
- B. on only one database server in both racks
- C. on all database servers and at least two storage servers in both racks
- D. on all database servers in the second rack
- E. on all storage servers in both racks
- F. on at least two storage servers in both racks
- G. on all database servers in the first rack
Answer: E,G
NEW QUESTION 31
How is Exadata Secure RDMA Fabric isolation used in X9M-2 with virtualization enabled?
- A. With Secure Fabric isolation, each Database VM Cluster uses a dedicated network partition and VLAN ID for Data Guard networking between the primary and disaster recovery Exadata racks. This improves security by isolating data guard traffic onto an encrypted network between data centers.
- B. With Secure Fabric isolation, each Database VM Guest uses a dedicated network partition and VLAN ID for client networking between application servers. This improves security by preventing man in the middle attacks.
- C. With Secure Fabric isolation, each Storage Server runs multiple KVM guests each dedicated to a Database VM cluster using a dedicated network partition and VLAN ID. This provides security and isolation between multiple tenants or VM clusters.
- D. With Secure Fabric isolation, each Database VM cluster uses a dedicated network partition and VLAN ID for cluster networking between the database servers in the VM Cluster. This provides security and isolation between multiple tenants or VM clusters.
Answer: D
NEW QUESTION 32
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:
How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?
- A. 7 consisting of 12 griddisks each
- B. 96 consisting of one griddisk each
- C. 0 because the new griddisks will be added to the existing faiigroups
- D. 1 consisting of all 96 griddisks
- E. 12 consisting of seven griddisks each
Answer: E
NEW QUESTION 33
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. Configuring ASR is mandatory for all Database Machine assets.
- C. ASR communicates with Oracle support services using HTTPS.
- D. ASR Manager must be installed and configured on one of the database servers.
- E. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
- F. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
Answer: D,E
NEW QUESTION 34
What is the minimum Oracle Linux version required to support RoCE and Persistent Memory?
- A. Oracle Linux 6.9
- B. Oracle Linux 7.5
- C. Oracle Linux 7.7
- D. Oracle Linux 8.0
Answer: B
NEW QUESTION 35
Your customer needs to ensure that their data is available on the Exadata machine during updates. The customer wants to be able to update one server at a time but still be protected against single-node server failure.
What ASM redundancy level should they use?
- A. High
- B. Normal
- C. External
- D. Sparse
- E. Extended
Answer: A
Explanation:
https://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf
NEW QUESTION 36
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. 3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 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, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 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: C
NEW QUESTION 37
Which dbmcli command is NOT valid on Exadata X9M?
- A. dbmcli -e "LIST IBPORT DETAIL"
- B. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' " - C. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
Answer: C
NEW QUESTION 38
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. fans in the storage servers
- B. RoCE network interface cards in the database servers
- C. power distribution units
- D. Cisco management switch
- E. RoCE network interface cards in the storage servers
- F. power supplies in the database servers
- G. Cisco RDMA over Converged Ethernet (RoCE) switches
Answer: D,E,F,G
NEW QUESTION 39
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 VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.
- B. 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'.
- C. 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.
- D. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
Answer: A,B
NEW QUESTION 40
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 1024GB
- B. 512GB
- C. 384GB
- D. 1536GB
- E. 2048GB
- F. 768GB
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 41
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?
- A. -> start /SP/console
- B. -> start /System
- C. -> start /SYS/power
- D. -> start /SYSTEM/power
- E. -> set /SYS power_state=ON
- F. You must be physically present in the data center to start an Exadata Storage Server.
Answer: B
NEW QUESTION 42
You use Enterprise Manager to monitor all the components of your Exadata Database Machine.
Recently, you discovered that certain asmdisks were offline in one of the diskgroups used by the rac database called prod.
In which two sources would you find diagnostic messages related to this problem?
- A. alert logs for the ASM instances
- B. alert logs for Enterprise Manager
- C. Enterprise Manager Alerts on the ILOM home page for cell connectivity problems for the prod database instances
- D. alert logs for the prod database instances
- E. Enterprise Manager Alerts on the Exadata Storage Server Grid home page
Answer: C,E
NEW QUESTION 43
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 the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI 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 and execute the script on all storage servers using the dcli command.
- D. Copy and execute the script on all storage servers using the EXACLI command.
- E. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
Answer: D
NEW QUESTION 44
Which two statements are false about backup to ZFS Storage Appliance (ZFSSA)?
- A. ZFSSA may connect directly to the Exadata 100Gb RoCE network switches.
- B. When backing up multi-rack systems, sharing Exadata X9M switches is recommended.
- C. ZFS Snapshots can provide rapid cloning of development and test environment.
- D. Top of Rack (ToR) switches are managed as part of the hardware stack and software levels are upgraded during the patching process.
Answer: A,D
NEW QUESTION 45
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. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- B. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- C. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
- D. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
Answer: B
NEW QUESTION 46
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. 2,3,4,6,1,7,5
- C. 4,3,2,6,1,7,5
- D. 3,2,6,4,1,7,5
- E. 3,2,6,1,4,7,5
Answer: B
NEW QUESTION 47
......
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.
Certification Topics of Oracle 1Z0-902 Exam
Exadata Database Maintenance Tasks
Exadata Database Machine Security
Exadata Database Machine Configuration and Administration
Exadata Database Machine Troubleshooting
Exadata Database Machine Site and Implementation Planning (OECA&OEDA)
Exam Engine for 1Z0-902 Exam Free Demo & 365 Day Updates: https://www.examtorrent.com/1Z0-902-valid-vce-dumps.html
1Z0-902 PDF Questions and Testing Engine With 62 Questions: https://drive.google.com/open?id=1ZbyIvVdstNLe13MefGSFxJj3fngYypzt
