CompTIA Online Training

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

April 11, 2019 by admin

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

Comments |0|