Brainscape's Knowledge GenomeTM

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


See full index

SAP BW4/HANA > BW4HANA14 > Flashcards

BW4HANA14 Flashcards

1
Q

You create a transformation from a DataSource to a standard DataStore object. The
DataSource provides an after-image delta. Which key figure aggregation type do you select?
A. Summation
B. Maximum
C. Minimum
D. Overwrite

A

D. Overwrite

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

Which of the following statements describe the advantages of
CompositeProviders over the classic MultiProviders/lnfoSets?
A. CompositeProviders provide joins and unions with a single object.
B. CompositeProviders can also include joins to classic MultiProviders.
C. CompositeProviders integrate with all the BW lnfoProviders.
D. A CompositeProvider can be consumed by another CompositeProvider.
E. Classic MultiProviders have to be recreated as CompositeProviders.

A

A. CompositeProviders provide joins and unions with a single object.
C. CompositeProviders integrate with all the BW lnfoProviders.
D. A CompositeProvider can be consumed by another CompositeProvider.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q 
Which of the following aggregation options must you define as an exception aggregation?
Choose the correct answers.
A. Summation
B. Average
C. Minimum
D. Maximum
E. Counter
F. Last Value
A

B. Average
E. Counter
F. Last Value

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

Workspace Query Designer can be used to create queries
that can be used across the entire company because the tool is
really using BEX Query Designer. Determine Whether this
statement is true or false.
A. True
B. False

A

B. False

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

By using a MultiProvider on top of each InfoCube to control
query access, you significantly reduce the effort required, for
example, to copy queries after remodeling takes place. Determine
Whether this statement is true or false.

A

True

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

Your customer wants to link a query to an external URL. Which of the following steps are
required for a report-report interface setting?
Note: There are 3 correct answers to this question.
A. Insert the parameter for the Web address in the assignment details.
B. Select the Web address from the list of report types.
C. Select Receiver Object and enter the Web address.
D. Select a system from the Source Systems tab.
E. Insert the Web address in the assignment details.

A

A. Insert the parameter for the Web address in the assignment details.
B. Select the Web address from the list of report types.
C. Select Receiver Object and enter the Web address.

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

Which of the following statements are true?
A. For time-dependent master data such as attributes, texts, or hierarchies, the key date determines
the date for which time validity the data is selected.
B. The key date acts as a static temporal filter for the whole query.
C. The key date is a mandatory field in the query definition.
D. The key date determines the temporal validity of the query definition.
E. For the key date you can also use a variable instead of a specific value.

A

A. For time-dependent master data such as attributes, texts, or hierarchies, the key date determines
the date for which time validity the data is selected.
E. For the key date you can also use a variable instead of a specific value.

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

Which of the following are external tools used for Data
Provisioning?
A. Direct Extractor Connection (DHC)
B. SAP Data Services
C. SAP Landscape Transformation Replication Server
D. Near Line Storage
E. Enterprise Information Management

A

A. Direct Extractor Connection (DHC)
B. SAP Data Services
C. SAP Landscape Transformation Replication Server

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

Which of the following statements regarding internal and external hierarchies are true?
Choose the correct answers.
A. Internal hierarchies have no link to master data tables
B. Internal hierarchies are used to display characteristics without using an external hierarchy
C. External hierarchies are defined in Business Explorer Query Designer on the hierarchy tab
D. ‘External’ hierarchies are defined as external because the data is stored outside of BW on the
OLAP server
E. External hierarchies are stored in BW master data tables

A

A. Internal hierarchies have no link to master data tables
B. Internal hierarchies are used to display characteristics without using an external hierarchy
E. External hierarchies are stored in BW master data tables

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

SAP HANA provides a choice of row or column storage types. Determine whether this
statement is true or false.

A

True

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

The productive BW system is always defined as a closed system in which changes can only be
made by importing a transport.
Determine whether this statement is true or false.

A

True

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

Which of the following statements regarding analysis authorizations are correct?
A. Authorization-relevant characteristics are characteristics for which the data are protected.
B. Authorizations for the authorization objects S_RS_COMP and S_RS_COMP1 are sufficient for users
who want to display data from authorization-relevant characteristics.
C. When a query is executed. all authorization-relevant characteristics that are contained in the
InfoProvider on which the query is based on are checked.
D. Using the transaction RSECADMIN, you can create analysis authorizations for a group of
authorization relevant characteristics and restrict the values for these characteristics.

A

A. Authorization-relevant characteristics are characteristics for which the data are protected.
C. When a query is executed. all authorization-relevant characteristics that are contained in the
InfoProvider on which the query is based on are checked.

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

A reference lnfoObject is a ‘template’ of an
lnfoObject that is then used as a reference or other
objects when the characteristic properties are the same.
Determine Whether this statement is true or false.

A

True

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

Which of the following statements are true about Advanced DataStore
Objects (ADSOs)?
A. To improve loading, data can be written directly into the active table
B. They can be used in various layers of the EDW architecture
C. ADSOs can contain a combination of InfoObjects and fields (that are not InfoObjects)
D. They are made up four tables - inbound, active, change and archive
E. Queries read data from the active and inbound tables

A

B. They can be used in various layers of the EDW architecture
C. ADSOs can contain a combination of InfoObjects and fields (that are not InfoObjects)
E. Queries read data from the active and inbound tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q 
How can text variables be processed?
Choose the correct answers.
A. Manual Entry
B. Replacement Path
C. Authorization
D. Customer Exit
A

A. Manual Entry
B. Replacement Path
D. Customer Exit

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

The target query needs a variable to be able to receive the filter values from the sender
query. Determine whether this statement is true or false.

A

True

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

Temporal conditions can be defined on columns of the
following data types: timestamp, date, and text. Determine
Whether this statement is true or false.

A

True

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

Which two steps do you need to perform to make a display attribute available as a navigation
attribute in a query?
A. Activate the navigation attribute in the characteristic properties in BW Query Designer.
B. Drag and drop the display attribute to the Free section or the BW Query Designer.
C. Activate the navigation attribute in the SAP BW data flow transformation.
D. Change the attribute type from Display to Navigation in the lnfoObject maintenance.
E. Activate the navigation attribute in the respective InfoProvider.

A

D. Change the attribute type from Display to Navigation in the lnfoObject maintenance.
E. Activate the navigation attribute in the respective InfoProvider.

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

Which of the following statements regarding hierarchical structure display are correct?
A. In a structure. hold down the CTRL key and drag the structure members that you want to display
as subitems directly over the structure member that you want to display as the parent node for the
subitems.
B. The hierarchical structure display only works for structures with key figures.
C. The number of levels for a hierarchical structure display is limited to 2.
D. You can use the node status to determine whether the node displays collapsed or expanded in the
report.

A

A. In a structure. hold down the CTRL key and drag the structure members that you want to display
as subitems directly over the structure member that you want to display as the parent node for the
subitems.
D. You can use the node status to determine whether the node displays collapsed or expanded in the
report.

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

When you select a query for translation in the Data Warehousing Workbench, you must also
manually select the query objects for translation. Determine whether this statement is true or false.

A

False

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

By selecting and combining the InfoObjects in a query, you
determine the way in which data from an lnfoProvider is
evaluated. Determine whether this statement is true or false.

A

True

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

Using the Remodeling Toolbox, lnfoObjects can be changed
without having to delete or reload master data. Determine Whether
this statement is true or false.

A

True

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

SAP BusinessObjects Analysis, edition for Microsoft Office is the reporting tool of choice for
executives because it allows the use of sophisticated graphical elements to visualize highly
aggregated data.
Determine Whether this statement is true or false.

A

True

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

The Data Transfer Process is a tool that is used to move
data within BW from an InfoProvider to a DataSource.
Determine whether this statement is true or false.

A

False

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

Which tabs do you find in the design panel of SAP BusinessObjects
Analysis, edition for Microsoft Excel? Choose the correct answers.
A. Components
B. information
C. Data Source
D. Workbook
E. Analysis

A

A. Components
B. information
E. Analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
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. Data transfer process
B. Real-time daemon
C. Info Package
D. Transformation

A

A. Data transfer process

D. Transformation

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

Which of the following is possible when using Open ODS Views?
A. Combine CompositeProviders with lnfoObjects
B. Consume external data without staging
C. Extend the HANA database table definitions to include fields
D. Combine external data with BW models
E. Physical integration of external data (staging)

A

B. Consume external data without staging
D. Combine external data with BW models
E. Physical integration of external data (staging)

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

In SAP BusinessObjects Analysis, edition for Microsoft Office, exceptions should be used
instead of conditional formatting in Microsoft Excel to highlight values because exceptions are
defined for a key figure and not individual cells?. Determine whether this statement is true or false.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q 
Which of these settings must you enter when creating a jump target in the RRI?
Choose the correct answers.
A. Target System
B. Report Type
C. Receiver Variable
D. Goto
A

B. Report Type

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

Which of the following guidelines should be considered in an enterprise- wide implementation
of BW on HANA?
A. How will the different data models be incorporate
B. Utilize the LSA++ layers in the design of the EDW
C. Which languages and currencies will need to be considered
D. What will the system and transport landscape be comprised of
E. Which users will be logging onto the system

A

A. How will the different data models be incorporate
B. Utilize the LSA++ layers in the design of the EDW
C. Which languages and currencies will need to be considered
D. What will the system and transport landscape be comprised of

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

Which of the following statements are true regarding the difference between compounding
and concatenation?
A. Compounding is easier to filter in queries because the objects are separate whereas with
concatenation, the key string needs to be masked
B. Compounding is easier for users to understand because it is based on a 1:1 object mapping but
concatenation is more complex for users to understand and decipher
C. Concatenation uses a single key value but compounding uses more than one
D. Adding key fields in concatenation is easier because only the transformation needs to be changed
but in compounding structures need to be changed and data re-loaded
E. Compounding is supported in the definition of the lnfoObject whereas concatenation requires the
creation of new database tables

A

B. Compounding is easier for users to understand because it is based on a 1:1 object mapping but
concatenation is more complex for users to understand and decipher
D. Adding key fields in concatenation is easier because only the transformation needs to be changed
but in compounding structures need to be changed and data re-loaded
E. Compounding is supported in the definition of the lnfoObject whereas concatenation requires the
creation of new database tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q 
Which of the following are InfoObjects?
A. Characteristics InfoObjects
B. Key Figures InfoObjects
C. Transformation InfoObjects
D. Time Characteristic InfoObjects
A

A. Characteristics InfoObjects
B. Key Figures InfoObjects
D. Time Characteristic InfoObjects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q 
In Design Studio Generic Analysis application, for which of the following components is a
context menu for navigation available?
A. Crosstab
B. Actions button
C. Navigation panel
D. Filter line
E. Chart
F. Information button
A

A. Crosstab
C. Navigation panel
E. Chart

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

Which of the following are advantages of column
tables?
A. Elimination of materialized aggregates
B. Higher data compression rates
C. Elimination of parallel execution
D. Elimination of additional indexes

A

A. Elimination of materialized aggregates
B. Higher data compression rates
D. Elimination of additional indexes

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

Your customer converts LSA to LSA++ and needs to streamline the enterprise data warehouse
layer.
What action do you take?
A. Reduce the number of persistent Info Providers.
B. Apply the SAP Business Warehouse workspace layer.
C. Migrate all SAP Business Warehouse objects to SAP HANA optimized
objects.
D. Apply the Open ODS layer.

A

B. Apply the SAP Business Warehouse workspace layer.

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

If an InfoSource is used in front of an InfoProvider and an
outbound InfoSource after an InfoProvider, the transformation logic
is always located between the outbound InfoSource of the source
InfoProvider and the inbound InfoSource of the target InfoProvider.
Determine whether this statement is true or false.

A

True

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

How can you use formula variables?
Choose the correct answers.
A. As operands for local calculations in reports.
B. As operands in formulas that are retrieved via replacement path.
C. As threshold values in exceptions and conditions.
D. As key values for characteristic restrictions.

A

B. As operands in formulas that are retrieved via replacement path.
C. As threshold values in exceptions and conditions.

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

When used for planning, Real Time InfoCubes contain a
single table and Advanced Data Store Objects comprise two
tables for storing compressed and uncompressed data.
Determine Whether this statement is true or false.

A

True

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

You can sort the members of an external hierarchy in ascending or descending order.
Determine whether this statement is true or false.

A

True

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

How can you delete queries and query components?
Choose the correct answers.
A. Use the transaction RSZDELETE.
B. Use the Query Monitor (transaction RSRTl).
C. Use the BW Query Designer.
D. Use the Data Warehousing Workbench (t-co RSA1).

A

A. Use the transaction RSZDELETE.

C. Use the BW Query Designer.

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

A filter is defined to apply to the whole query but a restricted key
figure only filters a single key figure value. Determine whether this
statement is true or false.

A

True

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

Which of the following is required to perform currency conversion in an SAP HANA
information model?
A. An innerjoin is required between the Open ODS View measures and the exchange rate table
B. A set of technical tables are required to store currencies and exchange rate types and rates
C. Setting a semantic type to a measure so the amount always includes a currency
D. Storing the currency and the exchange rate on the day of the transaction will improve
performance
E. An interface to define how the currency conversion should be processed

A

B. A set of technical tables are required to store currencies and exchange rate types and rates
C. Setting a semantic type to a measure so the amount always includes a currency
E. An interface to define how the currency conversion should be processed

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

If you create an ADSO with Features and Services of a Standard DSO
(Classic), it has the same three tables the Standard DSO (Classic). Determine whether this statement
is true or false.

A

True

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

SAP HANA In-Memory computing is a technology that stores a database
in a computer’s RAM rather than the hard-disk. Determine whether this
statement is true or false.

A

True

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

You create an advanced DataStore object (DSO) and select the standard
DSO template. Which of the following settings are applied automatically?
Note: There are 2 correct answers to this question.
A. Activate data
B. All characteristics are key
C. Unique data records
D. Write change log

A

A. Activate data

D. Write change log

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

Non-cumulative key figures are values calculated according to a
particular period of time and the value is then incremented or
decremented based on an inflow or outflow. Determine whether this
statement is true or false.

A

True

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

Storing raw data in PSA data packages is recommended when the data will update multiple
data targets or when the amount of data being extracted is large. Determine whether this statement
is true or false.

A

True

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

Which of the following statements regarding key figure structures are
correct?
A. To create a key figure structure, right-click on the key figure to open its context menu and choose
Create Structure.
B. Formulas can only be defined within key figure structures.
C. You can only use one key figure structure in a query.
D. Each component of a key figure structure must contain a key figure.

A

C. You can only use one key figure structure in a query.

D. Each component of a key figure structure must contain a key figure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q 
Which of the following are query read modes for SAP BW queries?
A. Query to read all data at once.
B. Query to read data on refresh.
C. Query to read only aggregated data.
D. Query to read data during navigation.
A

A. Query to read all data at once.

D. Query to read data during navigation.

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

Calculated columns can be created as calculation views,
attribute views or as an analytic view. Determine Whether
this statement is true or false.

A

True

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

Which of these reporting tools can you use to visualize the results of a BW query?
A. SAP Crystal Reports for Enterprise
B. Data Warehousing Workbench
C. SAP BusinessObjects Bl Platform
D. SAP BusinessObjects Analysis, edition for Microsoft Office

A

A. SAP Crystal Reports for Enterprise

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

The Column Store is one of the four main concepts of
the SAP HANA database. Determine whether this
statement is true or false.

A

True

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

What are some functions of the query monitor?
A. Test and check for BW queries.
B. Regenerate BW queries.
C. Change BW query definitions.
D. Check and monitor performance.
E. Change performance-relevant BW query properties.
F. View technical information about BW queries.
G. Delete BW queries.

A

A. Test and check for BW queries.
B. Regenerate BW queries.
D. Check and monitor performance.
E. Change performance-relevant BW query properties.
F. View technical information about BW queries.

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

What do you have to consider when working with variables?
A. You cannot use hierarchy variables in combination with hierarchy node variables.
B. Text variables must be with mandatory input.
C. In order to display the lower and upper limit of an interval you need two different text variables.
D. In order to be able to use the same dynamic selection twice in one query without entering the
values twice, you use the same variable twice in the query.

A

C. In order to display the lower and upper limit of an interval you need two different text variables.
D. In order to be able to use the same dynamic selection twice in one query without entering the
values twice, you use the same variable twice in the query.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q 
Modeling with SAP HANA, you can use a virtual table in a view. Which of the following are
advantages of this virtual data model?
A. Fewer objects are needed
B. The model is highly flexible
C. The data footprint is reduced
D. Data is only replicated once
E. The data is always up to date
A

