Renewal 1z0-070 Torrent 2021

NEW QUESTION 1
Which two statements are true about backup performance when using Recovery Manager (RMAN) on an X5 Database Machine?

• A. Backups are fast because the Infiniband network is faster than fiber channel storage, so RMAN read I/O operations are faster than in traditional storage networks.
• B. Backups are fast, because physical I/Os operations are reduced by the use of the Storage Index by cellsrv.
• C. Backups are fast, because data blocks are read from the Database Flash Cache.
• D. Backups are fast, because all data blocks are read from the Exadata Smart Flash Cache.
• E. For incremental backups using Block Change Tracking, cellsrv filters blocks and returns only those that have changed since the last backup.

Answer: DE

Explanation:
D: The storage server software manages the flash cache and can recognize different types of I/O requests so that non-repeatable data access like RMAN backup I/O does not flush database blocks from the cache. It also prioritizes frequently accessed block types such as redo logs, control files, and index root blocks.
E: RMAN block change tracking allows incremental backups to run very quickly and efficiently. With block change tracking, only the areas of the database that have been modified since the last incremental backup or full backup are read from disk.

NEW QUESTION 2
Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?

• A. The “keep” cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.
• B. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.
• C. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.
• D. Single block reads can benefit from Smart Flash Cache.
• E. Multiblock reads can benefit from Smart Flash Cache.

Answer: BDE

Explanation:
D: By default Exadata stores only small I/Os in the Exadata Smart Flash Cache. Small I/Os in most cases are single-block reads. During a full table scan Oracle requests blocks in multiblock lumps (by default 16 blocks), and these are

NEW QUESTION 3
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.

NEW QUESTION 4
You plan to monitor the status of the motherboard, memory, power, fans, and network
cards on the database nodes in your Exadata X6 Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

• A. No thresholds need to be set because they are present in the ILOM and in Enterprise Manager.
• B. Set thresholds in ILOM and in Enterprise Manager because they are not present anywhere and must be set in both places.
• C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.
• D. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

Answer: D

NEW QUESTION 5
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 6
Which three statements are true about the CELLCLI command?

• A. It can execute commands on multiple storage servers in parallel.
• B. It has command-line history.
• C. It requires root privileges to create CELLDISKS and GRIDDISKS.
• D. It can be executed on storage servers.
• E. It can be executed using the DCLI utility.

Answer: BDE

Explanation:
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.
References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- cellcli.htm

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
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 9
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 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 three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?

• A. on an ACFS file system stored in a staging database on the Database Machine
• B. a ZFS over NFS file system mounted on a database server where the external table will be accessed
• C. an Exadata-based ACFS file system on the Database Machine
• D. a DBFS file system stored in a staging database on the Database Machine
• E. on local storage on one or more storage servers that are accessible to the database server where the load will be performed

Answer: ABE

NEW QUESTION 12
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 13
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 14
Which two statements are true about data paths used during RMAN backup and restore operations when media management servers use InfiniBand to connect to an X5 Database Machine?

• A. During backups, data blocks are always read from Smart Flash Cache by cellsrv.
• B. During restores, data blocks read from the media are sent to a database server that sends the blocks to cellsrv to be written.
• C. During backups, data blocks are read by cellsrv and sent to a database server, which sends the blocks to the media manager to be written to media.
• D. During backups, data blocks are read by cellsrv and sent directly to the media manager to be written to media.
• E. During restores, data blocks read from the media are sent directly to cellsrv to be written.

Answer: DE

Explanation:
The fastest database backup is achieved via InfiniBand.
RMAN does not back up directly to tape. However, it will integrate with media management software such as Oracle Secure Backup and utilize their capabilities to manage tape libraries.
Exadata Database Machine: The Database Machine contains the databases that need to
be backed up. Oracle RMAN is the only mechanism to back up the databases that utilize Exadata Storage Servers as the storage. RMAN processes run on the database servers and interact with the Oracle Secure Backup (OSB) agent, which further interacts with the media management software and enables RMAN to communicate with the tape library.
References:http://apprize.info/data/oracle_4/6.html

NEW QUESTION 15
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 16
Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

• A. IPMI can be used for server configuration and management on each database server.
• B. The Baseboard Management Controller (BMC), which supports IPMI, runs as amultithreaded process on the storage server O/S.
• C. The Baseboard Management Controller (BMC), which supports IPMI, runs as a single- threaded process on the storage server O/S.
• D. IPMI can be used for server configuration and management on each storage server.

Answer: AC

Explanation:
A: IPMI – short for Intelligent Platform Management Interface – is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It’s not an Exadata command but rather a general Linux one.
To power on a cell or database server, issue this from another server:
# ipmitool -H prolcel01-ilom -U root chassis power on
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now
C: Like the KCS interface, the SSIF Interface is only specified as a ‘Single Threaded Interface’ for standard IPMI commands. That is, the BMC implementation is not expected to process more than one IPMI request at a time. While an implementation is allowed to have a degree of ‘command queuing’, for standard IPMI messages the SSIF lacks a ‘Seq’ field that software can use to match up particular instances of requests with responses.
References:https://www.intel.com/content/dam/www/public/us/en/documents/specification-updates/ipmi-intelligent-platform-mgt-interface-spec-2nd-gen-v2-0-spec-update.pdf

NEW QUESTION 17
Which two statements are true about the Integrated Lights Out Manager (ILOM) on an Exadata x5 or x6 Database Machine?

• A. ILOM on database servers can use IPMI to send sensor alerts to an Enterprise Manager Agent.
• B. ILOM on a storage server uses SNMP to send sensor alerts to the cellsrv process on the same storage server.
• C. ILOM on a storage server uses IPMI to send sensor alerts to the MS process on the same storage server.
• D. ILOM on a storage server uses SNMP to send sensor alerts to the MS process on the same storage server.
• E. ILOM on database servers can use SNMP to send sensor alerts to an Enterprise Manager Agent.

Answer: CE

Explanation:
C: ILOM supports the Intelligent Platform Management Interface (IPMI), which enables you to monitor and control your server platform, as well as to retrieve information about your server platform.
ILOM supports alerts in the form of IPMI Platform Event Trap (PET) alerts. Alerts provide advance warning of possible system failures.
E: Oracle ILOM supports the Simple Network Management Protocol (SNMP), which is used to exchange data about network activity.
SNMP functionality requires the following two components: References:https://docs.oracle.com/cd/E19860-01/E21452/E21452.pdf

NEW QUESTION 18
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 19
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 20
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: AD

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 21
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 22
You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your X6 Database Machine. The Database Machine database version is 11.2.
You plan to perform a physical database migration using Transportable Database. Which two are requirements for this method?

• A. The source database must be deployed on a Little Endian platform,
• B. The source database must be at least 11.1.
• C. The source database must be at least 11.2.
• D. The source database must use only bigfile tablespaces.
• E. The source database must be deployed on a Big Endian platform.
• F. The source database must not use bigfile tablespaces.

Answer: AC

Explanation:
Transportable database approach (TDB). If the source system is running Oracle 11.2 or above with Little Endian format, this method can be used to migrate the database to Exadata.
References:https://www.toadworld.com/platforms/oracle/w/wiki/11551.managing-troubleshooting-exadata-part-3-migrating-databases-to-exadata-database-machine-best- practices

NEW QUESTION 23
Your X6 Exadata Database Machine is running Oracle Database 12c, and has a large database with some very large tables supporting OLTP workloads.
High-volume insert applications and high-volume update workloads access the same tables.
You wish to compress these tables without causing unacceptable performance overheads to the OLTP workload.
Which three are true regarding this requirement?

• A. Compression is performed on database servers when using row store compress advanced in an Exadata environment.
• B. Using row store compress advanced will compress the data more than if using column store compress for archieve low.
• C. The compression method column store compress for archive high is the worst fit for this requirement.
• D. Compression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.
• E. Using row store compress advanced will compress the data less than if using column store compress forquery low.

Answer: ABD

Explanation:
A: Creating a Table with Advanced Row Compression
The following example enables advanced row compression on the table orders: CREATE TABLE orders ... ROW STORE COMPRESS ADVANCED;
B: ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor

NEW QUESTION 24
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 25
......