100% Guarantee 1z0-070 Exam Questions and Answers 2021

NEW QUESTION 1
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 2
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 3
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 4
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 5
You are examining your Exadata storage servers for routine maintenance requirements and run the imageinfo command as shown:
[root@excel04 ~] # imageinfo
Kernel version: 2.6.18-194.3.1.0.4.el5 #1 SMP Sat Feb 19 03:38:37 EST 2011 x86_64 Cell version: OSS_11.2.0.3.0_LINUX.X64_110429.1
Cell rpm version: cell-11.2.2.3.1_LINUX.X64_110429.1-1
Active image version: 11.2.2.3.1.110429.1
Active image activated: 2011-05-09 16:26:36- 0400 Active image status: success
Active image partition on device: /dev/md6 Active software partition on device: /dev/md8
In partition rollback: Impossible
Cell boot usb partition: /dev/sdm1
Cell boot usb version: 11.2.2.3.1.110429.1
Inactive image version: 11.2.1.2.6
Inactive image activated: 2010-10-04 23:59:16 -0400 Inactive image STATUS: success
Inactive system partition on device: /dev/md5
Inactive software partition on device: /dev/md7
Boot area has rollback archive for the version: 11.2.1.2.6 Rollback to the inactive partitions: Possible
Which two statements are true about the software and system partitions?

• A. /dev/md6 and /dev/md8 have one of their mirror copies on physical disk 1
• B. /dev/md6 and /dev/md8 are located only on physicaldisk1
• C. dev/md5 and /dev/md7 have one of their mirror copies on physicaldisk 0
• D. dev/md5 and /dev/md7 are located only on physicaldisk 0

Answer: BC

NEW QUESTION 6
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 7
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 8
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 9
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 10
You must replace the battery on the disk controller in three Exadata storage servers and must power off the affected storage servers.
Which two commands must you execute to safely power off the storage servers in an X5 Database Machine?

• A. ‘shutdown -h now’on the affected storage servers
• B. CellCLI> LIST GRIDDISK WHERE STATUS != ‘inactive’
• C. CellCLI > LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != ‘Yes’
• D. ‘crsctl stop cluster –all’on one of the database servers
• E. CellCLI> ALTER GRIDDISK ALL INACTIVE

Answer: CE

Explanation: C: Step 1:
Run the following command to check if there are other offline disks
CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'
If any grid disks are returned, then it is not safe to take the storage server offline because proper Oracle ASM disk group redundancy will not be intact.
E: Step 2:
Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline using the following command:
CellCLI> ALTER GRIDDISK ALL INACTIVE
Taking the storage server offline when one or more grid disks are in this state will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.

NEW QUESTION 11
Identify three valid reasons for creating multiple griddisks on a single harddisk-based celldisk.

• A. to implement storage realms so that storage that can be reserved for specific resource consumer groups in the same database
• B. to enable the creation of normal or high redundancy ASM diskgroups
• C. to segregate storage into multiple pools with different performance characteristics
• D. to enable disk mirroring for the system area
• E. to implement storage realms so that storage can be reserved for specific databases
• F. to implement storage realms so that storage that can be reserved for specific Grid Infrastructure

Answer: BCF

Explanation: Creating multiple grid disks per cell disk allows you to create multiple pools of storage on the same Exadata Storage Server. The multiple grid disks can be assigned to separate ASM diskgroups, which can be provisioned to different databases.
Note: Griddisk is a logical disk that can be created on a celldisk. In a standard Exadata deployment we create griddisks on hard disk based celldisks only. While it is possible to create griddisks on flashdisks, this is not a standard practice.
F: After you complete the cell configuration, you can perform the following optional steps on the storage cell:
References:https://docs.oracle.com/cd/E80920_01/SAGUG/SAGUG.pdf

NEW QUESTION 12
In which three situations will a Smart Scan occur on a table for which Smart Scan is possible, assuming that nothing in the environment prevents a Smart Scan?

• A. The ASM diskgroup containing the table’s tablespace has a 4 MByte AU size.
• B. Executing queries in parallel.
• C. setting serial_direct_read= true in the session issuing the SQL statements and executing a serial query.
• D. Having direct path reads used at execution time.
• E. An update to the table is made identifying the row to be modified by primary key.
• F. An index range scan occurs for the table.

Answer: BCD

Explanation: Whether you get a direct path read & smart scan, depends on the current buffer cache size, how big segment you’re about to scan and how much of that segment is actually cached at the moment. This dynamic decision unfortunately can cause unexpected surprises and variance in your report/batch job runtimes.
To work around these problems and force a direct path read/smart scan, you can either: D: One of the most common Exadata performance problems is that the direct path reads
(and thus also Smart Scans) don’t sometimes kick in when running full scans in serial
sessions.
Note: Smart Scan is a subset of Cell Offload Processing and is perhaps the feature that is most highly associated with Exadata. Smart Scan allows Oracle databases to push query information down to the storage level, specifically:

NEW QUESTION 13
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 14
An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.
Identify the two steps that you must perform to replace this failed physical disk.

• A. Add the griddisks back into the ASM diskground they used to be a member of.
• B. Create a new celldisk and new griddisks on the replaced physical disk.
• C. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
• D. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
• E. Replace the failed physical disk.

Answer: CE

Explanation: You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.
Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.
References:http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#DBMMN21047

NEW QUESTION 15
Which three statements are true about bulk data loading capabilities in an X5 Database Machine environment?

• A. DBFS must use the DBFS_DG diskgroup for any DBFS store.
• B. DBFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
• C. DBFS must be used to have a POSIX-compliant shared storage solution that is accessible from the database servers on a Database Machine.
• D. DBFS must be used to bulk load data into a production database on the Database Machine.
• E. ACFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
• F. ACFS must be used to have a POSIX –compliant shared storage solution that is accessible from the database servers on a Database Machine.
• G. ACFS may use the DBFS_DG diskgroup to contain the ADVM volume file.

Answer: BCD

Explanation: External tables on DBFS file-systems provide the probably the most high-performance way to bulk load data into your database.
Bulk Data Loading
Describe the various options for staging data to be bulk loading into Database Machine Configure the Database File System (DBFS) feature for staging input data files
Use external tables based on input data files stored in DBFS to perform high-performance data loads

NEW QUESTION 16
Which three storage components are available after nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks?

• A. mirrored system area on hard disk 0, hard disk 1, and hard disk 2
• B. Exadata Smart Flash Cache using all of the flashdisk space
• C. the DBFS_DG diskgroup with high redundancy
• D. mirrored system area on hard disk 0 and hard disk 1
• E. the RECO_<DBM_Name> ASM diskgroup
• F. the DATA_<DBM_Name> ASM diskgroup

Answer: CEF

Explanation: The first two disks of Exadata Storage Server are system disks. Oracle Exadata Storage Server Software system software resides on a portion of each of the system disks. These portions on both system disks are referred to as the system area.
The default configuration on Exadata is to have 3 diskgroups - DATA, RECO, and DBFS_DG.

NEW QUESTION 17
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: