1z0-338: Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials

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

ILOM CLI interface through the management network
ILOM Web interface through the management network
remote KVM session to the ILOM
from the database server operating system tool "ilomcli"
from the storage server operating system tool "ilomcli"

Correct answer: BCE

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?

Do not use IORM because it will interfere with the shared database functionality on Exadata.
Use ASM to create separate diskgroups for each database instance that is running on Exadata.
Use IORM to distribute disk bandwidth among the databases.
Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
Set up a resource consumer group within each database instance and manage it individually.

Correct answer: C

Explanation:

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

How does Advanced Compression differ from Hybrid Columnar Compression?

Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.
They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.
Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.
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

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.)

Create a CELLBOOT USB Flash Drive by using an external USB drive.
Mount the LVM backup image across the network and recover the system.
Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
Reboot the new server by using a bootable recovery image from the external USB drive.
Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).

Correct answer: CDE

Explanation:

Which statement is true about instance caging setup?

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

Correct answer: A

Explanation:

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

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

SQL*Plus and ASMCMD
ASMCA
Enterprise Manager Express
Enterprise Manager Cloud Control
RMAN
OUI

Correct answer: ABC

Explanation:

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

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?

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.
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.
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.
Define the split by setting up database services that are specific to department A and department B.

Correct answer: D

Which options does not benefit from storage offload processing?

indexes that rely on B-Tree pointers
column filtering
joins and aggregation
table scans
incremental backups with block change tracking

Correct answer: A

Explanation:

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

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?

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
ASR Manager inside the firewall to ensure that root access to Exadata Database Machine is not compromised
ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Database Machine
Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool

Correct answer: D

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

The DUPLICATE sub-clause enables parallel execution NUMA support.
Each In-Memory Compression Unit in the IM column store will have a mirrored copy placed on another node in the RAC cluster.
The command allows the current instance to exceed DRAM limits and expand across memory, flash, and disk.
The command creates an in-memory snapshot for write_only access.
The In-Memory Compression Unit will have a mirrored copy placed on every other node in the RAC cluster.

Correct answer: B

Explanation:

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

Vendor:	Oracle
Exam Code:	1z0-338
Exam Name:	Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials
Date:	Oct 09, 2018
File Size:	58 KB

Download Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials.1z0-338.ActualTests.2018-10-09.40q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown