Exadata PreSales

(1)

Exadata PreSales

Product Area Features and Functions for technical Individuals (Answer all questions in this section)

1. What does CellCLI do? Mark for Review (1) Points

CellCLI flushes the Smart Scan Flash Cache

CellCLI clears the last query that was sent via smart scan to the cells

CellCLI is the Cell Command Line Interface, a process invoked by Enterpr ise Manager only

CellCLI is the Cell Command Line Interface that used to administer and m onitor the Exadata Storage Servers. (*)

Correct Correct, CellCLI is the Cell Command Line Interface that manages the Exadata servers

2. Although the Oracle Exadata X3 Database Machine is being hailed as the "In Memory Machine" it is still best suited for warehouse workloa ds making it the "In Memory Warehouse Machine." Mark for Review

(1) Points

True

False (*)

Incorrect Incorrect, Oracle Exadata Database Machine X3 is an In M emory Machine suited for OLTP, Warehouse and Mixed Workloads

3. The unique technology driving the performance advantages of the Exadata Database Machine is the Oracle Exadata Storage Server, and its s oftware. By pushing database processing to the Exadata Storage Servers all the d isks can operate in parallel reducing database server CPU consumption while usin g much less bandwidth to move data between storage and database servers.

Mark for Review (1) Points

True (*)

(2)

Correct Correct, Oracle Exadata's Storage Server Software drives the per formance advantages of Exadata

4. The Exadata Flash Cache feature of the Exadata Storage S erver Software intelligently caches database objects in flash memory, replacing slow mechanical I/O operations to disk with very rapid flash memory operations. Mark for Review

(1) Points

True (*)

False

Incorrect Incorrect, the Exadata Flash Cache feature intelligently caches database objects in flash memory.

5. To design a Maximum Availability Architecture with Exada ta which of the following Oracle products will provide high availability?

(Choose all correct answers)

Oracle Data Guard (*)

Oracle Active Data Guard (*)

Oracle Total Recall

Oracle Golden Gate (*)

Incorrect Incorrect, Oracle Data Guard, Active Data Guard and Gold en Gate from failures across data centers

6. A customer approaches you about Oracle Exadata's new 1/8 th rack for a departmental system, which of the following statements is most tru e. Mark for Review

(1) Points

For departmental systems, it is best to position smaller systems like th e Oracle Database Appliance

(3)

Oracle Exadata is only for large companies or large departments

Oracle Exadata's 1/8 rack is perfectly suited for departmental systems o r smaller companies (*)

Oracle Exadata X3 does not offer an 1/8th rack configuration

None of the Above

Correct Correct, Oracle Exadata and the Oracle Database Appliance are co mplimentary technologies. Depending on the customers requirements either may be a good fit, even for departmental systems

7. Select the correct statement about the Oracle Exadata X3 's ability to scale out and scale upwards. Mark for Review

(1) Points

A customer may purchase a 1/8th rack to meet its current needs and upgra de online to a 1/4, 1/2 or full rack (*)

Once a customer buys an 1/8th rack, they must turn in the 1/8th rack and migrate their data to a 1/4, 1/2 or full rack

Oracle does not support upgrades of 1/8th racks at this time

None of the above

Incorrect Incorrect, Exadata allows easy expansion within and betw een racks.

Cross-Sell/Up-Sell/Solution Selling (Answer all questions in this section)

8. Customers deploying Oracle Applications on Exalogic and Exadata derive benefits among others, in four major areas: performance, consolid ation, manageability and supportability. Mark for Review

(1) Points

True (*)

(4)

Correct Correct, Oracle Apps on Exalogic and Exadata are benefited from increased performance, consolidation, ease of manageability and supportability.

9. Upsell opportunities in a Database Machine sales cycle a round performance, efficiency, analytics & data integration include which of the following? Mark for Review

(1) Points

Advanced Compression (*)

OLAP (*)

Oracle CRM

Data Mining (*)

All of the Above

Incorrect Incorrect, Advanced Compression, OLAP, Data Mining and G oldenGate are all upsell opportunities around performance, efficiency, analytics and data integration.

Objection Handling and Competition (Answer all questions in this section)

10. When prospecting a lead for an Oracle Exadata opportunit y, select the best statement(s) for overcoming an objection that a customers app lication is not certified on Exadata? Mark for Review

(1) Points

Applications do not need to be certified against Exadata.

Applications that are validated with Oracle Database 11.2 (and higher), Oracle ASM, and Linux or Solaris will run against Exadata.

Very few applications need to certify the storage subsystem underneath a database storage subsystem.

Exadata fundamentally is the Oracle Database with a very fast storage su bsystem (*)

(5)

Incorrect Incorrect, all of the above statements are great respons es to the application certification on Exadata objection

Objection Handling and Competition

(Answer all questions in this section)

11. A customer has spent years optimizing their application to run on their HP servers and Netapp storage. Select the best responses to thei r objection that moving to Exadata will require years of tuning. Mark fo r Review

(1) Points

Exadata is engineered and optimized end-to-end

Exadata storage has NO tuning knobs

Oracle Exadata represents years of tuning that do not have to be done by the customer

Performance tuning, and stress testing performed at Oracle is done on th e exact same configuration that the customer has ensuring better performance and higher quality. (*)

All of the above

Incorrect Incorrect, all of the statements are great responses to the performance optimization objection for Exadata

12. A customer does not believe Exadata is a viable solution because it doesn't have data models/business solutions to match Teradata. The b est response is: Mark for Review

(1) Points

Oracle has an extensive team of consultants who can build the data model s on demand based on your customer requirements.

Oracle has integrated BI data models sold as applications and industry d ata models and solutions, greatly speeding up deployment and reducing costs. (*)

This is a valid objection, I will raise this to product management durin g the next Oracle Open World.

(6)

Correct Correct, Oracle has industry and application data models that sp eed up deployment and reduce costs.

13. A customer would rather deploy their solution on commodi ty hardware. Select appropriate responses to this objection. Mark for Review (1) Points

While commodity hardware is cheaper than Exadata, the benefits associate d with Exadata outweigh the cost savings. (*)

Showcase a business case that outlines how they can save money with Exad ata (*)

Perform discovery to move from an IT centric discussion to a Business Va lue discussion (*)

Abandon the opportunity, Exadata cannot win on price

None of the Above

Incorrect Correct, focusing on business value and benefits is the best weigh to show cost savings with Exadata

Requirements Gathering and Discovery (Answer all questions in this section)

14. To help a customer "Increase Sales" using an Exadata sol ution, it is useful to determine the effectiveness of current sales analysis in improving sales. Mark for Review

(1) Points

True (*)

False

Correct Correct, to help a customer increase sales with Exadata, it is u seful to analyze the effectiveness of current sales analytics to determine if th ere is a business problem to solve.

15. A value hypothesis is not critical in providing focus an d depth in an Exadata discovery effort. Mark for Review

(7)

(1) Points

True

False (*)

Correct Correct, a value hypothesis is extremely critical in providing f ocus and depth for an Exadata discovery effort

Requirements Gathering and Discovery

16. When identifying Key Business Requirements, select some of the business capabilities your customer may be trying to enable. Mark fo r Review

(1) Points

Control Cost

Maintain consistent performance and Manage data growth.

Enable Self Service Analysis

Analyze diverse data that span long periods of time (*)

All of the Above

Incorrect Incorrect, all of the business capabilities listed could be potential issues customers could be trying to solve in an Exadata opportunit y.

Demonstration

17. A customer would like to use Golden Gate to sync their t wo Exadata machines across two sites. Select the most appropriate response. Mark for Review

(1) Points

Oracle GoldenGate is not certified to run against an Exadata machine

(8)

There is no such product as Oracle GoldenGate, Oracle Data Guard is the only product that can be used in this situation

Oracle GoldenGate can sync Exadata machines and is a viable solution (*)

Correct Correct, Oracle GoldenGate can sync Exadata Database Machines ac ross two sites and is a viable solution.

18. A customer needs to consolidate several databases onto a n Exadata full rack. Their largest database is several petabytes due to the arch ive data that must be kept online. There are several other databases, some that run RAC and some that do not. The databases are a mix of OLTP and Warehouse work loads. They would also like to try to compress their data using all methods avai lable. All databases are validated to run Oracle 11gR2 and higher. Describe the solution that you would propose. Mark for Review

(1) Points

2 Exadata 1/2 racks (1 for the OLTP database and 1 for the DW), 1 Storag e Expansion Rack, Database Licenses, Real Application Cluster, and Advanced Comp ression Licenses

1 Full Exadata Rack, 1 Storage Expansion Rack, Database Licenses, Real A pplication Cluster Licenses, and Advanced Compression Licenses (*)

1 Full Exadata Rack, Database Licenses, Real Application Cluster License s

1 Full Exadata Rack, 1 Storage Expansion Rack, Database Licenses

Correct Correct, at a minimum, this customer would need a full Exadata D atabase Machine plus a Storage Expansion Rack and licenses for Oracle Database, Oracle RAC and Oracle Advanced Compression.

System Architecture

19. What is the difference between a 1/8th rack and a 1/4 ra ck. Mark for Review

(1) Points

The 1/8th rack has 1/2 the hardware that the 1/4 rack has

The 1/8th rack has the same physical hardware as the 1/4 rack. All the m emory, half the disks and half the flash cards are available. (*)

(9)

The 1/8th rack has 1/2 the storage servers that the 1/4 rack does. All t he memory, disks and flash cards available in an 1/8th rack are available in a 1 /4 rack.

The 1/8th rack has less physical memory than the 1/4 rack

None of the above

Incorrect Incorrect, the 1/8th Exadata rack and the 1/4 Exadata ra ck have the same hardware, 1/2 of the cpus in the Database and Storage server ar e disabled

20. One of the unique things the Exadata storage does compar ed to traditional storage is return the entire table being queried rather than o nly the rows and columns that satisfy the database query. Mark for Review (1) Points

True

False (*)

Incorrect Incorrect, one of the unique things the Exadata storage does compared to traditional storage is return only the rows and columns that sa tisfy the database query rather than the entire table being queried.

System Architecture

21. What do Storage Indexes do in the Exadata Database Machi ne? Mark for Review

(1) Points

Eliminates disk I/Os if MIN and MAX can never match â whereâ clause of a query (* )

Storage Indexes are not a feature of the Exadata Database Machine

Monitor the storage server performance for hardware failures

Slow down processing on the Exadata Database Machine

Correct Correct, Storage Indexes eliminate disk I/Os if the MIN and MAX can never match the predicate in a query.

(10)

22. Select hardware components in an Exadata Database Machin e. Mark for Review

(1) Points

Storage Servers (*)

An Ethernet Switch (*)

InfiniBand Switches (*)

Database Servers (*)

HCC Compressor Drive

Correct Correct, the Exadata Database Machine consists of Database Serve rs, Storage Servers, InfiniBand Switches and an Ethernet Switch.

23. What are the 3 major software components of the Exadata Storage Server? Mark for Review

(1) Points

Database Resource Manager (DBRM)

I/O Resource Manager (*)

Oracle Enterprise Linux (*)

ASM

CELLSRV (*)

Incorrect Incorrect, the 3 major components of the database server are the Database Instance, ASM and Database Resource manager

Positioning the Solution

(11)

24. Which of the following are not key value propositions fo r the Database Machine? Mark for Review

(1) Points

Data Warehousing

OLTP

Middleware Integration (*)

Cloud Consolidation

All answers are incorrect

Incorrect Incorrect, middleware integration is not one of the key value propositions for the Database Machine

25. When positioning the Exadata Database Machine in an OLTP opportunity, which of the following conditions should be present to lead to a q uick win? Mark for Review

(1) Points

An existing stable application running on an HP server.

An existing stable application running on both RAC and Linux (or Solaris ) (*)

An application certified on Oracle Database 11g R2 and higher (*)

Correct Correct, an existing stable application running on both RAC and Linux (or Solaris) and certified on Oracle Database 11gR2 and higher will lead t o a quicker win in an OLTP opportunity for the Exadata Database Machine.

26. In general, it is more important to drive the critical I T support for the Exadata Database Machine than to attempt to develop a business case. Mark for Review

(1) Points

(12)

False (*)

Incorrect Incorrect, development of the business case and alignmen t with business priorities in support of the Exadata Database Machine is critica l to sales success.

27. True or false - the inclusion of a technical proof point for the Exadata Database Machine (Proof of Value) in the sales cycle is a key t o a shortened sales cycle. Mark for Review

(1) Points

True

False (*)

Correct Correct, technical proof points are likely to increase the time for a deal to close.

Target Customer Profile

28. A customer contacts you who has been having issues insta lling RAC in their environment due to incompatibility with various drivers, swit ches at the network layer. Is this customer a valid opportunity? Mark fo r Review

(1) Points

No, customers need to have a stable network switching infrastructure to run Exadata

Yes, Exadata comes pre-configured and Ready to Run. Testing is done at O racle to ensure compatibility of all components (*)

No, customers who have driver compatibility issues may likely have issue s configuring Exadata as well.

Correct Correct, Oracle Exadata comes preconfigured and ready to run.

29. Why is it important to seek multiple levels of sponsorsh ip in an Exadata opportunity? Mark for Review

(13)

Without understanding the overall business goals of the organization, Or acle quickly gets pulled down into an operational IT discussion

Sponsorship is needed from Day 1, thus discussions need to be at a busin ess goal level

IT has limited insight into details of the business goals & the financia l impact

IT is rarely the buyer â but their influence is significant is closing the d eal â without IT sponsorship & approval â there is no deal

All answers are correct (*)

Correct Correct, all of the above are reasons to seek multiple levels of sponsorship in an Exadata opportunity

30. Identify the key stakeholders for a VALUE BASED Oracle E xadata Opportunity? Mark for Review

(1) Points

Line of Business (LOB) owner (*)

Business Application Owner (*)

Database Administrators

Business Analyst (*)

CIO/CTO

Incorrect Incorrect, key stakeholders are Line of Business (LOB) o wner , Business Application owner and Business Analyst

Market Trends and Business Drivers

31. According to market analysts, what percentage of data wa rehouses, currently deployed in 2013, will fail to scale to meet new information volume, and complexity demands. Mark for Review

(1) Points

(14)

25%

50%

85% (*)

Incorrect Incorrect, according to Gartner, 85% of currently deploy ed warehouses will fail to scale to meet new demand

32. According to industry analysts, Grid computing is the no t the foundation for Exadata's scale-out computing. Mark for Review

(1) Points

True

False (*)

Correct Correct, Grid computing is the foundation for Exadata's scale-ou t computing

33. Exadata and Enterprise Manager 12c are key enablers for cloud architectures. Select the key features that position it well as an enabler for the cloud. Mark for Review

(1) Points

Exadata Database Machine delivered assembled, debugged, and ready-to-run

Self Service Provisioning

Scalability

Clustering (*)

All of the Above

Incorrect Incorrect, Exadata comes ready to run, its scalability a nd clustering position it well for the cloud. Self Service Provisioning through Enterprise Manager also provides a key tenant in Cloud computing.

(15)

Product Areas and Solution Overview (Answer all questions in this section)

34. What is the requirement for an application running on th e Exadata Database Machine? Mark for Review

(1) Points

The application must be validated on Oracle Database 11gR2 and higher, O racle Automatic Storage Manager (ASM) and Oracle Linux or Oracle Solaris. (*)

The application must be validated on Oracle Database 10g or higher and H P-UX 11.

The application certification does not matter as long as the middleware is appropriately certified for the Exadata Database Machine.

The application must be certified on Oracle Database 11gR1.

Correct Correct, any application running on the Exadata Database Machine must be validated on Oracle Database 11gR2, Oracle Automatic Storage Manager (A SM), and Oracle Linux or Oracle Solaris.

35. What key components of the architecture make the stateme nt "Exadata is architected for Flash" true. Mark for Review

(1) Points

Flash Cache (*)

Total Recall

Compression (*)

Scale Out Storage (*)

Incorrect Incorrect, Scale Out Storage, compression and Flash Cach e are enables for the Flash architecture Exadata utilizes

Product Areas and Solution Overview

36. Choose the systems that join Oracle Exadata as members o f Oracle's Engineered Systems Family Mark for Review

(16)

Oracle Exalogic (*)

Oracle Exalytics (*)

Oracle Big Data (*)

SPARC Supercluster (*)

T-Series

Incorrect Incorrect, Oracle Exadata is one of many engineered syst ems currently in production including Oracle Exalytics, Oracle Big Data, Oracle Database Appliance, and Oracle Exalogic.

37. Although Oracle Database 11gR2 maximizes the value propo sition for the Database Machine, earlier versions of 11g can be deployed on Exad ata. Mark for Review

(1) Points

True

False (*)

Incorrect Incorrect, Oracle Database 11gR2 and higher is required.

38. What are some of the key innovations in Oracle Exadata? Mark for Review

(1) Points

Updated Xen Hypervisor

Massive Memory (*)

Oracle Data Warehouse Builder

Automatically moves all active data into flash and RAM memory while keep ing less active data on disk. (*)

(17)

None of the Above

Incorrect Incorrect, Oracle Exadata X3 features massive memory and moved all I/Os to memory

Market Definition

39. True or false - The value proposition of the Exadata Dat abase Machine is based primarily on extreme performance. Mark for Review (1) Points

True

False (*)

Correct Correct, the value proposition of the Database Machine is based on extreme performance, lower cost, and a complete pre-integrated solution.

40. Exadata serves as the best machine for Database Consolid ation because Mark for Review

(1) Points

Exadata serves as a farm/cloud environment for databases (*)

Exadata offers extreme performance for complex workloads that mix OLTP, DW, batch, reporting (*)

Exadata requires more management (people resources) to tune the intensiv e workloads

All of the Above

Incorrect Incorrect, Exadata is the best machine for DB consolidat ion because it serves as a farm for databases and offers extreme performance. *****

Demonstration

(18)

(1) Points

1 Full Exadata Rack, 1 Storage Expansion Rack, Database Licenses

2. Select the key reason why Exadata is well positioned to support Cloud Mark for Review

(1) Points

Exadata offers the ability to add capacity to the cloud by adding additi onal racks of Exadata. It also has great database consolidation features. (*)

The Database As A Service Exadata pack offers provisioning capabilities through Enterprise Manager

Cloud management features like provisioning and resource allocation will be added in a future release. Exadata is not yet well positioned to support Clo ud architectures.

It is a single shared platform that can run only one type of workload

Correct Correct, Exadata can support cloud due to its ability to add add itional racks in a modular architecture.

(19)

Oracle Total Recall

Incorrect Incorrect, Oracle Data Guard, Active Data Guard and Gold en Gate from failures across data centers

4. What is the difference between an Exadata X3-2 machine a nd an Exadata X3-8 machine? Mark for Review

(1) Points

The Exadata X3-2 is the same as a 1/4 rack of the Exadata X3-8

The X3-8 is comprised of 2 large SMP database/compute servers while the X3-2 can scale to as many as 8 database/compute servers as processing requiremen ts increase. (*)

There are no major differences between the two machines.

The Exadata X3-2 machine has 2 storage servers while the Exadata X3-8 ma chine has 8 storage servers

Correct Correct, the X3-8 is comprised of 2 large SMP servers for large deployments. The X3-2 comes in various models to scale up as user requirements g row

(20)

True (*)

False

Correct Correct, the Exadata Flash Cache feature intelligently caches da tabase objects in flash memory.

6. Which of the following is an example of a weakness in th e offerings from competitors to the Exadata Database Machine? Mark for Review (1) Points

The competition has no weaknesses when compared to Exadata

The Exadata Database Machines is a pre-built fully integrated system tha t requires much less resources to implement. (*)

The competition has limited flash capabilities. (*)

The competition cannot handle mixed OLTP and Reporting demands. (*)

Competitors do not offer Oracle Database Integration, i.e. database offl oad functionality. (*)

Incorrect Incorrect, all of the above are examples of potential we aknesses in the offerings from competitors to the Database Machine.

7. A query is issued to the database that has a predicate, state=TX, the SQL processing is pushed down to the storage servers and the stora ge cells start processing the data in parallel returning only the data that fits the predicate to the database servers for sorting and other aggregate commands. This is an example of what technology in the Exadata Database Machine? Mark fo r Review

(1) Points

Flash Cache Read Back

Advanced Compression

(21)

Smart Scan (*)

Flash Cache Write Back

Correct Correct, This is an example of Exadata Smart Scan technology. By pushing SQL processing to the Exadata Storage Servers, data filtering and proce ssing occurs immediately and in parallel across all storage servers as data is r ead from disk

8. The unique technology driving the performance advantages of the Exadata Database Machine is the Oracle Exadata Storage Server, and its s oftware. By pushing database processing to the Exadata Storage Servers all the d isks can operate in parallel reducing database server CPU consumption while usin g much less bandwidth to move data between storage and database servers.

True (*)

False

Correct Correct, Oracle Exadata's Storage Server Software drives the per formance advantages of Exadata

9. Select the technology features that the Exadata Storage Server Software provides. Mark for Review

(1) Points

Hybrid Columnar Compression (*)

Smart Scan (*)

Smart Flash Cache (*)

Storage Indexes (*)

Active Columnar Compression (*)

Incorrect Incorrect, the Exadata Storage Software enables the plat form for extreme performance including: Smart Scan, Smart Flash Cache, HCC, IORM

(22)

and Storage Indexes

(1) Points

True

False (*)

11. True or false - Leveraging of commodity components is on e of the major contributors to the lower total cost of ownership for the Databas e Machine. Mark for Review

(1) Points

True (*)

False

Correct Correct! Leveraging of commodity components is one of the major contributors to the lower total cost of ownership for the Database Machine.

12. Which of the following are not key value propositions fo r the Database Machine? Mark for Review

(1) Points

Data Warehousing

OLTP

Middleware Integration (*)

(23)

All answers are incorrect

Incorrect Incorrect, middleware integration is not one of the key value propositions for the Database Machine

13. ODA and Exadata are complementary offerings. ODA, engine ered for extreme simplicity, can be an on-ramp to Exadata, engineered for Extrem e Performance. Mark for Review

(1) Points

True (*)

False

Incorrect Incorrect, ODA should not be positioned as a competitor to Exadata but as a complement.

Product Areas and Solution Overview (Answer all questions in this section)

14. Where can partners go on the web to find the latest info rmation about Oracle Exadata? Mark for Review

(1) Points

Oracle Exadata Knowledge Zone (*)

IOUG

Oracle Developers Conference

Our competitors

Correct Correct, the best place to find the latest information is on the oracle.com website and in the Oracle Exadata Datasheet.

15. The Exadata Storage Expansion rack is essentially a Data base Machine with Database Servers replaced by more Storage Servers. Mark fo r Review

(1) Points

(24)

False

Incorrect Incorrect, the Exadata Storage Expansion rack is designe d for database deployments that require very large amounts of data.

(1) Points

Flash Cache (*)

Total Recall

Compression (*)

Correct Correct, Scale Out Storage, compression and Flash Cache are enab les for the Flash architecture Exadata utilizes

17. Select the benefits of Exadata adoption across the indus try. Mark for Review

(1) Points

Data Compression Improvements (*)

Middleware consolidation

OLTP and DSS Workload support (*)

Workload consolidation (*)

Increased performance and scalability (*)

(25)

ovements and increased performance are among the benefits customers have seen wi th Exadata adoption

18. Oracle Exadata is hailed as the all-memory machine. How is this possible? Mark for Review

(1) Points

Memory on the database servers was doubled

All IO for active data can be done to flash memory & RAM memory (*)

Connectivity to the machine is now 10 Gigabit Ethernet

The disk-centric architecture accelerates database execution

Correct Correct, all IO for active data can be done to flash memory than ks to the Exadata software

System Architecture

19. The Exadata Smart Flash Cache Write back (FCWB) caches w rite I/Os in flash in addition to read I/Os. It accelerates write intensive work loads like frequently updated tables and indexes. Mark for Review

(1) Points

True (*)

False

Correct Correct, The FCWB accelerates write intensive workloads and data base writes go directly into cache.

20. Select the major characteristics of ASM and its use in E xadata. Mark for Review

(1) Points

Oracle Automatic Storage Management (ASM) is used as the file system and volume manager for Exadata (*)

(26)

ces and provides the advanced volume management and file system capabilities of Exadata. (*)

ASM does all compression of data as it is being written to the Exadata S torage to ensure optimal throughput

ASM acts as the manager for the Flash Write Back Cache

Striping database files evenly across the available Exadata cells and di sks results in uniform I/O load across all the storage hardware. (*)

Incorrect Incorrect, Oracle Automatic Storage Management (ASM) is used as the file system and volume manager for Exadata. ASM virtualizes the stor age resources and provides the advanced volume management and file system capabi lities of Exadata. Striping database files evenly across the available Exadata c ells and disks results in uniform I/O load across all the storage hardware. System Architecture

(1) Points

Storage Servers (*)

22. What do Storage Indexes do in the Exadata Database Machi ne? Mark for Review

(1) Points

(27)

Slow down processing on the Exadata Database Machine

Eliminates disk I/Os if MIN and MAX can never match â whereâ clause of a query (* )

Monitor the storage server performance for hardware failures

Correct Correct, Storage Indexes eliminate disk I/Os if the MIN and MAX can never match the predicate in a query.

23. What is the difference between DBRM and IORM? Mark fo r Review

(1) Points

There is no difference, DBRM and IORM perform the same function in the E xadata Database machine.

DBRM is a feature of the database and IORM is a feature of the Exadata S torage Server Software. And IORM management is controlled by DBRM plans defined in the databases data dictionary. They work together. (*)

DBRM is a feature of the Exadata Storage Server Software. IORM is a feat ure of the database.

None of the above

Correct Correct, DBRM is a feature of the database and IORM is a feature of the Exadata Storage Server Software. And IORM management is controlled by DB RM plans defined in the databases data dictionary. They work together.

Market Definition

24. Exadata serves as the best machine for Database Consolid ation because Mark for Review

(1) Points

Exadata serves as a farm/cloud environment for databases (*)

Exadata offers extreme performance for complex workloads that mix OLTP, DW, batch, reporting (*)

(28)

Exadata requires more management (people resources) to tune the intensiv e workloads

All of the Above

Correct Correct, Exadata is the best machine for DB consolidation becaus e it serves as a farm for databases and offers extreme performance.

25. Select the statement that is the most true Mark fo r Review

(1) Points

Enterprise Manager 12c is not able to manage the hardware and software c urrently, this capability will be introduced in a future version.

Enterprise Manager 12c is only able to manage the database subsystem of an Exadata Database Machine. Hardware and storage management must be done by ano ther management tool.

Enterprise Manager 12c is able to manage the hardware and software of an Exadata Database Machine. (*)

Incorrect Incorrect, Enterprise Manager 12c is able to provide an integrated view of the hardware and software on an Exadata Database machine. Target Customer Profile

26. Identify the metrics that facilitate a business case tha t tightly aligns with business vision and core priorities Mark for Review (1) Points

Revenue growth enabled by improved BI (*)

Service optimization

Speed to market to enable competitive advantages

Lower cost to develop/deploy solutions

Correct Correct! IT organizations are now often required to construct an d present a business case for technology spend.

(29)

27. Which of the following questions might be asked of a Sol ution Architect to identify a Exadata Database Machine opportunity? Mark fo r Review

(1) Points

How do you preserve a single source of the truth? (*)

Is your current solution entirely fault tolerant?

Are you planning to consolidate into a cloud environment?

Do business users complain about high response times?

All answers are correct

Incorrect Incorrect, all of the above questions might be asked of a Solution Architect to identify an Exadata Database Machine opportunity.

(1) Points

CIO/CTO

Incorrect Incorrect, key stakeholders are Line of Business (LOB) o wner , Business Application owner and Business Analyst

Requirements Gathering and Discovery (Answer all questions in this section)

(30)

of the business capabilities your customer may be trying to enable. Mark fo r Review

(1) Points

Control Cost

Analyze diverse data that span long periods of time (*)

All of the Above

Incorrect Incorrect, all of the business capabilities listed could be potential issues customers could be trying to solve in an Exadata opportunit y.

30. To help a customer "Increase Sales" using an Exadata sol ution, it is useful to determine the effectiveness of current sales analysis in improving sales. Mark for Review

(1) Points

True (*)

False

Correct Correct, to help a customer increase sales with Exadata, it is u seful to analyze the effectiveness of current sales analytics to determine if th ere is a business problem to solve.

31. In building a business case for Exadata, the 4 steps to get to discovery are to 1 - Qualify Customer's Interest, 2 - Create a Value Hypo thesis, 3 - Customer Education & Sponsorship, and 4 - Perform Value Discovery Mark for Review

(1) Points

True (*)

(31)

Correct Correct, the 4 key steps to get to discovery are qualifying cust omer interest, creating a hypothesis, educate the customer and perform discovery .

(1) Points

True (*)

False

(1) Points

OLAP (*)

Oracle CRM

Data Mining (*)

All of the Above

Incorrect Incorrect, Advanced Compression, OLAP, Data Mining and G oldenGate are all upsell opportunities around performance, efficiency, analytics and data integration.

Objection Handling and Competition (Answer all questions in this section)

(32)

sive to manage than competitors" is: "Improvements in the Oracle Database made i t increasingly self tuning and self-managing. The Exadata Storage Server Softwar e transparently pushes database optimization to storage eliminating much of the tuning needed for BI and ad-hoc analysis. Mark for Review

(1) Points

True (*)

False

Incorrect Incorrect, improvements in the Oracle Database have made it increasingly self managing and Exadata's Storage Software eliminates the tun ing needs by pushing optimization to the storage tier.

35. During an Exadata sales cycle, the customer objects stat ing it is risky to move their application to a preconfigured machine. Your respo nse is that "Deploying to an Exadata Database Machine offers less deployment ris k as it is delivered assembled, debugged and ready-to-run." Mark for Review (1) Points

True (*)

False

Correct Correct, the Exadata Database machine offers customers less depl oyment risk

36. When prospecting a lead for an Oracle Exadata opportunit y, select the best statement(s) for overcoming an objection that a customers app lication is not certified on Exadata? Mark for Review

(1) Points

Applications do not need to be certified against Exadata.

Applications that are validated with Oracle Database 11.2 (and higher), Oracle ASM, and Linux or Solaris will run against Exadata.

Very few applications need to certify the storage subsystem underneath a database storage subsystem.

Exadata fundamentally is the Oracle Database with a very fast storage su bsystem (*)

(33)

All of the above

Incorrect Incorrect, all of the above statements are great respons es to the application certification on Exadata objection

37. A valid response to the objection "Oracle cannot run OLT P and Warehouse workloads in the same machine." is that "Oracle Exadata excels a t OLTP and data warehousing. Oracle has a very large portfolio of data warehouse and OLTP reference customers who can testify to the performance, scalability an d analytical richness of the Oracle Database on Exadata." Mark for Review (1) Points

True (*)

False

Correct Correct, Oracle Exadata excels at both OLTP and data warehousing

Market Trends and Business Drivers (Answer all questions in this section)

(1) Points

Scalability

Clustering (*)

All of the Above

Incorrect Incorrect, Exadata comes ready to run, its scalability a nd clustering position it well for the cloud. Self Service Provisioning through Enterprise Manager also provides a key tenant in Cloud computing.

(34)

39. Exadata's Flash Cache Write Back Feature transparently c aches 'hot' read and write data to fast solid state storage improving query resp onse times and throughput. Mark for Review

(1) Points

True (*)

False

Incorrect Incorrect, Exadata transparently caches 'hot' read and w rite data to fast solid-state storage, improving query response times and throug hput

40. According to market analysts, what percentage of data wa rehouses, currently deployed in 2013, will fail to scale to meet new information volume, and complexity demands. Mark for Review

(1) Points

5%

25%

50%

85% (*)

Incorrect Incorrect, according to Gartner, 85% of currently deploy ed warehouses will fail to scale to meet new demand

************ Demonstration

(1) Points

(35)

2. Select the key reason why Exadata is well positioned to support Cloud Mark for Review

(1) Points

Exadata offers the ability to add capacity to the cloud by adding additi onal racks of Exadata. It also has great database consolidation features. (*)

Cloud management features like provisioning and resource allocation will be added in a future release. Exadata is not yet well positioned to support Clo ud architectures.

The Database As A Service Exadata pack offers provisioning capabilities through Enterprise Manager

It is a single shared platform that can run only one type of workload

Correct Correct, Exadata can support cloud due to its ability to add add itional racks in a modular architecture.

(1) Points

True (*)

(36)

Correct Correct, the Exadata Flash Cache feature intelligently caches da tabase objects in flash memory.

4. Which of the following is an example of a weakness in th e offerings from competitors to the Exadata Database Machine? Mark for Review (1) Points

The competition cannot handle mixed OLTP and Reporting demands. (*)

The Exadata Database Machines is a pre-built fully integrated system tha t requires much less resources to implement. (*)

The competition has limited flash capabilities. (*)

Competitors do not offer Oracle Database Integration, i.e. database offl oad functionality. (*)

The competition has no weaknesses when compared to Exadata

Correct Correct, all of the above are examples of potential weaknesses i n the offerings from competitors to the Database Machine.

Oracle Total Recall

Correct Correct, Oracle Data Guard, Active Data Guard and Golden Gate fr om failures across data centers

(37)

6. What does CellCLI do? Mark for Review (1) Points

CellCLI clears the last query that was sent via smart scan to the cells

CellCLI is the Cell Command Line Interface that used to administer and m onitor the Exadata Storage Servers. (*)

CellCLI is the Cell Command Line Interface, a process invoked by Enterpr ise Manager only

CellCLI flushes the Smart Scan Flash Cache

Correct Correct, CellCLI is the Cell Command Line Interface that manages the Exadata servers

7. What is the difference between an Exadata X3-2 machine a nd an Exadata X3-8 machine? Mark for Review

(1) Points

There are no major differences between the two machines.

The Exadata X3-2 is the same as a 1/4 rack of the Exadata X3-8

The X3-8 is comprised of 2 large SMP database/compute servers while the X3-2 can scale to as many as 8 database/compute servers as processing requiremen ts increase. (*)

The Exadata X3-2 machine has 2 storage servers while the Exadata X3-8 ma chine has 8 storage servers

Correct Correct, the X3-8 is comprised of 2 large SMP servers for large deployments. The X3-2 comes in various models to scale up as user requirements g row

8. Why does Hybrid Columnar Compression yield so much great er compression than typical compression? Mark for Review

(1) Points

Data is organized within a database block in a â rowâ format, where all column da ta for a particular row is stored sequentially within a single database block. H

(38)

the amount of storage savings achievable with compression technology.

HCC is not offered with Exadata, it is a feature of Oracle Big Data

HCC utilizes a combination of both row and columnar methods for storing data. This hybrid approach achieves the compression benefits of columnar storage , while avoiding the performance shortfalls of a pure columnar format. (*)

HCC stores column data together, with the same data type and similar cha racteristics, to dramatically increase the storage savings achieved from compres sion.

Correct Correct, HCC utilizes a combination of both row and columnar met hods for storing data.

9. A customer approaches you about Oracle Exadata's new 1/8 th rack for a departmental system, which of the following statements is most tru e. Mark for Review

(1) Points

For departmental systems, it is best to position smaller systems like th e Oracle Database Appliance

Oracle Exadata is only for large companies or large departments

Oracle Exadata's 1/8 rack is perfectly suited for departmental systems o r smaller companies (*)

Oracle Exadata X3 does not offer an 1/8th rack configuration

None of the Above

Correct Correct, Oracle Exadata and the Oracle Database Appliance are co mplimentary technologies. Depending on the customers requirements either may be a good fit, even for departmental systems

(39)

OLAP (*)

Oracle CRM

Data Mining (*)

All of the Above

Correct Correct, Advanced Compression, OLAP, Data Mining and GoldenGate are all upsell opportunities around performance, efficiency, analytics and data integration.

Cross-Sell/Up-Sell/Solution Selling

11. During an Exadata opportunity, security requirements are uncovered. Which of the following Oracle products can be positioned that comple ment Exadata? Mark for Review

(1) Points

Advanced Security (*)

Database Vault (*)

Label Security (*)

Oracle Exadata Security Pack

Total Security

Incorrect Incorrect, Database Vault, Advanced Security and Label s ecurity are complementary security offerings to Exadata

12. True or false - Leveraging of commodity components is on e of the major contributors to the lower total cost of ownership for the Databas e Machine. Mark for Review

(40)

(1) Points

True (*)

False

Correct Correct! Leveraging of commodity components is one of the major contributors to the lower total cost of ownership for the Database Machine.

13. When positioning the Exadata Database Machine in an OLTP opportunity, which of the following conditions should be present to lead to a q uick win? Mark for Review

(1) Points

An existing stable application running on an HP server.

An existing stable application running on both RAC and Linux (or Solaris ) (*)

An application certified on Oracle Database 11g R2 and higher (*)

Correct Correct, an existing stable application running on both RAC and Linux (or Solaris) and certified on Oracle Database 11gR2 and higher will lead t o a quicker win in an OLTP opportunity for the Exadata Database Machine.

(1) Points

True

False (*)

15. In general, it is more important to drive the critical I T support for the Exadata Database Machine than to attempt to develop a business case. Mark for Review

(41)

True

False (*)

Correct Correct, development of the business case and alignment with bus iness priorities in support of the Exadata Database Machine is critical to sales success.

16. During an Exadata sales cycle, the customer objects stat ing it is risky to move their application to a preconfigured machine. Your respo nse is that "Deploying to an Exadata Database Machine offers less deployment ris k as it is delivered assembled, debugged and ready-to-run." Mark for Review (1) Points

True (*)

False

Correct Correct, the Exadata Database machine offers customers less depl oyment risk

(1) Points

(42)

Correct Correct, all of the statements are great responses to the perfor mance optimization objection for Exadata

18. A customer does not believe Exadata is a viable solution because it doesn't have data models/business solutions to match Teradata. The b est response is: Mark for Review

(1) Points

Oracle has an extensive team of consultants who can build the data model s on demand based on your customer requirements.

Oracle has integrated BI data models sold as applications and industry d ata models and solutions, greatly speeding up deployment and reducing costs. (*)

This is a valid objection, I will raise this to product management durin g the next Oracle Open World.

None of the Above

Correct Correct, Oracle has industry and application data models that sp eed up deployment and reduce costs.

19. A valid response to the objection, "Oracle is more expen sive to manage than competitors" is: "Improvements in the Oracle Database made i t increasingly self tuning and self-managing. The Exadata Storage Server Softwar e transparently pushes database optimization to storage eliminating much of the tuning needed for BI and ad-hoc analysis. Mark for Review

(1) Points

True (*)

False

Correct Correct, improvements in the Oracle Database have made it increa singly self managing and Exadata's Storage Software eliminates the tuning needs by pushing optimization to the storage tier.

Market Trends and Business Drivers (Answer all questions in this section)

20. According to industry analysts, Grid computing is the no t the foundation for Exadata's scale-out computing. Mark for Review

(43)

True

False (*)

Correct Correct, Grid computing is the foundation for Exadata's scale-ou t computing

Market Trends and Business Drivers

21. Information services companies are challenged to manage their ever growing data volumes. The priorities driving IT investment in an Exad ata solution include a consolidated data platform that can support the consolida tion of enterprise data assets. Mark for Review

(1) Points

True (*)

False

Correct Correct, Data consolidation is a key initiative in the market an d a key initiative driving Exadata sales

(1) Points

Scalability

Clustering (*)

All of the Above

Correct Correct, Exadata comes ready to run, its scalability and cluster ing position it well for the cloud. Self Service Provisioning through Enterprise Manager also provides a key tenant in Cloud computing.

(44)

Target Customer Profile

23. Which data warehousing sales scenario identifies a poten tial quick win for the Database Machine? Mark for Review

(1) Points

An existing Oracle data warehouse customer experiencing performance and scalability issues

A customer or prospect looking for a pre-configured solution

A customer or prospect needing data mart consolidation

A customer or prospect with a need for a hardware re-fresh.

All answers are correct (*)

Correct Correct, all of the above data warehousing sales scenarios ident ify potential quick wins for the Database Machine.

24. Which of the following questions might be asked of a Sol ution Architect to identify a Exadata Database Machine opportunity? Mark fo r Review

(1) Points

How do you preserve a single source of the truth? (*)

Is your current solution entirely fault tolerant?

Are you planning to consolidate into a cloud environment?

Do business users complain about high response times?

All answers are correct

Correct Correct, all of the above questions might be asked of a Solution Architect to identify an Exadata Database Machine opportunity.

(1) Points

(45)

CIO/CTO

Correct Correct, Line of Business (LOB) owner , Business Application own er and Business Analyst

26. In building a business case for Exadata, the 4 steps to get to discovery are to 1 - Qualify Customer's Interest, 2 - Create a Value Hypo thesis, 3 - Customer Education & Sponsorship, and 4 - Perform Value Discovery Mark for Review

(1) Points

True (*)

False

Correct Correct, the 4 key steps to get to discovery are qualifying cust omer interest, creating a hypothesis, educate the customer and perform discovery .

27. When identifying Key Business Requirements, select some of the business capabilities your customer may be trying to enable. Mark fo r Review

(1) Points

Control Cost

(46)

All of the Above

Correct Correct, all of the business capabilities listed could be potent ial issues customers could be trying to solve in an Exadata opportunity.

28. The following is a key pain point for ExaBI, not Exadata . The inability quickly get access to the right detailed data when needed for bu siness decisions. Mark for Review

(1) Points

True

False (*)

Correct Correct, the inability to get access to the right detailed data is a key customer pain point for Exadata.

System Architecture

29. What are the 3 major software components of the Exadata Storage Server? Mark for Review

(1) Points

ASM

Oracle Enterprise Linux (*)

Database Resource Manager (DBRM)

CELLSRV (*)

I/O Resource Manager (*)

Correct Correct, the 3 major components of the storage server are the I/ O Resource Manager, Oracle Enterprise Linux and CELLSRV.

30. What is the difference between DBRM and IORM? Mark fo r Review

(47)

(1) Points

There is no difference, DBRM and IORM perform the same function in the E xadata Database machine.

DBRM is a feature of the database and IORM is a feature of the Exadata S torage Server Software. And IORM management is controlled by DBRM plans defined in the databases data dictionary. They work together. (*)

DBRM is a feature of the Exadata Storage Server Software. IORM is a feat ure of the database.

None of the above

Correct Correct, DBRM is a feature of the database and IORM is a feature of the Exadata Storage Server Software. And IORM management is controlled by DB RM plans defined in the databases data dictionary. They work together.

System Architecture

31. What are the 3 major software components of the Exadata Database Server? Mark for Review

(1) Points

Database Resource Manager (DBRM) (*)

Database Instance (*)

CELLSRV

I/O Resource Manager

ASM (*)

Incorrect Incorrect, the 3 major components of the database server are the Database Instance, ASM and Database Resource Manager

(1) Points

(48)

Storage Servers (*)

33. The Exadata Smart Flash Cache Write back (FCWB) caches w rite I/Os in flash in addition to read I/Os. It accelerates write intensive work loads like frequently updated tables and indexes. Mark for Review

(1) Points

True (*)

False

Correct Correct, The FCWB accelerates write intensive workloads and data base writes go directly into cache.

Market Definition

34. True or false - The value proposition of the Exadata Dat abase Machine is based primarily on extreme performance. Mark for Review (1) Points

True

False (*)

Correct Correct, the value proposition of the Database Machine is based on extreme performance, lower cost, and a complete pre-integrated solution.

(49)

35. Select the statement that is the most true Mark fo r Review

(1) Points

Enterprise Manager 12c is able to manage the hardware and software of an Exadata Database Machine. (*)

Enterprise Manager 12c is not able to manage the hardware and software c urrently, this capability will be introduced in a future version.

Enterprise Manager 12c is only able to manage the database subsystem of an Exadata Database Machine. Hardware and storage management must be done by ano ther management tool.

Correct Correct, Enterprise Manager 12c is able to provide an integrated view of the hardware and software on an Exadata Database machine.

(1) Points

Compression (*)

Flash Cache (*)

Total Recall

Correct Correct, Scale Out Storage, compression and Flash Cache are enab les for the Flash architecture Exadata utilizes

37. What is the requirement for an application running on th e Exadata Database Machine? Mark for Review

(1) Points

The application must be validated on Oracle Database 11gR2 and higher, O racle Automatic Storage Manager (ASM) and Oracle Linux or Oracle Solaris. (*)

The application must be validated on Oracle Database 10g or higher and H P-UX 11.

(50)

The application certification does not matter as long as the middleware is appropriately certified for the Exadata Database Machine.

The application must be certified on Oracle Database 11gR1.

Correct Correct, any application running on the Exadata Database Machine must be validated on Oracle Database 11gR2, Oracle Automatic Storage Manager (A SM), and Oracle Linux or Oracle Solaris.

38. The Exadata Storage Expansion rack is essentially a Data base Machine with Database Servers replaced by more Storage Servers. Mark fo r Review

(1) Points

True

False

Incorrect Incorrect, the Exadata Storage Expansion rack is designe d for database deployments that require very large amounts of data.

39. Select all the true statements regarding the Exadata1/8t h rack offering Mark for Review

(1) Points

Smaller and lower cost entry-level system with easy upgradability to lar ger Exadata Database Machine (*)

Makes breakthrough Exadata technology available more broadly to: smaller systems, departments, smaller companies, and smaller countries. (*)

It is 1/8th the cost of a 1/4 rack of Exadata

The rack is 1/8th the physical size of a full rack

All of the above

Correct Correct, the 1/8th rack Exadata Database machine is a smaller an d lower cost system that makes Exadata technology available to a broader audienc e

(51)

40. Where can partners go on the web to find the latest info rmation about Oracle Exadata? Mark for Review

(1) Points

IOUG

Oracle Exadata Knowledge Zone (*)

Oracle Developers Conference

Our competitors

Correct Correct, the best place to find the latest information is on the oracle.com website and in the Oracle Exadata Datasheet.

************

1. A valid response to the objection "Oracle cannot run OLT P and Warehouse workloads in the same machine." is that "Oracle Exadata excels a t OLTP and data warehousing. Oracle has a very large portfolio of data warehouse and OLTP reference customers who can testify to the performance, scalability an d analytical richness of the Oracle Database on Exadata." Mark for Review (1) Points

True (*)

False

Correct Correct, Oracle Exadata excels at both OLTP and data warehousing

2. During a meeting with a key Stakeholder, they raise an o bjection that they would like to purchase an appliance solution, like IBM Pureda ta or Teradata, to simplify deployment. Select the most appropriate response. Mark for Review

(1) Points

Oracle is a single point of development, sales and support for Exadata. Oracle's installation services set all initialization parameters by installing a working optimized database on delivery. (*)

(52)

Appliances are inherently problematic. Oracle's approach to the applianc e is to provide self-managing databases that make care and feeding a non-issue.

This is a valid objection, Oracle is in the process of developing a ware house appliance machine that will directly compete with IBM Puredata and Teradat a.

None of the Above

Correct Correct, POCs are not necessary to execute an Exadata opportunit y. Applications do not have to be certified on Exadata or the Exadata storage ce lls.

3. A valid response to the objection, "Oracle is more expen sive to manage than competitors" is: "Improvements in the Oracle Database made i t increasingly self tuning and self-managing. The Exadata Storage Server Softwar e transparently pushes database optimization to storage eliminating much of the tuning needed for BI and ad-hoc analysis. Mark for Review

(1) Points

True (*)

False

Correct Correct, improvements in the Oracle Database have made it increa singly self managing and Exadata's Storage Software eliminates the tuning needs by pushing optimization to the storage tier.

(1) Points

(53)

All of the above

Correct Correct, all of the statements are great responses to the perfor mance optimization objection for Exadata

(1) Points

OLAP (*)

Oracle CRM

Data Mining (*)

All of the Above

Correct Correct, Advanced Compression, OLAP, Data Mining and GoldenGate are all upsell opportunities around performance, efficiency, analytics and data integration.

Cross-Sell/Up-Sell/Solution Selling

(1) Points

True (*)

False