1z0-338

Number: 000-000
Passing Score: 800
Time Limit: 120 min
File Version: 1.0

1z0-338

Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials

Version 1.0
QUESTION 1
A cloud user is assigned the Service Administrator role.

Which cloud actions can this user perform?

A. Perform all tasks in the My Services application, including user and role management tasks.
B. View, create, update, and delete Oracle Compute Cloud Service resources.
C. View only the Oracle Compute Cloud resources.
D. Work with one or more Oracle Cloud services only and use the My Services application to manage his or
her own password and security challenge questions.
E. Perform cloud backups of a specific instance.

Correct Answer: B
Section: (none)
Explanation

Explanation/Reference:
Reference: https://docs.oracle.com/cloud/latest/computecs_common/OCSUG/GUID-F89D66BD-85F5-4325-
8A1F-F8EEE53A7CF1.htm#OCSUG113

QUESTION 2
Which two options would you use to allow direct path loads to run in parallel on your Exadata platform?
(Choose two.)

A. creating the required environment by using Smart Scan parallelization

B. setting the initialization parameter PARALLEL_ENABLED to TRUE to enable parallel direct path loads
C. setting the PARALLEL clause on both the external table and the table where you are loading the data
D. adding the PARALLEL hint to the CTAS or IAS statement
E. setting the PARALLEL_FORCE_LOCAL parameter to TRUE

Correct Answer: CD
Section: (none)
Explanation

Explanation/Reference:

QUESTION 3
You notice that a database node has hung, so you open a Service Request via My Oracle Support.

What diagnostic output will you send to My Oracle Support by default?

A. pkginfo
B. oswatcher
C. AWR
D. v$session output
E. list of database users

Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:

QUESTION 4
Which statement is true about Exadata Storage Servers?

A. Exadata Storage Servers automatically delete old diagnostic and metric files.
B. Exadata requires a running database instance on all storage servers and database servers.
C. Redundancy for the user data that is stored in a database that is running on Exadata is achieved with
RAID5.
D. Communication between a database and an Exadata storage flows over low latency 10 Gigabit Ethernet.
E. Exadata uses network affinity to determine which storage server data is written.

Correct Answer: A
Section: (none)
Explanation

Explanation/Reference:

QUESTION 5
Which three items are the main elements of Oracle Database Resource Manager? (Choose three.)

A. SQL Explain Plan

B. resource plan
C. resource consumer group
D. resource plan directive
E. IORMPLAN object

Correct Answer: BCD

Section: (none)
Explanation

Explanation/Reference:
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm001.htm#ADMIN11844

QUESTION 6
In a customer’s ACFS filesystem, they would like you to set up replication between the existing local primary
and the remote standby Exadata system.

Which tool would you use to administer the replication process?

A. Replication is controlled by using Enterprise Manager Cloud Control.

B. Replication is controlled by using sqlplus while you are logged in as SYSASM.
C. Replication is controlled by using the acfsutil command-line tool.
D. Replication of ACFS filesystems for non-database files on Exadata is not supported.
E. Replication is controlled by using the exacli command-line tool.

Correct Answer: C
Section: (none)
Explanation

Explanation/Reference:
Reference: http://www.oracle.com/technetwork/database/database-technologies/cloud-storage/acfs/
learnmore/acfs-replication-122-3634228.html

QUESTION 7
Which two statements are true about troubleshooting failed patching activities? (Choose two.)

A. Dependency issues found during yum updates should be ignored by using the force option.
B. Failed storage cell patches are rolled back to the previous release automatically.
C. Failed OS patches on database servers can be rolled back.
D. Dependency issues that are found during yum updates require rolling back to a previous release before
retrying.
E. Bundle patches applied by using opatch auto cannot roll back only the database or the grid
infrastructure home.
F. Database server OS updates can be rolled back by using opatch auto –rollback.

Correct Answer: AF
Section: (none)
Explanation

Explanation/Reference:
Reference: http://www.toadworld.com/platforms/oracle/w/wiki/11500.managing-troubleshooting-exadata-part-
1-upgrading-patching-exadata