A. Fewer objects are needed
C. The data footprint is reduced
D. Data is only replicated once

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

Which of the following statements regarding Advanced DataStore Objects
(ADSOs) are correct?
A. The keys of an ADSO can be a mixture of lnfoObjects and fields.
B. Non-cumulative key figures cannot be included in ADSOs.
C. ADSOs can have up to 120 key fields.
D. A direct update ADSO does not have an Inbound Table or a Change Log.
E. ADSOs cannot be used as a source in a transformation for another ADSO.

A

A. The keys of an ADSO can be a mixture of lnfoObjects and fields.
C. ADSOs can have up to 120 key fields.
D. A direct update ADSO does not have an Inbound Table or a Change Log.

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

Open ODS Views enable you to define SAP BW data models for objects like database tables,
database views or BW DataSources (for direct access).Determine Whether this statement is true or
false.

A

False

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

Match each object with its description. Match the item in the first column to the
corresponding item in the second column. LEFT -> lnfo Object Characteristic lnfo Object Key figure
InfoProvider RIGHT ->
A. Key figures, characteristics, time characteristics, units, and technical characteristics.
B. Provides information about its associated key figures.
C. Stores amounts or quantities.
D. Consists of lnfoObjects and is the basis for BW queries.

A

A. Key figures, characteristics, time characteristics, units, and technical characteristics.
B. Provides information about its associated key figures.
C. Stores amounts or quantities.
D. Consists of lnfoObjects and is the basis for BW queries.

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

Currency translation types are control how exchange rate calculations are performed when data is either loaded in to
BW once a query is executed. Determine whether this
statement is true or false.

A

True

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

Based on BW 7.5, which of the following should be considered when modeling master data
and transaction data?
A. If master data does not need to replicated, an Open ODS View for texts and attributes could be
used.
B. If transaction data should be stored, an Advanced Data Store Object (ADSO) should be used.
C. To load transaction data efficiently, an Open ODS View of type facts should be used.
D. Replicate the data into a classic InfoCube
E. If master data is to be persisted, then characteristics should be used

A

A. If master data does not need to replicated, an Open ODS View for texts and attributes could be
used.
B. If transaction data should be stored, an Advanced Data Store Object (ADSO) should be used.
C. To load transaction data efficiently, an Open ODS View of type facts should be used.
E. If master data is to be persisted, then characteristics should be used

61
Q

Before you can delete a variable in the BW Query Designer or in the transaction RSZDELETE,
you must find all places where this object is used and remove it from there first. Determine Whether
this statement is true or false.

A

True

62
Q

Unlike the classic star schema where facts are stored in the
fact table, in SAP HANA, multiple views may be used to
represent the central fact view in a virtual data model.
Determine Whether this statement is true or false.

A

False

63
Q

Which of the following are golden rules for modelers using SAP HANA?
Choose the correct answers.
A. Save less important data outside of memory
B. Use column stores for analytical tasks
C. Virtual data sources should use SAP HANA as the database
D. Be economical and re-use SAP HANA Views when possible
E. Modularize the data model and maximize performance using parallelization

A

B. Use column stores for analytical tasks

64
Q

Where do you define the sender/receiver assignment for a jump target?
Choose the correct answer.
A. In the SW Query Designer Properties pane.
B. In SAP BW, using transaction RSBBS.
C. In the context menu of a report cell in Analysis.
D. In the InfoProvider properties both of the sender and the receiver query.

A

A. In the SW Query Designer Properties pane.

65
Q

Which of the following are true regarding the PSA?
A. PSA tables are created per DataSource and source system.
B. PSA tables store data that has been transformed during extraction from the source system
C. PSA tables are transparent database tables
D. BW queries read detailed data from PSA tables
E. Every data load creates a new request in the PSA table

A

A. PSA tables are created per DataSource and source system.
C. PSA tables are transparent database tables
E. Every data load creates a new request in the PSA table

66
Q

How can you implement an ascending sorting by key figure values?
A. Use a Bottom…. condition.
B. Use a Top…. condition.
C. Use the sorting property for the key figure.

A

C. Use the sorting property for the key figure.

67
Q

Which of the following statements regarding filters are true?
A. Filter values in the Filter: Fixed Values section affect the whole query and can be overwritten via
navigation in the executed report.
B. A reusable filter can contain fixed values and default values.
C. Filter values in the Filter: Default Values section affect the whole query and can be overwritten via
navigation in the executed report.
D. Filter values in the Filter: Fixed Values section affect the whole query and can be narrowed via
navigation in the executed report.

A

B. A reusable filter can contain fixed values and default values.
C. Filter values in the Filter: Default Values section affect the whole query and can be overwritten via
navigation in the executed report.
D. Filter values in the Filter: Fixed Values section affect the whole query and can be narrowed via
navigation in the executed report.

68
Q 
Which of the following are jump targets within the RRI?
A. BW query
B. Analysis workbook
C .Transaction in SAP source system
D .Web address
A

A. BW query

B. Analysis workbook

69
Q

Exception aggregation has no effect on the saving of data
in the fact table because it is only effective for reporting.
Determine whether this statement is true or false.
A. True
B. False

A

True

70
Q

Time-dependent and time independent attributes
are stored in the same ‘X’ table which uses ‘Date From’
and ‘Date To’ as key fields. Determine Whether this
statement is true or false.

A

False

71
Q

Modelers use the Advanced DataStoreObject for modeling
the persistence of new scenarios in SAP BW HANA.
Determine whether this statement is true or false.

A

False

72
Q

Operational Data Provisioning provides a technical infrastructure that
supports operational analytics and near line storage (NLS) archiving.
Determine whether this statement is true or false.

A

False

73
Q

A characteristic value variable for the characteristic OCALQUARTER that shows the current
quarter, will show the same quarter of the last year if you enter an offset of -12.
Determine whether this statement is true or false.

A

False

74
Q

What happens if no value is chosen for the hierarchy variable in the variable prompt?
A. The characteristic is removed from the drilldown.
B. An error occurs if the variable is one for mandatory input.
C. The characteristic values are displayed as flat presentation.
D. The system automatically chooses the first hierarchy according to the technical name.
E. No data atall is displayed.

A

B. An error occurs if the variable is one for mandatory input.
C. The characteristic values are displayed as flat presentation.

75
Q

A condition is technically a filter that is applied to key figure values. Determine whether this
statement is true or false.

A

True

76
Q 
Which of the following sources are supported for Open ODS
Views?
A. Advanced Data Store Objects
B. SAP Replication servers
C. Transformations
D. DataSources in BW
E. BW SAP HANA database tables and views
A

A. Advanced Data Store Objects
C. Transformations
D. DataSources in BW
E. BW SAP HANA database tables and views

77
Q

The main goal of data warehousing is to store all relevant
enterprise data in a consistent, harmonized and valid state in
one system and make it available for reporting. Determine
Whether this statement is true or false ?

A

True

78
Q

Open ODS Views are the new object for virtual
access of external sources. Determine Whether this
statement is true or false.

A

True

79
Q

In Data Provisioning, files can only be imported into
the Workbench with the import wizard. Determine
whether this statement is true or false.

A

False

80
Q

Data Models in BW can be made available in SAP HANA using
the manual pull mechanism or automatically using the push function
which is set in the BW InfoProvider properties. Determine Whether
this statement is true or false.

A

True

81
Q 
An external SAP HANA view can be generated for which of the following object types?
A. CompositeProvider
B. Query
C. DataStore
D. Data Type
A

A. CompositeProvider
B. Query
C. DataStore

82
Q

The SAP BW architecture is made up of the extraction layer, the data layer, and the reporting
layer.
Determine
whether this statement is true or false.

A

True

83
Q

Which of the following statements regarding row and column hierarchies are correct?
Choose the correct answers.
A. Characteristics and display attributes can be included in the hierarchical display.
B. Characteristics and navigation attributes can be included in the hierarchical display.
C. Structures can be included in the hierarchical display.
D. Characteristics with an assigned external hierarchy can be included in the hierarchical display.
E. Hierarchical display can be chosen either for the rows or for the columns.

A

B. Characteristics and navigation attributes can be included in the hierarchical display.
C. Structures can be included in the hierarchical display.
D. Characteristics with an assigned external hierarchy can be included in the hierarchical display.

84
Q

How can you navigate in SAP BusinessObjects Analysis, edition for Microsoft Excel?
Choose the correct answers.
A. Use drag and drop within the crosstab.
B. Use drag and drop between the design panel and the crosstab.
C. Use drag and drop within the design panel.
D. Use double-click.
E. Use the context menu.
F. Use the standard Excel menu functions and icons.
G. Use the Analysis menu functions and icons.

A

A. Use drag and drop within the crosstab.
B. Use drag and drop between the design panel and the crosstab.
C. Use drag and drop within the design panel.
E. Use the context menu.
G. Use the Analysis menu functions and icons.

85
Q

CompositeProviders are the new object to define
joins/unions on existing persistent data models.
Determine whether this statement is true or false.

A

True

86
Q

The concept of storage separation in SAP HANA means that delta data is stored on disk to
minimize the demand on main memory.
Determine whether this statement is true or false.

A

True

87
Q 
Which technology do you use to load data from Microsoft Analysis Services to SAP Business
Warehouse?
A. Web service
B. Universal Data Connect
C. Database Connect
D. File interface
A

B. Universal Data Connect

88
Q

A process chain is a sequence of processes that are
scheduled to wait in the background for an event.
Determine whether this statement is true or false.

A

True

89
Q

The SAP HANA studio is developed in Java and is
based on the Eclipse platform? Determine whether this
statement is true or false.

A

True

90
Q

The SAP BusinessObjects Business Intelligence solution consists of
different client tools for specific use cases and the SAP BusinessObjects Bl platform server that
provides functionality including a central repository, user management, security, and reports
scheduling. Determine Whether this statement is true or false.

A

True

91
Q

Which one of the following are percentage functions that
are available as an operator in BW Query Designer?
A. Percentage Share of Result
B. Percentage Share of Overall Result
C. Percentage Share of Report Result
D. Percentage Share of lnfoProvider Result

A

A. Percentage Share of Result
B. Percentage Share of Overall Result
C. Percentage Share of Report Result

92
Q 
On which of the following objects can you restrict a
characteristic?
A. Formula
B. Exception
C. Condition
D. Hierarchy node
A

D. Hierarchy node

93
Q 
Name the missing field: DataSource->Transformation->\_\_\_\_\_\_\_\_\_\_->Transformation-
>InfoProvider .
A. Calculation schema
B. InfoObject
C. InfoSource
D. InfoCube
A

C. InfoSource

94
Q

Which of the following are Best Practice options for storing data in a BW system running on
SAP HANA?
A. Store the bulk of the data on disk for retrieval when required (warm data)
B. Store the most relevant data in a compressed column store (hot data)
C. Split the most relevant data by date and store between an uncompressed column store and tables
stored on disk (warm data)
D. Store all data in compressed column stores to maximize performance (hot data)
E. Move less important data into an external storage system (cool data)

A

A. Store the bulk of the data on disk for retrieval when required (warm data)
D. Store all data in compressed column stores to maximize performance (hot data)

95
Q

BW on SAP HANA differs from BW running on other databases in the following ways.
A. Query performance increases
B. Load performance decreases
C. The number of data persistency layers increases
D. Flexible combination of BW data model with SAP HANA native data model
E. Activation time for DataStore Objects data decreases

A

A. Query performance increases
D. Flexible combination of BW data model with SAP HANA native data model
E. Activation time for DataStore Objects data decreases

96
Q

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

A

False

97
Q

An authorization object provides up to 10 fields in which the authorized values have to be
inserted.
Determine Whether this statement is true or false.

A

True

98
Q

Key figures like headcount and account balances are
noncumulative with respect to time. Determine whether
this statement is true or false.

A

True

99
Q

As part of currency translation, a quantity conversion type
can be defined to convert the quantity of a currency into the
new currency. Determine whether this statement is true or
false.

A

False

100
Q

Data model definition is an activity carried out in the
realization phase of a BW Project. Determine Whether this
statement is true or false.

A

False

101
Q

In the Graphical Data Flow tool, data flow objects
are assigned to InfoAreas. Determine whether this
statement is true or false.

A

True

102
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. Design the data layer concept based on the LSA++ architecture.
B. Create functional and technical documentation.
C. Define a service level agreement.
D. Build SAP HANA views and define their properties.
E. Create and activate SAP BW objects.

A

B. Create functional and technical documentation.
D. Build SAP HANA views and define their properties.
E. Create and activate SAP BW objects.

103
Q 
Which one of these values does a boolean operator deliver
in a BW query formula when it is true?
A. 0
B. 1
C. True
D. Then
A

B. 1

104
Q

Using BW on HANA, modeling can be based on ‘function before
integration’ especially if the model is using fields together with
InfoObjects. Determine Whether this statement is true or false.

A

True

105
Q

When you make changes to an lnfoProvider level filter, it
affects all queries in which this filter is re-used. Determine
Whether this statement is true or false.

A

True

106
Q

Business Content available for SAP BW on SAP HANAuses the LSA++ design concept with a
DataSource, a Corporate Memory, and a persistent propagator ADSO.
Determine Whether this statement is true or false.

A

True

107
Q

Which of the following can you do in the BW Query Designer Cell Editor?
A. Use a cell as a reference cell so that it can be referenced in calculations.
B. Define help cells that contain comments for formulas in the report.
C. Apply cell formulas or selection conditions to any cell in your Analysis report.
D. Define formulas and selection conditions for cells to override the automatically created cell values

A

A. Use a cell as a reference cell so that it can be referenced in calculations.
D. Define formulas and selection conditions for cells to override the automatically created cell values

108
Q

In the BW query execution mode 6, all OLAP/calculation operations are pushed down to SAP
HANA.
Determine whether this statement is true or false.

A

True

109
Q

The EDW Core Layer includes all layers that contain
consolidated and harmonized dat
a. Determine Whether
this statement is true or false.

A

True

110
Q

In SAP BW 7.x, the PSA is optional. Determine

whether this statement is true or false.

A

True

111
Q

In developing a logical data model, SAP Best Practice is to build the model using a top-down,
key figure approach or a bottom-up DataSource approach. Determine Whether this statement is true
or false.

A

True

112
Q

For which of the following scenarios can conditions be used?
Choose the correct answers.
A. Filter for business partner numbers beginning with “1”.
B. Filter for business partners located in Germany.
C. Filter for business partners for which the number of the open order
items is greater than 100.
D. Filter for business partners which contribute to the upper 75 % of
sales revenue.

A

A. Filter for business partner numbers beginning with “1”.

113
Q

You need to create a report that shows non-selling materials. With which option in BW
Query Designer can you display characteristic values without transaction data in the report?
A. Change the access type for Result Values to Posted Values.
B. Change the access type for Result Values to Master Data.
C. Choose Always for the setting Show Result Rows.
D. Set the document link for master data in the query properties.
E. Choose Values in Master Data Table for the Filter Value Selection.

A

B. Change the access type for Result Values to Master Data.

114
Q

InfoObjects contain the technical and business information
for master data and transaction data within BW. Determine
whether this statement is true or false.

A

True

115
Q

The integration layer is one of the three layers of
SAP BW. Determine whether this statement is true
or false.

A

False

116
Q 
Which sources are available for a generic SAP Business Warehouse
DataSource?
Note: There are 3 correct answers to this question.
A. SAP HANA information view
B. Function module
C. SAP HANA remote source table
D. DB view or table
E. SAP query (Info Set)
A

B. Function module
D. DB view or table
E. SAP query (Info Set)

117
Q

In a productive landscape, SAP Best Practice is to have at least a development system, a
quality assurance system and a productive system.
Determine whether this statement is true or false.

A

True

118
Q

Which of the following statements regarding the main differences between Analysis views
and Analysis workbooks are correct?
A. An Analysis view contains one analysis (data source) while an Analysis workbook can contain
several analyses (data sources).
B. An Analysis view contains the navigation state of the data source, but a workbook contains the
design elements in Excel as well as the navigation state of the data sources.
C. An Analysis view contains data while an Analysis workbook does not.

A

A. An Analysis view contains one analysis (data source) while an Analysis workbook can contain
several analyses (data sources).
B. An Analysis view contains the navigation state of the data source, but a workbook contains the
design elements in Excel as well as the navigation state of the data sources.

119
Q

Which of the following statements regarding lnfoProvider level calculated key figures are
correct?
A. You can include formula variables.
B. You can include basic key figures. restricted key figures. and calculated key figures that have been
defined at the query level.
C. You must drag the calculated key figure to the section where it should be used in your query.
D. You can include basic key figures, restricted key figures, and calculated key figures that have been
defined at the lnfoProvider level.
E. When you make changes to an lnfoProvider level calculated key figure, it affects all queries in
which it is re-used

A

A. You can include formula variables.
C. You must drag the calculated key figure to the section where it should be used in your query.
D. You can include basic key figures, restricted key figures, and calculated key figures that have been
defined at the lnfoProvider level.
E. When you make changes to an lnfoProvider level calculated key figure, it affects all queries in
which it is re-used

120
Q

By default, the formula that was created first will be used when there is a formula collision.
Determine whether this statement is true or false.

A

False

121
Q

In the Modeling function area of the Data Warehousing
Workbench, you can create and maintain lnfoObjects, lnfo
Providers, and data flow objects. Determine whether this
statement is true or false.

A

True

122
Q

Which of the following are ways in which joins can be made using SAP
BW on SAP HANA?
A. A BW lnfoSet can be used to create a temporal join
B. A native SAP HANA calculation view can perform inner and outerjoins
C. An Advanced DSO can create joins between master data and transaction data
D. BW Composite Provider can provide inner and outer joins
E. Transformations can perform joins of multiple DataSources

A

A. A BW lnfoSet can be used to create a temporal join
B. A native SAP HANA calculation view can perform inner and outerjoins
C. An Advanced DSO can create joins between master data and transaction data
D. BW Composite Provider can provide inner and outer joins

123
Q

If you create a key figure object of type Amount
or Quantity, you must assign a Currency or
Quantity unit to the key figure. Determine whether
this statement is true or false.

A

True

124
Q

Which of the following statements regarding variables are correct?
A. SAP Exit is a variable processing type that is only available in SAP Bl Content variables.
B. The only processing type for SAP Bl content variables is SAP Exit.
C. Characteristic value variables can be used in all queries where the characteristic is used.
D. A hierarchy variable can get only one single value.
E. Variables always must get values so that the query can be executed.

A

A. SAP Exit is a variable processing type that is only available in SAP Bl Content variables.
C. Characteristic value variables can be used in all queries where the characteristic is used.
D. A hierarchy variable can get only one single value.

125
Q

You use the key figure Sales Order Amount in the Columns
section of a BW query and restrict it to the months January and
February 2016. How many columns will be displayed in the report?
A. One column with Sales Order Amount January and February 2016.
B. Two columns, one for Sales Order Amount January 2016 and one for
Sales Order Amount February 2016.

A

A. One column with Sales Order Amount January and February 2016.

126
Q

Which one of the following statements regarding external hierarchies are correct?
A. An external hierarchy belongs to exactly one characteristic.
B. A characteristic can only possess one external hierarchy.
C. An external hierarchy cannot be created and maintained in BW.
D. An external hierarchy represents master data which is not part of the InfoProvider on which the
query is based.
E. External hierarchies can be loaded from source systems.

A

A. An external hierarchy belongs to exactly one characteristic.
D. An external hierarchy represents master data which is not part of the InfoProvider on which the
query is based.
E. External hierarchies can be loaded from source systems.

127
Q 
From which of the following sources can SAP BW
extract data?
A. csv file
B. Microsoft Word file
C. Relational database system
D. SAP ERP system
A

A. csv file
C. Relational database system
D. SAP ERP system

128
Q

In the SAP BW data model, master data is stored
separately in attribute, text and hierarchy tables that are
linked together using surrogate ID (SID). Determine Whether
this statement is true or false.

A

True

129
Q

Which of the following are the correct terminology about hierarchies?
Choose the correct answers.
A. An entity in a hierarchy is called a node
B. Nodes that have no parents are called orphan nodes
C. Nodes that have no children nodes are called leaf nodes or leaves
D. A relationship between a node and its parent node is called a family tree
E. A hierarchy with leaves on different levels is an unbalanced hierarchy

A

B. Nodes that have no parents are called orphan nodes

130
Q

Using the RRI, you can jump from a report to another report or to a different destination, as
long as it is Within the SAP BW system.
Determine whether this statement is true or false.

A

True

131
Q

Which of the following statements about SAP HANA are true?
A. Data is retrieved in response to structured queries through disk access.
B. Data is retrieved in response to structured queries through main memory access.
C. HANA enables SAP to deliver in-memory applications that were previously impossible.
D. HANA uses a traditional, three-tier architecture of data, application, and presentation layers.

A

B. Data is retrieved in response to structured queries through main memory access.
C. HANA enables SAP to deliver in-memory applications that were previously impossible.

132
Q

You have created a condition that should show the customers for Top 10 Sales Revenue.
You can activate the condition in Analysis but do not see a result. What is the reason?
A. Conditions are not supported in Analysis.
B. You must reset the query in Analysis.
C. You must add the customer characteristic to the drill-down.

A

B. You must reset the query in Analysis.

133
Q 
In which sections of the query can key figures be inserted?
A. Filter: Default Value
B. Free
C. Rows
D. Columns
A

C. Rows

D. Columns

134
Q

The goal of implementing SAP Business Warehouse is to
move the reporting burden from the ERP system? Determine
whether this statement is true or false.

A

True

135
Q

If a global element of a query is changed in BW, these
changes are automatically passed to the SAP HANA
calculation view that was created from the BW query.
Determine Whether this statement is true or false.

A

False

136
Q

To model the tracking history scenarios of historical truth
and current truth, two different star schemas are required.
Determine whether this statement is true or false.

A

False

137
Q

Which of the following statements are true about InfoProviders?
A. They can be physical objects or logical views that are relevant for reporting
B. They are required if you want to permanently store data and report on it
C. They are objects for which queries can be created or executed
D. An InfoCube is an InfoProvider that stores data at a detailed level
E. They can only store data from a single source system

A

A. They can be physical objects or logical views that are relevant for reporting
B. They are required if you want to permanently store data and report on it
C. They are objects for which queries can be created or executed

138
Q

When you apply a navigation filter to a restricted key
figure, the restricted key figure remains the same in the
result. Determine whether this statement is true or false.

A

False

139
Q 
Which of the following are InfoProviders?
A. Persistent Staging Areas
B. InfoCubes
C. DataStore Objects
D. Advanced InfoCube Object
E. MultiProviders
A

B. InfoCubes
C. DataStore Objects
E. MultiProviders

140
Q

An exception can only be applied to a single key figure in a query. Determine Whether this
statement is true or false.

A

False

141
Q

How can you restrict a characteristic with an external hierarchy in a query?
A. Use one or multiple hierarchy nodes.
B. Use one or multiple characteristic values (leaves of the
hierarchy).
C. Use combinations of hierarchy nodes and characteristic values.

A

A. Use one or multiple hierarchy nodes.
B. Use one or multiple characteristic values (leaves of the
hierarchy).
C. Use combinations of hierarchy nodes and characteristic values.

142
Q

Which of the following are advantages of separating master data and transactional data?
A. Referential integrity of transaction data can be assured because records without matching master
data will not be loaded
B. Time-dependent data can be modeled simply
C. Harmonization of master data with multiple source systems can be achieved with system- specific
master data tables
D. Texts can be stored in multiple languages
E. Storage costs are reduced because data is only stored once

A

B. Time-dependent data can be modeled simply

143
Q

The Data Warehousing Workbench is used to create and
maintain modeling objects relevant to the data staging processes of
BW. Determine whether this statement is true or false.

A

True

144
Q

Open ODS Views allow for data to be consumed virtually without BW persistence because
the data model is an SAP HANA schema which is not managed by BW. Determine Whether this
statement is true or false.\

A

True

145
Q

What do you have to consider when you create a query with multiple structures?
A. You must use a maximum of two structures.
B. You must use one structure in the report columns and one structure the report rows.
C. You can only use one structure without key figures in a query.
D. By using both the structures in the rows or in the columns you can avoid formula collision.
E. You can only use one structure with key figures in a query.

A

A. You must use a maximum of two structures.

E. You can only use one structure with key figures in a query.

146
Q

Users who execute queries need authorizations in the authorization objects S_RS_COMP
and S_RS_COMP1.
Determine Whether this statement is true or false.

A

True

147
Q

Users create reports for customers and their sales volumes. Sometimes, they need to drill
down to the material level to analyze what exactly customers have bought. With which query layout
can you optimize the query performance?
A. Customer and material in the rows
B. Customer and material in the free characteristics
C. Customer in the rows and material in the free characteristics
D. Material in the rows and customer in the free characteristics
E. Customer and material in the rows with rows hierarchy expanded initially to customer

A

B. Customer and material in the free characteristics

148
Q 
Variables may be used as placeholders for which of the following values?
A. Characteristic values
B. Structures
C. Hierarchy nodes
D. Formula elements
A

A. Characteristic values
C. Hierarchy nodes
D. Formula elements

149
Q

SAP BW IP Direct Update vs Planning Mode

A

But first we have to understand the general structure of aDSOs. While the Advanced DataStore object appears as a flat table, there are three important tables in the background. In addition, views for extraction and reporting are automatically created. An aDSO thus always consists of five tables. However, depending on the settings and the aDSO type, some tables are not used.

The three most important tables are the inbound table, the active data table and the change log table. In the inbound table, all data records are stored with a technical key. This corresponds to the activation queue for the classic DSOs and is comparable to the uncompressed fact table of an InfoCube. In planning scenario, this table contains the delta records before the requests are activated.

In addition, the system generates a table for the active data (Active Data). This tables contains, just like in the classic DSO, current values after activation. The key defined in the DSO is used as the key of the table. It is similar to the compressed fact table of an InfoCube.

Planning Tools compared - SAP BW IP vs. BPC vs. SAC
Neuer Call-to-Action
The third table, the Change Log, is the same as in classic DSO. This table stores the differences between the inbound table and the active data table. The change log is needed for delta creation. However, in the planning environment this table is negligible.

While an aDSO with the Planning on InfoCube-like setting has an inbound and an active table, the data for an aDSO set to Planning on Direct Update is written directly into the active table.

Planning on Direct Update

And while all characteristics are defined as keys in an InfoCube-like aDSO, the keys must be defined manually in a direct update aDSO.

All characteristics are key

Please bear in mind that all fields, which are not marked as keys, will be overwritten. This feature makes aDSOs suitable for immediate updating, especially for storing comments where characteristics are used as key figures.

Use characteristic as key figure

Since the direct update aDSO, unlike InfoCube-like aDSO, only has an active table, it is not possible to delete individual requests. However, this feature makes it possible to write data directly to the active table via an API.

It should be also mentioned, that it is now possible to load data via a data transfer process (DTP) to direct update aDSOs. This was not possible with a classic DSO for direct update. However, only the setting Overwrite is available. The summation of key figures in the transformation is therefore not possible.

If you want to use measures with the aggregation behaviour NO2 (no aggregation), there is no way around direct update aDSOs. For example, when implementing price planning scenarios or setting active / inactive flags. When modelling with these key figures, you must use this aDSO type. It is not possible to use InfoCube-like aDSOs.

SAP BW4/HANA (1 decks)

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