Replace 1z0-070 Keys 2021

NEW QUESTION 1
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 2
Examine this list of software components:
1. Oracle Virtual Machine (OVM)
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server (CELLSRV)
8. diskmon
Identify the location where these software components can run in the standard Exadata Database Machine deployment.

• A. 1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.
• B. 1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
• C. 1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
• D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.
• E. 2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.

Answer: B

Explanation:
Automatic Diagnostic Repository Command Interpreter (ADRCI) can be used on an Exadata storage server.

NEW QUESTION 3
You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets.
Which three statements are true about this configuration?

• A. Simple Network Management Protocol (SNMP) traps are used to send notifications fromdatabase servers to the ASR Manager.
• B. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.
• C. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).
• D. When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.
• E. Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.
• F. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager.

Answer: BCF

Explanation:
B: Oracle ASR Manager only processes SNMP traps that are sent from IP addresses that Oracle ASR Manager recognizes.
Example of Exadata Storage Server SNMP Trap
This example shows the SNMP trap for an Exadata Storage Server disk failure. The corresponding hardware alert code has been highlighted.
2011-09-07 10:59:54 server1.example.com [UDP: [192.85.884.156]:61945]:
RFC1213-MIB::sysUpTime.0 = Timeticks: (52455631) 6 days, 1:42:36.31 SNMPv2-SMI::snmpModules.1.1.4.1.0 = OID: SUN-HW-TRAP-
MIB::sunHwTrapHardDriveFault
SUN-HW-TRAP-MIB::sunHwTrapSystemIdentifier = STRING: Sun Oracle Database Machine
Etc.
C (not D): The ASR Manager uses the SNMP GET protocol to query ASR assets for additional fault information.
To configure fault telemetry, choose one of the following three options:
Add SNMP Trap Destinations Using OneCommand (recommended for new installations) Add SNMP Trap Destinations for Multiple Servers Using the dcli Utility
Add SNMP Trap Destinations for a Single Server
References: http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm
https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD 331

NEW QUESTION 4
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 5
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 6
You are planning the monitoring configuration for your X5 Database Machine.
Which two components are monitored directly through the use of Exadata –specific Enterprise Manager Plug-Ins?

• A. the database server Clusterware
• B. the storage server ILOM
• C. ASM instances
• D. the database server O/S
• E. the Infiniband switches

Answer: BE

Explanation:
The Oracle Enterprise Manager Grid Control Exadata Monitoring plug-in bundle allows you to monitor the following key components of Exadata machine:
References:http://www.oracle.com/technetwork/oem/grid-control/exadata-plug-in-bundle- 188771.html

NEW QUESTION 7
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 8
You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Exadata X6 Database Machine.
You use RAC for your databases and also use Data Guard, having standby databases on another Database Machine.
You want to have scripts that contain the appropriate commands to patch your environment.
Your patch bundle is one the first database server and is located at/uo1/stage. You have downloaded the oplan utility to the first database server and run:
$ORACLE_HOME/oplan/oplan generateApplySteps /u01/stage
Which two statements are true concerning the type of instructions oplan will generate?

• A. Instructions for patching the Grid Infrastructure home on the primary location
• B. Instructions for patching the Data Guard environment on the standby location
• C. Instructions for patching the RAC Oracle Home on the primary location
• D. Instructions for patching only storage servers
• E. Instructions for patching all components on the Database Machine

Answer: AC

Explanation:
Oplan generates instructions for all of the nodes in the cluster. Note:

NEW QUESTION 9
Which three are sources for alerts from storage servers in an X5 Database Machine?

• A. Software errors reported by the MS process on the storage servers
• B. Hardware sensor alerts reported by the CELLSRV process on the storage servers
• C. Software errors reported by the RS process on the storage servers
• D. Hardware sensor alerts detected by the ILOM on the storage servers
• E. Metrics that have administrator-defined thresholds on the storage servers

Answer: ABE

Explanation:
AB: 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. In addition, the MS process can generate alerts for important storage cell hardware or software events.

NEW QUESTION 10
Which four are true about Exadata features?

• A. Storage Indexes persist across Exadata storage server reboots.
• B. Data Warehouse workloads will benefit from Smart Flash Cache configured in Write- Through mode.
• C. Hybrid Columnar Compressed tables can be compressed and decompressed on Exadata storage servers.
• D. Hybrid Columnar Compressed tables can be compressed and decompressed on the database servers.
• E. OLTP workloads will benefit from Smart Flash Cache configured in Write-Back mode.
• F. Storage Indexes persist across database server reboots.

Answer: CDEF

Explanation:
CD: That data remains compressed not only on disk, but also remains compressed in the Exadata Smart Flash Cache, on Infiniband, in the database server buffer cache, as well as when doing back-ups or logshipping to Data Guard.
E (not B): Use the Write-Back Flash Cache feature to leverage the Exadata Flash hardware and make Exadata Database Machine a faster system for Oracle Database Deployments. Write-through cache mode is slower than write-back cache mode. However, write-back
cache mode has a risk of data loss if the Exadata Storage Server loses power or fails.
F: Storage indexes are not stored on disk; they are resident in the memory of the storage cell servers.

NEW QUESTION 11
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 12
Which two activities are supported on the storage servers in an Exadata X6 Database Machine?

• A. Upgrading the Storage Server software package using RPM
• B. Configuring secure shell user equivalency for the cellmonitor user
• C. Installing an alternative package manager
• D. Changing the root password
• E. Upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

Answer: AC

NEW QUESTION 13
You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine.
A part of the requirement is to provide for high availability of the monitoring infrastructure. If the host running the agent that has Database Machine targets bound to it fails, the
monitoring of these targets must be done by another agent.
Which three statements are true regarding the configuration used to support this requirement?

• A. Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.
• B. Fail back to the original agent when the host is restarted is done automatically.
• C. Fail over to any secondary agent is done automatically.
• D. Fail over to any secondary agent must be done manually.
• E. Database machine plug-ins must be deployed to all Enterprise Manager agents.
• F. Fail back to the original agent when the host is restarted must be done manually.

Answer: BCE

NEW QUESTION 14
Which two are true concerning Columnar Flash Caching?

• A. It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.
• B. It automatically transforms ROW STORE COMPRESS compressed data into a purecolumnar format during Exadata Smart Flash Cache population.
• C. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.
• D. It is enabled by default.
• E. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.
• F. It improves single-row lookup performance.

Answer: DE

Explanation:
D: In-Memory Columnar Caching on cells is enabled by default when the INMEMORY_SIZE is configured. You do not need to do anything to get this enhancement.
E: Columnar Flash Caching implements a dual format architecture in Exadata flash by automatically transforming frequently scanned Hybrid Columnar Compressed data into a pure columnar format as it is loaded into the flash cache.

NEW QUESTION 15
In which scenario will griddisks residing on the same celldisk have balanced performance characteristics in an X5 High Capacity Exadata Storage Server?

• A. griddisks on memory based celldisks
• B. griddisks on hard disk-based celldisk consumed by ASM when creating diskgroups using ASM-based Intelligent Data Placement (IDP)
• C. griddisks on hard disk-based celldisks consumed by the Database Smart Flash Cache
• D. griddisks on Flash-based celldisks

Answer: B

Explanation:
Intelligent Data Placement enables you to specify disk regions on Oracle ASM disks for best performance. Using the disk region settings, you can ensure that frequently accessed data is placed on the outermost (hot) tracks which have greater speed and higher bandwidth. In addition, files withsimilar access patterns are located physically close, reducing latency. Intelligent Data Placement also enables the placement of primary and mirror extents into different hot or cold regions.
References:https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#O STMG10072

NEW QUESTION 16
Which two are true about the allocation of I/O resources by IORM within the CELLSRV process?

• A. Database Writer I/O always prioritized over all user I/O.
• B. If two consumer groups P and Q in the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups P and Q are still mapped to the same categories.
• C. If two consumer groups C and D in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively, and were remapped to a different category by the DBA, provided that the category plans and the interdatabase plans are unchanged.
• D. If two consumer groups A and B in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and interdatabase plans are unchanged, and consumer groups A and B are still mapped to the same category.
• E. Log Writer I/O and Control File I/O are always prioritized over all user I/O.

Answer: BE

Explanation:
B: Rules in an interdatabase resource plan specify allocations to databases, not consumer groups.
E: Redo and control file writes always take precedence. References:

NEW QUESTION 17
You are patching your Exadata X6 Database Machine by applying a new image to the Storage Servers in a rolling fashion.
Your ASM environment on the Database Machine has five diskgroups stored on an unpartitioned Exadata storage grid, with redundancy settings as shown:
1. DATA_DBM1 – Normal Redundancy
2. RECO_DBM1 – Normal Redundancy
3. DBFS_DG – Normal Redundancy
4. DATA2_DBM1 – High Redundancy
5. DATA3_DBM1 • High Redundancy
Which two diskgroups will not suffer from any data loss throughout the patching process even if there is a single disk failure on one of the cells

• A. DBFS_DG
• B. DATA3_DBM1
• C. DATA2_DBM1
• D. DATA_DBM1
• E. RECO_DBM1

Answer: DE

Explanation:
HIGH redundancy provides protection against 2 simultaneous disk failures from 2 distinct storage servers or 2 entire storage servers. HIGH redundancy provides redundancy during Exadata storage server rolling upgrades.
References:http://blog.umairmansoob.com/choosing-high-vs-normal-redundancy-with- exadata/

NEW QUESTION 18
Which three statements are true about the EXADCLI utility?

• A. It may be run interactively.
• B. It can be used to execute EXACLI scripts on multiple storage servers in parallel.
• C. It can be used to execute O/S commands on multiple storage servers in parallel.
• D. It can be used to execute EXACLI commands on multiple storage servers in parallel.
• E. It uses the same security mechanism as the EXACLI command.
• F. It may be used to execute DBMCLI commands on multiple database nodes in parallel.

Answer: DEF

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.

NEW QUESTION 19
Examine this IORM plan:

Which two are true concerning this plan?

• A. The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.
• B. I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if noother databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.
• C. If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.
• D. I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.
• E. If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.

Answer: BE

Explanation:
The IORM plan can be configured using the ALTER IORMPLAN command on command- line interface (CellCLI) utility on each Exadata storage cell. It consists of two parameters - dbplan and catplan. While the "dbplan" is used to create the I/O resource directives for the databases, the "catplan" is used to allocate resources by workload category consolidated on the target system.
allocation/share - Specify the resource allocation to a specific database in terms of percentage or shares.
limit - Specify maximum limit of disk utilization for a database.

NEW QUESTION 20
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 21
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 leaf switches
• B. the power distribution units
• C. the Cisco 48 port Catalyst Ethernet Switch
• D. the InfiniBand spine switches

Answer: CD

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 22
......