Breathing 1z0-070 Dumps Questions 2021

NEW QUESTION 1
Which three are true concerning Hybrid Columnar Compression (HCC) deployed on Exadata storage?

• A. HCC can be used only when the Exadata Smart Flash Cache is configured in Write- Through mode.
• B. HCC data is never cached in the Exadata Smart Flash Cache.
• C. By default, decompression is performed by Exadata Storage Servers.
• D. Rows residing in HCC compressed segments, are always self- contained in a single database block.
• E. Rows residing in HCC compressed segments, are always self- contained in a single compression unit.
• F. Row-level locks are supported on HCC compressed data.

Answer: CEF

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 2
Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine?

• A. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
• B. Configuring ASR is mandatory for all Database Machine assets.
• C. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• D. ASR Manager must be installed and configured on one of the database servers.
• E. ASR can upload configuration metadata to support problem resolution.
• F. ASR communicates with Oracle support services using HTTPS.

Answer: AC

Explanation: A: Oracle recommends that you install Oracle ASR Manager on an external, standalone server.
C: Oracle ASR is designed to generate Oracle service requests automatically when certain types of faults are detected on Oracle products that are qualified for Oracle ASR.
Oracle ASR works only for specific component faults. Most of the common components, such as disks, fans, and power supplies, are covered. However, some components are not covered. For example, Oracle ASR does not cover InfiniBand events; there are specific images and specific InfiniBand switch firmware that you must use. You cannot upgrade these components independently.

NEW QUESTION 3
You have partitioned an X5-2 full rack into two four-node RAC clusters called CLUSA and CLUSB.
No virtualization is used and the storage grid has not been partitioned.
Which two set of files on which servers must be modified after connecting an Exadata storage expansion rack to your X5-2 Exadata Database Machine on the InfiniBand network so that the storage servers in the expansion rack are added to the storage grid?

• A. the CELLINIT.ORA files on the database servers in CLUSA
• B. the CELLIP.ORA files on the database servers in CLUSA
• C. the CELLINIT.ORA files on the database servers in CLUSB
• D. the CELLIP.ORA files on all existing Exadata storage servers
• E. the CELLIP.ORA files on the database servers in CLUSB
• F. the CELLIP.ORA files on all newly added Exadata storage servers

Answer: BE

Explanation: The cellip.ora is the configuration file, on every compute node (database server), that tells ASM instances which cells are available to this cluster.
The cellip.ora file contains the storage cell IP addresses. References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-configuring.htm#SAGUG20369

NEW QUESTION 4
Which two are benefits of an active/inactive configured InfiniBand network on Exadata Database Machine X5?

• A. Improved performance for Oracle Network traffic
• B. Improved reliability for Cache Fusion RAC network traffic
• C. Improved reliability when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
• D. Improved performance for ASM rebalance network traffic
• E. Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands

Answer: BC

Explanation: Active-passive bonding provides reliability through failover.

NEW QUESTION 5
Which two completely prevent a Smart Scan from occurring?

• A. querying a table containing many chained rows
• B. querying a table containing many migrated rows
• C. performing a minimum or maximum function on an indexed column
• D. performing a Fast Full Index scan on a reverse key index
• E. referencing more than 255 columns form an OLTP compressed table in a query
• F. querying a table containing a JSON column

Answer: BE

Explanation: B: Migrated Rows is a special case of chained rows. Migrated rows still affect performance, as they do in conventional storage situations, but with the additional overhead of reducing the beneficial effects of “Smart Scan” in addition to increasing the number of I/Os
E: Smart Scans - broadly speaking and ignoring edge cases - can only transport a maximum of 254 columns from a single (non-HCC) segment. Requesting more columns will simply disable Smart Scans for that segment.
An interesting limitation to Exadata Smart Scans - if more than 254 columns from a table (not HCC compressed, more on that in moment) need to be projected, Smart Scans for that particular segment will be disabled and Exadata will fall back to conventional I/O. This means that the number of columns in the projection clause can make a significant difference to performance, since only Smart Scans allow taking advantage of offloading and particularly avoiding I/O via Storage Indexes.

NEW QUESTION 6
Which three are true concerning Storage Indexes?

• A. A maximum of eight table columns for any table are indexed per storage region.
• B. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan.
• C. Storage Indexes persist across any Exadata storage server reboots.
• D. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
• E. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL.
• F. Different storage regions may have different columns indexed for the same table.

Answer: ADE

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 7
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_UTIL_SM and CT_IO_UTIL_LG
• C. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC
• D. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ

Answer: D

NEW QUESTION 8
You are evaluating the performance of a SQL statement that accesses a very large table. You run this query:

Identify two reasons why the “physical read total bytes” statistic is greater than the “cell physical IO bytes eligible for predicate offload” statistic.

• A. There is an index on the column used in the WHERE clause, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.
• B. The table is an IOT and has an overflow segment, causing “cell multiblock physicalreads” to be requested by the database instance, resulting in additional I/O.
• C. There is an uncommitted transaction that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.
• D. The table is an index clustered table, causing “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.
• E. There are migrated rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

Answer: BE

NEW QUESTION 9
You plan to partition the database and storage grids in an X5-2 full rack, creating two clusters and two storage grids without using virtualization.
One cluster will be used for production and should consist of six database servers and nine storage servers.
The other cluster will be used for test and development, and should consist of two database servers and five storage servers.
The storage must be partitioned so that the storage servers are visible only to the appropriate database servers that are meant to access them.
What must be done to achieve this?

• A. Configure Exadata realms using Oracle ASM-scoped security mode.
• B. Configure Exadata realms using Database –scoped security mode.
• C. Edit the CELLI
• D. ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.
• E. Edit the CELLINI
• F. ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.
• G. Edit the CELLI
• H. ORA file on each database server to contain IP addresses of database servers which are allowed access to specific storage servers in the same storage grid.
• I. Edit the CELLI
• J. ORA file on each storage server on contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that storage server belongs.

Answer: C

Explanation: The cellinit.ora file is host-specific, and contains all database IP addresses that connect to the storage network used by Oracle Exadata Storage Servers. This file must exist for each
database that connect to Oracle Exadata Storage Servers.
The cellinit.ora file contains the database IP addresses. The cellip.ora file contains the storage cell IP addresses. Both files are located on the database server host.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-configuring.htm#SAGUG20369

NEW QUESTION 10
Because of a motherboard failure on an X6 high-capacity Exadata storage server, you must replace the server chassis with a replacement unit.
Which are three of the components must you move from the original Exadata storage server to the new Exadata storage server?

• A. Redundant power supplies
• B. The host bus channel adaptor
• C. The USB flash drive
• D. The four Sun Flash Accelerator PCIe cards
• E. The 12 physical disks

Answer: ADE

Explanation: Remove the following reusable components: References:https://docs.oracle.com/cd/E62172_01/html/E63689/goiqw.html#scrolltoc

NEW QUESTION 11
Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?

• A. The Infiniband subnet master location can be determined by using the getmaster command run on any database server.
• B. The Infiniband subnet master location can be determined by using the getmaster command run on an IB switch.
• C. The InfiniBand port status may be displayed on the storage servers by using the LIST IBPORT command in the CELLCLI utility.
• D. The InfiniBand port status may be displayed on the Infiniband switches by using the LIST IBPORT command in the DBMCLI utility.
• E. The InfiniBand port status may be displayed on the database servers by using the LIST IBPORT command in the DBMCLI utility.
• F. The InfiniBand port monitoring is automatic on the database servers and is managed by Enterprise Manager.

Answer: BCE

Explanation: B: From any InfiniBand switch in the network (leaf switch or spine switch), log in as root and run the getmaster command to obtain the location of the master SM as follows:
# getmaster
This command displays the host name or IP address and the IP address of the switch where the master SM is running.
C: CellCLI> list ibport - Will display InfiniBand configuration details
E: The DBMCLI utility is the command-line administration tool for configuring database servers, and managing objects in the server environment.
The LIST IBPORT command displays attributes for InfiniBand ports determined by the specified attributes and filters.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/exadata-dbmcli.htm
https://docs.oracle.com/cd/E18476_01/doc.220/e18478/GUID-9FF8B5B0-3481-4B73-89D3-108CBD7EB989.htm

NEW QUESTION 12
Which two statements are true about Exadata X5 cell metrics and alerts?

• A. Cell alerts on each storage server are accumulated in memory by the CELLSRV process and stored on a filesystem-based repository.
• B. Cell metrics are written to disk every hour by default.
• C. Cell metrics on each storage server are accumulated in memory by the CELLSRV process and written to a filesystem-based repository.
• D. Cell alerts on each server are accumulated in memory by the MS process and stored on a filesystem-based repository.
• E. Cell alerts are written to disk every hour by default.

Answer: BD

Explanation: Metrics are a series of measurements that are computed and retained in memory for an interval of time, and stored on a disk for a more permanent history.
On the storage servers, the CELLSRV process provides the majority of Oracle Exadata storage services and is the primary storage software component. One of its functions is to process, collect, and store metrics. The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of metrics in memory, and writes to an internal disk-based repository hourly.
References:http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html

NEW QUESTION 13
Which four statements are true about the configuration of Auto Service Request (ASR) for use with an X5 Database Machine?

• A. ASR Manager software may be installed on one of the database servers in the Database Machine.
• B. ASR can connect to the Internet using Simple Network Management Protocol (SNMP), using a proxy server.
• C. ASR Manager can connect to the Internet directly with HTTPS.
• D. ASR Manager can connect to the Internet with HTTPS using a proxy server.
• E. ASR can connect to the Internet directly using Simple Network Management Protocol (SNMP).
• F. ASR Manager software may be installed on a server that is not part of the Database Machine.

Answer: ACDF

Explanation: C: If you need to use HTTPS for security purposes, you can set up HTTPS/SSL for the ASR Manager HTTP receiver.
D: As part of the registration process for ASR Manager, you can optionally set the ASR Manager to access the internet through a proxy server.
References:https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.ht m#ASRUD137

NEW QUESTION 14
Which two statements are true regarding the use of Auto Service Request (ASR) with an X6 Database Machine?

• A. The database server ILOMs must use SMTP over the management network for notifications to ASR Manager.
• B. The database server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.
• C. The storage server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.
• D. The database server MS process must have SNMP traps configured to use the management network for notifications to ASR Manager.

Answer: BC

Explanation: B: 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.
C: Exadata Storage Server plug-inextends 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.
References: https://dbatrain.wordpress.com/2011/06/
http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html

NEW QUESTION 15
You plan to consolidate multiple mission-critical databases onto a single rack Exadata X6
database Machine.
You do not plan to use virtualization on the database servers.
You have identified two database categories, based on differing availability and maintenance objectives.
Which two choices will be the best solution?

• A. Create a single database cluster that accesses a single storage grid.
• B. Create a single database cluster that accesses multiple storage grids.
• C. Partition the Exadata storage servers into two separate storage grids.
• D. Create a single storage grid and share space on the celldisks using Exadata storage realms.
• E. Partition the database servers into two separate clusters.

Answer: BE

NEW QUESTION 16
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. Corruption in the /(root) filesystem
• C. Corruption in a normal or high redundancy ASM diskgroup
• D. The failure of both physical disks 0 and 1
• E. Only the failure of physical disk 1
• F. Only the failure of physical disk 0

Answer: BD

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.

NEW QUESTION 17
You have altered an index supporting a constraint to be invisible on a large data warehouse table in an X5 Database Machine.
Which two statements are true?

• A. You might retain the index, and leave it as invisible, and the constraint will still be recognized and enforced.
• B. You must retain the index and make it visible again for the constraint to be recognized and enforced.
• C. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY for the constraint to be recognized.
• D. You might drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags for the constraint to be recognized.
• E. You might drop the index and make the constraint invisible, for the constraint to be recognized and enforced.

Answer: BC

Explanation: B: With making indexes invisible, we can easily check whether indexes are useful without having to drop (and in case recreate) them actually. While this may be of interest for “ordinary” Oracle Databases already, it is particular a useful feature for Exadata where we expect some conventional indexes to become obsolete after a migration.
C: DISABLE NOVALIDATE RELY means: "I don't want an index and constraint checking to slow down my batch data loading into datawarehouse, but the optimizer can RELY on my data loading routine and assume this constraint is enforced by other mechanism". This information can greatly help optimizer to use correct materialized view when rewriting queries. So if you don't use materialized views for query rewrite then you can put RELY for all your constraints (or NORELY for all your constraints) and forget about it.