BW4HANA14 Flashcards
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
D. Overwrite
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. 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.
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
B. Average
E. Counter
F. Last Value
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
B. False
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.
True
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. 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.
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. 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.
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. Direct Extractor Connection (DHC)
B. SAP Data Services
C. SAP Landscape Transformation Replication Server
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. 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
SAP HANA provides a choice of row or column storage types. Determine whether this
statement is true or false.
True
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.
True
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. 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.
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.
True
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
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 can text variables be processed? Choose the correct answers. A. Manual Entry B. Replacement Path C. Authorization D. Customer Exit
A. Manual Entry
B. Replacement Path
D. Customer Exit
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.
True
Temporal conditions can be defined on columns of the
following data types: timestamp, date, and text. Determine
Whether this statement is true or false.
True
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.
D. Change the attribute type from Display to Navigation in the lnfoObject maintenance.
E. Activate the navigation attribute in the respective InfoProvider.
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. 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.
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.
False
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.
True
Using the Remodeling Toolbox, lnfoObjects can be changed
without having to delete or reload master data. Determine Whether
this statement is true or false.
True
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.
True
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.
False
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. Components
B. information
E. Analysis
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. Data transfer process
D. Transformation
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)
B. Consume external data without staging
D. Combine external data with BW models
E. Physical integration of external data (staging)
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.
True
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
B. Report Type
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. 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
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
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
Which of the following are InfoObjects? A. Characteristics InfoObjects B. Key Figures InfoObjects C. Transformation InfoObjects D. Time Characteristic InfoObjects
A. Characteristics InfoObjects
B. Key Figures InfoObjects
D. Time Characteristic InfoObjects
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. Crosstab
C. Navigation panel
E. Chart
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. Elimination of materialized aggregates
B. Higher data compression rates
D. Elimination of additional indexes
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.
B. Apply the SAP Business Warehouse workspace layer.
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.
True
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.
B. As operands in formulas that are retrieved via replacement path.
C. As threshold values in exceptions and conditions.
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.
True
You can sort the members of an external hierarchy in ascending or descending order.
Determine whether this statement is true or false.
True
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. Use the transaction RSZDELETE.
C. Use the BW Query Designer.
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.
True
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
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
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.
True
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.
True
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. Activate data
D. Write change log
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.
True
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.
True
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.
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.
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. Query to read all data at once.
D. Query to read data during navigation.
Calculated columns can be created as calculation views,
attribute views or as an analytic view. Determine Whether
this statement is true or false.
True
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. SAP Crystal Reports for Enterprise
The Column Store is one of the four main concepts of
the SAP HANA database. Determine whether this
statement is true or false.
True
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. 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.
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.
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.
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. Fewer objects are needed
C. The data footprint is reduced
D. Data is only replicated once
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. 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.
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.
False
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. 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.
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.
True
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. 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
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.
True
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.
False
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
B. Use column stores for analytical tasks
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. In the SW Query Designer Properties pane.
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. 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
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.
C. Use the sorting property for the key figure.
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.
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.
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. BW query
B. Analysis workbook
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
True
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.
False
Modelers use the Advanced DataStoreObject for modeling
the persistence of new scenarios in SAP BW HANA.
Determine whether this statement is true or false.
False
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.
False
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.
False
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.
B. An error occurs if the variable is one for mandatory input.
C. The characteristic values are displayed as flat presentation.
A condition is technically a filter that is applied to key figure values. Determine whether this
statement is true or false.
True
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. Advanced Data Store Objects
C. Transformations
D. DataSources in BW
E. BW SAP HANA database tables and views
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 ?
True
Open ODS Views are the new object for virtual
access of external sources. Determine Whether this
statement is true or false.
True
In Data Provisioning, files can only be imported into
the Workbench with the import wizard. Determine
whether this statement is true or false.
False
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.
True
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. CompositeProvider
B. Query
C. DataStore
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.
True
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.
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.
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. 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.
CompositeProviders are the new object to define
joins/unions on existing persistent data models.
Determine whether this statement is true or false.
True
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.
True
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
B. Universal Data Connect
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.
True
The SAP HANA studio is developed in Java and is
based on the Eclipse platform? Determine whether this
statement is true or false.
True
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.
True
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. Percentage Share of Result
B. Percentage Share of Overall Result
C. Percentage Share of Report Result
On which of the following objects can you restrict a characteristic? A. Formula B. Exception C. Condition D. Hierarchy node
D. Hierarchy node
Name the missing field: DataSource->Transformation->\_\_\_\_\_\_\_\_\_\_->Transformation- >InfoProvider . A. Calculation schema B. InfoObject C. InfoSource D. InfoCube
C. InfoSource
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. 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)
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. Query performance increases
D. Flexible combination of BW data model with SAP HANA native data model
E. Activation time for DataStore Objects data decreases
The InfoCube stores transaction data on a
detailed level. Determine whether this
statement is true or false.
False
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.
True
Key figures like headcount and account balances are
noncumulative with respect to time. Determine whether
this statement is true or false.
True
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.
False
Data model definition is an activity carried out in the
realization phase of a BW Project. Determine Whether this
statement is true or false.
False
In the Graphical Data Flow tool, data flow objects
are assigned to InfoAreas. Determine whether this
statement is true or false.
True
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.
B. Create functional and technical documentation.
D. Build SAP HANA views and define their properties.
E. Create and activate SAP BW objects.
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
B. 1
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.
True
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.
True
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.
True
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. 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
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.
True
The EDW Core Layer includes all layers that contain
consolidated and harmonized dat
a. Determine Whether
this statement is true or false.
True
In SAP BW 7.x, the PSA is optional. Determine
whether this statement is true or false.
True
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.
True
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. Filter for business partner numbers beginning with “1”.
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.
B. Change the access type for Result Values to Master Data.
InfoObjects contain the technical and business information
for master data and transaction data within BW. Determine
whether this statement is true or false.
True
The integration layer is one of the three layers of
SAP BW. Determine whether this statement is true
or false.
False
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)
B. Function module
D. DB view or table
E. SAP query (Info Set)
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.
True
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. 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.
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. 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
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.
False
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.
True
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 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
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.
True
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. 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.
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. One column with Sales Order Amount January and February 2016.
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. 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.
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. csv file
C. Relational database system
D. SAP ERP system
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.
True
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
B. Nodes that have no parents are called orphan nodes
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.
True
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.
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.
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.
B. You must reset the query in Analysis.
In which sections of the query can key figures be inserted? A. Filter: Default Value B. Free C. Rows D. Columns
C. Rows
D. Columns
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.
True
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.
False
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.
False
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. 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
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.
False
Which of the following are InfoProviders? A. Persistent Staging Areas B. InfoCubes C. DataStore Objects D. Advanced InfoCube Object E. MultiProviders
B. InfoCubes
C. DataStore Objects
E. MultiProviders
An exception can only be applied to a single key figure in a query. Determine Whether this
statement is true or false.
False
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. 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.
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
B. Time-dependent data can be modeled simply
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.
True
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.\
True
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. You must use a maximum of two structures.
E. You can only use one structure with key figures in a query.
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.
True
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
B. Customer and material in the free characteristics
Variables may be used as placeholders for which of the following values? A. Characteristic values B. Structures C. Hierarchy nodes D. Formula elements
A. Characteristic values
C. Hierarchy nodes
D. Formula elements
SAP BW IP Direct Update vs Planning Mode
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.