QUESTION 8
The 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: A
Section: (none)
Explanation

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

QUESTION 9
Your 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 but still be protected against single-node server
failure.

What ASM redundancy level should they use?

A. High
B. Normal
C. External
D. Extreme
E. Standard

Correct Answer: B
Section: (none)
Explanation

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

QUESTION 10
In 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: BCE

Section: (none)
Explanation

Explanation/Reference:

QUESTION 11
Your 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: C
Section: (none)
Explanation

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

QUESTION 12
How 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 where data is fairly static.
Correct Answer: D
Section: (none)
Explanation

Explanation/Reference:

QUESTION 13
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-
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: CDE

Section: (none)
Explanation

Explanation/Reference:

QUESTION 14
Which statement is true about instance caging setup?

A. The initialization parameter resource_manager_plan should be set.

B. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to
prevent oversubscribing.
C. Database instances need to be restarted to make changes to cpu_count effective.
D. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as
expected.
E. Instance caging is the right approach to make sure that database instances are not stealin memory from
one another.

Correct Answer: A
Section: (none)
Explanation

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

QUESTION 15
Which three tools can be used on a freshly re-imaged Exadata system to create, resize, or delete ACFS
filesystems? (Choose three.)

A. SQL*Plus and ASMCMD

B. ASMCA
C. Enterprise Manager Express
D. Enterprise Manager Cloud Control
E. RMAN
F. OUI

Correct Answer: ABC

Section: (none)
Explanation

Explanation/Reference:
Reference https://dbasolutions.wikispaces.com/ACFS+on+Linux

QUESTION 16
Your government customer has purchased a full rack of Exadata. The customer has two departments that
would like to share the Exadata Database Machine but 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 be used 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 by department 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: D
Section: (none)
Explanation

Explanation/Reference:

QUESTION 17
There 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: F
Section: (none)
Explanation

Explanation/Reference:

QUESTION 18
Which options does not benefit from storage offload processing?
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: A
Section: (none)
Explanation

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

QUESTION 19
Your 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 the database 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: D
Section: (none)
Explanation

Explanation/Reference:

QUESTION 20
Identify 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: ABC

Section: (none)
Explanation

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

QUESTION 21
Which 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: AC
Section: (none)
Explanation

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

QUESTION 22
What 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.
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: B
Section: (none)
Explanation

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

QUESTION 23
Which 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 single disk 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: E
Section: (none)
Explanation

Explanation/Reference:
Reference: http://blog.umairmansoob.com/tag/using-high-vs-normal-redundancy-in-exadata/
QUESTION 24
You 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.)

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: BD
Section: (none)
Explanation

Explanation/Reference:

QUESTION 25
When 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: B
Section: (none)
Explanation

Explanation/Reference:

QUESTION 26
To patch an Exadata cloud instance, you need to run the exadbcpatchmulti command as root from the
compute node. exadbcpatchmulti uses the exadbcpatch.cfg file 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?

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
Section: (none)
Explanation

Explanation/Reference:

QUESTION 27
What 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: BDF

Section: (none)
Explanation

Explanation/Reference:

QUESTION 28
Which 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: C
Section: (none)
Explanation

Explanation/Reference:

QUESTION 29
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: D
Section: (none)
Explanation

Explanation/Reference:

QUESTION 30
Which 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: C
Section: (none)
Explanation

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

QUESTION 31
Which 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.
E. The disks in ASM diskgroups must have similar performance characteristics in addition to having the
same size.
Correct Answer: E
Section: (none)
Explanation

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

QUESTION 32
Which 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: CD
Section: (none)
Explanation

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

QUESTION 33
When attempting to install Oracle Enterprise Manager agent software directly on an Exadata storage cell,
you get an error.

What caused the error?

A. The Enterprise Manager agent software is installed only on the Enterprise Manager repository.
B. The Enterprise Manager agent software is not a supported version for the storage cell.
C. Additional software should not be installed on the Exadata storage cell.
D. The Enterprise Manager agent software should be installed by using the YUM repository.

Correct Answer: B
Section: (none)
Explanation

Explanation/Reference:

QUESTION 34
You get a Host Unreachable error when you attempt to connect to a server through a network terminal
command line.

Identify two other ways that you can connect. (Choose two.)

A. Use the ILOM Web GUI.

B. Use the dcli command at the root prompt on a database node.
C. Attach a terminal device to the back panel of the server with a serial cable.
D. Connect by using SQL*Plus.
E. Log in as root on the database node by using the Net1 IP address.

Correct Answer: AB
Section: (none)
Explanation

Explanation/Reference:

QUESTION 35
Oracle Configuration Manager is the key to the proactive capabilities of MyOracle Support.

Which three statements describe OCM? (Choose three.)

A. It is used to collect configuration details and upload them to the management repository.
B. Configuration collection happens once an hour.
C. A customer can associate an SR to their configuration data to reduce issue resolution time.
D. Oracle Base, ASM, and GRID home must have the same owner for installation to work.
E. Configuration collection occurs every 24 hours.

Correct Answer: ACE

Section: (none)
Explanation

Explanation/Reference:

QUESTION 36
Identify 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: CE
Section: (none)
Explanation

Explanation/Reference:

QUESTION 37
Identify the two choices a customer must make that impact diskgroup creation when the customer wants to
have only a DATA diskgroup and a RECO diskgroup? (Choose two.)

A. the number of databases that will run on the cluster

B. the OS that will be run
C. the level of redundancy required
D. the ratio to use to split the available and usable storage between DATA and RECO
Correct Answer: AC
Section: (none)
Explanation

Explanation/Reference:

QUESTION 38
What are three Oracle recommended methods for migrating to Exadata with the least amount of down time?
(Choose three.)

A. CTAS over a database link

B. Expdp and Impdp
C. Cross Platform Incremental Backup and Restore
D. logical migration by using RMAN and GoldenGate
E. physical migration by using Data Guard

Correct Answer: CDE

Section: (none)
Explanation

Explanation/Reference:

QUESTION 39
Which 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: ABC

Section: (none)
Explanation

Explanation/Reference:

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

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: C
Section: (none)
Explanation

Explanation/Reference:

QUESTION 41
What 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: BE
Section: (none)
Explanation

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

QUESTION 42
Which 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: AE
Section: (none)
Explanation

Explanation/Reference:

QUESTION 43
Your 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 Exadata system. The ideal solution would be to use a remote file
system where an ACFS file system is exported to the HP-UX system.

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: ABD
Section: (none)
Explanation

Explanation/Reference:

QUESTION 44
Which 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 the same 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 a separate Exadata Database Machine
F. when no Data Guard standby database is available, configuring Exadata as a stretched RAC

Correct Answer: ABD

Section: (none)
Explanation

Explanation/Reference:

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

A. addition of an Exadata storage expansion rack

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: ADFG

Section: (none)
Explanation

Explanation/Reference:

QUESTION 46
Which 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: ACE

Section: (none)
Explanation

Explanation/Reference:

QUESTION 47
Your 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
D. system
E. opc

Correct Answer: CE
Section: (none)
Explanation

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

QUESTION 48
A customer has received an email notification about a temperature alert on one of the storage servers on
their Exadata system.

What action can the customer take to further investigate the alert?

A. Log in to the Oracle database and query v$temperature.

B. SSH to the storage server and use the CeIICLI sensor_check command to get information about the
storage server’s health.
C. Log in to the ILOM service processor and view the current status of the sensors and indicators on the
system.
D. Enter the data center and immediately power off the storage server.
E. Run exachk to find the system component that might be having a problem.

Correct Answer: B
Section: (none)
Explanation

Explanation/Reference:

QUESTION 49
When provisioning Oracle Exadata Cloud Service, the wizard requests information about backup and restore
options.

Which two options are provided to customers? (Choose two.)

A. backup directly to a Storage Cloud Software Appliance
B. backup to Oracle Replication Cloud
C. backup to Exadata storage (if this option was chosen during configuration)
D. cloud storage through Oracle Database Backup Cloud Service
E. backup to Oracle Tape Library Cloud

