Sample Questions for Exadata Certification 1

Exadata Implementation Specialist Examination (1Z0-536)

1. Which types of data are most likely to be cached In the Exadata Smart Flash Cache?

A. Results of random reads.
B. Results of table scans.
C. Write to a mirror
D. Redo data
E. All data is cached In the Flash Cache

2. Your customer wants to use Hybrid Columnar Compression to get maximum compression on their data. Which option represents a best practice for achieving this goal?

A. Load compressed files with Direct Path loading
B. Sort incoming data on a column with a low cardinality
C. Use DBFS and external flies to load the data
D. Use Data Pump to load data

3. Which statement would you make about sharing I/O resources in an Exadata environment?

A. You can manage workloads within a database with Database Resource Manager.
B. You can manage workloads across multiple databases with Database Resource Manager.
C. You can manage workloads within a database with 10 Resource Manager.
D. You cannot manage workloads across multiple databases.

4. How do you back up the software used on an Exadata storage cell?

A. You use RMAN.
B. You back up the software files using an operating system method.
C. You do a complete copy of their system storage area.
D. You do not need to backup this software, as there is an automated recovery mechanism built into each cell.

5. Which statement properly describes potential allocation for a grid disk?

A. A grid disk must use all of a cell disk.
B. A grid disk can only use portions of a cell disk across all cells.
C. A grid disk can use portions of a cell disk on a subset of cells.
D. A grid disk can span multiple Exadata Storage Server ceils.

Exadata Components

Hardware Components

-Database Node (Database Server)
-Cell Storage (Storage Server)
-Infiniband switch
-Cisco network switch
-Flash Cache

Software Components

-Storage Software
-Operating System (Linux/Solaris)
-Oracle Database Software

History of Exadata

First Oracle's exadata was released in 2008 known as hardware and software engineered to work together. Since than we have seen 6 release of exadata machine with improved the combination of hardware and software. Latest X5-2 released in 2015. Here we have given short history of each version from V1 to X5-2.

V1: The first Exadata was released in 2008 and labeled as V1. It was a combination of HP hardware and Oracle software. There were no flash cache used in this version. At that time Exadata was made specially for Data ware housing only. This product was not accepted widely as it was suffered from overheating. 

V2: After V1 Oracle has launched Exadata V2 in 2009. It was a combination of Sun hardware and Oracle software. Here in V2 Oracle has upgraded storage cell with 384 GB of Exadata smart cache. Many o the customer has changed the Exadata from V to V2 because of the overheating problem in Exadata V1.

X2: This is the third edition of Oracle Exadata released in 2010.There are two version X2-2 stands for dual core CPUs and X2-8 stands for 8 core CPUs database server. This version is supporting both OLTP and Data warehouse. Also this has massive features compare to older Exadata in terms of CPUs, Memory, Compression, Smart scan etc...

X3: This is the forth edition of Exadata released in 2012. There is no much more difference between X2 and X3 except in CPU and RAM. This version has more RAM and CPU power then the previous one.

X4: It was released in 2013. In this version processing was increased to 2×12 core CPUs. It had the capacity to upgrade memory to 512GB in a compute node. Flash and disk storage was also increased. It featured a new model of high-capacity disk. 600GB disks were retired, and included 1.2TB, 10,000 RPM disks. These disks were a smaller form factor (2.5” vs 3.5”). The other big change with the X4-2 was the introduction of an active/active InfiniBand network connection. On the X4-2, Oracle broke the bonded connection and utilized each InfiniBand port independently. This allowed an increased throughput across the InfiniBand fabric.

X5: It was announced in early 2015, the sixth generation of Exadata. The X5-2 was a dramatic change in the platform, removing the high-performance Disk option in favor of an all-flash, NVMe (Non-Volatile Memory Express) model. High-capacity disk sizes remain the same at 4TB per disk. The size of the flash cards doubled to 6.4TB per storage server. Memory stayed consistent with a base of 256GB, upgradeable to 768 GB, and the CPU core count increased to 18 cores per socket. With X5, customers are allowed to purchase X5-2 with any configuration required—a base rack begins with two compute nodes and three storage servers.

Exadata Certification Course Contents

Please go through below link to get the course contents for Exadata Certification.

                                                     Exadata Course

X2-2 Exadata Storage Overview

Exadata Storage

-High Performance storage
-Up to 1.8 GB/Sec raw data Bandwidth
-Up to 75.000 IOPS using flash
-64 Bit Intel-based sun fire server
-Pre-Installed Software - Storage Software , Oracle Linux x86_64 , Drivers and Utilities

Exadata Storage Configuration

-12 x 3.5 inch High Performance or High Capacity SAS disks
-384 GB of Exadata Smart Flash Cache
-12 CPU cores dedicated to SQL processing in storage
-24 GB memory
-Dual InfiniBand ports
-Redundant power supplies
-Oracle Exadata Storage
-Server software
-Oracle Linux or Solaris based Database Machines

Hardware Stack 

Storage Grid