Started on Tuesday, July 6, 2021, 10:30 PM

State Finished
Completed on Tuesday, July 6, 2021, 10:46 PM
Time taken 16 mins 57 secs
Grade 24.00 out of 25.00 (96%)
Feedback A minimum of 19 correct answers is required to pass.

Congratulations, you passed the quiz for the SAP HANA on Power Level 2 Quiz!

Question1 You are in a discussion with a client on the implementation of High Availability for their SAP S/4PIANA

Correct infrastructure. Which possible scenario would *NOT* be possible?

1.00 points out

of 1.00 Select one:
Allocate an LPAR on a second POWER server as a PowerHA failover server.

If the primary PIANA database is on a POWER server, install the Standby PIANA database on an LPAR on a
separate local POWER server.

If the S/4FIANA database is currently on a Dell server, they could just install the Standby FIANA databaseÿ
on a POWER server for higher reliability of the standby.

Running a Standby HANA database as a virtual machine in an LPAR on the same POWER server to protect
from an instance failure.

Your answer is correct.

Question 2 What is the largest memory that is certified for SAP S/4HANA on a single POWER server?

Correct
Select one:
1.00 points out
of 1.00 6TB

24TB

32TB

16TB

Your answer is correct.

Question 3 The design of the POWER system architecture has several advantages over Intel x86 server architecture. Which
Correct of the following is *NOT* one of the POWER advantages?

1.00 points out

of 1.00 Select one:
Higher CPU to memory bandwidth vs. Intel x86 which allows for faster in-memory data processing over x86.

Larger memory capacity than Intel x86 to enable a larger single node HANA in-memory database.

Higher number of cores per socket than Intel x86, which allows for greater parallel processing.

SMT8 hyperthreading which enables 4X more threads for increased parallel processing over Intel x86.

Your answer is correct.

Question 4 Which of the following statement is *NOT* true regarding the Insert/Update/Delete process in SAP HANA?

Correct
Select one:
1.00 points out
of 1.00 Read operations are always performed on both the main store and the differential buffer in order to get
accurate results.

All inserts/updates/deletes are stored as a new row in the differential buffer, thus making these operations
very fast.

At given intervals, the data in the differential buffer and main store are merged together to form a new main
store so that new transactions don't have as much work to do merging them together for every query.

The differential buffer and main store are persisted (stored) on disk to ensure integrity of the data.

Your answer is correct.

Question 5 These are some of the HA features of Power Systems, *except* for:

Correct
Select one:
1.00 points out
of 1.00 NVMe Flash for rapid application restart

Live Partition Mobility (LPM) to transparently move live LPARs to another Power System

Chipkill memory

Dynamic component de-allocation

Your answer is correct.

Question 6 With Power Systems there are no restrictions on the number of cores per VM, or the number of sockets per VM,

Correct for a given LPAR. On Intel x86 servers, there is an SAP HANA restriction. Which of the following is true about

1.00 points out support for SAP HANA virtualization on Intel x86 servers?
of 1.00
Select one:
SAP HANA VMs must be allocated on full sockets, from 1to 8 sockets per VM.

SAP HANA VMs can only be created on V2 socket increments from 1to 8 sockets.

SAP HANA VMs can only be created in V2 socket sizes ( V2, 1, IV2, 2, 2Yi ,

SAP HANA VMs can only be created on Vi, 1, 2, 3 and 4 sockets.

.....
sockets).

•s

Your answer is correct.

Question 7 On Power Systems, SAP HANA is certified for up to 16TB of memory for OLAP applications. When running SAP

Correct HANA in a virtualized environment on VMware vSphere on a single Intel x86 server, what is the maximum

1.00 points out amount of memory that is supported for OLAP applications?
of 1.00
Select one:
3TB

6TB

16TB

24TB

Your answer is correct.

Question 8 Which of the following statement is true about SAP HANA?

Correct
Select one:
1.00 points out
of 1.00 The SAP HANA database requires less memory than the raw size of the data because it stores its data in
a compressed format and achieves a compression ratio of between 4X to 5X.

SAP HANA is an in-memory database and stores all its data in memory. As such, it only requires persistency
for its logs.

With SAP HANA Multi-target Replication, data from the primary database is replicated to one or more
secondary systems. The application can connect to any of the primary or secondary databases to run a full
transactional workload against.

SAP HANA data tiering features are used to reduce the size of the primary database and, therefore, the
memory required in the server. For S/4HANA, you can suggest to the client to implement Dynamic Tiering
for warm data.

Your answer is correct.

Question 9 The customer you are about to visit has had questions on the differences between running PowerVM and

Incorrect VMware vSphere. What are the key points you should highlight?

0.00 points out

of 1.00 Select one:
PowerVM can support any number of production HANA instances, whereas vSphere is limited by the
number of sockets on the server.

PowerVM supports up to 8 HANA production instances and any number of non-production instances on a
single server. However, vSphere is restricted by the number of sockets (for example, on a 4-socket Intel
server, it can only support up to 8 VMs).

PowerVM is the operating system for Power Systems while VMware vSphere is an additional software
*
layer on top of the Intel x86 operating system (Linux). This is the reason why PowerVM has very low
performance impact compared to vSphere.

PowerVM and VMware vSphere are very similar in features and both are SAP HANA certified on Power
Systems. PowerVM, however, is free and comes built-in on all POWER9 systems.

Your answer is incorrect.

Question 10 You are speaking with a client and they want to know what the two most important components of a server's

Correct hardware are that influences SAP HANA's performance. Which of the following are the two most important

1.00 points out aspects influencing SAP HANA's performance?

of 1.00
Select one:
Scalability and CPU cores

CPU Sockets and Storage

RAM and Virtualization

RAM and CPU cores

Your answer is correct.

Question 11 SAP HANA Insert/Update/Delete processing utilizes an in-memory structure called a Differential Store. This

Correct structure is asynchronously merged with the Main Store at specified intervals. What components of a server are

1.00 points out most critical in this process to achieve minimal latency?
of 1.00
Select one:
The memory bandwidth is critical for moving data between memory and CPU cores and NVMe for faster
storage access.

The movement of data from storage into RAM and the speed of the processors. Thus, on Power Systems, it
would be the PCIe GEN4 interface to the storage and the number of CPU cores that is most critical.

With SMT8, data can be merged in parallel quickly and data can be moved quickly to disk through the PCIe
GEN4 interface.

The memory bandwidth is critical for moving data between memory and CPU cores and the higher
threading via SMT8 to process the data in parallel.

Your answer is correct.

Question 12 Running an S/4HANA application over many years will inevitably lead to data growth. What is one suggestion

Correct that SAP recommends?

1.00 points out

of 1.00 Select one:
Delete data older than one year to reduce the primary database size.

Setup a multi-target replication with active-active server infrastructure to split the workload.

Scale-out the HANA server before scale-up.

Scale-up the HANA server before scale-out.

Your answer is correct.

Question 13 For clients who would like to run Spatial analysis on their SAP HANA data, which edition of SAP HANA would

Correct
they be required to purchase?

1.00 points out

of 1.00 Select one:
SAP HANA Express Edition

SAP HANA Enterprise Edition V

SAP HANA Platform Edition

SAP HANA Runtime Edition

Your answer is correct.

Question 14 On Power Systems, SAP HANA is certified for up to 24TB of memory for OLTP applications. When running SAP

Correct HANA in a virtualized environment on VMware vSphere on a single Intel x86 server, what is the maximum

1.00 points out amount of memory that is supported for OLTP applications?
of 1.00
Select one:
24TB

16TB

6TB

3TB

Your answer is correct.

Question 15 A client has approached you and complained that their SAP HANA backup is taking a long time. They explain to

Correct you that they are running on a Lenovo HANA appliance and the storage subsystem is connected to a SANs

1.00 points out infrastructure. How would running their HANA application on POWER make a difference?
of 1.00
Select one:
Power Systems use NVMe as persistent storage which provides a shorter path to any storage subsystem.

With PCIe GEN4, Power Systems have twice the bandwidth as Intel server's PCIe GEN3 interface. This
will allow for faster data transfer to the storage subsystem.

The higher memory bandwidth in Power Systems moves the data faster between the RAM and CPU and,
therefore gets the data out faster.

Power Systems support more RAM to store all the data in memory and use the CAPI interface to move data
faster.

Your answer is correct.

Question 16 CPU core performance is one of the advantages of POWER over Intel x86. With SAP HANA, parallel processing

Correct for a given workload is paramount to performance. As such, what is another performance advantage of POWER

1.00 points out over Intel x86 processors?

of 1.00
Select one:
Power Systems can cluster servers together with Enterprise Pooling (EP), giving Power Systems for SAP
HANA an unlimited amount of resources to run HANA workloads. Additionally, with Capacity on Demand
(CoD), an infinite number of CPU resources can be added to scale with the workload.

Power Systems have been certified by SAP to scale-out to 16 nodes for SAP BW. This gives Power Systems
access to more parallelism than Intel x86 servers.

Power System's support of SMT8 hyperthreading 4x the number of prallel threads vs. Intel x86's SMT2.
*
Furthermore, in a virtualized environment, due to a security vulnerability, Intel x86 hyperthreading must
be turned off when used with SAP HANA.

Power Systems have more CPU sockets than Intel Systems and, therefore, have more cores to process
workloads.

Your answer is correct.

Question 17 What does Multitenant Database Container (MDC) give you?
Correct
Select one:
1.00 points out
of 1.00 With MDC, all tenants share the same database but could have a different software maintenance level.

Applications connected to an MDC database have full transaction capabilities (read/write) across all
tenants.

With MDC, each tenant of the database can be installed in a different LPAR on a Power System server.

MDC provides the capability to place different SAP applications into its own tenant container, with
complete isolation from each other and the advantage of ease of management.

Your answer is correct.

Question 18 The memory sizing for the client's HANA implementation is estimated to be 1.5 TB. What would it cost to

Correct purchase the license for SAP HANA Enterprise Edition (not including the annual maintenance for the first year)

1.00 points out for a system with 1.5TB of memory?

of 1.00
Select one:
$349K

$3,040K

$3,576K

$1,000K

Your answer is correct.

Question 19 You have been asked to give a client a rough estimate for the amount of memory that is required to host their

Correct S/4HANA database. The client estimates that their raw data size is approximately 10TB. What would be the rule
1.00 points out of thumb for the amount of memory required for S/4HANA for a database that is lOTBs in size?
of 1.00
Select one:
10 TB

20 TB

2.5 TB

5 TB

Your answer is correct.

Question 20 What is the largest memory that is certified for SAP BW in a single POWER server?
Correct
Select one:
1.00 points out
of 1.00 32TB

64TB

24TB

16TB

Your answer is correct.

Question 21 When proposing POWER to customers, what are the 4 key value propositions over Intel x86 offerings?

Correct
Select one:
1.00 points out
of 1.00 Flexibility, Resiliency, Expandability and Performance

Flexibility, Resiliency, Performance and Ease of Management

Virtualization, Security, Performance and Competitive Cost

Flexibility, Reliability, Performance and Scalability

Your answer is correct.

Question 22 SAP PIANA can be implemented as an appliance or as Tailored Datacentre Integration (TDI). What did TDI 5

Correct
bring to an SAP PIANA implementation that is key to your understanding when competing with Intel servers?

1.00 points out

of 1.00 Select one:
a. The fixed memory-to-core ration was removed, with sizings now based on the workload-driven input
*
into the HANA Quick Sizer.

b. Power Systems are now certified as an appliance and for TDI implementations. Customers will now have a
choice of a preconfigured SAP PIANA system and the benefit from the flexibility, ease of management and
lower TCO of TDI.

c. SAP PIANA Appliances are no longer supported and customers can use any SAP certified servers and
storage independently.

d. Customers on SAP certified servers can have the flexibility of using their choice of SAP certified enterprise
storage.

Your answer is correct.

Question 23 Which of the following is *NOT* an SAP HANA data tiering solution for warm data?

Correct
Select one:
1.00 points out
of 1.00 SAP HANA Near-Line Storage V

SAP HANA Paged-Attributes

SAP HANA Dynamic Tiering

SAP HANA Extension Node/s

Your answer is correct.

Question 24 You have a sales opportunity where the customer is planning to implement a brownfield SAP S/4HANA

Correct application. The HANA sizing tool indicates that the customer will have a HANA database size of 3TB (12TB raw

1.00 points out

data) and growing by 500GB/year over the next 3 years. The customer would like to deploy a TDI 5
of 1.00 implementation. Which of the following statement is correct?

Select one:
You should propose a Power System H924 with 4TB RAM for the production HANA database.

You should propose a Power System E950 configured with a set of LPARs, initially with 3TB of memory for
the production instance and they can use the other LPARs for Dev, QA and Sandbox.

You should propose a Power System H924 with 3TB RAM for the production HANA database in an LPAR and
the other 3TB divided between a Dev, QA and Sandbox LPARs.

You should propose a Power System E950 configured with a set of LPARs, initially with 6TB of memory
for the production instance and they can use the other LPARs for Dev, QA and Sandbox.

Your answer is correct.

 Question 25 In a competitive bid, the HPE and Lenovo sales teams are putting in their proposal to host an SAP S/4HANA

Correct landscape. The production instance is sized at 4.5TB of memory, the development instance is sized at 500GB of

1.00 points out memory, the QA instance is sized at 4TB of memory and the test instance is sized at 1TB of memory. Which of
of 1.00 the following configuration is correct?

Select one:
Lenovo sales is proposing a Lenovo System x3950 (Skylake processors) with VMware vSphere 6.0 virtual
machines. The HANA production VM on 4.5TB RAM , Dev on 500GB RAM, QA on 4TB RAM and test on 1TB
RAM.

HP sales is proposing a HPE Superdome Flex (Skylake processors) with VMware vSphere 6.0 virtual
machines. The HANA production VM on 4.5TB RAM , Dev on 500GB RAM, QA on 4TB RAM and test on 1TB
RAM.
HP sales is proposing a HPE Superdome Flex (Skylake processors) with VMware vSphere 6.7 virtual
machines. The HANA production VM (on VMware vSphere) on 4.5TB RAM , Dev on 500GB RAM, QA on
4TB RAM and test on 1TB RAM.

Lenovo sales is proposing a Lenovo ThinkSystem SR950 (Broadwell processors) with SLES KVM virtual
machines. The HANA production VM on 4.5TB RAM , Dev on 500GB RAM, QA on 4TB RAM and test on 1TB
RAM.

Your answer is correct.

© Copyright IBM Corporation 2021 Course materials may not be reproduced in whole or in part without the prior written
permission of IBM.