Correct Answer: CD
Section: (none)
Explanation

Explanation/Reference:
Reference: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/backing.html

QUESTION 50
In which three cases would RMAN backup and recovery be a good strategy for migrating to the cloud?
(Choose three.)

A. when the source platform is little endian, character set is AL32UTF8, and the architecture is multitenant
B. when moving an Oracle Data Guard physical standby database to the cloud
C. when you are migrating a database from a different database version and it might have a different
character set
D. when you are concerned about the endian nature of the database and want to perform conversions from
different formats
E. when a physical migration approach is feasible and physical database reorganization is no necessary

Correct Answer: BCE

Section: (none)
Explanation

Explanation/Reference:

QUESTION 51
Your customer has encountered some system disk issues and has been told that a “storage cell rescue
procedure” must be implemented.

What will this procedure accomplish?

A. It will perform a predictive disk failure replacement for cell disks.

B. It will recover the Exadata system volumes by using the internal USB flash disk.
C. It will perform cell flash cache failure replacement.
D. It will perform a complete storage server hardware replacement.
E. It will perform a database server disk replacement.

Correct Answer: BCD

Section: (none)
Explanation

Explanation/Reference:

QUESTION 52
Which two terms correctly describe the concept of moving database processing from the database layer to
the storage layer to reduce the volume of data that needs to be processed by the database server? (Choose
two.)

A. sharding
B. offloading
C. Smart Scan
D. predicate filtering
E. column projection

Correct Answer: BC
Section: (none)
Explanation

Explanation/Reference:
Reference: http://www.oracle.com/technetwork/database/exadata/exadata-dbmachine-x4-twp-2076451.pdf

QUESTION 53
Which 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: C
Section: (none)
Explanation

Explanation/Reference:
Explanation:
Open SSH Ports
The Enterprise Manager Cloud Control 12c Agents require ssh access to the Exadata Database Machine
components they monitor. As the Agents will run on the compute 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
the compute nodes.

QUESTION 54
Which 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

Correct Answer: ABC

Section: (none)
Explanation

Explanation/Reference:
QUESTION 55
Which 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: AB
Section: (none)
Explanation

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

QUESTION 56
What 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: CDE

Section: (none)
Explanation

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

QUESTION 57
Which 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;
E. LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;

