In SAP HANA a table can be stored as:
A) row table
B) column table
C) both A and B
D) neither A or B
1.

To transform information into value, business information must be ____?

a.
b.
c.
d.
e.
f.

Analyzed and used for decision making
Sought
Defined
Found
Both A & C
A, B, & D

Answer: F
1.

T or F? The key analysis method “slicing” means to apply a filter in more than one dimension to create a
“smaller” subset.

Answer: F This is the definition of “dicing.”
1.

Webl provides four different types of tables. They are:

a.
b.
c.
d.
e.
f.

Vertical tables and Horizontal tables
Cluster tables and Pooled tables
Transparent tables and Hashed tables
Forms and Crosstabs
B&C
A&D

1.

What are the drivers of SAP HANA?

a.
b.
c.
d.
e.

Big data
Predictive analytics
Real-time analytics
Self-service BI
All of the above

Answer: E
1.

T or F? With high-capacity RAM, a database is stored on a disk.

Answer: F With high-capacity RAM, a database is stored in memory.
1.

Which has faster data aggregation, higher cache efficiency, high compression rates, and better I/O bandwidth utilization?

a. Row data
b. Columnar data

Answer: B
1.

Which is true regarding the results of slow analytics?

a.
b.
c.
d.

Users expect slow response times
Less data = slower response
More data = slower response
Business value of analytics increases

Answer : C
1.

SAP NetWeaver BWA and SAP HANA similarities include:

a.
b.
c.
d.
e.
f.

Columnar storage
In-memory processing
Distributed computing
Calculation engine
All of the above
None of the above

1.

Multidimensional Expressions (MDX) is:

a.
b.
c.
d.
e.
f.

a query language for OLAP databases a query language for relational databases a query language that is used to interact and perform tasks with multidimensional databases a digital database whose organization is based on the relational model of data
Both A & C
Both B & D

Answer: E

Answer: E
In SAP HANA a table can be stored as:
A) row table
B) column table
C) both A and B
D) neither A or B
Answer: C

Web Intelligence:
1. In Web Intelligence, data returned by the query that is stored in the document can be visualized as a
a. pie chart
b. cone
c. sphere
d. cube
2. In reference to Web Intelligence, a data provider is an employee who gives data to another employee of the organization, usually a supervisor or manager.
a. True
b. False
3. Which of the following is one of the simplest ways to display data in Web Intelligence?
a. Pie chart
b. Bar graph

c. Vertical table
d. None of the above
HANA Lecture 1:
1. What is not a disadvantage of columnar data storage.
a. Load times can be slow
b. Less efficient for transactional processes
c. Possibly slower relational interfaces (Middleware)
d. Faster data aggregation
2. The business value of analytics decreases as analytic application performance slows down.
a.
True b. False
Hana Lecture 2:
1. Which of the following is not a join used in SAP HANA
a. Inner Join
b. Text Join
c. Outer Join
d. Referential Join
e. All of the above are used in SAP HANA
2. Column tables should be used for write-intensive scenarios, not for read-operations on mass data.
a. True
b. False
Service Systems and Work Systems:
1. One challenge of using the Work System Method for a project can be the customer’s reluctance to be responsible for the outcome of the project.
a. True
b. False

1.
2.
3.
4.

What is SAP Hana?
A. a type of software that is designed to retrieve, analyze and report data
B. is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud and applies real time analytics
C. the panel facing the driver of a vehicle or the pilot of an aircraft, containing instruments and controls
D. is a measurable value that demonstrates how effectively a company is achieving key business objectives. Answer: B

1.
2.
3.
4.

Relational databases typical use what?
A. Column Storage
B.
Left based Storage
C. Row Storage
D. Right based Storage
Answer: C

1.
2.

Is column-based storage more suitable for man business