Latest 1z0-070 Pdf 2021

NEW QUESTION 1
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 2
Which two statements are true about the use of DBFS, ACFS, and external file systems and components in an X5 Database Machine environment?

• A. ACFS uses storage in a database on the database machine
• B. DBFS supports file system snapshots.
• C. ACFS supports file system snapshots.
• D. Storage Area Network (SAN) –based file systems may be accessed directly from the storage servers in a database machine.
• E. Oracle Sun ZFS Storage Appliance- based files are not automatically protected by Data Guard.

Answer: BC

Explanation:
DBFS SecureFiles Store Capabilities include support for file system snapshots. Oracle ACFS includes advanced features such as file system snapshot.
References:
http://www.oracle.com/technetwork/ru/database/dbfs-sf-oow2009-v2-160969.pdf http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/benefits-of-oracle-acfs-2379064.pdf

NEW QUESTION 3
Identify two supported modifications to an X5 Database Machine.

• A. installing a Host Bus Adapter (HBA) in the compute nodes
• B. installing additional Operating System (O/S) packages on the computer nodes
• C. installing additional Operating System (O/S) packages on the Exadata storage servers
• D. installing a Host Bus Adapter (HBA) in the storage servers
• E. replacing the Cisco Ethernet switch with another make or model
• F. replacing the Infiniband switches with another make or model

Answer: BD

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 4
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 5
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 6
Which three statements are true about Recovery Manager (RMAN) daily differential incremental backup strategies on an X5 Database Machine for a database having 25% or more of its blocks modified each day and which has an 8 k block size?

• A. Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup.
• B. Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth.
• C. Enabling Block Change Tracking (BCT) on the database can result in a reduction ofphysical I/O on the cells during incremental backups.
• D. For level-1 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
• E. For level-0 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
• F. cellsrv returns only blocks that have changed since the last backup.

Answer: ACF

Explanation:
A: Fast Incremental backups is possible with Block change tracking, which is initially introduced from version 10.2 onwards, by this tool it's very useful to reduce the RMAN incremental backup duration.
If the changes are something around 20% then in this situation BCT helps a lot.
C: Exadata Storage Server offload capability combined with RMAN block change tracking will efficiently perform large I/Os at the storage-tier level, returning only individual changed blocks for incremental backups and increasing the backup performance of the system.
Note: Level 1 backup: A level 1 backup includes only those blocks that have been changed since the "parent" backup was taken. Remember a parent backup may be either a level 0 or a level 1 backup.
Block change tracking allows indeed the highest benefit for databases where the changes are not so high,
Level 0 backup: A level 0 incremental backup is physically identical to a full backup and it includes every data block in the file except empty blocks. The only difference is that the level 0 backup is recorded as an incremental backup in the RMAN repository, so it can be used as the parent for a level 1 backup.
References:http://www.dba-oracle.com/t_rman_backup_types.htm http://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup- 11202-183503.pdf
https://www.toadworld.com/platforms/oracle/w/wiki/11124.fast-incremental-backups-active- data-guard

NEW QUESTION 7
You are in the process of upgrading your X5 Database Machine half rack to a full rack. The new storage servers are called DM01CEL08 through DM01CEL14.
After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATA diskgroup by executing this SQL statement?

• A. 0, because the new griddisks will be added to the existing failgroups
• B. 12, consisting of seven griddisks each
• C. 96, consisting of seven griddisk each
• D. 7, consisting of 12 griddisks each
• E. 1, consisting of all 96 griddisks

Answer: D

Explanation:
The number of failure groups equals the number of Exadata Cells. Each failure group is composed of a subset of grid disks in the Oracle ASM disk group that belong to a single storage cell.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm

NEW QUESTION 8
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 9
You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = low_latency alter iormplan active
There are no database or category plans defined.
You are encountering disk I/O performance problems at certain times, which vary by day
and week.
DSS and Batch workloads perform well some of the time.
Further investigation shows that at times, the workloads are all OLTP I/Os, at other times all batch I/Os, and sometimes a bit of each.
You wish to have disk I/O managed so that performance will be optimized for all workloads. Which statements would you issue to all Exadata Storage Servers to achieve this?

• A. alter iormplan objective=high_throughput
• B. alter iormplan objective=balanced
• C. alter iormplan objective=low_latency
• D. alter iormplan objective= auto
• E. alter iormplan objective= ‘ ’

Answer: D

Explanation:
The supported IORM objectives are auto, low_latency, balanced, and high_throughput. The recommended objective option is auto which allows IORM to continuously monitor the workloads, and select the best mode based on the active workloads currently on the cells.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- iorm.htm

NEW QUESTION 10
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 11
Which two statements are true about the Enterprise Manager plug-in configuration for the X5 Database Machine?

• A. There is one plug-in for Cloud Control.
• B. There are several separate plug-ins for Cloud Control.
• C. Some components of the Database Machine require SNMP trap forwarders.
• D. All components of the Database Machine require SNMP trap forwarders.

Answer: AC

NEW QUESTION 12
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 13
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 14
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. The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization.
• B. The database grid may be partitioned when deploying a multirack Database Machine configuration.
• C. A single database cluster benefits from accessing multiple storage grids.
• D. Multiple database clusters may access the same storage grids.
• E. Multiple database clusters never benefit from accessing a single storage grid.

Answer: BCD

NEW QUESTION 15
Identify three valid configuration options that can be implemented during the initial configuration process of a new X5 Database Machine by using the Exadata Deployment Assistant.

• A. Virtualized Computer Node configuration
• B. OS users that own the Grid Infrastructure installation
• C. Cluster configuration for up to 32 clusters
• D. The size for the system area on the first two disks in each cell
• E. Virtualized Storage node configuration

Answer: ACD

Explanation:
Oracle Exadata Deployment Assistant has two main phases
Oracle Exadata Deployment Assistant can configure Oracle Exadata Database Machine, Recovery Appliance, or Oracle SuperCluster.
References: https://docs.oracle.com/cd/E55822_01/AMOGD/configurator.htm#AMOGD22056 https://www.toadworld.com/platforms/oracle/w/wiki/11469.oracle-exadata-deployment- assistance-oeda

NEW QUESTION 16
You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = off alter iormplan active
There are no database or category plans defined.
You are suffering I/O performance problems at certain times, which vary by day and week. DSS and batch workloads perform well, but your OLTP workloads suffer poor response
times when running at the same time as these other workloads.
You must ensure that DSS and batch workloads retain relatively high throughput without causing excessive degradation of OLTP performance.
Which statement would you issue to all Exadata Storage Servers to achieve this?

• A. alter iormplan objective = low_latency
• B. alter iormplan objective = high_throughput
• C. alter iormplan objective = balanced
• D. alter iormplan objective = auto

Answer: A

Explanation:
When the objective option is set to basic, the database resource plan maximum utilization limits are not enforced. For stricter plan conformance, and enforcement of maximum utilization limits, the objective option must be set to something other than basic. The supported IORM objectives are auto, low_latency, balanced, and high_throughput.
The objective may also be changed to low_latency in which case the latency for critical I/Os is very good but there is a significant degradation in scan throughput when both workloads are running concurrently.

NEW QUESTION 17
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 18
You plan to monitor the ASM configuration on an X5 Database Machine as part of your role supporting Exadata-based ASM diskgroups.
You want to check for potential space problems that take ASM mirroring requirements into account.
Which two values would you monitor from V$ASM_DISKGROUP or by using the ASMCMD LSDG command?

• A. cold_used_mb
• B. total_mb
• C. required_mirror_free_mb
• D. free_mb
• E. usable_file_mb

Answer: BD

Explanation:
Determine the Amount of Available Space
To increase the size of the disks in a disk group you must either have unallocated disk
space available, or you have to reallocate space currently used by a different disk group.
Example: View the space currently used by the disk groups. SELECT name, total_mb, free_mb, total_mb - free_mb used_mb, round(100*free_mb/total_mb,2) pct_free
FROM v$asm_diskgroup ORDER BY 1;

The example above shows that the DATAC1 disk group has only about 15% of free space available while the RECOC1 disk group has about 87% free disk space. The PCT_FREE displayed here is raw free space, not usable free space. Additional space is needed for rebalancing operations.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm#SAGUG20526

NEW QUESTION 19
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 20
Which two must be true for a Smart Scan to occur on a table?

• A. Sessions querying the table must set cell_offload_processing = true.
• B. It must be stored in an ASM diskgroup with a 4MByte AU size.
• C. It must be heap organized.
• D. It must be accessed using direct path reads.
• E. The table must not be compressed.

Answer: AD

NEW QUESTION 21
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 22
Which three statements are true about Automatic Hard Disk Scrubbing and repair on high- capacity storage servers in an X5 Database Machine?

• A. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.
• B. Hard disks are scanned every two weeks by default but only when disks are idle.
• C. Hard disks are scanned every two weeks by default in all situations.
• D. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.
• E. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.

Answer: ACE

Explanation:
The default schedule of scrubbing is every two weeks.
References:http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage- servers.htm

NEW QUESTION 23
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. Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.
• B. Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.
• C. Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.
• D. Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.
• E. Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.

Answer: C

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 24
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 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.
• B. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
• C. All Exadata storage servers may run Oracle Virtual Machine (OVM).
• D. All Exadata storage servers must run Oracle Linux.
• 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: D

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