Correct Answer: D
Section: (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 on another 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, ASMModeStatus
DBFS_DG_CD_02_cell01 Yes ONLINE
DBFS_DG_CD_03_cell01 Yes ONLINE
DBFS_DG_CD_04_cell01 Yes ONLINE

QUESTION 58
Which two statements are true about CellCLI? (Choose two.)

A. CellCLI can be used to back up the Exadata storage cells or make a bootable disk to restore the cell.
B. With a simple CellCLl command, you can synchronize changes to all the storage cells in the Exadata
realm.
C. Using CellCLI, you can stop and start the ASM instances that are using the grid disks on the Exadata
storage cell.
D. Using a CellCLI command, you can change the SNMP subscribers or add multiple SNMP subscribers.
E. Using a CellCLI command, you can see whether grid disks are being used by ASM or not.

Correct Answer: DE
Section: (none)
Explanation

Explanation/Reference:

QUESTION 59
When performing the Oracle recommended bonding of NETl/NETZ or NET4/NET5, what other step should
be completed in order to ensure connectivity, in case of a network hardware outage?

A. Each link should terminate at a separate switch to provide network redundancy.

B. NET0/NET3 should also be bonded and linked to a separate network.
C. The MTU should be set to 7000 to improve performance.
D. Jumbo Frames should be disabled.
E. STP should be disabled to prevent routing loops.

Correct Answer: A
Section: (none)
Explanation

Explanation/Reference:

QUESTION 60
Which 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

Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
Reference: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/service-roles-and-users.html

QUESTION 61
Which three statements are true about the Enterprise Manager setup in Exadata? (Choose three.)

A. The Exadata Plug-In is automatically installed with EM Agent 12cR1.

B. When installing Enterprise Manager after a Platinum Services installation, you should reuse the existing
EM Agent.
C. InfiniBand Switches are monitored remotely.
D. Enterprise Manager creates a schematic of all servers and their health in the Exadata rack.
E. Enterprise Manager shows the health of individual ports on the InfiniBand Switches.

Correct Answer: CDE

Section: (none)
Explanation

Explanation/Reference:

QUESTION 62
What type of SRs does the ASR Manager generate for Exadata?

A. operating system components

B. software assets
C. hardware assets
D. data entry errors
E. backup and restore failures

Correct Answer: B
Section: (none)
Explanation

Explanation/Reference:

QUESTION 63
Consider the following command:

./patchmgr -cells dm01 -patch -rolling

Which two actions does this command perform? (Choose two.)

A. upgrades one or more Exadata Storage Servers simultaneously

B. upgrades one or more Exadata Storage Servers listed in the dm01 file
C. upgrades one or more Exadata Storage Servers, one at a time
D. rolls back one or more Exadata Storage Servers to the previous release
E. upgrades one or more Exadata Storage Servers and InfiniBand Switches
F. upgrades an Exadata Storage Server named dm01

Correct Answer: AF
Section: (none)
Explanation
Explanation/Reference:

QUESTION 64
Storage indexes are unique to Exadata Database Machine and their primary goal is to reduce the amount of
I/O required to service I/O requests for Exadata Smart Scan. Put the following steps in order:

1. The Exadata cell services software conducts I/O requests on 1 MB storage regions.
2. cellsrv checks the high and low values, and determines that the storage region does not contain
any values that meet the predicate.
3. The database is started.
4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage
index storage.
5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.
6. A subsequent query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.
7. The MYOBJ_STATE’S region index is populated with high and low values for the OBJECT_ID column
during the l/O request.

A. 3, 5, 1, 7, 6, 2 and 4
B. 3, 7, 1, 5, 6, 2, and 4
C. 3, 7, 5, 2, 1, 6, and 4
D. 3. 6, 1, 7, 2, 5, and 4
E. 3, 5, 2, 1, 6, 7, and 4

Correct Answer: E
Section: (none)
Explanation

Explanation/Reference:

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

1. Changes for Linux kernel firewall configuration

2. Changes for custom performance monitoring tools
3. Changes for security scan tools
4. 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: E
Section: (none)
Explanation

Explanation/Reference:
QUESTION 66
Oracle 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
D. storage cell monitoring through the CeIICLI interface
E. listener access through the back-end management interface for MySQL and SQL Developer

Correct Answer: ABC

Section: (none)
Explanation

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

QUESTION 67
Which 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 to ONLINE 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: BC
Section: (none)
Explanation

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

QUESTION 68
Which 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 Enterprise Manager's Monitored SQL Executions page.

Correct Answer: ABC

Section: (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_jXAhUGzRQKHdeCAg0
Q6AEIJzAA#v=onepage&q=Oracle's%20Auto%20DOP%20algorithms%20calculate%20the%20Degree%
20of%20Parallelism%20based%20on%20a%20table's%20block%20counts&f=false.

QUESTION 69
Which 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: A
Section: (none)
Explanation

Explanation/Reference:

QUESTION 70
When 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: E
Section: (none)
Explanation

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

QUESTION 71
Which 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: DE
Section: (none)
Explanation

Explanation/Reference:

QUESTION 72
The 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: BC
Section: (none)
Explanation

Explanation/Reference:

QUESTION 73
Which two statement are true about enabling the write-back flash cache?

A. When enabling the write-back-flash-cache in a rolling manner dbcli should be used to inactivate the grid
disks on all cells first.
B. Before write-back-flash-cache is enabled you need to drop the flash cache first.
C. Write back flash cache requires a minimum required software version.
D. When enabling write-back-flash-cache in a non-rolling manners it is important to ensure that
asmdeactivationoutcome is set to yes and asmmodestatus is set to online for all grid disks.
E. flashcachemode should be set to write back by updating cellinit.ora and restarting cellsrv.

Correct Answer: BC
Section: (none)
Explanation

Explanation/Reference:

QUESTION 74
Which characteristics of DBFS on Exadata would you suggest as being a key benefit?

A. When using DBFS customers will not need to use FUSE or any client software to administer the file
system.
B. DBFS offers tremendous I/O bandwidth.
C. Tens of thousands of files are the perfect use case for DBFS on Exadata.
D. DBFS in an Exadata environment is faster than an NFS mount system because of smart scan
performance gain.
E. DBFS allow customer to store LOB and CLOB files external to database for more flexibility.
Correct Answer: C
Section: (none)
Explanation

Explanation/Reference:

QUESTION 75
Which three steps should you perform before executing the following command which will set the cell flash
cache mode to write back?
# cellcli –e alter cell flashcachemode=writeback

A. Inactivate all physical disks on the cell.

B. Shutdown the cellsrv services on the cell.
C. Disable the storage indexes on the cell.
D. Inactivate the grid disks on the cell.
E. Create a new flash cache on the cell.
F. Drop the existing flash cache on the cell.

Correct Answer: BDF

Section: (none)
Explanation

Explanation/Reference:

QUESTION 76
Where would your customer go to find the latest Exadata patches?

A. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and
InfiniBand patches.
B. The Exadata owner guide.
C. The patch database in my Oracle support.
D. My Oracle Support note 888828.1.
E. The database machine in Exadata storage server 11g release 1 (11.1) supported version (Doc ID:
835032.1).

Correct Answer: D
Section: (none)
Explanation

Explanation/Reference:

QUESTION 77
When a customer use Enterprise Manager to monitor and maintain their Exadata machine, which protocol
does enterprise manager uses to send and receive information about component failure event and status.

A. ILOM
B. ICMP
C. RPC
D. IPMI
E. SNMP
Correct Answer: E
Section: (none)
Explanation

Explanation/Reference:

QUESTION 78
Which three statements describe the memory capabilities of the X6-2 Exadata system?

A. The database server come with 256GB memory default.

B. The database server can contain 768GB memory.
C. The HC and EF storage servers contain 128GB memory.
D. The database server come with 512GB memory by default.
E. The HC and EF server come with 512GB memory default.

Correct Answer: ABC

Section: (none)
Explanation

Explanation/Reference:

QUESTION 79
Which two statements are true about the two types of Exadata storage servers, the HC storage server and
the EF storage server?

A. The EF storage servers contain 8 X 3.2TB PCIe flash cards.

B. The HC storage servers contain 12 X 8TB hard disks and 4 X 3.2TB PCI flash cards.
C. The HC storage server is an all disk storage server with no flash containing 12 X 8TB hard disk.
D. The EF storage server contains 8 X 3.2TB PCI flash card and can be upgraded with 4 more a total of 12.
E. The EF storage server contain 8 X 3.2TB PCI flash cards and 4 X 8TB disk drives.

Correct Answer: AB
Section: (none)
Explanation

Explanation/Reference:

QUESTION 80
Your customer would like to install security software on all systems that are hosted out of their datacenter.
Which statement correctly identifies Oracle guide line on where security software can be installed on
Exadata?

A. The security software can be installed on the database server or a storage cells as long as the software is
certified for Oracle enterprise Linux.
B. The security software can be installed on the database server or storage cells as required.
C. The security software can be installed on database server but not on the storage cell.
D. The security software can be installed on database server but not on the storage cells unless the software
is explicitly certified for Oracle enterprise Linux.

Correct Answer: C
Section: (none)
Explanation

Explanation/Reference:

QUESTION 81
How do ASM failure group provide redundancy?

A. For external redundancy ASM disk groups are placed in a Raid 1+0 configuration to ensure the no blocks
are lost during an outage.
B. They ensure that the ASM disks are accessed via ADB protocol and not physically mounted on the
database server.
C. They assign ASM disks to failure groups to ensure that the mirror copies of a block are not in the same
failure group.
D. They ensure that the cell disks are sliced into grid disks by using cellsrv processes.

Correct Answer: C
Section: (none)
Explanation

Explanation/Reference: