1Z0-902 Dumps By Pros - 1st Attempt Guaranteed Success [Q24-Q44]

1Z0-902 Dumps By Pros - 1st Attempt Guaranteed Success

100% Guarantee Download 1Z0-902 Exam Dumps PDF Q&A

NEW QUESTION # 24
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?

• A. Collected configuration information can be uploaded manually to Oracle.
• B. It is mandatory to install OCM on all database servers.
• C. It collects configuration information on demand.
• D. It is mandatory to install OCM on at least one database server.
• E. It collects configuration information automatically.
• F. Collected configuration information can be uploaded automatically to Oracle.

Answer: B,D,F

NEW QUESTION # 25
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 "create threshold ds_temp comparison='>', critical=30" on each database server
• B. dbmcli -e "set alert ds_temp> 30" on each database server
• C. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
• D. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server

Answer: A

Explanation:
The correct command to generate alerts for an event when the temperature of the database servers in an Exadata Full Rack exceeds 30C is "dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server". The dbmcli is the command-line interface for the Oracle Database Management Agent (DMA), which allows you to perform various management tasks on the Exadata servers. This command creates a threshold for the ds_temp metric with a comparison operator of ">" (greater than), and a critical value of 30. The threshold is set on all database servers in the Exadata Full Rack, so when the server temperature exceeds 30C, an alert will be generated.

NEW QUESTION # 26
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?

• A. corruption in a normal or high redundancy ASM diskgroup
• B. accidental loss of all data from all griddisks in a storage server
• C. corruption in the / (root) filesystem
• D. the failure of physical disk 1
• E. the failure of both physical M.2 disks
• F. moving all disks from one cell to another as part of a chassis-level component failure
• G. the failure of physical disk 0 and 11

Answer: B,C

Explanation:
Reason B, corruption in the / (root) filesystem, is a valid reason for executing a storage server rescue procedure. If the root filesystem is corrupted, the storage server will no longer be able to boot and will need to be rescued.
Reason F, accidental loss of all data from all griddisks in a storage server, is also a valid reason for executing a storage server rescue procedure. If all data is accidentally lost from the griddisks in a storage server, the server will need to be rescued in order to recover the data.
For more information about the Exadata X9M-2 storage server rescue procedure, 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] Oracle Exadata Database Machine X9M-2 Storage Server Rescue Procedure - Oracle Docs [3] Oracle Exadata Database Machine X8M-2 Mid-Size Rack Installation - Oracle Docs [4] Oracle Exadata Database Machine X8M-2 Storage Server Rescue Procedure - Oracle Docs [5] Oracle Exadata Database Machine X9M-2 Storage Server Update Procedure - Oracle Docs [6] Oracle Exadata Database Machine X8M-2 Storage Server Update Procedure - Oracle Docs

NEW QUESTION # 27
Which dbmcli command is NOT valid on Exadata X9M?

• A. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
• B. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
• C. dbmcli -e "LIST IBPORT DETAIL"
• D. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"

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.

NEW QUESTION # 28
Which dbmcli command is NOT valid on Exadata X9M?

• A. dbmcli -e "LIST ALERTHISTORY WHERE agelnMinutes < 15"
• B. dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "
• C. dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DS_.*'"
• D. dbmcli -e "LIST IBPORT DETAIL"

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 # 29
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. 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. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

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
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

• A. OECA allows one XT storage server in the configuration.
• B. OECA extends the hardware for the elastic configuration only.
• C. OECA facilitates PDU power selection initially and after equipment addition.
• D. OECA reconfigures the size of disk groups and recreates grid disks.
• E. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.

Answer: A,E

NEW QUESTION # 31
Which two of the following network connection types can be deployed on the client network ports of an Exadata X9M-2 Database Server?

• A. 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 using
  SFP28 transceivers and OM4 fiber cable for client network
• B. 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
• C. 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
• D. 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

Answer: B,D

NEW QUESTION # 32
Which two activities are supported on the storage servers in an Exadata Database Machine?

• A. installing an alternative package manager
• B. upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure
• C. configuring secure shell user equivalency for the cellmonitor user
• D. upgrading the Storage Server software package using rpm
• E. changing the root password

Answer: C,E

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:
1. changing the root password
2. configuring secure shell user equivalency for the cellmonitor user
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html

NEW QUESTION # 33
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. 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. The sparse_<DBM_NAME> diskgroup is created automatically.
• E. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.

Answer: A,B

Explanation:
According to the Oracle Exadata Database Machine Technical Architecture1, the initial storage configuration after the standard (non-virtualized) deployment of a new Exadata Database Machine with High Capacity storage servers includes two ASM disk groups: DATA_<DBM_Name> and RECO_<DBM_NAME>. These disk groups are built on hard disks and flash disks inside the Exadata Storage Servers1.
The correct statements about this configuration are:
Option D: There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes. Storage indexes are a feature of Exadata Storage Software that can improve query performance by avoiding unnecessary I/O operations. Storage indexes use a small amount of flash memory to store metadata about data blocks stored on disk1.
Option E: There is free space available on flashdisks inside the Exadata storage servers to configure Exadata Smart Flash Logs. Exadata Smart Flash Logs are another feature of Exadata Storage Software that can improve database performance by using flash memory as an extension of the database redo log buffer. This can reduce latency and increase throughput for redo log writes1.

NEW QUESTION # 34
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A. Exadata storage realms using ASM-scoped security mode
• B. Using EXADCLI instead of CELLCLI to create the griddisks
• C. File permissions on the griddisks in each database server
• D. Exadata storage realms using database-scoped security mode
• E. File permissions on the griddisks in each storage server

Answer: B,E

NEW QUESTION # 35
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 dcli command and manually execute it on all storage servers using the EXACLI command.
• C. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
• D. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.
• E. Copy and execute the script on all storage servers using the EXACLI command.

Answer: A

Explanation:
According to Oracle's documentation1, the Cell Control Command-Line Interface (CellCLI) utility is the command-line administration tool for Oracle Exadata System Software. It can be used to perform various tasks on Exadata Storage Servers, such as creating and managing objects, monitoring performance, and configuring alerts.
To run CELLCLI commands on multiple cells simultaneously, you can use the Distributed Command-Line Interface (dcli) utility2. The dcli utility allows you to execute commands or scripts on a group of cells or hosts in parallel. You can use the dcli utility to copy files from one cell or host to multiple cells or hosts using the -f option3. You can also use the dcli utility to execute commands or scripts on multiple cells or hosts using the -l option to specify a user name and the -g option to specify a file containing a list of cells or hosts3.
Therefore, to achieve your requirement of running a script with several CELLCLI commands on each cell in your Exadata full rack simultaneously, you must:
Copy and execute the script on all storage servers using the dcli command.

NEW QUESTION # 36
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
• B. Install on Oracle Database Appliance.
• C. Provide individual x86 64-Bit gateway hardware.
• D. Install on Exadata Engineered System.
• E. Install in Oracle Virtual Machine with required hardware.

Answer: A,B,C

Explanation:
According to Oracle's documentation1, the customer options for hosting the Platinum Services Advanced Support Gateway are:
Provide individual x86 64-Bit gateway hardware1
Purchase the recommended x86 64-Bit gateway hardware from Oracle1
Install on Oracle Database Appliance2

NEW QUESTION # 37
Which two statements are true for the Oracle Exadata Configuration Assistant (OECA)?

• A. OECA extends the hardware for the elastic configuration only.
• B. OECA facilitates PDU power selection initially and after equipment addition.
• C. OECA allows one XT storage server in the configuration.
• D. OECA's "Add Equipment" input option allows allocation of RU slots for customer equipment.
• E. OECA reconfigures the size of disk groups and recreates grid disks.

Answer: A,B

Explanation:
B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.
References for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.
Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Add Equipment: This input option allows you to allocate RU slots for ... [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ... [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to ... Power Selection [1][2]: This input option allows you to select PDU power initially ... [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide ... The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can ...

NEW QUESTION # 38
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?

• A. Check the database to see if any rebalance operations are active.
• B. Ask the system administrator to replace the broken disk with a spare.
• C. Call Oracle Support and make an appointment so that the drive can be replaced.
• D. Download and run the latest exadiag tool.
• E. Wait for the email of the failure that Exadata or Enterprise Manager will send.
• F. Wait for a blue light to appear on the disk if the rebalance operation is running.

Answer: B

NEW QUESTION # 39
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 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.
• C. 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.
• D. 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.

Answer: C

NEW QUESTION # 40
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_.*'"
  B) dbmcli -e "LIST METRICCURRENT WHERE name = 'DS_TEMP' "

Answer: A

NEW QUESTION # 41
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 to configure Exadata Smart Flash Logs.
• B. There is free space available on the hard disks inside the database servers for possible extension of the /uoi file system.
• 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. The sparse_<DBM_NAME> diskgroup is created automatically.
• E. There is free space available on flashdisks inside the Exadata storage servers for possible use for storage indexes.

Answer: A,B

NEW QUESTION # 42
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 "create threshold ds_temp comparison='>', critical=30" on each database server
• B. dbmcli -e "set alert ds_temp> 30" on each database server
• C. dbmcli -e "alert metriccurrent ds_temp where metricValue > 30" on each database server
• D. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server

Answer: A

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

NEW QUESTION # 43
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 12x 32GB DIMMs.
• B. Add 24x 32GB DIMMs.
• C. Add 16x 32GB DIMMs.
• D. Add 16x 64GB DIMMs.
• E. Remove existing memory modules.
• F. Add 12x 64GB DIMMs.
• G. Add 32x 64GB DIMMs.
• H. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• I. Shutdown the Database Server if running.

Answer: C,D,E

NEW QUESTION # 44
......

Earn Quick And Easy Success With 1Z0-902 Dumps: https://www.actualtests4sure.com/1Z0-902-test-questions.html

Kickstart your Career with Real  Updated Questions: https://drive.google.com/open?id=17u9wx3juWygmHYy2iLUpWBSlu2UE1IfK