This page was exported from Free Exam Dumps Collection [ http://free.examcollectionpass.com ] Export date:Sat Nov 30 19:12:04 2024 / +0000 GMT ___________________________________________________ Title: [2023] Pass Oracle 1z1-902 Premium Files Test Engine pdf - Free Dumps Collection [Q20-Q37] --------------------------------------------------- [2023] Pass Oracle 1z1-902 Premium Files Test Engine pdf - Free Dumps Collection New 2023 Realistic 1z1-902 Dumps Test Engine Exam Questions in here The Oracle 1z1-902 certification exam is designed to validate the skills and knowledge of IT professionals who are tasked with implementing the Exadata Database Machine X8M. The exam covers a wide range of topics, including the installation and configuration of Exadata storage servers, the configuration of network components, and the management and administration of Oracle databases on the Exadata platform.   QUESTION 20You 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?  6, 2, 1, 8, 4, 5  6, 8, 3, 4, 2, 1  6, 3, 1, 9, 7, 8  6, 1, 2, 7, 5, 8 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-QUESTION 21What is the maximum DRAM capacity you can expand an X9M-2 DB Server?  1536GB  512GB  2048GB  768GB  1024GB  384GB 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).QUESTION 22You 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?  dbmcli -e “set alert ds_temp> 30” on each database server  dbmcli -e “set threshold ds_temp comparison=’ >’, critical=30” on each database server  dbmcli -e “alert metriccurrent ds_temp where metricValue > 30” on each database server  dbmcli -e “create threshold ds_temp comparison=’>’, critical=30” on each database server QUESTION 23An Exadata X9M-2 Elastic Rack with 4 Database Servers and 8 HC Storage Servers and 3-phase 24kVA 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 splitter cable can be used to provide power to all PDU cables.  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.  The installation cannot proceed until two power feeds are available per PDU.  The installation can go ahead, no change is required. In order for an Exadata X9M-2 Elastic Rack to be installed, two power feeds are required for each of the three-phase 24kVA PDUs. A single cable from each PDU will not be enough to power the rack, and neither a splitter cable nor rearrangement of the power cables from the servers to the PDUs will be able to provide sufficient power for the system. Therefore, the installation cannot proceed until two power feeds are available per PDU.For more information about power requirements for Exadata X9M-2 Elastic Racks, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources.Search results: [1] Oracle Exadata Database Machine X9M-2 Full Rack Installation – Oracle Docs [2] Exadata Database Machine X8M-2 Mid-Size Rack Installation – Oracle DocsQUESTION 24You have been asked by Oracle Support to check the firmware of the hard & flash disks in a storage server. Which cellcli command should you use to get this information?  list celldisk attributes name, deviceName, diskType, physicalFirmware  list cell attributes name, deviceName, diskType, physicalFirmware  list physicaldisk attributes name, deviceName, diskType, physicalFirmware  list devices attributes name, deviceName, diskType, physicalFirmware QUESTION 25Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?  ASR Manager must be installed and configured on a dedicated server external to the Database Machine.  Configuring ASR is mandatory for all Database Machine assets.  ASR Manager must be installed and configured on one of the database servers.  ASR can upload configuration metadata to support problem resolution.  ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.  ASR communicates with Oracle support services using HTTPS. 1. ASR can upload configuration metadata to support problem resolution1.2. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults1https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htmQUESTION 26You 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?  dbmcli -e “set alert ds_temp> 30” on each database server  dbmcli -e “set threshold ds_temp comparison=’ >’, critical=30” on each database server  dbmcli -e “alert metriccurrent ds_temp where metricValue > 30” on each database server  dbmcli -e “create threshold ds_temp comparison=’>’, critical=30” on each database server The Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (page 5-54) recommends using the dbmcli command to set thresholds on metrics, such as temperature. To do this, you should use the following command:dbmcli -e “set threshold ds_temp comparison=’ >’, critical=30” on each database server.This will generate an alert if the temperature exceeds 30C.QUESTION 27Examine this list of software components:1. Oracle KVM Guest2. Oracle Enterprise Manager Agent (OMA)3. ASM instance4. RDBMS instance5. Automatic Diagnostic Repository Command Interpreter (ADRCI)6. CELLCLI7. Cell Server(CELLSRV)8. diskmon9. 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?  2, 3, 4, 8, and 10 run on the database servers; 1, 5, 6, 7and 9 run on the Exadata storage servers.  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.  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.  3, 4, 8, and 10 run on the database servers; 1, 2, 5, 6, 7 and 9 run on the Exadata storage servers.  1, 2, 3, 4, 8 and 9 run on the database servers; 5, 6, 7, 9 and 10 run on the Exadata storage servers. Oracle KVM Guest, Oracle Enterprise Manager Agent (OMA), RDBMS instance, Automatic Diagnostic Repository Command Interpreter (ADRCI), CELLCLI, diskmon, and Restart Server (RS) can all run on the database servers. The Cell Server (CELLSRV) and Management Server (MS) can both run on the Exadata storage servers. Specific instructions for installing and configuring these software components can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_software_components.html.QUESTION 28Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?  2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 25Gb ports on eth5 and eth6 usingSFP28 transceivers and OM4 fiber cable for client network  2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fibre cable for client network, and 2x 10Gb ports on eth9 and eth10 using RJ45 cat6 cable for backup network  2x 10Gb ports on eth1 and eth2 using FU45 cat6 cable for client network, and 2x 25Gb ports on eth11 and eth12 using SFP28 transceivers and OM4 fiber cable for backup network  2x 25Gb ports on eth1 and eth2 using SFP28 transceivers and OM4 fiber cable for backup network, and 2x 10Gb ports on eth3 and eth4 using RJ45 cat6 cable for client network QUESTION 29You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?  to the CELLADMIN account by calling CELLCLI on all cells using DCLI  to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli  to the CELLMONITOR account using cellcli interactively on each storage server  to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli  to the CELLMONITOR account calling CELLCLI on all cells using DCLI  to the CELLADMIN account using cellcli interactively on each storage server To drop all celldisks on all the storage servers in an X9M-2 quarter rack, you should use the CELLADMIN account, which has the necessary privileges to perform this task. You can use the CELLCLI command-line interface to drop the celldisks. The best way to do this is by calling CELLCLI on all cells using DCLI (Oracle Database Command Line Interface) which allows you to run commands on multiple servers at once. Alternatively, you can use an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli. It is not recommended to use the CELLMONITOR account, as it has a more limited set of privileges. It is also important to note that EXACLI is not a valid tool for this taskhttps://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.htmlQUESTION 30You 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?  ASM instances  Hybrid Columnar Compression (HCC) ratios on Extended (XT) storage servers  the storage server ILOM  the Power Distribution Units (PDUs)  Oracle clusterware on the database server  the RDMA over Converged Ethernet (RoCE) switches According to Oracle’s documentation12, the components that are monitored directly through the use of Exadata-specific Enterprise Manager Plug-Ins are:The storage server ILOM2The Power Distribution Units (PDUs)2The RDMA over Converged Ethernet (RoCE) switches3QUESTION 31Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?  Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.  Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk.  Run exachk and resolve only WARNINGS that you have not seen before.  Run the appropriate patchmgr preqequisite check step for each component being updated.  Run patchmgr –all_comp -autofix -autobackup -upgrade -rolling.  For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling. QUESTION 32You 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?  You query v$SYSTAT and filter for the statistic ‘cell smart table scan’, associated to your table.  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’.  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.  YOU query VSSYSTEM_EVENTS and filter for the event ‘cell physical IO interconnect bytes returned by smart scan’, associated to your table. The two actions that are not appropriate for monitoring how a large production table is accessed in order to leverage the benefits of the Exadata Platform are A) querying VSSYSTEMEVENTS and filtering for the event ‘cell physical IO interconnect bytes returned by smart scan’, associated to your table; and B) querying v$segmentstatistics and filtering for the Object ID of your table from dbaobjects and the the column STATISTICNAME=’optimized physical reads’. Instead, you should query v$SYSTAT and filter for the statistic ‘cell smart table scan’, associated to your table (C), or 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). These two methods are outlined in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book (Chapter 8, Monitoring the Exadata Database Machine).QUESTION 33You 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?  ifconfig -a legrep “re0| re1”  /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.p1 -all  netstat -rn  cat /proc/net/bonding/bondeth0 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 ServerQUESTION 34Which three statements are true about the CELLCLI command?  It can execute commands on multiple storage servers in parallel.  It has command-line history.  It requires root privileges to create CELLDISKS and GRIDDISKS.  It can be executed on storage servers.  It can be executed using the DCLI utility. The CELLCLI utility is a command line interface to Exadata that enables the execution of commands across multiple storage servers in parallel. It also has command-line history, so users can easily recall previously entered commands. Furthermore, the CELLCLI utility can be executed using the DCLI utility, which provides a convenient way to execute commands on multiple storage servers simultaneously.However, CELLCLI does not require root privileges to create CELLDISKS and GRIDDISKS, and it cannot be executed on storage servers. This is because CELLCLI is used to manage the Exadata database machine from the database server [1]. For more information about CELLCLI, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].QUESTION 35Which two statements are true in regards to starting the Exadata Virtual Machine?  To see Oracle Linux boot messages during guest startup, use -console option with the vm_maker -start-domain command.  Use vm_maker -start-domain to start a virtual machine manually.  Use vm_maker boot-from-iso command to boot a virtual machine.  To streamline the diagnosis of virtual machines, one ISO file is used for multiple Oracle Exadata System Software releases.  Use vm_maker -auto-start command to configure a virtual machine to start automatically when the KVM host is started. QUESTION 36Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?  The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.  914mm of space required above the rack height is required for maintenance access.  The incline of any access route ramp must be less than or equal to 6 degrees.  All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.  Oracle Exadata Rack may only be installed on raised floor environments.  A conditioned space is required to remove the packaging material to reduce particles before entering the data center. QUESTION 37Which two options can be used to identify a damaged or failing flash card on an X9M-2 Database Machine High Capacity storage server?  using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user  using the CELLCLI CALIBRATE command on the storage server after logging in as the root user  hardware monitoring using the storage server ILOM  using the CELLCLI list LUN DETAIL command as the celladmin user 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. Loading … The Oracle Exadata Database Machine X8M is a high-performance database machine that is designed to deliver extreme performance for database workloads. The machine combines the performance of flash memory with the scalability of a shared storage architecture to deliver unmatched performance for Oracle Database workloads. The machine is designed to handle the most demanding workloads and is optimized for both OLTP and data warehousing workloads. With its unique architecture and advanced features, the Exadata Database Machine X8M is a game-changer in the world of database systems.   Updated Official licence for 1z1-902 Certified by 1z1-902 Dumps PDF: https://www.examcollectionpass.com/Oracle/1z1-902-practice-exam-dumps.html --------------------------------------------------- Images: https://free.examcollectionpass.com/wp-content/plugins/watu/loading.gif https://free.examcollectionpass.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-06-27 14:12:54 Post date GMT: 2023-06-27 14:12:54 Post modified date: 2023-06-27 14:12:54 Post modified date GMT: 2023-06-27 14:12:54