Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

E_HANABW_13 Questions and Answers

Question # 6

XML would be good for: Choose the correct answer(s):

A.

Extracting from another BI system.

B.

Extracting from a SAP R/3 system

C.

Efficiently loading 10,000 records.

D.

Loading a shopping cart from an Internet application

Full Access
Question # 7

What is the right modeling object for semantic partitioning in SAP BW/4HANA?

A.

SAP HANA calculation view

B.

Layered scalable architecture

C.

Semantic group

D.

Semantically partitioned object (SPO)

Full Access
Question # 8

How many hierarchies can be created for a key figure?

A.

2

B.

None

C.

5

D.

More than 1

E.

10

Full Access
Question # 9

What skills are required to use SAP SQL Data Warehousing?

A.

SQL and database skills.

B.

C++ to debug the SAP HANA source code Machine learning, because this is a prerequisite in all modern data warehouse implementations.

C.

SAP BW/4HANA skills, because you can only access data in SAP SQL Data Warehousing through the SAP BW/4HANA query.

Full Access
Question # 10

The InfoCube stores transaction data on a detailed level. Determine whether this statement is true or false.

A.

True

B.

False

Full Access
Question # 11

What functions has Data Warehousing Workbench (DWWB)?

A.

Modeling

B.

Scheduling

C.

Monitoring

D.

Reporting

Full Access
Question # 12

Which of the following objects are supported in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

A.

InfoSet

B.

MultiProvider

C.

InfoCube

D.

CompositeProvider

E.

DataStore object (advanced)

Full Access
Question # 13

After you imported data into SAP Analytics Cloud, you create a new formula.

Where is the request processed?

A.

SAP BW OLAP engine

B.

SAP HANA SQL engine

C.

SAP HANA XS engine

D.

SAP HANA calculation engine

Full Access
Question # 14

Which of the following are advantages of column tables?

A.

Elimination of additional indexe

B.

Elimination of parallel execution

C.

Elimination of materialized aggregates

D.

Higher data compression rates

Full Access
Question # 15

Identify issue affecting query performance that you, as a BI administrator, are responsible for.

A.

Read mode

B.

Web page design and Java scripting

C.

Data model

D.

Compression

Full Access
Question # 16

What are the core predictive functions to answer business questions?

Note: There are 2 correct answers to this question.

A.

Gaussian normal distribution

B.

Classification and regression

C.

XRF spectroscopy

D.

Segmentation or clustering

Full Access
Question # 17

Which of the following are ways in which joins can be made using SAP BW on SAP HANA?

A.

A native SAP HANA calculation view can perform inner and outerjoins

B.

An Advanced DSO can create joins between master data and transaction data

C.

A BW InfoSet can be used to create a temporal join

D.

Transformations can perform joins of multiple DataSources

E.

BW Composite Provider can provide inner and outerjoins

Full Access
Question # 18

What can you achieve with rule groups in an SAP BW transformation?

Note: There are 2 correct answers to this question.

A.

Characteristics with the same key figure mapping are grouped.

B.

Keep the number of records in the source and in the target identical.

C.

Key figures with the same characteristic mapping are grouped

D.

One record in the source creates a record in the target for each rule group.

Full Access