oracle.braindumps.1z0-338.v2018-07-22.by.daniel...a. do not use iorm because it will interfere with...

25
https://www.gratisexam.com/ 1z0-338.exam.47q Number : 1z0-338 Passing Score : 800 Time Limit : 120 min https://www.gratisexam.com/ 1z0-338 Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials

Upload: others

Post on 29-May-2020

11 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

1z0-338.exam.47q

Number: 1z0-338Passing Score: 800Time Limit: 120 min

https://www.gratisexam.com/1z0-338

Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials

Page 2: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Exam A

QUESTION 1The Exadata architecture is divided into two specific tiers: the database tier and the storage tier.

What protocol do these tiers use to communicate with each other?

A. iDB – Intelligent Database Protocol

B. InfiniBand protocol

C. Ethernet protocol

D. Secure Shell protocol

E. Fibre Channel protocol

Correct Answer: ASection: (none)Explanation

Explanation/Reference:Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/concepts.htm#SAGUG20333

QUESTION 2Your customer needs to ensure that their data is available on the Exadata machine during patches. The customer wants to be able to patch one server at a time butstill be protected against single-node server failure.

What ASM redundancy level should they use?

https://www.gratisexam.com/

A. High

B. Normal

C. External

D. Extreme

E. Standard

Page 3: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Correct Answer: BSection: (none)Explanation

Explanation/Reference:Reference http://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf (page 7)

QUESTION 3In which three ways can customers access the ILOM interface to manage the Exadata database and storage server hardware components? (Choose three.)

A. ILOM CLI interface through the management network

B. ILOM Web interface through the management network

C. remote KVM session to the ILOM

D. from the database server operating system tool "ilomcli"

E. from the storage server operating system tool "ilomcli"

Correct Answer: BCESection: (none)Explanation

Explanation/Reference:

QUESTION 4Your customer is implementing a storage consolidation strategy on their existing Exadata.

Which step represents the Oracle recommended action that the customer should take in their approach?

A. Do not use IORM because it will interfere with the shared database functionality on Exadata.

B. Use ASM to create separate diskgroups for each database instance that is running on Exadata.

C. Use IORM to distribute disk bandwidth among the databases.

D. Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.

E. Set up a resource consumer group within each database instance and manage it individually.

Correct Answer: CSection: (none)Explanation

Explanation/Reference:

Page 4: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Reference: http://www.oracle.com/technetwork/topics/cloud/whatsnew/mixedworkloadmgmtexadata-300345.pdf page 42

QUESTION 5How does Advanced Compression differ from Hybrid Columnar Compression?

A. Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.

B. They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.

C. Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.

D. Advanced Compression is good for tables with active updates and deletes, whereas Hybrid Columnar Compression is best applied to tables or partitions wheredata is fairly static.

Correct Answer: DSection: (none)Explanation

Explanation/Reference:

QUESTION 6The 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 LVMsnapshot was corrupt and now the compute node must be re-imaged with an Oracle Support installation image.

Which three tasks must be performed in order to re-image the compute node? (Choose three.)

A. Create a CELLBOOT USB Flash Drive by using an external USB drive.

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

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

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

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

Correct Answer: CDESection: (none)Explanation

Explanation/Reference:

QUESTION 7Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but

Page 5: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

the concern is that department A will be able to see data from department B.

Which architecture would you suggest to solve this deployment issue?

A. Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can beused by department B.

B. Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used bydepartment B.

C. Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.

D. Define the split by setting up database services that are specific to department A and department B.

Correct Answer: DSection: (none)Explanation

Explanation/Reference:

QUESTION 8There are many different ways to load data into database tables.

Which method does Oracle strongly recommend?

A. generic connectivity via ODBC or JDBC

B. database gateways to open systems and mainframes

C. Oracle GoldenGate

D. Oracle Data Pump

E. SQL*Loader import

F. data loading via external tables

Correct Answer: FSection: (none)Explanation

Explanation/Reference:

QUESTION 9Which options does not benefit from storage offload processing?

Page 6: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

https://www.gratisexam.com/

A. indexes that rely on B-Tree pointers

B. column filtering

C. joins and aggregation

D. table scans

E. incremental backups with block change tracking

Correct Answer: ASection: (none)Explanation

Explanation/Reference:Reference: https://www.pythian.com/blog/exadata-join-offloading-in-action/

QUESTION 10Your customer would like to configure monitoring capabilities alongside ASR on the stand-alone server that was set aside to run ASR Manager.

What configuration would you set up for the customer?

A. Enterprise Manager, SQL Developer Server, and ASR Manager on the stand-alone server because ASR needs SQL Developer to gain SQL access to thedatabase server

B. ASR Manager inside the firewall to ensure that root access to Exadata Database Machine is not compromised

C. ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Database Machine

D. Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool

Correct Answer: DSection: (none)Explanation

Explanation/Reference:

Page 7: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

QUESTION 11Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)

A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

B. Install in Oracle Virtual Machine with required hardware.

C. Install on Exadata Engineered System.

D. Provide individual x86 64-Bit gateway hardware.

E. Install on Oracle Database Appliance.

Correct Answer: ABCSection: (none)Explanation

Explanation/Reference:Reference: http://www.oracle.com/us/assets/platinum-services-faq-1653259.pdf

QUESTION 12Which two statements are true about metrics in the DBMCLI utility? (Choose two.)

A. Metric values are computed and stored in memory, and then permanently stored on disk.

B. DBMCLI can be used to report on Exadata storage server metrics.

C. Metrics are reported as one of four types: cumulative, instantaneous, rate, or transition.

D. Fields in AlertHistory cannot be modified.

E. DBMCLI reported metrics are informational only and cannot be used to trigger alerts or reported events.

Correct Answer: ACSection: (none)Explanation

Explanation/Reference:Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/app_dbmcli.htm#DBMMN22246

QUESTION 13What happens in an Exadata Database Machine when the DUPLICATE sub-clause of the INMEMORY attribute is specified?

A. The DUPLICATE sub-clause enables parallel execution NUMA support.

B. Each In-Memory Compression Unit in the IM column store will have a mirrored copy placed on another node in the RAC cluster.

C. The command allows the current instance to exceed DRAM limits and expand across memory, flash, and disk.

Page 8: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

D. The command creates an in-memory snapshot for write_only access.

E. The In-Memory Compression Unit will have a mirrored copy placed on every other node in the RAC cluster.

Correct Answer: BSection: (none)Explanation

Explanation/Reference:Reference: http://www.oracle.com/technetwork/database/in-memory/learnmore/twp-dbim-exadata-2556211.pdf (page 3)

QUESTION 14Which statement explains the difference between Normal and High redundancy ASM failure groups?

A. Normal redundancy protects the DATA diskgroup, whereas High redundancy protects the RECO diskgroup.

B. Normal redundancy (best practice) provides protection against two simultaneous disk failures, whereas High redundancy provides protection against a singledisk failure or an entire storage server failure.

C. High redundancy gives more usable storage, whereas Normal redundancy provides better I/O performance.

D. Normal redundancy protects from disk failure when a cell is offline or being updated, whereas High redundancy protects the system when all the cells are offline.

E. Normal redundancy tolerates a single cell failure, whereas High redundancy tolerates a two-cell failure.

Correct Answer: ESection: (none)Explanation

Explanation/Reference:Reference: http://blog.umairmansoob.com/tag/using-high-vs-normal-redundancy-in-exadata/

QUESTION 15You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes.

Which two statements are true? (Choose two.)

Page 9: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

A. The accumulated I/O saved by the storage index is 1.68 MB.

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

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

D. The storage index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.

E. The storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.

Correct Answer: BDSection: (none)Explanation

Page 10: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Explanation/Reference:

QUESTION 16When backing up a storage cell, what is actually being backed up?

A. the first two disks in a storage cell that contain the Linux operating system

B. all the disk headers and storage indexes in the storage cell

C. the contents of the CELLBOT USB flash drive

D. the Linux RPM that is used to deploy the storage cell software

Correct Answer: BSection: (none)Explanation

Explanation/Reference:

QUESTION 17To patch an Exadata cloud instance, you need to run the exadbcpatchmulti command as root from the compute node. exadbcpatchmulti uses the exadbcpatch.cfgfile to provide information about the location of files related to patching operations as well as additional parameters related to these operations.

What is the purpose of the sw_bkup_needed=1 parameter that can be set in the exadbcpatch.cfg file?

https://www.gratisexam.com/

A. creates a backup of the patch in case of an error in the patching routine

B. performs a backup of each Oracle home directory before a patch is applied

C. forces the software to create a backup of the exadbpatch.cfg file

D. adds a dialog box that prompts for a backup before the patch can be applied

E. creates a backup of the Oracle database data files

Correct Answer: E

Page 11: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Section: (none)Explanation

Explanation/Reference:

QUESTION 18What are three ways to be informed of an Exadata Storage Sever disk failure? (Choose three.)

A. review of the database server iostat output

B. alert notifications through email when SMTP notification is configured

C. review of the ILOM log

D. review of the output of LIST ALERTHISTORY

E. review of the output of SELECT STATUS FROM V$DATAFILE

F. alert notifications in the Enterprise Manager Exadata Plug-In

Correct Answer: BDFSection: (none)Explanation

Explanation/Reference:

QUESTION 19Which statement is true about the patching features provided in Platinum Services?

A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

B. Patching support includes Exadata, Exalogic, and Database Appliance.

C. Patching services are available for the full software stack up to twice per year.

D. The rolling window and complete down time approaches are two options to patching.

Correct Answer: CSection: (none)Explanation

Explanation/Reference:

QUESTION 20

Page 12: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

How would you ensure that batch jobs don’t impact the performance of online queries that use the same database?

A. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workloads.

B. Configure and enable Parallel Query.

C. Deploy Instance Caging to control batch jobs.

D. Build a Database Resource Management Plan, giving priority to query workloads.

E. Configure IORM to disable Flash Cache usage for batch workloads.

Correct Answer: DSection: (none)Explanation

Explanation/Reference:

QUESTION 21Which statement is true about Hybrid Columnar Compression (HCC)?

A. HCC is a good choice for LOBs, BLOBs, and CLOBs.

B. HCC data resides compressed in flash.

C. HCC being a database feature will work with all types of storage hardware.

D. HCC is best suited for OLTP type databases with a large number of ongoing transactions.

Correct Answer: CSection: (none)Explanation

Explanation/Reference:Reference https://www.dewpoint.com/sites/default/files/images/Dewpoint%20White%20Paper%20-%20Hybrid%20Columnar%20Compression%20HCC%20Jan2013.pdf

QUESTION 22Which statement is true about the disks that are used in ASM diskgroups on the Exadata platform?

A. HP and HC disks can be mixed to any capacity within the same diskgroup.

B. If High redundancy is selected, grid disks from at least two storage servers must be specified.

C. In an Exadata storage server, 12 DATA grid disks, 12 RECO grid disks, and 12 DBFS_DG grid disks are configured by default.

D. The redundancy setting can be changed easily if a wrong choice is made between Normal and High.

Page 13: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

E. The disks in ASM diskgroups must have similar performance characteristics in addition to having the same size.

Correct Answer: ESection: (none)Explanation

Explanation/Reference:Reference: http://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf (page 9)

QUESTION 23Which two statements are true about migrating your database to Exadata? (Choose two.)

A. Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.

B. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.

C. ASM and the database best practice configuration that is supplied during Exadata deployment should be retained during and after migration.

D. The logical migration methods allow more flexibility in changing the database structure for best performance than the physical methods.

E. All indexes should be dropped when migrating to Exadata.

Correct Answer: CDSection: (none)Explanation

Explanation/Reference:Reference: http://www.slideshare.net/monowar94ru/migrating-databases-to-exadata- database-machine

QUESTION 24Identify two ways that Smart Flash Cache can be enabled on an Exadata Database Machine. (Choose two.)

A. It is enabled through OEDA by selecting the Enable FlashCache check box in the hardware configuration section.

B. It can be enabled with the ‘cellcli – I alter flashCache=on’ command.

C. It can be enabled manually with the CREATE FLASHCACHE command from CellCLI.

D. It can be enabled by default during installation.

E. It can be enabled by using the cellCLI DROP FLASHCACHE command.

Correct Answer: CESection: (none)Explanation

Page 14: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Explanation/Reference:

QUESTION 25Which three mandatory tasks must be performed when configuring the Auto Service Request (ASR) Manager? (Choose three.)

A. verifying the ASR configuration

B. registering the ASR Manager

C. activating a node on the ASR Manager

D. installing the ASR software on each database server

E. setting up ASR SNMP traps in Enterprise Manager

Correct Answer: ABCSection: (none)Explanation

Explanation/Reference:

QUESTION 26Which statement is true about the Exadata CELLBOOT USB?

https://www.gratisexam.com/

A. Each patch that is performed on the Exadata storage servers requires manual resync of the CELLBOOT USB.

B. Some space from the CELLBOOT USB is used for cache metadata when write-back flash cache is enabled.

C. Regular Exadata storage server patches make sure that the internal USB is updated so that it can be used for recovery.

D. Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.

E. changes to network configuration files are possible without using ipconf.p1 as long as all the relevant files are updated.

Correct Answer: CSection: (none)Explanation

Page 15: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Explanation/Reference:

QUESTION 27What are two value propositions for using the Oracle Configuration Manager (OCM) on Exadata? (Choose two.)

A. automatic resolution of configuration issues without customer intervention

B. improved access to best practices and Oracle knowledge base

C. fewer SRs to open

D. guaranteed better performance

E. faster issue resolution

Correct Answer: BESection: (none)Explanation

Explanation/Reference:Reference: http://docs.oracle.com/cd/E40166_01/html/E40167/z4001567132545836.html

QUESTION 28Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

A. Flash Cache

B. database views

C. InfiniBand networking

D. high performance SAS2 disk drives

E. cell offloading

Correct Answer: AESection: (none)Explanation

Explanation/Reference:

QUESTION 29Your customer wants to load source information into a database. The source files are generated on a remote HP-UX system and need to be written to the Exadatasystem. The ideal solution would be to use a remote file system where an ACFS file system is exported to the HP-UX system.

Page 16: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Which three options are supported using ACFS on Exadata 12.1.0.2 and later?

A. SAMBA

B. NFS

C. HANFS

D. DBFS

E. ACFS is not supported on Exadata

Correct Answer: ABDSection: (none)Explanation

Explanation/Reference:

QUESTION 30Which three configurations would you recommend to provide High Availability? (Choose three.)

A. enabling Flashback Technologies - for fast point-in-time recovery from logical corruptions and for fast reinstatement of a primary database following failover

B. configuring bonding for the management network in order to provide highest availability for the Data Guard network

C. using Normal redundancy diskgroups for all diskgroups where the primary database is protected by a Data Guard standby database that is deployed on thesame Exadata Database Machine

D. when no Data Guard standby database is deployed, using High redundancy for both the RECO and DATA diskgroups

E. using Normal redundancy diskgroups for all diskgroups where the primary database is protected by a Data Guard standby database that is deployed on aseparate Exadata Database Machine

F. when no Data Guard standby database is available, configuring Exadata as a stretched RAC

Correct Answer: ABDSection: (none)Explanation

Explanation/Reference:

QUESTION 31Identify four significant changes when a backup of Exadata compute nodes must be performed. (Choose four.)

A. addition of an Exadata storage expansion rack

Page 17: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

B. storage server rebalancing

C. installation or reconfiguration of significant non-Oracle software

D. application of Oracle patches

E. before shutdown to preserve storage indexes

F. application of operating system patches

G. reconfiguration of significant operating system parameters

Correct Answer: ADFGSection: (none)Explanation

Explanation/Reference:

QUESTION 32Which three features are unique to Exadata Storage? (Choose three.)

A. grid disks with default AU allocation sizes of 1 MB

B. usage of flash technology to cache recently used data

C. prioritization of disk I/Os based on the database

D. prioritization of OLTP I/Os over scan I/Os

E. database storage flash cache space allocation guarantees and limits

Correct Answer: ACESection: (none)Explanation

Explanation/Reference:

QUESTION 33Your Exadata Cloud instance has been fully provisioned and you continue the setup by logging in to the newly created Virtual Machines (VMs) by using SSH.

Which two default usernames can be used to log in to the VMs? (Choose two.)

A. administrator

B. oracle

C. root

Page 18: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

D. system

E. opc

Correct Answer: CESection: (none)Explanation

Explanation/Reference:Reference: https://docs.oracle.com/en/cloud/paas/java-cloud/jscug/switching-vm-users.html

QUESTION 34Which statement is true about Enterprise Manager 12c for Exadata?

A. EM Agents are installed on each database and storage node.

B. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.

C. EM Agents can communicate to storage cells via SSH.

D. The Exadata Plug-In for monitoring switches is installed in each EM Agent.

E. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.

Correct Answer: CSection: (none)Explanation

Explanation/Reference:Explanation:Open SSH PortsThe Enterprise Manager Cloud Control 12c Agents require ssh access to the Exadata Database Machine components they monitor. As the Agents will run on thecompute nodes the ssh ports, 22, on each of the storage cells, ILOMs, PDUs, KVMs, InfiniBand switches, and Cisco switch will need to be opened for each of thecompute nodes.

QUESTION 35Which three options describe the flash memory capabilities of the Exadata X6-2 database and storage servers? (Choose three.)

A. no flash storage on the database server

B. 4 x 3.2 TB NVMe flash cards on the HC storage server

C. 8 x 3.2 TB NVMe flash cards on the EF storage server

D. 4 x 3.2 TB NVMe flash cards on the database server

E. 8 x 3.2 TB NVMe flash cards on the HC storage server

Page 19: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Correct Answer: ABCSection: (none)Explanation

Explanation/Reference:

QUESTION 36Which two steps are needed to set up instance caging on an Exadata system? (Choose two.)

A. Set the CPU_COUNT parameter to the maximum number of CPUs that the database instance should utilize at any time.

B. Enable a resource plan to manage the CPUs.

C. Specify the optimization objective as low_latency or high__throughput.

D. Set PGA_AGGREGATE_LIMIT to an acceptable level for the intended instances.

E. Change the initialization parameter THREADED_EXECUTION to TRUE and restart the instance.

Correct Answer: ABSection: (none)Explanation

Explanation/Reference:Reference: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf

QUESTION 37What are the three Flash Cache prioritization levels that can be set via the CELL_FLASH_CACHE command? (Choose three.)

A. PINNED

B. LOG

C. NONE

D. KEEP

E. DEFAULT

Correct Answer: CDESection: (none)Explanation

Explanation/Reference:Reference: https://www.pythian.com/blog/whats-in-your-exadata-smart-flash-cache/

Page 20: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

QUESTION 38Which CellCLI command is used to conclude that a storage server can be taken offline without impacting database availability?

A. LIST GRIDDISK ATTRIBUTES name, status;

B. LIST CELLDISK ATTRIBUTES name, raidLevel, asmModeStatus;

C. LIST CELLDISK ATTRIBUTES name, raidLevel

D. LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;

https://www.gratisexam.com/

E. LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;

Correct Answer: DSection: (none)Explanation

Explanation/Reference:Explanation/Reference:ASMDeactivationOutcome recall that grid disks can be deactivated, which is effectively taking them offline. Since ASM mirroring ensures that the data is located onanother disk, making this disk offline does not lose data. However, if the mirror is offline, or is not present, then making this grid disk offline will result in loss of data.This attribute shows whether the grid disk can be deactivated without loss of data. A value of "Yes" indicates you can deactivate this grid disk without data loss.CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatusDBFS_DG_CD_02_cell01 Yes ONLINEDBFS_DG_CD_03_cell01 Yes ONLINEDBFS_DG_CD_04_cell01 Yes ONLINE

QUESTION 39Which user can create administrator accounts and change the administrator password in Oracle Exadata Cloud Service?

A. system

B. Account Administrator

C. Identity Domain Administrator

D. sys

E. Service Instance Administrator

Page 21: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Correct Answer: CSection: (none)Explanation

Explanation/Reference:Reference: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/service-roles-and-users.html

QUESTION 40Consider the following software changes that are performed manually on a Linux server:

1. Changes for Linux kernel firewall configuration2. Changes for custom performance monitoring tools3. Changes for security scan tools4. Changes for Linux system performance optimization

Which of the software changes listed are permitted on Exadata Storage Servers?

A. only 3

B. 1, 2, 3, and 4

C. none

D. only 2

E. only 1 and 2

F. only 2 and 3

Correct Answer: ESection: (none)Explanation

Explanation/Reference:

QUESTION 41Oracle ILOM is an embedded service processor in many Oracle Exadata Database Machine components.

What are three features provided by Oracle ILOM? (Choose three.)

A. secure access for lights out management of the database and storage servers

B. web-based, secure shell, IPMI, and SNMP access for out-of-band management

C. role-based security access to limit functions to individual user administration tasks

Page 22: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

D. storage cell monitoring through the CeIICLI interface

