Download Oracle Exadata X5 Administration.1z0-070.TestInside.2020-06-02.62q.vcex

Vendor: Oracle
Exam Code: 1z0-070
Exam Name: Oracle Exadata X5 Administration
Date: Jun 02, 2020
File Size: 767 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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?
  1. No thresholds need to be set because they are present in the ILOM and in Enterprise Manager.
  2. Set thresholds in ILOM and in Enterprise Manager because they are not present anywhere and must be set in both places.
  3. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.
  4. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.
Correct answer: D
Question 2
Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?
  1. ASR Manager may be installed on any type of server running Oracle Solaris.
  2. ASR Manager may be installed on any type of server running Oracle Linux.
  3. Oracle Linux must be used on the server where ASR Manager is installed.
  4. SMTP must be enabled on at least one database server.
  5. Oracle Solaris must be used on the server where ASR Manager is installed.
  6. ASR Manager must be installed on one of the database servers.
  7. HTTPS connectivity must be enabled from the ASR Manager host to the Internet. 
Correct answer: ABG
Explanation:
AB: Oracle recommends that you install Oracle ASR Manager on an external, standalone server. This server receives fault telemetry information from Oracle Exadata Database Machine servers. This server must run an Oracle Solaris or Linux operating system. G: Before installing Oracle Auto Service Request (Oracle ASR) you must ensure connectivity to the Internet using HTTPS.References: Oracle Auto Service Request Exadata Database Machine Quick Installation Guidehttp://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-89192315-1B1A-4B5A-89BB-94BB5B6ABB05
AB: Oracle recommends that you install Oracle ASR Manager on an external, standalone server. This server receives fault telemetry information from Oracle Exadata Database Machine servers. This server must run an Oracle Solaris or Linux operating system. 
G: Before installing Oracle Auto Service Request (Oracle ASR) you must ensure connectivity to the Internet using HTTPS.
References: Oracle Auto Service Request Exadata Database Machine Quick Installation Guide
http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-89192315-1B1A-4B5A-89BB-94BB5B6ABB05
Question 3
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?
  1. Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.
  2. Fail back to the original agent when the host is restarted is done automatically.
  3. Fail over to any secondary agent is done automatically.
  4. Fail over to any secondary agent must be done manually.
  5. Database machine plug-ins must be deployed to all Enterprise Manager agents.
  6. Fail back to the original agent when the host is restarted must be done manually.
Correct answer: BCE
Question 4
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.
  1. Add the griddisks back into the ASM diskgroup they used to be a member of.
  2. Create a new celldisk and new griddisks on the replaced physical disk.
  3. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
  4. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
  5. Replace the failed physical disk.
Correct 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
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
Question 5
Which two completely prevent a Smart Scan from occurring?
  1. querying a table containing many chained rows
  2. querying a table containing many migrated rows
  3. performing a minimum or maximum function on an indexed column
  4. performing a Fast Full Index scan on a reverse key index
  5. referencing more than 255 columns form an OLTP compressed table in a query
  6. querying a table containing a JSON column
Correct 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. Incorrect Answers:A: Smart scan can cope with some cases of chained rowsReferences: http://oracle-randolf.blogspot.se/2013/01/exadata-smart-scan-projection-limitation.html
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
Question 6
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?
  1. 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.
  2. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
  3. All Exadata storage servers may run Oracle Virtual Machine (OVM).
  4. All Exadata storage servers must run Oracle Linux.
  5. 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).
Correct 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
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
Question 7
Which two are true concerning Columnar Flash Caching?
  1. It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.
  2. It automatically transforms ROW STORE COMPRESS compressed data into a pure columnar format during Exadata Smart Flash Cache population.
  3. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.
  4. It is enabled by default.
  5. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.
  6. It improves single-row lookup performance.
Correct 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. Incorrect Answers:F: Columnar Flash Caching accelerates reporting and analytic queries while maintaining excellent performance for OLTP style single row lookups.References:http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-monitoring.htm#SAGUG20883http://www.oracle.com/technetwork/database/exadata/exadata-x5-8-ds-2745934.pdf
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. 
Incorrect Answers:
F: Columnar Flash Caching accelerates reporting and analytic queries while maintaining excellent performance for OLTP style single row lookups.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-monitoring.htm#SAGUG20883
http://www.oracle.com/technetwork/database/exadata/exadata-x5-8-ds-2745934.pdf
Question 8
You are evaluating the performance of a SQL statement that accesses a very large table. 
You run this query:
  
Identify two reasons why the “cell physical IO interconnect bytes” statistic is greater than the “cell physical IO interconnect bytes returned by smart scan” statistic.
  1. There is a transaction, which committed after the query began, 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.
  2. There are chained rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.
  3. The table is a hash clustered table, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.
  4. The table is list partitioned, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O.
  5. There is a local index on a list partitioned table on the column used in the WHERE clause, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O.
Correct answer: CD
Explanation:
C: Scan on a clustered table can prevent a Smart Scan from occur.D: Scan on an index-organized table can prevent a Smart Scan from occur.Note: The Cell physical IO interconnect bytes returned by smart scan metric shows how many bytes of I/O were returned by a smart scan to the database server.References: https://uhesse.com/2011/01/19/exadata-part-i-smart-scan/
C: Scan on a clustered table can prevent a Smart Scan from occur.
D: Scan on an index-organized table can prevent a Smart Scan from occur.
Note: The Cell physical IO interconnect bytes returned by smart scan metric shows how many bytes of I/O were returned by a smart scan to the database server.
References: https://uhesse.com/2011/01/19/exadata-part-i-smart-scan/
Question 9
Which three are true about Exadata Smart Flash Log?
  1. Databases on the Database Machine use Exadata Smart Flash Log by default.
  2. I/O Resource Manager database plans can be used to enable or disable Exadata Smart Flash Log for individual databases.
  3. LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first.
  4. I/O Resource Manager category plans can be used to enable or disable Exadata Smart Flash Log for different I/O categories.
  5. The use of Exadata Smart Flash Logs is mandatory for support of production databases.
Correct answer: ABC
Explanation:
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases. B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine. C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time. Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time. This algorithm will significantly smooth out redo write response times and provide overall better database performance. Incorrect Answers:D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time.References: http://structureddata.org/2011/10/12/exadata-smart-flash-logging-explained/
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases. 
B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart Flash Logging for the different databases running on the Database Machine. 
C: Smart Flash Logging works as follows. When receiving a redo log write request, Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time. 
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time. 
This algorithm will significantly smooth out redo write response times and provide overall better database performance. 
Incorrect Answers:
D: Category plans are configured and enabled using the CellCLI utility on the cell. Only one category plan can be enabled at a time.
References: http://structureddata.org/2011/10/12/exadata-smart-flash-logging-explained/
Question 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?
  1. Linux operating system on the storage server
  2. InfiniBand HCA firmware on the storage server
  3. Storage server hard disk device drivers
  4. Storage server flash device drivers
Correct answer: D
Explanation:
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
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
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!