Exam Title: Oracle Exadata Database Machine and Cloud Service 2017
Implementation Essentials
Exam Number: 1Z0-338
Exam Price: Rs.16,166.00 More on exam pricing
Format: Multiple Choice
Duration: 120 Minutes
Number of Questions: 71
Passing Score: 63%
Validated Against: Exam has been validated against Oracle Exadata Database
Machine X6.
Take Recommended Training Courses
Complete one of the courses below to prepare for your exam (optional):
Data Management Learning Subscription
Exadata Database Machine: 12c Administration Workshop
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs
and/or field experience) provides the best preparation for passing the exam.
Oracle Database Software
Configure and administer a basic database using Oracle features and
functions
Tune the Oracle database for performance in common use case scenarios
Administration and Configuration
Compress data using Advanced Compression and Hybrid Columnar Compression
Use network configuration options
Create and configure Automatic Storage Management disk groups using Exadata
Explain the impact of various diskgroup failure group choices
Install software onto the Exadata Database Machine
Describe various tasks that can be done with the Integrated Lights Out
Management (ILOM) console
Reconfigure a 1/8th rack into a 1/4 rack
Describe network components in Exadata
Create a database snapshot on Exadata for testing purposes
High Availability
Describe Oracle’s recommended guidelines for high availability
configurations on Exadata
Identify failure scenarios and implement recovery procedures
Install high availability software onto the Exadata Database Machine
Software Maintenance
Describe software components
Locate patches for Exadata
Apply Oracle recommendations to the patching process for Exadata
Describe the Oracle Configuration Manager
Explain how to perform planned maintenance of the Exadata machine
Describe how to use the Oracle Exadata Deployment Assistant to create virtual
machines on Exadata
Resource Management
Set up instance caging
Manage I/O on Exadata
Exadata in the Cloud
Describe the Oracle Exadata Cloud Service provisioning process
Configure backup and recovery on the Exadata Cloud Service
Administer the Oracle Database on the Exadata Cloud Service
Administer the Oracle Database on the Exadata Cloud Machine
Oracle Exadata Architecture
Describe offloading processing
Describe the architecture used by Oracle Exadata software
Use Smart Flash Cache
Enable Flash Cache Write Back
Enable Advanced Compression and Hybrid Columnar Compression on Exadata tables
Describe storage indexes
Describe Oracle recommended configurations for High Availability configurations
Enable parallelism for Data Warehouse workloads
Describe database and Automatic Storage Management-Scoped Security Cconcepts
Describe the Power Distribution Unit
Describe memory capabilities of different models
Describe the importance and use of In-Memory Fault Tolerance in the Exadata
Database Machine
Explain the differences between the types of storage servers available on the
Exadata Database Machine
Backup and Recovery
Create a backup plan for Exadata
Implement recovery procedures on different failure scenarios
Describe troubleshooting tasks for backup and recovery processes
Describe how the Exadata Storage Servers are backed up internally
Monitoring
Install an Enterprise Manager Exadata Monitoring plug-in
Set up an agent, plugin, and Exadata target for Enterprise Manager Cloud Control
Monitor the storage cell using Cell Command Line Interface and Distributed
Command Line Interface
Describe the purpose and uses for Simple Network Management Protocol (SNMP),
Intelligent Platform Management Interface (IPMI) and Integrated Lights Out
Management for a DB machine
Use osWatcher and iostat to monitor the Database Machine operating system
Use exacli and dbcli to monitor storage cells
Bulk Loading and Migration
Use Database File System (DBFS) to perform bulk loading operations
Use the ASM Cluster File System (ACFS) to perform bulk data loading operations
Configure a Database for staging input data files
Use external tables for data loads
Describe migration strategies for Exadata
Explain Oracle recommendations on how to choose a migration strategy
Support
Set up an Automatic Service Request (ASR) on the Database Machine
Explain the ASR configuration process
Describe implementation requirements for Platinum Support
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.
Answer: B
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
Answer: C,D
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$sessionoutput
E. list of database users
Answer: C
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.
Answer: A
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
Answer: B,C,D
Click here to
view complete Q&A of 1z0-338 exam
Certkingdom Review,
Certkingdom PDF Torrents
Best Oracle 1z0-338 Certification, Oracle 1z0-338 Training at certkingdom.com