[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-338 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-338
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-338.html

Oracle Exadata Database Machine and Cloud Service 2018 Implementation Essentials

Question No: 31

Which two statements describe correct network configuration for Exadata Database Machine?

  1. The InfiniBand network subnet manager runs on all database servers to achieve High Availability.

  2. Oracle Clusterware communication is configured to use the management network.

  3. The InfiniBand network interfaces on Linux servers are configured using active-passive bonding.

  4. Database connections to the SCAN listener route through the Ethernet switch in the Exadata rack.

  5. Database servers are deployed with three logical network interfaces configured: management, client access, and private.

Answer: C,D

Question No: 32

Which two actions are permitted with Exadata Database Machine?

  1. replacing the Ethernet switch with an equivalent 1U 48-port Gigabit Ethernet switch

  2. installing a second Ethernet switch in the Exadata rack for client access network connectivity

  3. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand Gateway Switch

  4. configuring a Linux active-active channel bonding on the database servers by using two 10-Gigabit Ethernet port

  5. configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers

Answer: A,B

Explanation: http://www.oracle.com/technetwork/database/exadata/exadata-dbmachine- x3-2-ds-1855384.pdf?ssSourceSiteId=ocomen

“Each Exadata Database Machine X3-2 rack has 2U available at the top of the rack which can be used by customers to optionally install their own client network Ethernet switches in the Exadata rack instead of in some other rack. Some restrictions apply.

Ensurepass 2018 PDF and VCE

Question No: 33

High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?

  1. Enable Write-Back Flash Cache due to heavy DBWR usage.

  2. Enable Write-Back Flash Cache due to heavy LGWR usage.

  3. Swap hard disks to High Capacity disks.

  4. Tune the application to reduce I/O requests.

  5. Leverage IORM to give priority to critical workloads.

Answer: B,D,E

Explanation: B (not A): Smart Flash Logging is a recent Exadata enhancement that provides physical disk redo write relief in times of high LGWR activity; alone, probably not a driver for Exadata.

Question No: 34

You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O savings as a result of the storage indexes. Which two statements are true?

SQLgt; select count (*) from transmap.mymap_comp 2 where map_id between 400 and 500;

COUNT(*)

——————– 103000

Elapsed: 00:00:00.08

SQLgt; select b.name, a.value/1024/1024 value from vSmystat a, vSstatname b,

where b.statistic# = a.statistic#

and b.nafne in (鈥ell physical IO bytes eligible for predicate offload#39;,

鈥ell physical IO interconnect bytes#39;,

鈥ell physical IO bytes saved by storage index#39;,

鈥ell physical IO interconnect bytes returned by smart scan#39;) order by 1;

Statistic Value (MB)

———————————————– ———

cell physical IO bytes eligible for predicate offload 2,255 .09 cell physical IO bytes saved by storage index .00

cell physical IO interconnect bytes 1.72

cell physical IO interconnect bytes returned by smart scan 1.68

  1. The storage indexes were disabled using the disable_storage_INDEX Parameter.

  2. Storage Index data is not on the Cell Server#39;s region index memory structures yet because this predicate has not been used.

  3. Since the database was started, no quires were run against this table with the same predicate.

  4. The storage indexes reduced the amount of physical I/O bytes significantly for this query.

Answer: B,C

Explanation: * cell physical I/O bytes eligible for predicate offload Number of bytes eligible for predicate offload, an indication of smart scan

  • (not D) cell physical I/O bytes saved by storage index Here 0.

    Number of bytes saved by a storage index; this is a reflection of how many physical disk I/O bytes (and by proxy, requests) were saved due to a storage index eliminating candidate blocks

    Question No: 35

    How would you execute CellCLI commands and scripts?

    1. using SQL*Plus on database nodes

    2. by CellCLI commands executed on the database nodes

    3. using third party tools after installing the CellCLI RPM plug-in

    4. directly executing the commands and scripts on the Exadata storage cell

    5. remotely by connecting to Port 1521 using SSL

    Answer: D

    Explanation: The storage cells in Exadata Database Machine are managed via two tools called CellCLI and DCLI.

    Question No: 36

    Which two attributes describe key benefits of the InfiniBand network?

    1. All Exadata database servers have a direct path link to each Exadata Storage Server.

    2. Cell-to-cell communication uses Reliable Datagram Sockets (RDS) over InfiniBand to achieve low latency.

    3. Expanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.

    4. Each InfiniBand link provides 10 Gigabits of bandwidth.

    5. Oracle#39;s interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.

    Answer: C,E

    Explanation: C: Oracle Exadata is architected to scale-out to any level of performance. To achieve higher performance and greater storage capacity, additional database servers and Exadata cells are added to the configuration – e.g., Half Rack to Full Rack upgrade. As more Exadata cells are added to the configuration, storage capacity and I/O performance increases near linearly.

    E: Oracle#39;s interconnect protocol uses direct data placement (DMA – direct memory access) to ensure very low CPU overhead by directly moving data from the wire to database buffers with no extra data copies being made. The InfiniBand network has the flexibility of a LAN network, with the efficiency of a SAN.

    Incorrect:

    Not A: The architecture of the Exadata solution includes components on the database server and in the Exadata cell. The software architecture for a Quarter Rack configuration is shown below.

    Ensurepass 2018 PDF and VCE

    Not B: No cell-to-cell communication is ever done or required in an Exadata configuration. Not D: Each InfiniBand link provides 40 Gigabits of bandwidth –

    Question No: 37

    The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-image with an Oracle Support installation image.

    Which three tasks would you need to perform to re-image the compute node?

    1. Mount the LVM backup image across the network and recover the system.

    2. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.

    3. Create a CELLBOOT USB Flash Drive using an external USB drive.

    4. Reboot the new server using a bootable recovery image from the external USB drive.

    5. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

    Answer: C,D,E

    Question No: 38

    Which three statements accurately describe update of software on Exadata Database Machine?

    1. The Oracle Database patchset software (for example, 11.2.0.3) requires the Exadata- specific version.

    2. Rolling patching is faster than non-rolling patching, but database down time is longer.

    3. The Oracle Database software on Exadata is updated using standard OPatch and the Oracle Universal Installer.

    4. Running Exadata with different storage server software versions is supported, but should be minimized to rolling patching scenarios.

    5. The database server operating system software (other than kernel and OFED) may be installed or updated from non-Exadata sources

    6. Storage server updates require access to an Unbreakable Linux Network (ULN) based repository.

    Answer: C,D,F Explanation: C:

  • Oracle offers two utilities for software deployment: Oracle Universal Installer to install Oracle products OPatch to apply interim patches

    F: When storage cells are patched, there is almost always a set of storage server patches that need to be applied to the Exadata Compute Nodes as well. Historically, these were called “minimal packs,” but recent improvements to the compute node patching process deliver these updates using yum channels on Oracle’s Unbreakable Linux Network (ULN).

    Incorrect:

    Not B: Rolling patching has no downtime.

    Question No: 39

    Which two statements appropriately describe the backup and recovery procedures on Exadata?

    1. Cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.

    2. Data stored in a database is backed up and restored by using CellCLI commands.

    3. Database server software backup is automatic and recovery is accomplished by using a rescue procedure.

    4. Data stored in a database is backed up and restored by using RMAN commands.

    5. Cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.

    Answer: A,D

    Explanation: A: Your Exadata Storage Servers do not need to be backed up; Exadata automatically backs these up using a self-maintained internal USB drive.

    D: Backup your Oracle databases using Oracle RMAN

    Question No: 40

    Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

    1. Remove the doors of the 1/8th rack. Add the new servers.

      Cable the Database Servers in the rack.

      Cable the Exadata Storage Servers in the rack. Close the rack.

    2. Activate all cores by using a software command. Activate all hard drives and flash drives.

      Create the grid disks.

      Expand the Oracle ASM diskgroups. Review the new configuration.

    3. Remove the doors of the 1/8th rack.

      Add an additional Sun Datacenter InfiniBand Switch. Add the new servers.

      Cable the Database Servers in the rack.

      Cable the Exadata Storage Servers in the rack. Close the rack.

      Configure the new hardware.

    4. Activate all cores by using a software command. Activate all hard drives and flash drives.

    Answer: B

    Explanation: Not A: no need to remove doors. Not C: No additional Infiband Switch needed. Note:

  • Database Machine Upgrades

    Ensurepass 2018 PDF and VCE

  • Database Machine Components and Upgradeability

  • Ensurepass 2018 PDF and VCE

    100% Ensurepass Free Download!
    Download Free Demo:1z0-338 Demo PDF
    100% Ensurepass Free Guaranteed!
    1z0-338 Dumps

    EnsurePass ExamCollection Testking
    Lowest Price Guarantee Yes No No
    Up-to-Dated Yes No No
    Real Questions Yes No No
    Explanation Yes No No
    PDF VCE Yes No No
    Free VCE Simulator Yes No No
    Instant Download Yes No No

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.