What do you have to consider when you create a query with multiple structures? There are 2 correct answers to this question. You must use a maximum of two structures. You must use one structure in the report columns and one structure the report rows. You can only use one structure without key figures in a query. By using both the structures in the rows or in the columns you can avoid formula collision. You can only use one structure with key figures in a query.
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. True False.
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. True False.
Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse? Web service Universal Data Connect Database Connect File interface.
Which of the following can you do in the BW Query Designer Cell Editor? There are 2 correct answers to this question.
Note: There are 2 correct answers to this question. Use a cell as a reference cell so that it can be referenced in calculations. Define help cells that contain comments for formulas in the report. Apply cell formulas or selection conditions to any cell in your Analysis report. Define formulas and selection conditions for cells to override the automatically created cell values.
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? Change the access type for Result Values to Posted Values. Change the access type for Result Values to Master Data. Choose Always for the setting Show Result Rows. Set the document link for master data in the query properties. Choose Values in Master Data Table for the Filter Value Selection.
Which two steps do you need to perform to make a display attribute available as a navigation attribute in a query?
There are 2 correct answers to this question. Activate the navigation attribute in the characteristic properties in BW Query Designer. Drag and drop the display attribute to the Free section or the BW Query Designer. Activate the navigation attribute in the SAP BW data flow transformation. Change the attribute type from Display to Navigation in the lnfoObject maintenance. Activate the navigation attribute in the respective InfoProvider.
Which of the following statements regarding row and column hierarchies are correct? Choose the correct answers.
There are 3 correct answers to this question. Characteristics and display attributes can be included in the hierarchical display. Characteristics and navigation attributes can be included in the hierarchical display. Structures can be included in the hierarchical display. Characteristics with an assigned external hierarchy can be included in the hierarchical display. Hierarchical display can be chosen either for the rows or for the columns.
Which of the following statements regarding hierarchical structure display are correct?
There are 2 correct answers to this question. 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. The hierarchical structure display only works for structures with key figures. The number of levels for a hierarchical structure display is limited to 2. You can use the node status to determine whether the node displays collapsed or expanded in the report.
Which one of the following statements regarding external hierarchies are correct?
There are 3 correct answers to this question. An external hierarchy belongs to exactly one characteristic. A characteristic can only possess one external hierarchy. An external hierarchy cannot be created and maintained in BW. An external hierarchy represents master data which is not part of the InfoProvider on which the query is based. External hierarchies can be loaded from source systems.
You can sort the members of an external hierarchy in ascending or descending order. Determine whether this statement is true or false. True False.
How can you restrict a characteristic with an external hierarchy in a query? Use one or multiple hierarchy nodes. Use one or multiple characteristic values (leaves of the hierarchy). Use combinations of hierarchy nodes and characteristic values.
Variables may be used as placeholders for which of the following values? There are 3 correct answers to this question. Characteristic values Structures Hierarchy nodes Formula elements.
How can text variables be processed? Choose the correct answers. There are 3 correct answers to this question. Manual Entry Replacement Path Authorization Customer Exit.
What do you have to consider when working with variables? There are 2 correct answers to this question. You cannot use hierarchy variables in combination with hierarchy node variables. Text variables must be with mandatory input. In order to display the lower and upper limit of an interval you need two different text variables. 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.
Which of the following statements regarding variables are correct? There are 3 correct answers to this question. SAP Exit is a variable processing type that is only available in SAP Bl Content variables. The only processing type for SAP BI content variables is SAP Exit. Characteristic value variables can be used in all queries where the characteristic is used. A hierarchy variable can get only one single value. Variables always must get values so that the query can be executed.
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. True False.
How can you use formula variables? Choose the correct answers.
Note: There are 2 correct answers to this question. As operands for local calculations in reports. As operands in formulas that are retrieved via replacement path. As threshold values in exceptions and conditions. As key values for characteristic restrictions.
What happens if no value is chosen for the hierarchy variable in the variable prompt? There are 2 correct answers to this question.
Note: There are 2 correct answers to this question. The characteristic is removed from the drilldown. An error occurs if the variable is one for mandatory input. The characteristic values are displayed as flat presentation. The system automatically chooses the first hierarchy according to the technical name. No data at all is displayed.
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 False.
An exception can only be applied to a single key figure in a query. Determine Whether this statement is true or false. True False.
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? Conditions are not supported in Analysis. You must reset the query in Analysis. You must add the customer characteristic to the drill-down.
How can you implement an ascending sorting by key figure values? Use a Bottom.... condition. Use a Top.... condition. Use the sorting property for the key figure.
For which of the following scenarios can conditions be used? Choose the correct answers. There are 2 correct answers to this question. Filter for business partner numbers beginning with "1". Filter for business partners located in Germany. Filter for business partners for which the number of the open order items is greater than 100. Filter for business partners which contribute to the upper 75 % of sales revenue.
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 False.
Where do you define the sender/receiver assignment for a jump target? Choose the correct answer. In the SW Query Designer Properties panel. In SAP BW, using transaction RSBBS. In the context menu of a report cell in Analysis. In the InfoProvider properties both of the sender and the receiver query.
Which of these settings must you enter when creating a jump target in the RRI? Choose the correct answers. There are 2 correct answers to this question. Target System Report Type Receiver Variable Goto.
Which of the following are jump targets within the RRI?
There are 3 correct answers to this question. BW query Analysis workbook Transaction in SAP source system Web address.
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 False.
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?
There are 2 correct answers to this question. Customer and material in the rows Customer and material in the free characteristics Customer in the rows and material in the free characteristics Material in the rows and customer in the free characteristics Customer and material in the rows with rows hierarchy expanded initially to customer.
Which objects are mandatory when you create a transactional data flow in operational data provisioning?
Note: There are 2 correct answers to this question.
Data transfer process Real-time daemon Info Package Transformation.
What are some functions of the query monitor? Note: There are 5 correct answers to this question. Test and check for BW queries. Regenerate BW queries. Change BW query definitions. Check and monitor performance. Change performance—relevant BW query properties. View technical information about BW queries. Delete BW queries.
Which of the following are query read modes for SAP BW queries?
Note: There are 2 correct answers to this question. Query to read all data at once. Query to read data on refresh. Query to read only aggregated data. Query to read data during navigation.
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 False.
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 False.
How can you delete queries and query components?
Choose the correct answers. Use the transaction RSZDELETE. Use the Query Monitor (transaction RSRTl). Use the BW Query Designer. Use the Data Warehousing Workbench (t-co RSA1).
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. True 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 False.
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 False.
Which of the following statements regarding analysis authorizations are correct?
Note: There are 3 correct answers to this question. Authorization—relevant characteristics are characteristics for which the data are protected. 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. When a query is executed. all authorization—relevant characteristics that are contained in the InfoProvider on which the query is based on are checked. Using the transaction RSECADMIN, you can create analysis authorizations for a group of authorization relevant characteristics and restrict the values for these characteristics.
Which of these reporting tools can you use to visualize the results of a BW query?
Note: There are 2 correct answers to this question. SAP Crystal Reports for Enterprise Data Warehousing Workbench SAP BusinessObjects BI Platform SAP BusinessObjects Analysis, edition for Microsoft Office.
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 False.
SAP HANA provides a choice of row or column storage types. Determine whether this statement is true or false. True False.
Modeling with SAP HANA, you can use a virtual table in a view. Which of the following are advantages of this virtual data model?
Note: There are 4 correct answers to this question. Fewer objects are needed The model is highly flexible The data footprint is reduced Data is only replicated once The data is always up to date.
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 False.
Which of the following are Best Practice options for storing data in a BW system running on SAP HANA? Store the bulk of the data on disk for retrieval when required (warm data) Store the most relevant data in a compressed column store (hot data) Split the most relevant data by date and store between an uncompressed column store and tables stored on disk (warm data) Split the most relevant data by date and store between an uncompressed column store and tables stored on disk (warm data) Move less important data into an external storage system (cool data).
Which of the following are golden rules for modelers using SAP HANA? Choose the correct answers.
Note: There are 4 correct answers to this question. Save less important data outside of memory Use column stores for analytical tasks Virtual data sources should use SAP HANA as the database Be economical and re-use SAP HANA Views when possible Modularize the data model and maximize performance using parallelization.
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 False.
Based on BW 7.5, which of the following should be considered when modeling master data and transaction data?
Note: There are 4 correct answers to this question. If master data does not need to replicated, an Open ODS View for texts and attributes could be used. If transaction data should be stored, an Advanced Data Store Object (ADSO) should be used. To load transaction data efficiently, an Open ODS View of type facts should be used. Replicate the data into a classic InfoCube If master data is to be persisted, then characteristics should be used.
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 False.
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 False.
Which of the following are advantages of separating master data and transactional data?
Note: There are 3 correct answers to this question. Referential integrity of transaction data can be assured because records without matching master data will not be loaded Time—dependent data can be modeled simply Harmonization of master data with multiple source systems can be achieved with system— specific master data tables Texts can be stored in multiple languages Storage costs are reduced because data is only stored once.
Which of the following statements are true regarding the difference between compounding and concatenation?
Note: There are 4 correct answers to this question. Compounding is easier to filter in queries because the objects are separate whereas with concatenation, the key string needs to be masked 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 Concatenation uses a single key value but compounding uses more than one 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 Compounding is supported in the definition of the lnfoObject whereas concatenation requires thecreation of new database tables.
Which of the following are ways in which joins can be made using SAP BW on SAP HANA?
Note: There are 3 correct answers to this question. A BW lnfoSet can be used to create a temporal join A native SAP HANA calculation view can perform inner and outerjoins An Advanced DSO can create joins between master data and transaction data BW Composite Provider can provide inner and outer joins Transformations can perform joins of multiple DataSources.
Which of the following guidelines should be considered in an enterprise—wide implementation of BW on HANA?
Note: There are 4 correct answers to this question. How will the different data models be incorporate Utilize the LSA++ layers in the design of the EDW Which languages and currencies will need to be considered What will the system and transport landscape be comprised of Which users will be logging onto the system.
Data model definition is an activity carried out in the realization phase of a BW Project.
Determine whether this statement is true or false. True False.
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 False.
Business Content available for SAP BW on SAP HANA uses the LSA++ design concept with a DataSource, a Corporate Memory and a persistent propagator ADSO.
Determine Whether this statement is true or false. True False.
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 False.
Which of the following are the correct terminology about hierarchies? Choose the correct answers.
Note: There are 3 correct answers to this question. An entity in a hierarchy is called a node Nodes that have no parents are called orphan nodes Nodes that have no children nodes are called leaf nodes or leaves A relationship between a node and its parent node is called a family tree A hierarchy with leaves on different levels is an unbalanced hierarchy.
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. True False.
Which of the following is required to perform currency conversion in an SAP HANA information model?
Note: There are 3 correct answers to this question. An inner join is required between the Open ODS View measures and the exchange rate table A set of technical tables are required to store currencies and exchange rate types and rates Setting a semantic type to a measure so the amount always includes a currency Storing the currency and the exchange rate on the day of the transaction will improve performance An interface to define how the currency conversion should be processed.
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 False.
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. True False.
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 False.
Which of the following statements regarding internal and external hierarchies are true? Choose the correct answers.
Note: There are 3 correct answers to this question. Internal hierarchies have no link to master data tables Internal hierarchies are used to display characteristics without using an external hierarchy External hierarchies are defined in Business Explorer Query Designer on the hierarchy tab 'External' hierarchies are defined as external because the data is stored outside of BW on the OLAP server External hierarchies are stored in BW master data tables.
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. True False.
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 False.
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. True False.
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 False.
Which of the following statements regarding Advanced DataStore Objects (ADSOs) are correct?
Note: There are 3 correct answers to this question. The keys of an ADSO can be a mixture of lnfoObjects and fields. Non-cumulative key figures cannot be included in ADSOs. ADSOs can have up to 120 key fields. A direct update ADSO does not have an Inbound Table or a Change Log. ADSOs cannot be used as a source in a transformation for another ADSO.
Which of the following statements describe the advantages of CompositeProviders over the classic MultiProviders/lnfoSets?
Note: There are 3 correct answers to this question. CompositeProviders provide joins and unions with a single object. CompositeProviders can also include joins to classic MultiProviders. CompositeProviders integrate with all the BW lnfoProviders. A CompositeProvider can be consumed by another CompositeProvider. Classic MultiProviders have to be recreated as CompositeProviders.
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. True False.
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 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 False.
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. True False.
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. True False.
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 False.
The EDW Core Layer includes all layers that contain consolidated and harmonized data.
Determine Whether this statement is true or false. True False.
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 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 False.
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 False.
The Column Store is one of the four main concepts of the SAP HANA database.
Determine whether this statement is true or false. True False.
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 False.
The integration layer is one of the three layers of SAP BW.
Determine whether this statement is true or false. True 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. True False.
The InfoCube stores transaction data on a detailed level.
Determine whether this statement is true or false. True False.
InfoObjects contain the technical and business information for master data and transaction data within BW.
Determine whether this statement is true or false. True False.
Which of the following are InfoObjects?
Note: There are 3 correct answers to this question. Characteristics InfoObjects Key Figures InfoObjects Transformation InfoObjects Time Characteristic InfoObjects.
Which of the following are true regarding the PSA?
Note: There are 3 correct answers to this question. PSA tables are created per DataSource and source system. PSA tables store data that has been transformed during extraction from the source system PSA tables are transparent database tables BW queries read detailed data from PSA tables Every data load creates a new request in the PSA Table.
In SAP BW 7.x, the PSA is optional.
Determine whether this statement is true or false. True False.
In the Graphical Data Flow tool, data flow objects are assigned to InfoAreas.
Determine whether this statement is true or false. True False.
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 False.
Which of the following statements are true about InfoProviders?
Note: There are 3 correct answers to this question. They can be physical objects or logical views that are relevant for reporting They are required if you want to permanently store data and report on it They are objects for which queries can be created or executed An InfoCube is an InfoProvider that stores data at a detailed level They can only store data from a single source system.
Which of the following are InfoProviders?
Note: There are 3 correct answers to this question. Persistent Staging Areas InfoCubes DataStore Objects Advanced InfoCube Object MultiProviders.
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 False.
Key figures like headcount and account balances are noncumulative with respect to time.
Determine whether this statement is true or false. True False.
Which of the following statements are true about Advanced DataStore Objects (ADSOs)?
Note: There are 3 correct answers to this question. To improve loading, data can be written directly into the active table They can be used in various layers of the EDW architecture ADSOs can contain a combination of InfoObjects and fields (that are not InfoObjects) They are made up four tables - inbound, active, change and archive Queries read data from the active and inbound tables.
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. True False.
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 False.
CompositeProviders are the new object to define joins/unions on existing persistent data
models.
Determine whether this statement is true or false. True False.
Name the missing field: DataSource→ Transformation → __________→ Transformation → InfoProvider. Calculation schema InfoObject InfoSource InfoCube.
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. True False.
An external SAP HANA view can be generated for which of the following object types?
Note: There are 3 correct answers to this question. Composite Provider Query DataStore Data Type.
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 False.
The SAP HANA studio is developed in Java and is based on the Eclipse platform?
Determine whether this statement is true or false. True False.
In Data Provisioning, files can only be imported into the Workbench with the import wizard.
Determine whether this statement is true or false. True False.
Which of the following are external tools used for Data Provisioning?
Note: There are 3 correct answers to this question. Direct Extractor Connection (DHC) SAP Data Services SAP Landscape Transformation Replication Server Near Line Storage Enterprise Information Management.
Calculated columns can be created as calculation views, attribute views or as an analytic view.
Determine Whether this statement is true or false. True False.
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 False.
Open ODS Views are the new object for virtual access of external sources.
Determine Whether this statement is true or false. True False.
Which of the following is possible when using Open ODS Views?
Note: There are 3 correct answers to this question. Combine Composite Providers with lnfoObjects Consume external data without staging Extend the HANA database table definitions to include fields Combine external data with BW models Physical integration of external data (staging).
Which of the following sources are supported for Open ODS Views?
Note: There are 4 correct answers to this question. Advanced DataStore Objects SAP Replication servers Transformations DataSources in BW BW SAP HANA database tables and views.
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 False.
Which of the following statements about SAP HANA are true?
Note: There are 2 correct answers to this question. Data is retrieved in response to structured queries through disk access. Data is retrieved in response to structured queries through main memory access. HANA enables SAP to deliver in-memory applications that were previously impossible. HANA uses a traditional, three-tier architecture of data, application, and presentation layers.
Which of the following are advantages of column tables?
Note: There are 3 correct answers to this question. Elimination of materialized aggregates Higher data compression rates Elimination of parallel execution Elimination of additional indexes.
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 False.
From which of the following sources can SAP BW extract data?
Note: There are 3 correct answers to this question. csv file Microsoft Word file Relational database system SAP ERPsystem.
In the Modeling function area of the Data Warehousing Workbench, you can create and maintain infoObjects, infoProviders, and data flow objects. Determine whether this statement is true or false. True False.
BW on SAP HANA differs from BW running on other databases in the following ways.
Note: There are 3 correct answers to this question. Query performance increases Load performance decreases The number of data persistency layers increases Flexible combination of BW data model with SAP HANA native data model Activation time for DataStore Objects data decreases.
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 False.
Which tabs do you find in the design panel of SAP Business Objects Analysis, edition for Microsoft Excel? Choose the correct answers.
Note: There are 3 correct answers to this question. Components Information Data Source Workbook Analysis.
How can you navigate in SAP BusinessObjects Analysis, edition for Microsoft Excel?
Choose the correct answers.
Note: There are 5 correct answers to this question. Use drag and drop within the crosstab. Use drag and drop between the design panel and the crosstab. Use drag and drop within the design panel. Use double—click. Use the context menu. Use the standard Excel menu functions and icons. Use the Analysis menu functions and icons.
Which of the following statements regarding the main differences between Analysis views and Analysis workbooks are correct?
Note: There are 2 correct answers to this question. An Analysis view contains one analysis (data source) while an Analysis workbook can contain several analyses (data sources). 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. An Analysis view contains data while an Analysis workbook does not.
In Design Studio Generic Analysis application, for which of the following components is a context menu for navigation available?
Note: There are 3 correct answers to this question. Crosstab Actions button Navigation panel Filter line Chart Information button.
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 False.
When you make changes to an InfoProvider level filter, it affects all queries in which this filter is re—used. Determine whether this statement is true or false. True False.
In which sections of the query can key figures be inserted?
Note: There are 2 correct answers to this question. Filter: Default Value Free Rows Columns.
Which of the following statements regarding filters are true?
Note: There are 3 correct answers to this question. Filter values in the Filter: Fixed Values section affect the whole query and can be overwritten via navigation in the executed report. A reusable filter can contain fixed values and default values. Filter values in the Filter: Default Values section affect the whole query and can be overwritten via navigation in the executed report. 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 statements are true?
Note: There are 2 correct answers to this question. 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. The key date acts as a static temporal filter for the whole query. The key date is a mandatory field in the query definition. The key date determines the temporal validity of the query definition. For the key date you can also use a variable instead of a specific value.
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 False.
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. True False.
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? One column with Sales Order Amount January and February 2016. Two columns, one for Sales Order Amount January 2016 and one for Sales Order Amount February 2016.
Which of the following statements regarding InfoProvider level calculated key figures are correct?
Note: There are 4 correct answers to this question. You can include formula variables. You can include basic key figures. restricted key figures. and calculated key figures that have been defined at the query level. You must drag the calculated key figure to the section where it should be used in your query. You can include basic key figures, restricted key figures, and calculated key figures that have been defined at the lnfoProvider level. When you make changes to an lnfoProvider level calculated key figure, it affects all queries in which it is re—used.
Which one of the following are percentage functions that are available as an operator in BW Query Designer?
Note: There are 3 correct answers to this question. Percentage Share of Result Percentage Share of Overall Result Percentage Share of Report Result Percentage Share of lnfoProvider Result.
Which one of these values does a boolean operator deliver in a BW query formula when it is true? 0 1 True Then.
Which of the following aggregation options must you define as an exception aggregation?
Choose the correct answers.
Note: There are 3 correct answers to this question. Summation Average Minimum Maximum Counter Last Value.
Which of the following statements regarding key figure structures are correct?
Note: There are 2 correct answers to this question. To create a key figure structure, right—click on the key figure to open its context menu and choose Create Structure. Formulas can only be defined within key figure structures. You can only use one key figure structure in a query. Each component of a key figure structure must contain a key figure.
Which of the following settings can you define in a data transfer process (DTP) if you load data into a DataStore object (advanced)?
There are 2 correct answers to this question. Activation handling Parallel Processing Extraction Mode Data tiering.
What are desired outcomes of an SAP BW/4HANA pilot project?
Note: There are 3 correct answers to this question. Confirm increased database size using SAP BW/4HANA instead of a common RDBMS. Identify required changes for the business processes to comply with SAP BW/4HANA standard software. Identify customizing and configuration areas to be applied to future projects. Identify objects from SAP BI content and/or SAP HANA live that will be leveraged in subsequent projects. Transfer experience of the pilot project to future projects.
For which table type does SAP HANA compress data? Please choose the correct answer. Row store table Virtual table Cluster table Column store table.
Which functionality does the SAP Landscape Transformation Replication Server support?
Please choose the correct answer. Integrated interface for SAP HANA streaming analytics Real-time scenarios using log-based replication functionality Automatic conversion from non-Unicode to Unicode during data load or replication Data replication to SAP HANA, other RDBMSs, and flat files.
For which SAP BW/4HANA objects is it possible to create an external SAP HANA view?
There are 2 correct answers to this question. Open ODS views Key figures Composite Providers Characteristics.
Which of the following is the core workflow when working with SAP Analytics Cloud? Please choose the correct answer. Acquire - Prepare - Explore - Visualize - Collaborate Prepare - Explore - Acquire - Visualize - Collaborate Acquire - Prepare - Visualize - Explore - Collaborate Explore - Acquire - Prepare - Visualize – Collaborate.
For which scenario do you recommend an InfoSource? Please choose the correct answer. Allow the creation of delta records. Store intermediate results. Use it as a source for the data transfer process. Connect multiple sources and targets.
When do you recommend using an external hierarchy?
Note: There are 3 correct answers to this question. The structure will depend on the order of the row characteristcs The hierarchical structure will be time-dependent The structure data will be restricted to a hierarchy node The structure will contain formulas The query data will be restricted to a hierarchy node.
What can you achieve with rule groups in an SAP BW transformation?
There are 2 correct answers to this question. Key figures with the same characteristic mapping are grouped One record in the source creates a record in the target for each rule group Characteristics with the same key figure mapping are grouped Records of the source are grouped to decrease number of records in the target.
Your customer converts LSA to LSA++ and needs to streamline the enterprise data warehouse layer. What action do you take? Reduce the number of persistent Info Providers. Apply the SAP Business Warehouse workspace layer. Migrate all SAP Business Warehouse objects to SAP HANA optimized objects. Apply the Open ODS layer.
Which of the following are external tools used for Data Provisioning?
Note: There are 3 correct answers to this question. Enterprise Information Management Near Line Storage SAP Data Services SAP Landscape Transformation Replication Server Direct Extractor Connection (DHC).
Which of the following sources can you connect to SAP BW/4HANA with the SAP HANA source system?
Note: There are 2 correct answers to this question. SAP BW/4HANA transformations. Remote sources available with SAP HANA smart data integration and smart data access. Local SAP HANA schemas. Web templates.
Which of the following objects are supported in SAP BW/4HANA?
Note: There are 2 correct answers to this question. CompositeProvider DataStore object (advanced) InfoSet MultiProvider InfoCube.
How is data security handled for the live connection between SAP Analytics Cloud and SAP BW/4HANA? Data can be secured by allowing or prohibiting access to ADSO partitions. SAP Analytics Cloud performs an authorization check after retrieving the query result from the SAP BW/4HANA back end. SAP BW/4HANA analysis authorizations are evaluated on the SAP BW/4HANA back-end side. Data records are filtered according to the settings in the SAP BW/4HANA analysis authorizations.
Which kinds of data can you model with Open ODS views?
Note: There are 2 correct answers to this question. Queries Language-dependent texts Unstructured data Master data.
On which SAP BW/4HANA objects does the Predictive Factory run? External SAP Hana views generated from SAP BW/4HANA. SAP BW/4HANA InfoCubes. Active tables of SAP BW/4HANA DataStore Objects (advanced). SAP BW/4HANA Analysis Process Designer.
Which of the following are characteristics of the DevOps methodology?
Note: There are 2 correct answers to this question. SAP HANA data warehousing foundation. Shortened lead time between fixes. A clear separation of development and operations tasks on an organizational level. Automation of repetitive tasks.
Which of the following documents can be created with SAP Lumira, designer edition?
Note: There are 2 correct answers to this question. Crystal Reports BEx Web templates Analytical applications that are focused on slice-and-dice analysis Dashboards.
Which of the following statements about data flow objects in SAP BW/4HANA are true?
Note; There are 2 correct answers to this question. The data flow object is the successor of the semantically partitioned object (SPO) in SAP BW/4HANA. A data flow object is a TLOGO object (transportable object) in SAP BW/4HANA and describes a data flow. Data flow objects are not available for SAP BW/4HANA. Data flow objects can be modeled in the Eclipse-based modeling tools for SAP BW/4HANA.
What are the modeling objects for persistency in SAP BW/4HANA?
Note: There are 2 correct answers to this question. HybridProvider InfoObject PSA table InfoCube DataStore object (advanced).
On which modeling object in SAP BW/4HANA are physical partitioning and data tiering capabilities for large amounts of data possible? Composite Provider InfoObject InfoCube DataStore object (advanced).
Which statement for field-based modeling in SAP BW/4HANA is true? Field-based modeling cannot leverage the SAP BW/4HANA authorization concept. Field-based modeling complements InfoObject modeling and is fully integrated with existing SAP BW/4HANA objects/models and SAP BW/4HANA authorizations. Field-based modeling is only available for SAP sources. Field-based modeling is not recommended for mass data loads.
What is the role of the CompositeProvider in SAP BW/4HANA? It is the core object for persistency in SAP BW/4HANA. It is a virtual object to combine data from SAP BW/4HANA and SAP HANA via join or union. It is the planning engine in SAP BW/4HANA. It is the successor of the BW InfoCube.
What can you do in the graphical data flow modeler?
Note: There are 2 correct answers to this question. Push down OLAP logic to SAP HANA. Create and schedule process chains. Navigate to object editors. Model new or explore existing data flows.
Where should you develop process chains in SAP BW/4HANA as of SP 08? SAP Web IDE Process chain modeler in the SAP BW/4HANA web administration tools. Standalone process chain designer Transaction RSPC in the SAP GUI.
What is the in-app help for the SAP BW/4HANA cockpit? A browser-based information management system A browser-based information management system An embedded help within SAP Fiori apps, including context-sensitive information and guided tours A new SAP interface for help applications.
Where does monitoring and scheduling take place in SAP BW/4HANA as of SP 08? In the SAP BW/4HANA administration cockpit In the standalone process chain monitoring tool In the SAP GUI In SAP Web IDE.
What are the main benefits of database partitioning on DataStore objects (advanced)?
Note: There are 2 correct answers to this question. System performance is optimized and very large tables are supported. The memory footprint is reduced on the SAP HANA database. The data is distributed across all nodes in scale-out systems. Data is not distributed across all nodes in scale-out systems. Data compression is higher compared to non-partitioned DataStore objects (advanced).
Where should queries be modeled when the ADSO is partitioned semantically? Queries should be modeled based on the individual DataStore objects (advanced). Queries should be modeled based on A-tables in an SAP HANA calculation view. Queries should be modeled based on the CompositeProvider on top of the semantic group. Queries should be modeled based on the Open ODS view.
How do you manage data access security in a mixed scenario? You must maintain SAP HANA privileges manually. You must use SAP HANA data anonymization features like differential privacy to obscure the data. You can create SAP HANA privileges out of SAP BW/4HANA authorization objects. You must maintain authorizations in the analytic clients.
Is it possible to extend SAP HANA EIM with custom adapters? No, this is not necessary because all existing sources can already be accessed via SAP HANA EIM. Yes, you can use enhancement spots via the ODP framework to extend SAP ERP extractors. No, custom code is a potential security risk and therefore not allowed. Yes, SAP HANA smart data integration offers an adapter API.
Which of the following are characteristics of the DevOps methodology? Note: There are 2 correct answers to this question. SAP HANA data warehousing foundation. Shortened lead time between fixes. A clear separation of development and operations tasks on an organizational level. Automation of repetitive tasks.
Which of the following statements about the native DataStore object in SAP SQL Data Warehousing is true? Native DataStore objects require InfoObjects in SAP BW/4HANA. Native DataStore objects will replace SAP HANA calculation views over time. A native DataStore object can be accessed from SAP BW/4HANA. A native DataStore object is generated when a DataStore object (advanced) is activated in SAP BW/4HANA.
For what kind of tasks is SAP Data Hub designed?
Note: There are 2 correct answers to this question. For orchestrating Big Data landscapes. For building a data warehouse and persisting the data. For connecting all types of data sources (enterprise systems, data lakes, etc.) For replicating data from operational systems.
What is the relationship between SAP Data Hub and SAP Vora? SAP Data Hub is the new data warehouse solution and SAP Vora is designed for archiving mass data. SAP Data Hub is the new data warehouse solution from SAP built on SAP Vora. SAP Vora capabilities are included in SAP Data Hub, however SAP Data Hub and SAP Vora are designed to address different use cases, based on customers' specific needs. SAP Vora is an add-on to SAP Data Hub.
What is the definition of a task workflow in SAP Data Hub? An SAP Data Hub task workflow creates the underlying data model of the SAP Data Hub. An SAP Data Hub task workflow orchestrates multiple tasks and executes them in a given order. An SAP Data Hub task workflow is responsible for data aging in SAP BW/4HANA. An SAP Data Hub task workflow executes the ETL processes.
What are the core predictive functions to answer business questions?
Note: There are 2 correct answers to this question. XRF spectroscopy Gaussian normal distribution Classification and regression Segmentation or clustering.
Where are the partitions for Data Tiering Optimization (DTO) with SAP BW/4HANA created? Under Partitions on the Settings tab of the DataStore object (advanced). In the SAP BW/4HANA Web Administration cockpit. On the General tab of the DataStore object (advanced). In the Maintain Temperatures SAP GUI transaction.
How can you use SAP BPC Standard data in SAP Analytics Cloud? Planning is not possible, but reporting is. You can access the data via the BPC live connection of SAP Analytics Cloud. You can use the BPC import connection of SAP Analytics Cloud. You cannot use SAP BPC Standard data in SAP Analytics Cloud.
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. Design the data layer concept based on the LSA++ architecture. Create functional and technical documentation. Create functional and technical documentation. Build SAP HANA views and define their properties. Create and activate SAP BW objects.
On which of the following objects can you restrict a characteristic? Formula Exception Condition Hierarchy node.
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. Insert the parameter for the Web address in the assignment details. Select the Web address from the list of report types. Select Receiver Object and enter the Web address. Select a system from the Source Systems tab. Insert the Web address in the assignment details.
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. Insert the parameter for the Web address in the assignment details. Select the Web address from the list of report types. Select Receiver Object and enter the Web address. Select a system from the Source Systems tab. Insert the Web address in the assignment details.
SAP BusinessObjects Web Intelligence allows all information consumers in the company to build individual applications for their reporting needs.
Determine whether this statement is true or false. True False.
A practical use case for formatted reporting is an annual report that is centrally created and managed, and distributed to all executives in the company.
Determine whether this statement is true or false. True False.
SAP BusinessObjects Design Studio is the tool of choice for graphical visualizations of
aggregated data. Dashboards are often built on queries with a very small result set.
Determine whether this statement is true or false. True False.
The SAP Lumira desktop experience is used to prepare data from multiple sources, visualize it, and then compose stories from those visualizations that can be shared with other decision makers.
Determine whether this statement is true or false. True False.
You need to transfer delta data and ensure Full Quality of Service. You are using an SAP Business
Warehouse Web service. Which SAP Process Integration (SAP PI) adapter do you use? SAP PI File Transfer Protocol adapter SAP PI ABAP proxy communication adapter SAP PI Remote Function Call adapter SAP PI Simple Object Access Protocol Call adapter .
|
