http://https://www.newpassleader.com/Oracle/1z0-070-exam-preparation-materials.html (90 Q&As Dumps, 30%OFF Special Discount: 30free )
NEW QUESTION NO: 10
Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 Database Machine?
A. Linux operating system on the storage server
B. InfiniBand HCA firmware on the storage server
C. Storage server hard disk device drivers
D. Storage server flash device drivers
Answer: D
Explanation/Reference:
Exadata patches are intended for and include fixes for both the storage servers and Compute servers, and optionally InfiniBand switches.
Patching order
You should patch the Exadata Database Machines in the following sequence Oracle GI/RDBMS Homes
Exadata Storage Cells
Compute nodes
Infiniband Switches
References: https://www.toadworld.com/platforms/oracle/w/wiki/11640.oracle-exadata-patching
NEW QUESTION NO: 11
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: B,C
Explanation/Reference:
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 NO: 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: B,E
Explanation/Reference:
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.
Incorrect Answers:
A: Smart scan can cope with some cases of chained rows
References: http://oracle-randolf.blogspot.se/2013/01/exadata-smart-scan-projection-limitation.html
NEW QUESTION NO: 13
Which three must be true for a Smart Scan to occur for a table?
A. cell_offload_processing must be true in sessions issuing SQL statements that access the table.
B. The query must be executed serially.
C. The query must be executed in parallel.
D. Direct path reads must be used at run time.
E. The ASM diskgroup containing the table's tablespace must have a 4 Mbyte AU size.
F. The ASM diskgroup containing the table's tablespace must have cell.smart_scan_capable set to true.
Answer: A,D,F
Explanation/Reference:
A: pt_param( 'cell_offload_processing' 'TRUE') hint is used to enable the exadata smart scan feature in sql execution process.
D: Direct reads bypass the buffer cache and go directly into the process PGA. Cell offload operations occur for direct reads only.
F: The cell.smart_scan_capable attribute must be set to TRUE.
Incorrect Answers:
B, C: The query can run either serially or in parallel.
References: http://blog.tanelpoder.com/2013/05/29/forcing-smart-scans-on-exadata-is-_serial_direct_read- parameter-safe-to-use-in-production/
NEW QUESTION NO: 14
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: B,D,E
Explanation/Reference:
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
Incorrect Answers:
C: Oracle has over time has almost completely eliminated caching of table scan blocks from the buffer cache and why by default Exadata does not cache full table scan blocks in the Exadata Smart Flash Cache.
During a full table scan Oracle requests blocks in multiblock lumps (by default 16 blocks), and these are not stored in the Exadata Smart Flash Cache unless you change the CELL_FLASH_CACHE clause for the segment.
References: http://www.informit.com/articles/article.aspx?p=2418151&seqNum=3
NEW QUESTION NO: 15
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: B,D
Explanation/Reference:
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 NO: 16
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: A,C
Explanation/Reference:
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.
Incorrect Answers:
D: Oracle recommends that you install Oracle ASR Manager on an external, standalone server.
References: http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-490B2837-C608-4626-B4FF-
59F679C36302
NEW QUESTION NO: 17
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: A,D
Explanation/Reference:
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 NO: 18
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 a multithreaded 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: A,C
Explanation/Reference:
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 NO: 19
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: C,D,E,F
Explanation/Reference:
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 log shipping 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.
Incorrect Answers:
A: Storage indexes are not stored on disk; they are resident in the memory of the storage cell servers.
They are created automatically after the storage cells receive repeated queries-with predicates-for columns. No user intervention is needed to create or maintain storage indexes. And because they are memory-resident structures, they disappear when the storage cells are rebooted.
References: http://www.oracle.com/technetwork/testcontent/o31exadata-354069.html
NEW QUESTION NO: 20
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 multiple storage grids.
B. Partition the Exadata storage servers into two separate storage grids.
C. Create a single database cluster that accesses a single storage grid.
D. Partition the database servers into two separate clusters.
E. Create a single storage grid and share space on the celldisks using Exadata storage realms.
Answer: A,D