1z1-902 Actual Questions Answers PDF 100% Cover Real Exam Questions
1z1-902 Exam questions and answers
NEW QUESTION # 31
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Run the appropriate patchmgr preqequisite check step for each component being updated.
- 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 patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- D. Run exachk and resolve only WARNINGS that you have not seen before.
- E. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
- F. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
Answer: A,C,E,F
NEW QUESTION # 32
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Run the appropriate patchmgr preqequisite check step for each component being updated.
- 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 patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- D. Run exachk and resolve only WARNINGS that you have not seen before.
- E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- F. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
Answer: A,B,D,F
Explanation:
According to Oracle.com documents or resources, the four actions that you should take before proceeding with applying updates to your Exadata Database Machine are:
A) Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
B) Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
C) Run exachk and resolve only WARNINGS that you have not seen before3.
D) Run the appropriate patchmgr preqequisite check step for each component being updated3.
NEW QUESTION # 33
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 database-scoped security mode
- B. Exadata storage realms using ASM-scoped security mode
- C. Using EXADCLI instead of CELLCLI to create the griddisks
- D. File permissions on the griddisks in each storage server
- E. File permissions on the griddisks in each database server
Answer: B,D
Explanation:
When multiple databases share space on the storage servers in an unpartitioned storage grid, two Exadata security features can be configured to control which databases can access which griddisks.
Exadata storage realms using ASM-scoped security mode: This feature allows you to create storage realms and assign them to specific databases. This allows you to control which databases have access to which griddisks. The ASM-scoped security mode applies to all griddisks within an ASM disk group, which means that all griddisks in a disk group will be accessible only to the databases that belong to the assigned storage realm.
File permissions on the griddisks in each storage server: This feature allows you to configure file permissions on the griddisks at the storage server level. You can assign specific permissions to specific users or groups, allowing you to control which databases can access which griddisks.
NEW QUESTION # 34
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 ALERTHISTORY WHERE agelnMinutes < 15"
- D. dbmcli -e "LIST IBPORT DETAIL"
Answer: C
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 # 35
For which four component failures on an X9M Database Machine does Auto Service Request (ASR) raise service requests?
- A. RoCE network interface cards in the storage servers
- B. Cisco management switch
- C. power supplies in the database servers
- D. power distribution units
- E. RoCE network interface cards in the database servers
- F. Cisco RDMA over Converged Ethernet (RoCE) switches
- G. fans in the storage servers
Answer: A,C,D,F
Explanation:
According to the Oracle Auto Service Request (ASR) documentation1, ASR raises service requests for qualified Oracle products that are detected with specific faults. The qualified Exadata products include2:
Database servers
Storage servers
InfiniBand switches
Cisco switches (X8M and later systems)
Power distribution units (PDUs)
NEW QUESTION # 36
Which two statements are true about applying updates on Exadata systems?
- A. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
- B. Failed storage server updates are automatically rolled back to a previous release.
- C. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
- D. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
- E. Failed database server updates are rolled back to a working state on a previous release automatically.
- F. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
Answer: B,E
Explanation:
When applying updates on Exadata systems, database server updates are automatically rolled back to a working state on a previous release if the update fails. This ensures that the system can be restored to a working state in the event of a failed update. Additionally, storage server updates are also automatically rolled back to a previous release in the event of a failed update.
This is documented in the Oracle Exadata Database Machine X9M Implementation Essentials official text book and more information can be found on the Oracle support website [1][2].
NEW QUESTION # 37
Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine?
- A. Database Quarantine
- B. SQL Plan Quarantine
- C. Disk Region Quarantine
- D. Manually created Quarantine
- E. Cell Offload Quarantine
Answer: A,B
NEW QUESTION # 38
You 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?
- A. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
- B. to the CELLADMIN account using cellcli interactively on each storage server
- C. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
- D. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
- E. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
- F. to the CELLMONITOR account using cellcli interactively on each storage server
Answer: B,C,E
Explanation:
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 task
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html
NEW QUESTION # 39
Which are two valid reasons for executing an X9M-2 Exadata storage server rescue procedure?
- A. the failure of both physical M.2 disks
- B. the failure of physical disk 1
- C. moving all disks from one cell to another as part of a chassis-level component failure
- D. corruption in the / (root) filesystem
- E. the failure of physical disk 0 and 11
- F. accidental loss of all data from all griddisks in a storage server
- G. corruption in a normal or high redundancy ASM diskgroup
Answer: D,F
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 # 40
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- B. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- C. The incline of any access route ramp must be less than or equal to 6 degrees.
- D. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- E. 914mm of space required above the rack height is required for maintenance access.
- F. Oracle Exadata Rack may only be installed on raised floor environments.
Answer: F
Explanation:
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors
NEW QUESTION # 41
Which four actions should you take before proceeding with applying updates to your Exadata Database Machine?
- A. Run the appropriate patchmgr preqequisite check step for each component being updated.
- 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 patchmgr --all_comp -autofix -autobackup -upgrade -rolling.
- D. Run exachk and resolve only WARNINGS that you have not seen before.
- E. For database servers, perform a server backup using patchmgr -dbnodes db_list_file -backup -rolling.
- F. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release.
Answer: A,B,D,F
Explanation:
According to Oracle.com documents or resources, the four actions that you should take before proceeding with applying updates to your Exadata Database Machine are:
1. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.
2. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.
3. Run exachk and resolve only WARNINGS that you have not seen before3.
4. Run the appropriate patchmgr preqequisite check step for each component being updated3.
NEW QUESTION # 42
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
- A. It collects configuration information on demand.
- B. Collected configuration information can be uploaded manually to Oracle.
- C. It is mandatory to install OCM on at least one database server.
- D. It is mandatory to install OCM on all database servers.
- E. It collects configuration information automatically.
- F. Collected configuration information can be uploaded automatically to Oracle.
Answer: B,C,E
NEW QUESTION # 43
Which of the following is NOT a requirement when validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine?
- A. A conditioned space is required to remove the packaging material to reduce particles before entering the data center.
- B. All four leveling and stabilizing feet should be raised and out of the way prior to moving the rack.
- C. The incline of any access route ramp must be less than or equal to 6 degrees.
- D. The entire access route to the installation site should be free of raised-pattern flooring that can cause vibration.
- E. 914mm of space required above the rack height is required for maintenance access.
- F. Oracle Exadata Rack may only be installed on raised floor environments.
Answer: F
Explanation:
Exadata Database Machine is a pre-configured and pre-tuned hardware and software system designed to run Oracle Database, it can be installed on raised floor environments, but also on concrete or tile floors Oracle Exadata Database Machine X9M Implementation Essentials states that Exadata racks are designed to be installed on flat surfaces, not raised floor environments. It is not required to install the rack on raised floor environments. Additionally, the other options listed are all requirements for validating, receiving, unpacking, and planning access route and space requirements for Exadata Database Machine. (Source: Oracle Exadata Database Machine X9M Implementation Essentials, page 41)
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmin/index.html
NEW QUESTION # 44
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 "alert metriccurrent ds_temp where metricValue > 30" on each database server
- B. dbmcli -e "set threshold ds_temp comparison=' >', critical=30" on each database server
- C. dbmcli -e "create threshold ds_temp comparison='>', critical=30" on each database server
- D. dbmcli -e "set alert ds_temp> 30" on each database server
Answer: C
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 # 45
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
- A. 768GB
- B. 1536GB
- C. 2048GB
- D. 512GB
- E. 1024GB
- F. 384GB
Answer: C
NEW QUESTION # 46
......
BootcampPDF 1z1-902 Exam Practice Test Questions: https://www.bootcamppdf.com/1z1-902_exam-dumps.html
Pass 1z1-902 Exam Info and Free Practice Test: https://drive.google.com/open?id=1IbJjn6qZk_kukwPas5h3BCNhqeBzur2h