Oracle Exadata X5 Administration (1Z0-070)

About Oracle Exadata X5 Administration (1Z0-070)

1Z0-070 exam helps you in becoming Oracle Certified Expert, Oracle Exadata X5 Administrator. This certification helps you in demonstrating your mastery of a collection of skills including Exadata specific database administration, ASM administration, Network administration, and Linux administration. Passing this exam will proves that you have fluency in and a solid understanding of the skills required to configure, install and administer an Exadata Database Machine. 

Skills Learnt

In this, you will gain thorough knowledge of Exadata specific concepts and implementation details including Database Machine Architecture, First Time Deployment, Patching, Smart Storage Operations, Storage Indexes, the I/O Resource Manager, Smart Scan, Exadata specific monitoring, Tuning, Backup and Recovery considerations and migration to Exadata.

Course Structure

The Oracle Exadata X5 Administration (1Z0-070) Exam covers the following topics - 

1. Exadata Database Machine Overview

• Identify the benefits of using Database Machine for different application classes

• Describe the key capacity and performance specifications for Database Machine

2. Key Capabilities of Exadata Database Machine

• Describe the key capabilities of Exadata Database Machine

• Describe the Exadata Smart Scan capabilities

• Describe the capabilities of hybrid columnar compression

• Describe the capabilities and uses of the Smart Flash Cache

• Describe t he capabilities of Columnar Flash Caching

• Describe the capabilities of the Smart Flash Log

• Describe the purpose and benefits of Storage Indexes

• Describe the capabilities and uses of Exadata Snapshot databases

• Describe Cell to Cell Data Transfer and Exadata Network Resource Management

3. Configure Exadata Storage Server

• Configure Exadata software and resources using Cellcli or other tools

• Create and configure ASM disk groups using Exadata

• Use the CellCLI, ExaCLI, DCLI and ExaDCLI Exadata administration tools

• Configure Exadata Storage Server security

4. Recommendations for Optimizing Database Performance

• Optimize database performance in conjunction with Exadata Database Machine

• Optimize Cell performance for Flash Cache and latency capping

5. Consolidation Options and Recommendations

• Describe the options for consolidating multiple databases on Database Machine

• Describe the benefits and costs associated with different options

• Identify the most appropriate approach for consolidation in different circumstances

6. Bulk Data Loading

• Configure the Database File System (DBFS) feature for staging input data files

• Use external tables based on input data files stored in DBFS to perform high-performance data loads

7. Configuring Enterprise Manager Cloud Control 12c  to Monitor Exadata Database Machine

• Describe the Enterprise Manager cloud Control architecture as it specifically applies to Exadata Database Machine

• Describe the discovery process and post discovery configurations

8. Monitoring Exadata Database Machine Database Servers

• Describe the monitoring recommendations for Exadata Database Machine database servers

• Use Cloud Control or DBMCLI to monitor Exadata Database Machine Database Servers

9. Monitoring other Exadata Database Machine Components

• Monitor Exadata Database Machine components: Cisco Switch, Power Distribution Units

10. Backup and Recovery for Exadata Database Machines

• Describe how RMAN backups are optimized using Exadata Storage Server

• Describe the recommended approaches for disk-based and tape-based backups of databases on Database Machine

• Perform backup and recovery

• Connect a media server to the Database Machine InfiniBand network

11. Patching Exadata Database Machine

• Describe how software is maintained on different Database Machine components

12. Exadata Database Machine Architecture

• Describe the Database Machine network architecture and requirements

• Describe the Database Machine software architecture

• Describe the Exadata Storage Server storage entities and their relationships

• Describe how multiple Database Machines can be interconnected and scaled up

13. Exadata Database Machine Initial Configuration

• Describe site planning requirements for Database Machine

• Describe the installation and configuration process with the Exadata Deployment Assistant

• Describe the default configuration for Database Machine

• Describe supported and unsupported customizations for Database Machine

14. I/O Resource Management

• Use Exadata Storage Server I/O Resource Management to manage workloads within a database and across multiple databases

• Configure database resource management plans and profiles

• Configure category plans

• Configure inter-database plans

• Describe and configure the I/O resource manager objectives

• Monitor I/O using I/O Metrics

15. Using Smart Scan

• Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server

• Describe the requirements for Smart Scan

• Describe the circumstances that prevent using Smart Scan

• Identify Smart Scan in SQL execution plans including smart joins

• Use database statistics and wait events to confirm how queries are processed

16. Migrating Databases to Exadata Database Machine

• Describe the steps to migrate your database to Database Machine

• Explain the main approaches for migrating your database to  Database Machine

• Identify the most appropriate approach for migration in different circumstances

17. Exadata Database Machine Platform Monitoring

• Describe the purpose and uses of SNMP for the Database Machine

• Describe the purpose and uses of IPMI for the Database Machine

• Describe the purpose and uses of ILOM for the Database Machine

18. Monitoring Exadata Storage Servers

• Describe Exadata Storage Server metrics, alerts, Thresholds and active requests

• Describe and use Exedata Storage Server Quarantines, Disk Scrubbing and repair

• Monitor Exadata Storage Server using Command line or Cloud control

19. Monitoring the InfiniBand Network

• Monitor InfiniBand switches With Cloud Control or CLI

• Monitor InfiniBand switch ports

• Monitor InfiniBand ports on the database servers ajd Cells with LIST IBPORT command

20. Monitoring Tools

• Use monitoring tools: Exachk, ExaWatcher, TFA Collector DiagTools, ADRCI, Imageinfo and Imagehistory, OSWatcher

21. Database Machine Maintenance tasks

• Power Database Machine on and off

• Safely shut down a single Exadata Storage Server

• Replace a damaged physical disk on a cell

• Replace a damaged flash card on a cell

• Move all disks from one cell to another

• Use the Exadata Cell Software Rescure Procedure

22. Database Machine Automated Support Ecosystem

• Describe the Auto Service Request (ASR) function and how it relates to Exadata Database Machine

• Describe the implementation requirements for ASR

• Describe the ASR configuration process

• Describe Oracle Configuration Manager (OCM) and how it relates to Exadata Database Machine

Exam Pattern 

• Exam Name: Oracle Exadata X5 Administration
• Exam Code: 1Z0-070
• Number of Questions: 90
• Length of Time:  120 minutes
• Exam Fee: $245 USD 
• Exam Language: English

What do we offer?

• Full-Length Mock Test with unique questions in each test set
• Practice objective questions with section-wise scores
• An in-depth and exhaustive explanation for every question
• Reliable exam reports evaluating strengths and weaknesses
• Latest Questions with an updated version
• Tips & Tricks to crack the test
• Unlimited access

What are our Practice Exams?

• Practice exams have been designed by professionals and domain experts that simulate exam scenario.
• Practice exam questions have been created on the basis of content outlined in the official documentation.
• Each set in the practice exam contains unique questions built with the intent to provide real-time experience to the candidates as well as gain more confidence during exam preparation.
• Practice exams help to self-evaluate against the exam content and work towards building strength to clear the exam.
• You can also create your own practice exam based on your choice and preference 

100% Assured Test Pass Guarantee

We have built the TestPrepTraining Practice exams with 100% Unconditional and assured Test Pass Guarantee! 

If you are not able to clear the exam, you can ask for a 100% refund.