E. listener access through the back-end management interface for MySQL and SQL Developer

Correct Answer: ABCSection: (none)Explanation

Explanation/Reference:Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50469/features.htm#DBMSQ21287

QUESTION 42Which two statements are true about enabling write-back flash cache? (Choose two.)

A. When enabling write-back flash cache in a non-rolling manner, it is important to ensure that asmdeactivationoutcome is set to YES and asmModeStatus is set toONLINE for all grid disks.

B. Write-back flash cache requires a minimum required software version.

C. Before write-back flash cache is enabled, you need to drop the Flash Cache first.

D. The setting flashCacheMode should be set to Writeback by updating cellkey.ora and restarting cellsrv.

E. When enabling write-back flash cache in a rolling manner, DBCLI should be used to inactivate the grid disks on all cells first.

Correct Answer: BCSection: (none)Explanation

Explanation/Reference:Reference: http://www.oracle.com/technetwork/articles/database/exadata-write-back-flash-2179184.html

QUESTION 43Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata? (Choose three.)

A. Auto DOP is enabled via the PARALLEL_M1N_TIME_THRESHOLD initialization parameter.

B. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on a table's block counts.

C. Auto DOP is disabled by default, and must be enabled before SQL statements can take advantage of its features.

D. Auto DOP, an exclusive feature in Exadata, allows the database optimizer to evaluate each statement and run it in parallel without special hints.

E. Auto DOP is enabled by default, starting with Oracle 11gR2 and later, which allows full use of its features.

F. The SQL statements that take advantage of Auto DOP can be identified by using data from Oracle Automatic Workload Repository (AWR) or EnterpriseManager's Monitored SQL Executions page.

Page 23: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Correct Answer: ABCSection: (none)Explanation

Explanation/Reference:Reference:https://books.google.com.pk/books?id=iY8Mt8SbWicC&pg=PA619&lpg=PA619&dq=Oracle%27s+Auto+DOP+algorithms+calculate+the+Degree+of+Parallelism+based+on+a+table%27s+block+counts&source=bl&ots=2WytrJ-Ojq&sig=wR8LwE3H4NgaDEZ8rQP8uVs2I1M&hl=en&sa=X&ved=0ahUKEwjb_8iSy_jXAhUGzRQKHdeCAg0Q6AEIJzAA#v=onepage&q=Oracle's%20Auto%20DOP%20algorithms%20calculate%20the%20Degree%20of%20Parallelism%20based%20on%20a%20table's%20block%20counts&f=false.

QUESTION 44Which statement is true about Oracle compression?

A. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.

B. Hybrid Columnar Compression can be defined for a single column.

C. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.

D. A partitioned table can define the use of Advanced Compression Hybrid Columnar Compression for each partition.

Correct Answer: ASection: (none)Explanation

Explanation/Reference:

QUESTION 45When preparing to install ASR on your customer’s Exadata Database Machine, which user account will you use first to configure the Exadata Database Server?

A. asmadmin

B. oracle

C. asruser

D. celladmin

E. root

F. asradmin

Correct Answer: ESection: (none)Explanation

Page 24: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

Explanation/Reference:Reference: https://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm#ASXQI103

QUESTION 46Which two statements appropriately describe the backup and recovery procedures on Exadata? (Choose two.)

A. The data that is stored in a database is backed up and restored by using CellCLI commands.

B. The cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.

C. The database server software backup is automatic and recovery is accomplished by using a rescue procedure.

D. The data that is stored in a database is backed up and restored by using RMAN commands.

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

Correct Answer: DESection: (none)Explanation

Explanation/Reference:

QUESTION 47The ipmi tool command is most commonly used to perform which two tasks?

A. To configure base networking and bonds within the Exadata server.

B. To power on a chassis from another system in Exadata machine.

C. To show the ILOM SP server event logs in details for a listing of components status on a particular machine.

D. To manage and maintain the Exadata storage servers and related cell commands.

E. To manage cluster components.

Correct Answer: BCSection: (none)Explanation

Explanation/Reference:

Page 25: Oracle.Braindumps.1z0-338.v2018-07-22.by.Daniel...A. Do not use IORM because it will interfere with the shared database functionality on Exadata. B. Use ASM to create separate diskgroups

https://www.gratisexam.com/

https://www.gratisexam.com/