[Aug-2021] Pass 1z0-070 Exam in First Attempt Updated1z0-070 GuideTorrent Exam Question
Oracle Exadata Dumps 1z0-070 Exam for Full Questions - Exam Study Guide
NEW QUESTION 41
You are designing the monitoring architecture and procedures for an X5 Database Machine fabric consisting of two full racks, to provide for the monitoring for all components on the critical path of the admin network.
Which two components need to be monitored?
- A. the InfiniBand spine switches
- B. the Cisco 48 port Catalyst Ethernet Switch
- C. the power distribution units
- D. the Infiniband leaf switches
Answer: A,B
Explanation:
The Cisco Catalyst 4948 Ethernet switch is supplied with the Oracle Exadata Rack.
D: Figure: Running the Subnet Manager in Different Rack Configurations
References:
https://docs.oracle.com/cd/E18476_01/doc.220/e18478/GUID-9FF8B5B0-3481-4B73-89D3-108CBD7EB989.htm#ELMOG76346
http://docs.oracle.com/cd/E80920_01/DBMIN/configuring-exadata.htm#DBMIN21274
NEW QUESTION 42
You must replace the battery on the disk controller in three Exadata storage servers and must power off the affected storage servers.
Which two commands must you execute to safely power off the storage servers in an X5
Database Machine?
- A. CellCLI> LIST GRIDDISK WHERE STATUS != 'inactive'
- B. 'crsctl stop cluster -all'on one of the database servers
- C. CellCLI> ALTER GRIDDISK ALL INACTIVE
- D. CellCLI > LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome !=
'Yes' - E. 'shutdown -h now'on the affected storage servers
Answer: C,D
Explanation:
C: Step 1:
Run the following command to check if there are other offline disks
CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'
If any grid disks are returned, then it is not safe to take the storage server offline because proper Oracle ASM disk group redundancy will not be intact.
E: Step 2:
Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline using the following command:
CellCLI> ALTER GRIDDISK ALL INACTIVE
Taking the storage server offline when one or more grid disks are in this state will cause
Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.
NEW QUESTION 43
Which statement is true about operating systems in an X5 Database Machine multirack configuration consisting of two full racks and one Exadata storage expansion rack?
- A. All Exadata storage servers may run Oracle Virtual Machine (OVM).
- B. All Exadata storage servers must run Oracle Linux.
- C. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
- D. All Exadata storage servers used by the same virtual cluster nodes must run the same
O/S but Exadata Storage Servers in different clusters may run different operating systems. - E. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same version of Oracle Virtual Machine (OVM).
Answer: B
Explanation:
On both physical and virtual deployments, Exadata systems use minimal Linux distributions to ensure that just the RPMs needed to run Oracle database, are installed and enabled.
References:http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds-
2406241.pdf
NEW QUESTION 44
Identify two valid reasons for executing an X5 Exadata storage server rescue procedure.
- A. Accidental loss of all data from all griddisks in a storage server
- B. Only the failure of physical disk 1
- C. The failure of both physical disks 0 and 1
- D. Only the failure of physical disk 0
- E. Corruption in a normal or high redundancy ASM diskgroup
- F. Corruption in the /(root) filesystem
Answer: C,F
Explanation:
The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.
Incorrect Answers:
E, F: If only one system disk fails, then use CellCLI commands to recover.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#GUID-
710814E7-4691-49EE-95AD-726D2D6C5BFE
NEW QUESTION 45
Which three are true concerning Hybrid Columnar Compression (HCC) deployed on
Exadata storage?
- A. Rows residing in HCC compressed segments, are always self- contained in a single database block.
- B. By default, decompression is performed by Exadata Storage Servers.
- C. HCC data is never cached in the Exadata Smart Flash Cache.
- D. Rows residing in HCC compressed segments, are always self- contained in a single compression unit.
- E. HCC can be used only when the Exadata Smart Flash Cache is configured in Write-
Through mode. - F. Row-level locks are supported on HCC compressed data.
Answer: B,D,F
Explanation:
C: The decompression process typically takes place on the Oracle Exadata Storage Server in order to maximize performance and offload processing from the database server.
E: A logical construct called the compression unit is used to store a set of hybrid columnar compressed rows. When data is loaded, column values for a set of rows are grouped together and compressed. After the column data for a set of rows has been compressed, it is stored in a compression unit.
F: What happens when I update a row on compressed tables? What about locks?
Note: Oracle's Hybrid Columnar Compression technology is a new method for organizing data within a database block. As the name implies, this technology utilizes a combination of both row and columnar methods for storing data. This hybrid approach achieves the compression benefits of columnar storage, while avoiding the performance shortfalls of a pure columnar format.
NEW QUESTION 46
Your Exadata X6-2 Database Machine has the exachk utility preinstalled. You decide to use it periodically to validate the installation against Oracle's recommended best practices.
Which three actions could you take to do this?
- A. Use a cron job on a database node to run it at regular intervals.
- B. Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.
- C. Use a cron job on each cell to run it at regular intervals.
- D. Run it once each cell and it will then perform periodic monitoring automatically.
- E. Use exachk to schedule itself to run at regular intervals.
Answer: A,B,E
Explanation:
AD: To schedule exachk, we can create a cron job or we can create a job in Enterprise Manager..
To add an Enterprise Manager job to execute Exachk on a periodic basis. Execute the following steps. First go to Enterprise, Job, Library. Then create a new OS Command job E: exachk options include AUTORUN_SCHEDULE, which schedules recurring health checks using the AUTORUN_SCHEDULE daemon option.
References:
http://www.oracle.com/technetwork/database/availability/exadata-health-resource-usage-2021227.pdf
http://docs.oracle.com/cd/E68491_01/OEXUG/automated-daemon-mode-operation.htm Best practices: Execute the latest version of the exachk utility before and after planned maintenance activities and at least once every month
NEW QUESTION 47
Which two are benefits of an active/inactive configured InfiniBand network on Exadata
Database Machine X5?
- A. Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
- B. Improved performance for Oracle Network traffic
- C. Improved performance for ASM rebalance network traffic
- D. Improved reliability for Cache Fusion RAC network traffic
- E. Improved reliability when executing Distributed Command Line Interface (DCLI) to run
CELLCLI commands
Answer: D,E
Explanation:
Active-passive bonding provides reliability through failover.
NEW QUESTION 48
You plan to consolidate your company's INVENTORY and SALES databases onto your new Exadata X6 Database Machine.
You are considering consolidation of all schemas into one RAC database.
Which three factors would you need to consider before choosing this approach?
- A. the maintenance schedule
- B. the number of database users
- C. the number of simultaneous sessions
- D. Security Policies
- E. the number of database roles
Answer: B,C,D
NEW QUESTION 49
You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.
You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.
You issue this command on the first cell:
You examine the output from the first cell which contains:
Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?
- A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC
- B. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC
- C. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ
- D. CT_IO_UTIL_SM and CT_IO_UTIL_LG
Answer: C
Explanation:
Explanation/Reference:
CT_IO_RQ_SM
The cumulative number of small I/O requests issued by the category for hard disks. A large value indicates a heavy I/O workload from this category.
CT_IO_RQ_LG
The cumulative number of large I/O requests issued by the category for hard disks. A large value indicates a heavy I/O workload from this category.
CT_IO_WT_SM_RQ
The average IORM wait time per request for small I/O requests issued to hard disks by an IORM category.
CT_IO_WT_LG_RQ
The average IORM wait time per request for large I/O requests issued to hard disks by an IORM category.
Incorrect Answers:
A: CT_IO_RQ_SM_SEC
This metric is derived from CT_IO_RQ_SM. It specifies the rate of small I/O requests issued by the category for hard disks. Its units are number of I/O requests per second. A large value indicates a heavy I/ O workload from this category in the past minute.
B: CT_IO_UTIL_SM
The percentage of disk resources utilized by small requests from this category.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-monitoring.htm
NEW QUESTION 50
As part of planning for database consolidation, you grouped your databases into two categories based on different technical and business objectives.
Which three statements are true about possible configurations for your Exadata X6 Database Machine fabric?
- A. A single database cluster benefits from accessing multiple storage grids.
- B. The database grid may be partitioned when deploying a multirack Database Machine configuration.
- C. Multiple database clusters never benefit from accessing a single storage grid.
- D. Multiple database clusters may access the same storage grid.
- E. The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization.
Answer: A,B,D
NEW QUESTION 51
Which three are true concerning Storage Indexes?
- A. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan.
- B. A maximum of eight table columns for any table are indexed per storage region.
- C. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
- D. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL.
- E. Storage Indexes persist across any Exadata storage server reboots.
- F. Different storage regions may have different columns indexed for the same table.
Answer: B,C,D
Explanation:
A: Each disk in the Exadata storage cell is divided into equal sized pieces called storage regions (default 1MB). There is an index entry for every storage regions (1MB of data stored on disk). Each entry contains the minimum and maximum value for columns seen in 'where' clause predicates. Information for up to 8 columns can be stored. The index is then used to eliminate disk IO by identifying which storage regions don't match the 'where' clause of a query.
NEW QUESTION 52
Which two options should be used to identify a damaged or failing flash card on an X6 Database Machine high-capacity storage server?
- A. Using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
- B. Using the CELLCLI LIST LUN DETAIL command as the celladmin user
- C. Using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin
- D. Hardware monitoring using the storage server ILOM
Answer: A,D
Explanation:
The CALIBRATE command runs raw performance tests on cell disks, enabling you to verify the disk performance before the cell is put online. You must be logged on to the cell as the root user to run CALIBRATE.
Oracle ILOM automatically detects system hardware faults and environmental conditions on the server. If a problem occurs on the server, Oracle ILOM will automatically do the following:
Illuminate the Service Required status indicator (LED) on the server front and back panels.
Identify the faulted component in the Open Problems table.
Record system information about the faulted component or condition in the event log.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm#SAGUG20617
NEW QUESTION 53
Which three are true about Exadata Smart Flash Log?
- A. LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first.
- B. The use of Exadata Smart Flash Logs is mandatory for support of production databases.
- C. Databases on the Database Machine use Exadata Smart Flash Log by default.
- D. I/O Resource Manager database plans can be used to enable or disable Exadata Smart Flash Log for individual databases.
- E. I/O Resource Manager category plans can be used to enable or disable Exadata Smart Flash Log for different I/O categories.
Answer: A,C,D
Explanation:
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases.
B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine.
C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time.
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better database performance.
Incorrect Answers:
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time.
References: http://structureddata.org/2011/10/12/exadata-smart-flash-logging-explained/
NEW QUESTION 54
Identify two supported modifications to an X5 Database Machine.
- A. replacing the Infiniband switches with another make or model
- B. installing additional Operating System (O/S) packages on the Exadata storage servers
- C. installing additional Operating System (O/S) packages on the computer nodes
- D. installing a Host Bus Adapter (HBA) in the storage servers
- E. replacing the Cisco Ethernet switch with another make or model
- F. installing a Host Bus Adapter (HBA) in the compute nodes
Answer: C,D
Explanation:
B: Updating Exadata Database Servers (compute nodes).
The software and firmware components that are updated for a specific release depend on the current Exadata software release the database server is running and the release you are updating to. Linux operating system packages and Exadata software are always updated while firmware may be updated for only a small selection of the components or not at all.
D: The storage cells (storage servers/nodes) contain HBAs, and spare PCI I/O slots.
References:https://docs.oracle.com/cd/E41033_01/html/E55032/bbgiabie.html
http://docs.oracle.com/cd/E80920_01/DBMMN/updating-exadata-software.htm#DBMMN-GUID-AB25ED9A-7920-441A-9A60-14ED2753B01C
NEW QUESTION 55
Which two are benefits of an active/inactive configured InfiniBand network on Exadata Database Machine X5?
- A. Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
- B. Improved reliability when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
- C. Improved performance for Oracle Network traffic
- D. Improved performance for ASM rebalance network traffic
- E. Improved reliability for Cache Fusion RAC network traffic
Answer: B,E
Explanation:
Active-passive bonding provides reliability through failover.
NEW QUESTION 56
Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components?
- A. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
- B. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes.
- C. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
- D. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
- E. Cloud control can monitor and manage a Database Machine compute node expansion rack.
- F. Computer nodes forward their SNMP traps to the Management Server process on the same computer node.
- G. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage nodes.
Answer: B,C,D,E
Explanation:
Explanation/Reference:
B (not A): Oracle Exadata components-including database and storage servers, switches, and power distribution units (PDUs)-use SNMP to raise alerts and report monitoring information.
Oracle's CellCLI interface is a Java-based framework delivered by the storage cell's management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the Management Server process (MS) on the Storage servers.
G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units.
References: http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-
2291964.html
NEW QUESTION 57
Which two statements are true about the EXACLI utility?
- A. It can be executed using the EXADCLI utility.
- B. It supports all CELLCLI commands.
- C. It requires access through a cell user that has role-based privileges granted.
- D. It requires the same privileges as the celladmin linux user to create CELLDISKS and GRIDDISKS.
- E. It can execute commands on multiple cells in parallel.
- F. It can be executed directly on cells.
Answer: A,E
Explanation:
The exadcli utility facilitates centralized management across an Oracle Exadata system by automating the execution of ExaCLI commands.
Exadcli executes the commands on a set of remote nodes and returns the output to the centralized management location where the exadcli utility was run.
The exadcli utility runs commands on multiple remote nodes in parallel threads.
NEW QUESTION 58
Which four statements are true concerning the configuration or use of Enterprise Manager
Cloud Control to monitor and manage Exadata Database Machine components?
- A. Cloud Control cannot monitor partitioned Exadata Database Machine systems.
- B. Oracle management agents must only be installed on one storage node in a Database
Machine to enable monitoring and management of all storage nodes. - C. Cloud Control can monitor and manage a Database Machine storage Expansion rack.
- D. Oracle management agents must only be installed on one compute node in a Database
Machine to enable monitoring and management of all compute nodes and storage nodes. - E. Storage nodes forward their SNMP traps to the Management Server process on the same storage node.
- F. Cloud control can monitor and manage a Database Machine compute node expansion rack.
- G. Computer nodes forward their SNMP traps to the Management Server process on the same computer node.
Answer: C,D,E,F
Explanation:
B (not A): Oracle Exadata components-including database and storage servers, switches, and power distribution units (PDUs)-use SNMP to raise alerts and report monitoring information.
Oracle's CellCLI interface is a Java-based framework delivered by the storage cell's management server process (MS) that provides administrative capabilities to your storage server entities.
C: Cloud control can monitor the Exadata Database Machine.
Figure: Oracle Enterprise Manager Cloud Control 12c monitoring architecture. Note the
Management Server process (MS) on the Storage servers.
G (not D): Before using Oracle Enterprise Manager Cloud Control 12c with Oracle Exadata, an Oracle Management Agent and Oracle Exadata plug-in must be installed on every
Oracle Exadata database server (compute node). This agent monitors software targets, such as the database instances and Oracle Clusterware resources, on the database servers. The plug-in enables monitoring of other hardware components in Oracle Exadata, including the storage servers, switches, and power distribution units.
References:http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor- exadata-em12-2291964.html
NEW QUESTION 59
A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.
The script must run on each cell simultaneously.
How would you achieve this?
- A. Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.
- B. Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.
- C. Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.
- D. Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.
- E. Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.
Answer: B
Explanation:
The exadcli utility runs commands on multiple remote nodes in parallel threads.
You can issue an ExaCLI command to be run on multiple remote nodes. Remote nodes are referenced by their host name or IP address. Unlike dcli, exadcli can only execute ExaCLI commands. Other commands, for example, shell commands, cannot be executed using exadcli.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/exadcli.htm#DBMMN-GUID-4AE469A6-F291-4737-B975-F1B4B91D0BA0
NEW QUESTION 60
Which three statements are true concerning the configuration of SNMP on an Exadata x5 or x6 Database Machine?
- A. Some SNMP notifications may be configured using the alter cell command on the storage servers.
- B. All SNMP notifications from the storage server ILOMs are sent directly to the Automatic Service Request (ASR) manager.
- C. All SNMP notifications from a database server ILOM are sent directly to the management server (MS) process on the same database server.
- D. All SNMP notifications from a database server ILOM are sent directly to the Automatic Service Request (ASR) manager.
- E. Some SNMP notifications from a storage server ILOM are sent directly to the management server (MS) process on the same storage servers.
- F. The Database Machine internal Cisco Switch communicates directly with the Enterprise Manager agent via SNMP.
Answer: A,D,E
Explanation:
B: You can configure SNMP Trap Destinations for the Exadata Storage Servers with the following command:
# cellcli -e "alter cell snmpSubscriber=(host ='ASR-Manager-name-or-IP- address',port=162,community=public,type=asr)"
D: Exadata Storage Server plug-in
This extends the monitoring of exadata cells in addition to providing a GUI interface. The plug-in uses an SSH connection to the cellmonitor user on the cells and uses list commands only. This is for interactive monitoring. One may also set thresholds using the plug-in which are distinct from any thresholds set using cellcli utility as the celladmin user.
For alerts to be sent to the plug-in, SNMP traps are used as follows:
Cell ILOM alerts are sent to the cell Management Server (MS) via an SNMP trap. The MS then send SNMP notifications onward to the plug-in.
Cell alerts flagged by MS itself, such as cell thresholds being exceeded, or ADR software alerts, are sent to the plug-in using SNMP.
E: Database Server ILOM plug-in
Monitoring databases and their instances, ASM environments, the Grid Infrastructure, and the host software environment are done by Enterprise Manager in the usual way as these are standard targets. But monitoring the hardware for the database servers requires the
ILOM plug-in, as there is no Management Server (MS) on the database servers to receive
SNMP traps from the ILOM. The plug-in will receive sensor state and availability data from the ILOM including alerts based on pre-set ILOM thresholds.
References:
https://dbatrain.wordpress.com/2011/06/
http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html
NEW QUESTION 61
Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?
- A. a DBFS file system stored in a staging database on the Database Machine
- B. on local storage on one or more storage servers that are accessible to the database server where the load will be performed
- C. a ZFS over NFS file system mounted on a database server where the external table will be accessed
- D. an Exadata-based ACFS file system on the Database Machine
- E. on an ACFS file system stored in a staging database on the Database Machine
Answer: B,C,E
NEW QUESTION 62
......
Authentic Best resources for 1z0-070 Online Practice Exam: https://www.guidetorrent.com/1z0-070-pdf-free-download.html