Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SAP > BW/4HANA Dump > Flashcards

BW/4HANA Dump Flashcards

1
Q

What information is available in the SAP BW/4HANA cockpit?

Note: There are 2 correct answers to this question.

Transformation editor
Source system maintenance
DTP editor
Request maintenance for ADSOs and InfoObjects
Process chain dashboard

A

Request maintenance for ADSOs and InfoObjects
Process chain dashboard

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

On which technology is the SAP BW/4HANA cockpit based?

ABAP
Python
SAP Fiori
SQL

A

SAP Fiori

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Is it possible to personalize the tiles on the SAP BW/4HANA cockpit?

You can easily personalize the SAP BW/4HANA cockpit to your specific needs, for example by adding a tile showing the logs of “your” process chains.

SAP provides personalization content.

Personalization is done automatically. The system uses machine learning algorithms to fully automate the personalization.

No, personalization is not needed.

A

You can easily personalize the SAP BW/4HANA cockpit to your specific needs, for example by adding a tile showing the logs of “your” process chains

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which of the following statements about Open ODS views in SAP BW/4HANA is true? One answer

They provide a rich set of analytical capabilities.
They consume external (and internal) data flexibly without staging
They combine data from SAP BW/4HANA and SAP HANA via join or union.
They are an advanced persistency layer.

A

They consume external (and internal) data flexibly without staging

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the right place to develop transformations in SAP BW/4HANA since SP 08?

SAP Web IDE
BW modeling tools in Eclipse
SAP GUI
SAP Web GUI

A

BW modeling tools in Eclipse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

For which database(s) is SAP BW/4HANA built?

SAP IQ
Any relational database
SAP HANA
Hadoop

A

SAP HANA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Complete the sentence: Data modeling in SAP BW/4HANA is …

based on predefined semantics and modeling patterns (master data, DataStore objects (advanced)) as well as database fields.
not recommended for large data volumes.
based on InfoObjects only.
only possible without persist the data.

A

based on predefined semantics and modeling patterns (master data, DataStore objects (advanced)) as well as database fields.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the characteristics of DataStore objects (advanced) in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

They are based on “smart” tables and typically used for storing transaction data.
They contain navigational attributes.
They are based on a star schema.
They are modeled based on InfoObjects or field definitions.
They are the successor of the MultiProvider.

A

They are based on “smart” tables and typically used for storing transaction data.
They are modeled based on InfoObjects or field definitions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the characteristics of InfoObjects in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

They do not support multiple languages – only English is available.
They are virtualized objects without any persistency.
They provide integrated time dependency (slowly changing dimensions).
They support geospatial.
The number of their characteristics is limited to 128.

A

They provide integrated time dependency (slowly changing dimensions).
They support geospatial.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Where do you manage DataStore objects (advanced) in SAP BW/4HANA as of SP 08?

SAP GUI
SAP Web IDE
Request management tool
SAP BW/4HANA administration cockpit

A

SAP BW/4HANA administration cockpit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What forms part of the metadata overview for aDSOs and InfoObjects in the SAP BW/4HANA administration cockpit as of SP 08?

Note: There are 2 correct answers to this question.

Field names, associations, and authorization information
Detailed table and sizing information
DDIC tables and general settings
Detailed information about data tiering optimization

A

DDIC tables and general settings
Detailed information about data tiering optimization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which transaction do you use to open the SAP BW/4HANA administration cockpit in the SAP GUI?

RSPCM
BW4WEB
RSA1
RS2HANA_ADMIN

A

BW4WEB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Why is partitioning important in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

Partitioning makes it easier to build and maintain aggregates in the SAP HANA database.
The limit of 2 billion records for each partition is no longer valid.
Partitioning improves performance with mass data due to partition pruning.
Partitioning reduces the memory footprint in the SAP HANA database.
Partitioning supports very large column store tables (each partition can be up to 2 billion records).

A

Partitioning improves performance with mass data due to partition pruning.
Partitioning supports very large column store tables (each partition can be up to 2 billion records).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are the main partitioning concepts in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

Horizontal partitioning: Different rows are put into different tables.

Physical table partitioning: The DataStore object (advanced) is divided into several small, equally sized partitions, e.g. a separate partition for each month.

List partitioning: A partition is assigned a list of values. If the partitioning key has one of these values, the partition is chosen.

Conceptional/semantic partitioning: The InfoProvider is split (e.g. by region/calendar year) and the CompositeProvider is used as a virtual layer.

A

Physical table partitioning: The DataStore object (advanced) is divided into several small, equally sized partitions, e.g. a separate partition for each month.

Conceptional/semantic partitioning: The InfoProvider is split (e.g. by region/calendar year) and the CompositeProvider is used as a virtual layer.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which processing types can you define for a formula variable?
There are 3 correct answers to this question.

Response:

manual input

replacement path from another variable

replacement path from an infoobject

replacement path from another query

authorization

A

manual input

replacement path from another variable

replacement path from an infoobject

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You model a second SAP BW/4HANA Compositeprovider to intergrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider.

What must you do first?
Please choose the correct answer.

Response:

Create an open ODS View with consumption properties to consume the data in the SAP BW/4HANA schema.

Set the CompositeProvider can Be Added to another compositeprovider flag.

Assign consumption properties to the new SAP HANA calculation view.

Connect an export Datasource from the exisiting CompositeProvider to the new compositeprovider.

A

Set the CompositeProvider can Be Added to another compositeprovider flag.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the purpose of grouping fields in a composite provider?
Please choose the correct answer.

Response:

to improve reporting performance

to define subsets of fields for rule groups

to define subsets of fields for semantic groupings

to improve a logical order for the query designer

A

To improve a logical order for the query designer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?
Please choose the correct answer.

Response:

3

7

10

5

A

5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which advantages does the SAP Lumira template for generic analysis provide?
There are 2 correct answers to this question.

Response:

You can create a bookmark to a navigation state and link it on any web page.

You can use it for any BW query or SAP HANA calculation view.

You can use visual Basic for applications to improve the design.

You can compare two Datasources in one report

A

You can create a bookmark to a navigation state and link it on any web page.

You can use it for any BW query or SAP HANA calculation view.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

You have created an SAP HANA Calculation View in SAP Web IDE for SAP HANA and want to integrate it into an SAP BW/4HANA CompositeProvider.

Which “Settings for HANA Consumption in BW” in transaction SPRO can you use in this scenario?
There are 2 correct answers to this question.

Response:

Hybrid Mode

HANA DeploymentInfrastructure (HDI)

External SAP HANA View

SAP HANA Repository

A

Hybrid Mode

HANA DeploymentInfrastructure (HDI)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Which of the following are strengths of SAP S/4HANA embedded analytics?
There are 2 correct answers to this question.

Response:

Redundant data is reduced.

Cross-system consistency is generated.

Historical dat for stretegic decisions is stored.

Operational data is accessed in real time.

A

Redundant data is reduced.

Operational data is accessed in real time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

When can you NOT use a characteristic with the high cardinality property?
There are 3 correct answers to this question.

Response:

When it will be a navigation attribute

When it will be a time-dependent attribute

When it will be a compound characteristic

When it will be part of a report-to-report interface

When it will be part of a hierarchy

A

When it will be a navigation attribute

When it will be a compound characteristic

When it will be part of a hierarchy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

You define a temporal condition for a temporal join in a calculation view. Which column data types are suppored?
There are 3 correct answers to this question.

Response:

Decimal

Boolean

Timestamp

Date

Integer

A

Timestamp

Date

Integer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

You need to combine master data (right table) and transactional data (left table) using a referential join. How will this referential join behave?
Please choose the correct answer.

Response:

It is executed as an inner join when a description mapping is defined between the left table and the right table.

It returns a result data set if the left table has a corresponding entry on the right table.

It is executed as an inner join when NO fields from the right table are requested.

It always returns all fields from the right table as a result data set.

A

It returns a result data set if the left table has a corresponding entry on the right table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year?
Please choose the correct answer.

Response:

-12

-4

-3

-1

A

-4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

Which transformation options can be executed in an SAP HANA database?
There are 2 correct answers to this question.

Response:

Formulas

Read master data

ABAP expert routines

Transfer routines

A

Formulas

Read master data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Your main BW Query contains a characteristic value variable with a replacement path from a query. When is the pre-query executed?
Please choose the correct answer.

Response:

Directly after data is loaded to the InfoProvider of the pre-query.

Each time the main query is executed, after the filter values are applied.

Each time the main query is executed, before the filter values are applied.

Directly after a predefined broadcasting event was triggered to calculate the pre-query.

A

Each time the main query is executed, before the filter values are applied.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Which object can you associate with a source field in the characteristic folder of an open ods view type facts?
There are 2 correct answers to this question.

Response:

open ods view type facts

open ods view type master data for attribute

open ods view type master data for hierarchies

sap bw infoobjects

A

open ods view type facts

open ods view type master data for attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What must you do if you want to use an object from business content in sap bw/4hana?
Please choose the correct answer.

Response:

convert the object from A version to D version

copy the business content object into customer name space

activate the object in data warehousing workbench

identify the business content object in sap hana studio

A

activate the object in data warehousing workbench

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

What are InfoProviders?
Choose the correct answer.
A Objects that define the fields used for extraction from a source system
B Objects that reports are based on
C Objects that stage data during loading

A

B Objects that reports are based on

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Which of the following are examples of key figures?
Choose the correct answers.
A Invoiced quantity
B Customer number
C Vacation days remaining

A

A Invoiced quantity
C Vacation days remaining

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

What is a DataStore Object (advanced)?
Choose the correct answer.
A The central object in SAP BW/4HANA used for data storage and consolidation
B A virtual staging object used to combine multiple data sources
C An object used to store the results of a query to improve performance

A

A The central object in SAP BW/4HANA used for data storage and consolidation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

What can you find in the Operational Delta Queue?
Choose the correct answer.
A Data that is waiting to be loaded to SAP BW/4HANA
B A list of reports that are scheduled to run offline
C A sequence of housekeeping job steps that can be scheduled to ensure that SAP BW/4HANA operated efficiently

A

A Data that is waiting to be loaded to SAP BW/4HANA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

What are the features of a DataStore Object of the type Standard?
Choose the correct answers.
A A change log to manage the delta process
B An activation step to control the release of loaded data to reporting users
C Support for loading data using APIs

A

A A change log to manage the delta process
B An activation step to control the release of loaded data to reporting users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

What are the modeling features of a CompositeProvider?
Choose the correct answers.
A Union
B Join
C Aggregation
D Ranking

A

A Union
B Join
C Aggregation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Which of the following is the core workflow when working with SAP Analytics Cloud?
Please choose the correct answer.

Response:

Prepare - Explore - Acquire - Visualize - Collaborate

Acquire - Prepare - Visualize - Explore - Collaborate

Explore - Acquire - Prepare - Visualize - Collaborate

Acquire - Prepare - Explore - Visualize - Collaborate

A

Acquire - Prepare - Visualize - Explore - Collaborate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

You created an Open ODS view based on a database table in SAP HANA to virtually display the data in SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA.

Which objects will be created when using the Generate Dataflow function via the Open ODS view?
There are 3 correct answers to this question.

Response:

SAP HANA calculation view

Data source

Transformation

CompositeProvider

DataStore object (advanced)

A

Data source

Transformation

DataStore object (advanced)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

When can you NOT use a characteristic with the high cardinality property?
There are 3 correct answers to this question.

Response:

When it will be a compound characteristic

When it will be part of a hierarchy

When it will be a time-dependent attribute

When it will be part of a report-to-report interface

When it will be a navigation attribute

A

When it will be a compound characteristic

When it will be part of a hierarchy

When it will be a navigation attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context?
There are 2 correct answers to this question.

Response:

The ABAP CDS views must be released via program RODPS_OS_EXPOSE for BW extraction.

An Operational Data Provisioning Framework must be configured in SAP BW/4HANA.

The ABAP CDS views must be defined with the appropriate data extraction annotations.

An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.

A

The ABAP CDS views must be defined with the appropriate data extraction annotations.

An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Which sources types can you select when you create an Open ODS view?
There are 3 correct answers to this question.

Response:

Infosource

Characteristic

Transformation

Virtual table using SAP HANA smart data access

SAP BW DataSource

A

Transformation

Virtual table using SAP HANA smart data access

SAP BW DataSource

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

Which type of BW variable do you use as a dynamic threshold for an exception in a BW query?
Please choose the correct answer.

Response:

Characteristic value variable

Formula variable

Text variable

Hierarchy variable

A

Formula variable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

How can the delta merge process be initiated?
There are 3 correct answers to this question.

Response:

By setting a specific flag in the transformation

By using a specific process type in a process chain

By using SAP HANA smart merge technology

By setting a specific flag in the data transfer process

By using the SAP BW/4HANA data load monitor

A

By using a specific process type in a process chain

By using SAP HANA smart merge technology

By setting a specific flag in the data transfer process

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Which properties determine the delta process within the operational Data provisioning (ODP) delta management for Datasources?
There are 3 correct answers to this question.

Response:

Serialization

Paralleization

Delta type

Recors type

Record mode

A

Serialization

Delta type

Record mode

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

You need to view the SAP HANA Calculation views, SAP BW Datasources, and infoareas in the same SAP HANA Studio perspective. what should you do?
Please choose the correct answer.

Response:

Attach an ABAP Project to an SAP BW project.

Attach an SAP BW project to an ABAP Project

Attach an SAP HANA System to an SAP BW project

Attach an SAP BW Project to an SAP HANA System.

A

Attach an SAP HANA System to an SAP BW project

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder?
There are 2 correct answers to this question.

Response:

Open ODS view of type Facts

Open ODS view of type Master Data

InfoObject of type Characteristic

Calculation View of type Dimension

A

Open ODS view of type Master Data

Calculation View of type Dimension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

You want to validate your sap data model. To use the data preview functionality, what must you ensure?
Please choose the correct answer.

Response:

you must provide the key date in the view properties

the _SYS_BIC user is created in the system and the runtime information is written to schema _SYS_STATISTICS

the design time version must be saved and successfully activated

you are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user

A

the design time version must be saved and successfully activated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

What can you achieve with rule groups in an SAP BW transformation?
There are 2 correct answers to this question.

Response:

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

Key figures with the same characteristic mapping are grouped.

Records of the source are grouped to decrease the number of records in the target.

Characteristics with the same key figure mapping are grouped.

A

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

Key figures with the same characteristic mapping are grouped.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

You load a Datastore object (advanced) every night. where can you delete the request you loaded two nights ago without deleting the last request?
Please choose the correct answer.

Response:

From a Datastore object (advanced) based on the model template standard Datastore object if the request is activated.

From a Datastore object (advanced) based on the model template standard Datastore object if the request is activated you execute a full load.

From a Datastore object (advanced) based on the model template Infocube if the request is activated.

From a Datastore object (advanced) based on the model template Infocube if the request is NOT activated

A

From a Datastore object (advanced) based on the model template Infocube if the request is NOT activated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q

Which join types can you use in a CompositeProvider?
There are 3 correct answers to this question.

Response:

Referential join

Text join

Full Outer join

Hierarchy join

Inner join

A

Referential join

Full Outer join

Inner join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q

You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year?
Please choose the correct answer.

Response:

-1

-3

-4

-12

A

-4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time update scenario. Which fields are added to the DataSource automatically?
There are 3 correct answers to this question.

Response:

SDI_CHANGE_SEQUENCE

SDI_CHANGE_TIME

SDI_RECORD_MODE

SDI_RECORD_SEQUENCE

SDI_CHANGE_TYPE

A

SDI_RECORD_MODE

SDI_CHANGE_TYPE

SDI_CHANGE_TIME

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q

What is the purpose of grouping fields in a composite provider?
Please choose the correct answer.

Response:

to define subsets of fields for semantic groupings

to improve a logical order for the query designer

to improve reporting performance

to define subsets of fields for rule groups

A

to improve a logical order for the query designer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum). If you keep the default settings of the BW query, what is presented regarding the result rows?
Please choose the correct answer.

Response:

One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of all 100 customers

Only one result row with the sales revenue sum of the top 10 customers

One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers

Only one result row with the sales revenue sum of all 100 customers

A

Only one result row with the sales revenue sum of the top 10 customers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q

You create a DataStore object (advanced) using the “Data Mart DataStore Object” modeling property. Which behaviors are specific to this modeling property?
There are 2 correct answers to this question.

Response:

All characteristics are automatically defined as key.

The change log table will only be filled after data activation.

Query results are only shown when data has been activated.

Reporting is done based on a union of the inbound and active tables.

A

All characteristics are automatically defined as key.

Reporting is done based on a union of the inbound and active tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

What are the possible ways to fill a pre-calculated value set (bucket)?
There are 3 correct answers to this question.

Response:

By using a query

By using a transformation and data transfer process(DTP)

By entering the values manually

By accessing an SAP HANA Calculation View of data category Dimension

By referencing a table

A

By using a query

By entering the values manually

By referencing a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

You expect to have more than 2 billion records as master data references for a characteristic in your data model and want to use the high cardinality option.

What do you need to consider in reporting?
Please choose the correct answer.

Response:

Using this characteristic as a navigational attribute will impact response time.

The local SID values are created automatically during reporting, which will impact the response time.

Using a hierarchy of this characteristic for navigation will impact response time.

The High Cardinality property needs to be defined in the Composite Provider.

A

Using a hierarchy of this characteristic for navigation will impact response time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q

From which SAP BW/4HANA objects can you start generating an external View?
There are 2 correct answers to this question.

Response:

Semantic group object

BW query

CompositeProvider

Open ODS view

A

BW query

CompositeProvider

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q

Where can you integrate an analysis view from SAP Analysis for microsoft office?
there are 3 correct answers to this question.

Response:

In a projection node of an SAP HANA calculation view

In an SAP BusinessObjects web intelligence report

In an SAP Crystal reports for Enterprise report

In another SAP Analysis for microsoft office workbook

In a BW query

A

In an SAP BusinessObjects web intelligence report

In an SAP Crystal reports for Enterprise report

In another SAP Analysis for microsoft office workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q

Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)?
There are 3 correct answers to this question.

Response:

Open Hub Destination

CompositeProvider

InfoSource

DataStore Object (advanced)

SAP HANA Analysis Process

A

Open Hub Destination

InfoSource

DataStore Object (advanced)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
60
Q

What are desired outcomes of an SAP BW/4HANA pilot project? There are 3 correct answers to this question.

A. Identify customizing and configuration areas to be applied to future projects.

B. Confirm increased database size using SAP BW/4HANA instead of a common RDBMS.

C. Identify objects from SAP BI content that will be leveraged in subsequent projects.

D. Identify required changes for the business processes to comply with SAP BW/4HANA standard software.

E. Transfer experience of the pilot project to future projects.

A

A. Identify customizing and configuration areas to be applied to future projects.

C. Identify objects from SAP BI content that will be leveraged in subsequent projects.

E. Transfer experience of the pilot project to future projects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
61
Q

What are some of the key characteristics of SAP BW/4HANA?

SAP BW/4HANA is not part of SAP NetWeaver anymore and is a separate new product.

SAP BW/4HANA does not support BEx Queries anymore.

SAP BW/4HANA only runs on SAP HANA.

SAP BW/4HANA is built natively in the SAP HANA platform and does not support ABAP as a programming language anymore.

A

SAP BW/4HANA is not part of SAP NetWeaver anymore and is a separate new product.

SAP BW/4HANA only runs on SAP HANA.

62
Q

What functions does the SAP BW/4HANA Cockpit provide?

Modeling process chains
Monitoring process chains
Modeling process chain variants
Modeling HANA analysis processes
Administration of data loading requests for InfoObjects and DataStore objects (advanced)
Administration of external SAP HANA Views
Administration of Analysis Authorizations

A

Modeling process chains
Monitoring process chains
Modeling process chain variants

Administration of data loading requests for InfoObjects and DataStore objects (advanced)
Administration of external SAP HANA Views
Administration of Analysis Authorizations

63
Q

What are key characteristics of SAP Data Warehouse Cloud ?
Collaboration: Enablement of both enterprise IT and line of business users
Performance: Leverage the power of SAP HANA
End-to-End Integration: Consumption of data from any source in SAP Analytics Cloud
Elasticity: Pay for what you use concept
Deployment: Free choice between on premise or private cloud

A

Collaboration: Enablement of both enterprise IT and line of business users
Performance: Leverage the power of SAP HANA
End-to-End Integration: Consumption of data from any source in SAP Analytics Cloud
Elasticity: Pay for what you use concept

64
Q

Sequence of activities for Remote conversion
Data transfer
scope selection in sending system
conversion into new obj in receiving
transport selected to receiving

A

scope selection in sending system
transport selected to receiving
conversion into new obj in receiving
Data transfer

65
Q

Which statement represents transitive attributes in SAP BW/4HANA in the best way?

Transitive attributes are the new name for InfoObject display attributes.
Transitive attributes are navigation attributes of existing InfoObject attributes.
Transitive attributes are a new type of InfoObject attributes to manage comments on certain attribute values.
Transitive attributes are a new type of InfoObject attributes that are populated from SAP HANA Calculation Views.

A

Transitive attributes are navigation attributes of existing InfoObject attributes.

66
Q

Which source types can you use to model an Open ODS View? 4

Database table or view
Virtual table using SAP HANA smart data access
BW DataSource
DataStore-Object (advanced)

A

Database table or view
Virtual table using SAP HANA smart data access
BW DataSource
DataStore-Object (advanced)

67
Q

which connection types are available when you define a new Open Hub Destination with target type Database table in SAP BW/4HANA 2.0 SP04 or higher?
Table in local Database
SAP HANA Smart Data Access (SDA)
SAP Data Services
Database Connection (DBCON)
OData
Operational Data Provisioning (ODP)

A

Table in local Database
SAP HANA Smart Data Access (SDA)
Database Connection (DBCON)

68
Q

In which exceptional case should you use the BAdI provider as preferred data model in SAP BW/4HANA?

Your license does not allow you to use HANA Script.
You implement a planning application based on SAP BPC, add-on for SAP BW/4HANA.
You implement a customer-specific virtual scenario and SAP ABAP logic is unavoidable there.
Your requirements contain key figures with exception aggregation.

A

You implement a customer-specific virtual scenario and SAP ABAP logic is unavoidable there.

69
Q

Which are recommended approaches for modeling virtual mixed scenarios?
2 correct

Generation of external SAP HANA Views for BW/4HANA objects

Provisioning of BW/4HANA data to SAP HANA based on the Open Hub interface

Modeling CompositeProviders based on SAP HANA Views

Loading of SAP HANA data into SAP BW/4HANA based on the ODP_HANA interface

A

Generation of external SAP HANA Views for BW/4HANA objects

Modeling CompositeProviders based on SAP HANA Views

70
Q

Where can you the set the Operations in SAP HANA property to define the runtime pushdown of BW Queries in SAP BW/4HANA?

CompositeProviders
InfoObject characteristics
BW Queries
DataStore Objects (advanced)

A

CompositeProviders
InfoObject characteristics
BW Queries

71
Q

You would like to implement a Data Tiering Optimization concept for a DataStore Object (advanced) that contains data from several years.

Schedule a job that executes the data displacement.

Define the ADSO tiers you would like to manage the data in.

Define ADSO partitions on the InfoObject that represents the calendar year.

Define the planned temperature for each of the partitions.

A

Define ADSO partitions on the InfoObject that represents the calendar year.

Define the ADSO tiers you would like to manage the data in.

Define the planned temperature for each of the partitions

Schedule a job that executes the data displacement.

72
Q

What interfaces does Operational Data Provisioning (ODP) provide for SAP BW/4HANA as a consumer?

Interface to objects of other BW systems

Interface to third-party databases

Interface to SAP HANA Calculation Views

Interface to SAP HANA HDI Calculation Views

Interface to SAP ABAP CDS Views

Interface to SAP HANA CDS Views

Interface to SAP systems based on SAP BW DataSources (Extractors)

Interface to Hadoop file clusters.

A

Interface to objects of other BW systems

Interface to SAP HANA Calculation Views

Interface to SAP ABAP CDS Views

Interface to SAP systems based on SAP BW DataSources (Extractors)

73
Q

Which of the following statements regarding connecting SAP Cloud applications to SAP BW/4HANA is correct?

SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_BYD.

SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_CDS.

SAP SuccessFactors can be connected based on Operational Data Provisioning (ODP) in the context of ODP_BYD.

SAP SuccessFactors can be connected based on SAP HANA Smart Data Integration (SDI) and its OData adapter.

A

SAP S/4HANA Cloud can be connected based on Operational Data Prov

SAP SuccessFactors can be connected based on SAP HANA Smart Data Integration (SDI) and its OData adapter.

74
Q

In BW/HANA it is possible to consume a SAP ABAP CDS View which is enabled for extraction virtually as well (that is, without loading the data)?

No. You have to load the data into advanced DSOs or InfoObjects first.

Yes. Model a CompositeProvider which consumes the SAP HANA Calculation View created by the ABAP CDS View.

Yes. Model an Open ODS view which is based on a BW DataSource of type SAP HANA Smart Data Access (HANA_SDA).

Yes. Model an Open ODS View which is based on a BW DataSource of type ODP_CDS.

A

Yes. Model an Open ODS View which is based on a BW DataSource of type ODP_CDS.

75
Q

SAP BW/4HANA, there is a new solution for statistical analysis of data management processes and query execution. Which technology is it based on?
SAP ABAP-Managed Database Procedures
SAP HANA Calculation Views
SAP HANA HDI Calculation Views
SAP ABAP Core Data Services
SAP BW/4HANA Open ODS Views

A

SAP ABAP Core Data Services

76
Q

Which delta-mechanism(s) is (are) available to load data from SAP S/4HANA Cloud to SAP BW/4HANA?
3 answers

SAP S/4HANA Cloud does not provide any delta mechanism for this scenario.

SAP S/4HANA Cloud supports Generic Delta based on a UTC Time Stamp.

SAP S/4HANA Cloud supports Change Data Capture (CDC) based on a database trigger.

SAP S/4HANA Cloud supports Generic Delta based on a Calendar Date.

A

SAP S/4HANA Cloud supports Generic Delta based on a UTC Time Stamp.

SAP S/4HANA Cloud supports Change Data Capture (CDC) based on a database trigger.

SAP S/4HANA Cloud supports Generic Delta based on a Calendar Date.

77
Q

Which tool(s) can you leverage to evaluate CDS Extractors in SAP S/4HANA? 1 answer

Business Content DataSource Browser in the general customizing (Tr. SPRO).

View Browser app in the SAP S/4HANA Fiori Launchpad.

BW Extraction app in the SAP S/4HANA Fiori Launchpad.

There is no such tool available. But the CDS Extractors are listed and documented in detail in the SAP help for SAP S/4HANA.

CDS Extraction app in the SAP BW/4HANA Cockpit.

A

View Browser app in the SAP S/4HANA Fiori Launchpad.

78
Q

Which tool(s) can you leverage to evaluate CDS Extractors in SAP S/4HANA?

Business Content DataSource Browser in the general customizing (Tr. SPRO).

View Browser app in the SAP S/4HANA Fiori Launchpad.

BW Extraction app in the SAP S/4HANA Fiori Launchpad.

There is no such tool available. But the CDS Extractors are listed and documented in detail in the SAP help for SAP S/4HANA.

CDS View I_DataExtractionEnabledView

A

View Browser app in the SAP S/4HANA Fiori Launchpad.

CDS View I_DataExtractionEnabledView

79
Q

What is the impact of SAP S/4HANA on an existing SAP BW system? 2 answers

After implementation of SAP S/4HANA embedded analytics, some applications in the SAP BW system might become obsolete.

SAP S/4HANA embedded analytics fully takes over the role of existing SAP BW environments. SAP BW systems can be decommissioned.

Extraction to the existing SAP BW system might change because not all extractors (DataSources) are available in SAP S/4HANA in the same way.

Conversion of the existing SAP BW system to SAP BW/4HANA is a precondition for an SAP S/4HANA implementation.

A

After implementation of SAP S/4HANA embedded analytics, some applications in the SAP BW system might become obsolete.

Extraction to the existing SAP BW system might change because not all extractors (DataSources) are available in SAP S/4HANA in the same way.

80
Q

What are the tools available to model individual ad-hoc scenarios in a BW/4HANA Workspace? 3 answers

SAP Analysis for MS Office

SAP BW/4HANA Modeling Tools

SAP BW Workspace Designer App in
SAP BW/4HANA Cockpit

SAP BW Workspace Query Designer (Tr. RSWQD)

A

SAP Analysis for MS Office

SAP BW Workspace Designer App in
SAP BW/4HANA Cockpit

SAP BW Workspace Query Designer (Tr. RSWQD)

81
Q

Which statement represents transitive attributes in SAP BW/4HANA in the best way?
Choose the correct answer.
A Transitive attributes are the new name for InfoObject display attributes.
B Transitive attributes are navigation attributes of existing InfoObject attributes.
C Transitive attributes are a new type of InfoObject attributes to manage comments on certain attribute values.
D Transitive attributes are a new type of InfoObject attributes that are populated from SAP HANA Calculation Views.

A

B Transitive attributes are navigation attributes of existing InfoObject attributes.

82
Q

Advanced DataStore objects are the central data model to manage transactional data in SAP BW/4HANA. They provide all services that were provided by InfoCubes and DataStore objects (classic) in SAP NetWeaver BW.
Determine whether this statement is true or false.

True

False

A

True

83
Q

CompositeProviders do not allow you to model temporal joins and SAP recommends using BW InfoSets for such scenarios in SAP BW/4HANA.
Determine whether this statement is true or false.

True

False

A

False
CompositeProviders cover these scenarios and therefore fully replace InfoSets of SAP NetWeaver BW.

84
Q

Which source types can you use to model an Open ODS View?
Choose the correct answers. 4 answers

A Database table or view
B Virtual table using SAP HANA smart data access
C BW DataSource
D DataStore-Object (advanced)

A

A Database table or view
B Virtual table using SAP HANA smart data access
C BW DataSource
D DataStore-Object (advanced)

85
Q

Which connection types are available when you define a new Open Hub Destination with target type Database table in SAP BW/4HANA 2.0 SP04 or higher?
Choose the correct answers.
A Table in local Database
B SAP HANA Smart Data Access (SDA)
C SAP Data Services
D Database Connection (DBCON)
E OData
F Operational Data Provisioning (ODP)

A

A Table in local Database
B SAP HANA Smart Data Access (SDA)

D Database Connection (DBCON)

86
Q

In which exceptional case should you use the BAdI provider as preferred data model in SAP BW/4HANA?
Choose the correct answer.
A Your license does not allow you to use HANA Script.
B You implement a planning application based on SAP BPC, add-on for SAP BW/4HANA.
C You implement a customer-specific virtual scenario and SAP ABAP logic is unavoidable there.
D Your requirements contain key figures with exception aggregation.

A

C You implement a customer-specific virtual scenario and SAP ABAP logic is unavoidable there.

87
Q

Which are recommended approaches for modeling virtual mixed scenarios?
2 answers

Generation of external SAP HANA Views for BW/4HANA objects

Provisioning of BW/4HANA data to SAP HANA based on the Open Hub interface

Modeling CompositeProviders based on SAP HANA Views

Loading of SAP HANA data into SAP BW/4HANA based on the ODP_HANA interface

A

Generation of external SAP HANA Views for BW/4HANA objects

Modeling CompositeProviders based on SAP HANA Views

88
Q

In SAP BW/4HANA, there is a new solution for statistical analysis of data management processes and query execution. Which technology is it based on?

SAP ABAP-Managed Database Procedures
SAP HANA Calculation Views
SAP HANA HDI Calculation Views
SAP ABAP Core Data Services
SAP BW/4HANA Open ODS Views

A

SAP ABAP Core Data Services

89
Q

Which delta-mechanism(s) is (are) available to load data from SAP S/4HANA Cloud to SAP BW/4HANA?
3 answers

SAP S/4HANA Cloud does not provide any delta mechanism for this scenario.

SAP S/4HANA Cloud supports Generic Delta based on a UTC Time Stamp.

SAP S/4HANA Cloud supports Change Data Capture (CDC) based on a database trigger.

SAP S/4HANA Cloud supports Generic Delta based on a Calendar Date.

A

SAP S/4HANA Cloud supports Generic Delta based on a UTC Time Stamp.

SAP S/4HANA Cloud supports Change Data Capture (CDC) based on a database trigger.

SAP S/4HANA Cloud supports Generic Delta based on a Calendar Date.

90
Q

Which tool(s) can you leverage to evaluate CDS Extractors in SAP S/4HANA?

Business Content DataSource Browser in the general customizing (Tr. SPRO).

View Browser app in the SAP S/4HANA Fiori Launchpad.

BW Extraction app in the SAP S/4HANA Fiori Launchpad.

There is no such tool available. But the CDS Extractors are listed and documented in detail in the SAP help for SAP S/4HANA.

CDS Extraction app in the SAP BW/4HANA Cockpit.

A

View Browser app in the SAP S/4HANA Fiori Launchpad.

91
Q

Which technology does SAP S/4HANA embedded analytics leverage?

SAP HANA Calculation Views
SAP ABAP Core Data Services
Embedded SAP BW with real-time InfoCubes
SAP HANA Core Data Services

A

SAP ABAP Core Data Services

92
Q

What are the tools available to model individual ad-hoc scenarios in a BW/4HANA Workspace? 3 answers

SAP Analysis for MS Office

SAP BW/4HANA Modeling Tools

SAP BW Workspace Designer App in SAP BW/4HANA Cockpit

SAP BW Workspace Query Designer (Tr. RSWQD)

A

SAP Analysis for MS Office

SAP BW Workspace Designer App in SAP BW/4HANA Cockpit

SAP BW Workspace Query Designer (Tr. RSWQD)

93
Q

Which are the core functional use cases of SAP Analytics Cloud?
5 answers

Providing flexible self-service reporting

Modeling planning applications

Defining predictive scenarios

Modeling SAP BW/4HANA objects

Uploading local data into a SAP BW Workspace

Modeling and sharing visualizations and dashboards

Setting up analytic applications with individual custom scripts.

A

Providing flexible self-service reporting

Modeling planning applications

Defining predictive scenarios

Modeling and sharing visualizations and dashboards

Setting up analytic applications with individual custom scripts.

94
Q

Which of the following statements regarding connecting SAP Cloud applications to SAP BW/4HANA is correct? 2 answers

SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_BYD.

SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_CDS.

SAP SuccessFactors can be connected based on Operational Data Provisioning (ODP) in the context of ODP_BYD.

SAP SuccessFactors can be connected based on SAP HANA Smart Data Integration (SDI) and its OData adapter.

A

SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_CDS.

SAP SuccessFactors can be connected based on SAP HANA Smart Data Integration (SDI) and its OData adapter.

95
Q

Which technology does SAP S/4HANA embedded analytics leverage? Choose 1

SAP HANA Calculation Views

SAP ABAP Core Data Services

Embedded SAP BW with real-time InfoCubes

SAP HANA Core Data Services

A

SAP ABAP Core Data Services

96
Q

Which of the following are tools of SAP BW/4HANA?

Data Warehousing Workbench
BW Modeling Tool in Eclipse
Bex Analyzer
SAP BW/4HANA Cockpit

A

Data Warehousing Workbench
BW Modeling Tool in Eclipse
SAP BW/4HANA Cockpit

97
Q

What is a DataSource?

A flat structure of logically related fields that contain data to be transferred into SAP BW/4HANA
An object that defines master data modeling rules, such as compounding
A store of data used for staging
A structure used to define transformation rules

A

A flat structure of logically related fields that contain data to be transferred into SAP BW/4HANA

98
Q

What is replication?

Copying data from one layer to another
Making the source system fields used in an extraction available to SAP BW/4HANA
Moving data from the source system to SAP BW/4HANA

A

Making the source system fields used in an extraction available to SAP BW/4HANA

99
Q

What are InfoProviders?

Objects that define the fields used for extraction from a source system
Objects that reports are based on
Objects that stage data during loading

A

Objects that reports are based on

100
Q

What additional objects can be generated from an Open ODS view?
3 options

DataSource
Transformation
DataStore Object (advanced)
CompositeProvider

A

DataSource
Transformation
DataStore Object (advanced)

101
Q

Which of the following are Best Practice options for storing data in a BW system running on SAP HANA?

Store the bulk of the data on disk for retrieval when required (warm data)

Store the most relevant data in a compressed column store in memory (hot data)

Split the most relevant data by date and store between an uncompressed column store and tables stored on disk (warm data)

Store all data in compressed column stores to maximize performance (hot data)

Move less important data into an external storage system (cool data)

A

Store the bulk of the data on disk for retrieval when required (warm data)

Store the most relevant data in a compressed column store in memory (hot data)

Move less important data into an external storage system (cool data)

102
Q

Based on BW/4HANA focus, which of the following should be considered when modeling master data and transaction data?

If master data does not need to be replicated, an Open ODS View for texts and attributes could be used.

If transaction data should be stored, a DataStore Object (advanced) (aDSO) should be used

To load transaction data efficiently, an Open ODS View of type facts should be used

Without additional data load, combine data from existing InfoProviders using a CompositeProvider.

If master data is to be persisted, then characteristics should be used

A

If master data does not need to be replicated, an Open ODS View for texts and attributes could be used.

If transaction data should be stored, a DataStore Object (advanced) (aDSO) should be used

Without additional data load, combine data from existing InfoProviders using a CompositeProvider.

If master data is to be persisted, then characteristics should be used

103
Q

What is the purpose of the Virtual Data Mart Layer? 3

Agile Extension: Allow business users to upload files and directly report on them.

Enhancing master data: Add navigational attributes as required for a specific business scenario.

Flexibility: If you need to exchange the physical InfoProvider below, all BW queries can remain unchanged.

Support the Unknown: Store data that is currently not needed in case it is needed later.

Virtual Combination: Filter and join data from existing InfoProviders without uploading already available records.

A

Enhancing master data: Add navigational attributes as required for a specific business scenario.

Flexibility: If you need to exchange the physical InfoProvider below, all BW queries can remain unchanged.

Virtual Combination: Filter and join data from existing InfoProviders without uploading already available records.

104
Q

Which of the following guidelines should be considered in an enterprise-wide implementation of BW on HANA?

How will the different data models be incorporated
Utilize the LSA++ layers in the design of the EDW
Which languages and currencies will need to be considered
What will the system and transport landscape be comprised of
Which users will be logging onto the system

A

How will the different data models be incorporated
Utilize the LSA++ layers in the design of the EDW
Which languages and currencies will need to be considered
What will the system and transport landscape be comprised of

105
Q

Which BW/4HANA objects can be modeled as a purely field-based model? 3 correct

InfoObjects with Hierarchies
Open ODS Views
ADSOs
CompositeProviders

A

Open ODS Views
ADSOs
CompositeProviders

106
Q

Which of the following statements regarding internal and external hierarchies are true?

Internal hierarchies have no link to Master Data tables

Internal hierarchies are used to display characteristics without using an external hierarchy

External hierarchies are defined in Business Explorer Query Designer on the Hierarchy tab

External hierarchies are defined as “external” because the data is stored outside of BW on the OLAP server

External hierarchies are stored in BW Master Data tables

A

Internal hierarchies have no link to Master Data tables
Internal hierarchies are used to display characteristics without using an external hierarchy
External hierarchies are stored in BW Master Data tables

107
Q

Which of the following contain the correct terminology about hierarchies?

An entity in a hierarchy is called a node
Nodes that have no parents are called orphan nodes
Nodes that have no children nodes are called leaf nodes or leaves
A relationship between a node and its parent node is called a family tree
A hierarchy with leaves on different levels is an unbalanced hierarchy

A

An entity in a hierarchy is called a node

Nodes that have no children nodes are called leaf nodes or leaves

A hierarchy with leaves on different levels is an unbalanced hierarchy

108
Q

What are typical examples of Mixed Scenarios? 3 correct

Data Acquisition in SAP BW/4HANA and applying SQL logic in modeled SAP HANA Views on top of generated SAP HANA Views

Data Acquisition in SAP HANA and applying BW logic in CompositeProviders which contain only SAP HANA Calculation Views

Data Acquisition in SAP BW/4HANA and applying BW logic in CompositeProviders which contain only aDSOs and InfoObjects.

Data Acquisition in SAP BW/4HANA and SAP HANA and applying BW logic in CompositeProviders which contain only aDSOs and SAP HANA Calculation Views

A

Data Acquisition in SAP BW/4HANA and applying SQL logic in modeled SAP HANA Views on top of generated SAP HANA Views

Data Acquisition in SAP HANA and applying BW logic in CompositeProviders which contain only SAP HANA Calculation Views

Data Acquisition in SAP BW/4HANA and SAP HANA and applying BW logic in CompositeProviders which contain only aDSOs and SAP HANA Calculation Views

109
Q

What are key characteristics of SAP Data Warehouse Cloud ?

Collaboration: Enablement of both enterprise IT and line of business users

Performance: Leverage the power of SAP HANA

End-to-End Integration: Consumption of data from any source in SAP Analytics Cloud

Elasticity: Pay for what you use concept

Deployment: Free choice between on premise or private cloud

A

Collaboration: Enablement of both enterprise IT and line of business users

Performance: Leverage the power of SAP HANA

End-to-End Integration: Consumption of data from any source in SAP Analytics Cloud

Elasticity: Pay for what you use concept

110
Q

Which are properties of Live Data Connectivity of SAP Analytics Cloud?

Live Data Connectivity is the only method to provide data from a BW/4HANA system.

Live Data Connectivity is limited regarding the amount of data.

With Live Data Connectivity, the authorizations of the connected system are considered.

With Live Data Connectivity, analysis is performed without data replication.

A

With Live Data Connectivity, the authorizations of the connected system are considered.

With Live Data Connectivity, analysis is performed without data replication.

111
Q

For which infoprovider types can you select navigation attributes?
There are 2 correct answers to this question.

Response:

open ODS Views

Datastore object (advanced) of type infocube

Datastore object (advanced) of type standard datastore object.

Composite provider

A

open ODS Views

Composite provider

112
Q

What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA?
There are 2 correct answers to this question.

Response:

There must be no BW analysis authorizations defined that use any of the cost centers.

There must be no hierarchy for the cost centers.

There must be no BW query that uses cost center as a free characteristic.

There must be no transaction data referring to the cost centers.

A

There must be no hierarchy for the cost centers.

There must be no transaction data referring to the cost centers.

113
Q

Your company is using SAP S/4HANA as a business operational system and you have to provide operational analytical reports. Why might you consider SAP S/4HANA embedded analytics?
Please choose the correct answer.

Response:

To use the ABAP CDS view based virtual data model.

To use the SAP HANA optimized business content.

To use the generated external SAP HANA Calculation Views.

To use the SAP HANA Deployment Infrastructure.

A

To use the ABAP CDS view based virtual data model.

114
Q

How can you persist data from any SAP HANA database table to a table in the SAP BW Schema?
There are 3 correct answers to this question.

Response:

Create an Open ODS view.

Consume the view using a CompositeProvider.

Load the data to a DataStore object (advanced).

Create a DataSource.

Create an SAP HANA calculation view.

Create an Open ODS view. Generate a data flow.

A

Load the data to a DataStore object (advanced).

Create a DataSource.

Create an Open ODS view. Generate a data flow.

115
Q

You want to run a BW query, but you only have partial authorization for the data selection. What happens related to the BW query in this scenario?
Please choose the correct answer.

Response:

The BW query starts and the unauthorized values are 0.

The BW query does notstart running.

The BW query starts and shows an error message.

The BW query starts and only the authorized data is displayed.

A

The BW query starts and only the authorized data is displayed.

116
Q

When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features?
There are 2 correct answers to this question.

Response:

When you define the material characteristic, select the “Enhanced Master data update” setting.

When you define the data transfer process, choose the “Set manually” setting for “Overall status of request”.

When you define the attributes of material, select the “Time Dependent” setting.

When you define the data transfer process, select the “Load records with new key only” setting.

A

When you define the material characteristic, select the “Enhanced Master data update” setting.

When you define the data transfer process, choose the “Set manually” setting for “Overall status of request”.

117
Q

Which features can be leveraged using a CompositeProvider in SAP BW/4HANA?
There are 3 correct answers to this question.

Response:

Define new restricted key figures

Integrate SAP HANA calculation views

Combine InfoProviders using Joins and Unions

Create new calculated fields

Join two ABAP CDS views

A

Integrate SAP HANA calculation views

Combine InfoProviders using Joins and Unions

Join two ABAP CDS views

118
Q

You want to use the SAP HANA concept of semantic types as part of the currency conversion mechanism. You decide to use semantic type Amount with Currency Code within your SAP HANA calculation view.

Which currency reference can be assigned to the measure?
There are 3 correct answers to this question.

Response:

A currency from SAP BW customizing

A currency from another column

A currency from an SAP HANA content calculation view

A fixed currency

A currency from a currency conversion

A

A fixed currency

A currency from a currency conversion

A currency from another column

119
Q

Which of the following is the core workflow when working with SAP Analytics Cloud?
Please choose the correct answer.

Response:

Explore - Acquire - Prepare - Visualize - Collaborate

Acquire - Prepare - Visualize - Explore - Collaborate

Acquire - Prepare - Explore - Visualize - Collaborate

Prepare - Explore - Acquire - Visualize - Collaborate

A

Acquire - Prepare - Visualize - Explore - Collaborate

120
Q

You use the wizard to create an SAP BW/4HANA Big data source system. Which activities are mandatory?
There are 3 correct answers to this question.

Response:

Select a database objectschema.

Specify connection type BigData.

Specify release type.

Select a remote source.

Specify business content type.

A

Select a database objectschema.

Specify connection type BigData.

Select a remote source.

121
Q

You need to use an SAP ERP standard DataSource to load data into SAP BW/4HANA. Which prerequisite must be fulfilled to use the DataSource in the Operational Data Provisioning context?
Please choose the correct answer.

Response:

It must be in-memory-optimized.

It must exist in table ROOSATTR.

It must have a queue entry in transaction ODQMON.

It must be delta-enabled.

A

It must exist in table ROOSATTR.

122
Q

What are benefits of separating master data from transactional data in SAP BW/4HANA?
There are 2 correct answers to this question.

Response:

Distinguish between changeable and non-changeable data

Avoid generation of SID values

Ensure referential integrity on your transactional data

Provide language-dependent texts

A

Distinguish between changeable and non-changeable data

Ensure referential integrity on your transactional data

123
Q

Which reporting object do you use to combine data from different SAP BW InfoProviders?
Please choose the correct answer.

Response:

Dataprovider

BW query

Analysis workbook

Analysis view

A

Analysis workbook

124
Q

You create an SAP HANA HDI Calculation View. What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension?
There are 3 correct answers to this question.

Response:

Create restricted columns.

Provide default time characteristics.

Aggregate measures as a sum.

Persist transactional data.

Combine master data and transactional data.

A

Create restricted columns.

Provide default time characteristics.

Aggregate measures as a sum.

125
Q

What can you leverage using the live data connections of SAP Analytics Cloud with SAP BW/4HANA?
There are 2 correct answers to this question.

Response:

Existing authorization concepts

Process chain streaming functionality

BW data models for analysis

BW data models for planning scenarios

A

Existing authorization concepts

BW data models for analysis

126
Q

What must you do to define an inventory infoprovider in SAP BW/4HANA?
There are 3 correct answers to this question.

Response:

Assign at least one non-cumulative key figure.

Select the Unique Data Records model property.

Select the All characteristics are key model property.

Assign at least one cumulative key figure.

Select the Inventory model property.

A

Assign at least one non-cumulative key figure.

Select the All characteristics are key model property.

Select the Inventory model property.

127
Q

You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder?
There are 2 correct answers to this question.

Response:

Open ODS view of type Facts

InfoObject of type Characteristic

Calculation View of type Dimension

Open ODS view of type Master Data

A

Calculation View of type Dimension

Open ODS view of type Master Data

128
Q

Which condition must you ensure if you want to replicate data based on a view with SAP Landscape transformation replication server?
Please choose the correct answer.

Response:

View-based data result sets must be kept persistent first until data replication can take place.

One table as part of the view has to be defined as primary table and is used to trigger data replication.

Each table of the view requires a defined trigger to enable data replication.

An SAP HANA source system must be defined to consume the view.

A

Each table of the view requires a defined trigger to enable data replication.

129
Q

What can you do in the sap bw/4hana cockpit?
There are 3 correct answers to this question.

Response:

manage request in infoobjects and datastore object

model, schedule and monitor process chain

model and transport data flow

maintain data tiering setting

model and schedule replication task

A

manage request in infoobjects and datastore object

model, schedule and monitor process chain

model and transport data flow

130
Q

Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generatesfully populated, multi-tabbed stories?
Please choose the correct answer.

Response:

Search to Insight

Smart Predict

Smart Discovery

Forecasting

A

Smart Discovery

131
Q

You edit an SAP BW/4HANA object. In which SAP HANA studio views can you view the last modifier and modification time?
There are 2 correct answers to this question.

Response:

Properties view

Problems view

Reporting preview

History view

A

Properties view

History view

132
Q

In which sequence can you create a reusable key figure structure?
There are 2 correct answers to this question.

Response:

A. 1. Apply filters to a key figure structure in SAP Analysis for Microsoft Office.
A . 2. Save the structure as a global structure.

B. 1. Create a new structure in the context menu of an InfoProvider.
B. 2. Add key figures, selections, and formulas.

C. 1. Create a new structure with key figures, selections, and formulas in a query.
C. 2. Save the structure as a global structure.

D. 1. Create a new structure in the context menu of a calculated key figure.
D. 2. Save the structure as a global structure.

A

B. 1. Create a new structure in the context menu of an InfoProvider.
B. 2. Add key figures, selections, and formulas.

C. 1. Create a new structure with key figures, selections, and formulas in a query.
C. 2. Save the structure as a global structure.

133
Q

Which objects can you use as components in a compositeprovider in SAP BW/4HANA?
There are 2 correct answers to this question.

Response:

Open ODS view

Compositeprovider

Semantic group

BW query

A

Open ODS view

Compositeprovider

134
Q

You want to define a restricted column in an SAP HANA calculation view. What do you need to define?
There are 2 correct answers to this question.

Response:

An aggregation method

An SAP HANA data type

A condition criterium

A reference to an existing measure

A

A condition criterium

A reference to an existing measure

135
Q

Which processing types can you define for a formula variable?
There are 3 correct answers to this question.

Response:

replacement path from an infoobject

replacement path from another variable

authorization

manual input

replacement path from another query

A

manual input

replacement path from an infoobject

replacement path from another variable

136
Q

You create a DataStore object (advanced) using model template Standard DataStore Object. Which flags are set?
There are 2 correct answers to this question.

Response:

Unique data records

All characteristic are key

Activate Data

Write change log

A

Activate Data

Write change log

137
Q

You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued.

Which join properties do you assign to the required join type?
Please choose the correct answer.

Response:

Referential join with temporal join properties

Inner join with Dynamic join properties

Referential join with Dynamic join properties

Inner join with temporal join properties

A

Referential join with temporal join properties

138
Q

What is the effect of using the RODPS_REPL_TEST program to test sap erp operational data provisioning (ODP) data source?
There are 2 correct answers to this question.

Response:

the reset delta function affects all ODP delta queues

the program behaves like the sap rsa3 extractor checker

the application data is physically written to the queue

the program behaves as an additional subscriber

A

the application data is physically written to the queue

the program behaves as an additional subscriber

139
Q

You created a generic DataSource in SAP ERP using a function module. Which manual activity could you perform to enable your generic DataSource to use as an ODP_SAP DataSource in SAP BW/4HANA?
Please choose the correct answer.

Response:

Generate the PSA table of the DataSource in SAP BW/4HANA

Release the DataSource in SAP BW/4HANA for ODP

Adapt the function module using transaction ODQMON

Run program RODPS_OS_EXPOSE in SAP ERP for the DataSource

A

Run program RODPS_OS_EXPOSE in SAP ERP for the DataSource

140
Q

What is the purpose of an architecture overview model?
Please choose the correct answer.

Response:

To automatically generate the LSA++ architecture

To determine the sequence of projects

To identify the user groups and required authorizations

To identify the required data sources

A

To automatically generate the LSA++ architecture

141
Q

Your customer converts LSA to LSA++ and needs to streamline the enterprise data warehouse layer.What action do you take?Please choose the correct answer.

Response:
A. Migrate all SAP Business Warehouse objects to SAP HANA optimized objects.

B. Apply the SAP Business Warehouse workspace layer.

C. Reduce the number of persistent InfoProviders.

D. Apply the Open ODS layer.

A

C. Reduce the number of persistent InfoProviders.

142
Q

Which objects are mandatory when you create a transactional data flow in operational data
provisioning?
Note: There are 2 correct answers to this question.

a) O Data transfer process
b) O Real-time daemon
c) O InfoPackage
d) O Transformation

A

a) O Data transfer process

d) O Transformation

143
Q

Which of the following activities are part of the realization phase of an SAP Business
Warehouse (SAP BW) project?
Note: There are 3 correct answers to this question.
a) O Design the data layer concept based on the LSA++ architecture.
b) O Create functional and technical documentation.
c) O Define a service level agreement.
d) O Build SAP HANA views and define their properties.
e) O Create and activate SAP BW objects.

A

b) O Create functional and technical documentation.

d) O Build SAP HANA views and define their properties.

e) O Create and activate SAP BW objects.

144
Q

Which sources are available for a generic SAP Business Warehouse DataSource?
Note: There are 3 correct answers to this question.
a) O SAP HANA information view
b) O Function module
c) O SAP HANA remote source table
d) O DB view or table
e) O SAP query (InfoSet)

A

b) O Function module

d) O DB view or table

e) O SAP query (InfoSet)

145
Q

Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse?
Please choose the correct answer.

a) Web service
b) Universal Data Connect
c) Database Connect
d) File interface

A

b) Universal Data Connect

146
Q

You would like to implement a virtual scenario in yur SAP BW/4HANA system.

Which approach does SAP recommend for this kind of scenario? Note: There are 3 correctanswerto this question.
Integrate external data into SAP BW/4HANA based on the Write Interface-ebabled DataStore object.

Model a CompositeProvider which combines data from multiple SAP BW/4HANA InfoProviders and SAP HANA Views.

Generate external SAP HANA view of SAP BW/4HANA InfoProviders to consume SAP BW/4HANA data in SAP HAN

Define an Open ODS View which integrates an SAP HANA table into SAP BW/4HAN

Load SAP HANA dat into SAP BW/4HANA InfoProviders based on the Operational Data Provisioning (ODP) framework.

A

Model a CompositeProvider which combines data from multiple SAP BW/4HANA InfoProviders and SAP HANA Views.

Generate external SAP HANA view of SAP BW/4HANA InfoProviders to consume SAP BW/4HANA data in SAP HANA

Integrate external data into SAP BW/4HANA based on the Write Interface-ebabled DataStore object.

147
Q

You want to create an SAP BW Query showing data loading statistics provided by the SAP BW/4HANA statisical analysis.

Which object does SAP deliver to provide data for your SAP BW Query?
Open ODS View
ABAP CDS View
Badl Provider
DataStore object (advanced)

A

ABAP CDS View

148
Q

From an SAP BW/4HANA perspective, what is the difference between SAP HANA Smart Data Access (SDA) and SAP HANA Smart Data Integration (SID)? Note: There are 2 correctanswersto this question.

SDI provides options for data replication in real-time, while SDA does NOT provide this capability.

SDA is integrates into the SAP HANA Indexserver while you need to setup an additional SAP 1-1 HANA Data Provisioning server for SDIcorrect

SAP BW/4HANA DataSources of source system type “SAP HANA” can connect to SDA sources, U but NOT to SDI sources.

SAP BW/4HANA Open ODS View can be modelled on SDI sources, but NOT on SDA sources.

A

SDA is integrates into the SAP HANA Indexserver while you need to setup an additional SAP 1-1 HANA Data Provisioning server for SDI

SAP BW/4HANA Open ODS View can be modelled on SDI sources, but NOT on SDA sources.

149
Q

For which SAP Cloud system does SAP recommend using the SAP HANA SDI and its Odata adapter to load data into SAP BW/4HANA?
SAP C/4HANA
SAP SuccessFactorswrong
SAP S/4HANA Cloud
SAP Ariba

A

SAP Ariba

150
Q

Why do you create a Semantic Group?
To create folders for SAP BW Query elements
To load InfoObject attribute with Enhanced Master Data Update
To generate multiple similar DataStore objects (advanced)
To define settings for Data Tiering Optimization (DTO)

A

To define settings for Data Tiering Optimization (DTO)

151
Q

ou create a DataStore object (advanced) with only the setting ““Sraging DataStore Object”” and ““Reporting-Enabled”” selected.

Which table or combination of tables is used when data is extracted from this DataStore object (advanced) in a data flow?
The union of the Inbound table and the Changelog table
The union of the Inbound table and the Active Data tablewrong
Inbound table only
Active Data table only

A

Active Data table only

SAP (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions