Test three

You create a transformation from a DataSource to a DataMart DataStore object (advanced). All key figures are updated as Sum. Which Delta methods indicate that the DataSource provides consistent information for this target? Note: There are 2 correct to this question. ADD. AIM. ABR. AIE.

You want to build a web-based dashboard with interactive visualizations using Javascript. Which SAP tool can you use to create this?. SAP Analytics Cloud, analytics designer. SAP Smart Business Cockpits. SAP Crystal Reports. SAP BusinessObiects Web Intelligence.

What is the maximum number of reference characteristics that can be used for one key figure with a multi-dimensional exception aggregation in a BW query?. 7. 5. 10. 3.

You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP Standard DataSource OFI_GL 14 (New GL Items).Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system. Transaction RSA1 (Bl Content) in the SAP BW/4HANA system. Transaction RS02 (Maintain Generic DataSource) in the SAP source system. Transaction ODQMON (Monitor Delta Queues) in the SAP source system.

In which ODP context is the operational delta queue (ODQ) managed by the target system?. ODP_SAP. ODP_CDS. ODP_HANA. ODP_BW.

Which interface do you use to create a BW InfoObiect with access type "SAP HANA view"?. BW modeling perspective in SAP HANA studio. Embedded SAP GUI in SAP HANA studio. SAP HANA modeler perspective in SAP HANA studio. SAP BW/4HANA Cockpit.

When modeling data flows, you have to make sure that the interaction of the DataSource with its Delta Management method, the type of the DataStore object (advanced), and the update method of the key figures in the transformation provide consistent information for the target. Which of the following combinations are valid? Note: There are 3 correct to this question. *DataSource with Delta Management method ABR; *DataSource Object (advanced) type Standard; *Update method Move. *DataSource with Delta Management method ABR; *DataSource Object (advanced) type Standard; *Update method Summation. *DataSource with Delta Management method ABR; *DataSource Object (advanced) type Data Mart; *Update method Summation. *DataSource with Delta Management method AIE; *DataSource Object (advanced) type Data Mart; *Update method Summation. *DataSource with Delta Management method ADD; *DataSource Object (advanced) type Standard; *Update method Move.

Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?. Search to Insight. Smart Predict. Predictive Forecast. Smart Discovery.

Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data? Note: There are 3 correct answers to this question. Virtual data mart layer. Open operational data store layer. Data acquisition layer. Flexible Enterprise Data Warehouse Core layer.

For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus? Note: There are 2 correct answers to this question. Leveraging SQL in-house knowledge. Loading snapshots or deltas from different sources on a periodic basis. Enhancing existing SAP HANA content models. Reporting on a harmonized set of master data.

You create an SAP HANA HDI Calculation View. What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question. You can persist transactional data. You can provide default time characteristics. You can create restricted columns. You can combine master data and transactional data. You can aggregate measures as a sum.

In an SAP HANA smart data integration flowgraph, which transformation options are available? Note: There are 3 correct answers to this question. Include a stored procedure. Run an SAP HANA analysis process. Combine datasets. Call an ABAP function module. Split datasets.

For which scenarios do you use the SAP HANA model focus? Note: There are 2 correct to this question. Load snapshots using ABAP CDS Views. Define ABAP Managed Database Procedures in data flows. Define calculations using geopatial functions. Build views and procedures using SQL script.

You have an existing field-based data flow that follows the LSA++ concept with all of its layers. To meet a new urgent business requirement, you want to leverage a characteristic hierarchy with the least amount of effort to change your data flow. Which object do you use to associate an InfoObiect?. CompositeProvider. Data Store object (advanced). BW Query. Open ODS View.

What is required before you can integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join) of the same HDI container?. Build the runtime object of the HDI Calculation View (data category Cube with Star Join) to generate a design time file. Create a synonym for the HDI Calculation View (data category Cube with Star Join). Create a synonym for the HDI Calculation View (data category Dimension). Build the design time file of the HDI Calculation View (data category Dimension) to generate a runtime object.

For a BW query, you want to have the first month of the current quarter as a default value for an input-ready BW variable for the characteristic (CALMONTH). Which processing type do you use?. Manual Input with default value. Customer Exit. Manual Input with offset value. Replacement Path.

For InfoObiect ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the High Cardinality flag.What is the effect on SID values in this scenario?. SID values are generated when data for InfoObiect ADDRESS is loaded. SID values are not stored for InfoObiect ADDRESS. SID values are generated when InfoObiect ADDRESS is activated. SID values are generated when InfoObiect CITY is activated.

In SAP Web IDE for SAP HANA, you have imported a project including an HDB module with calculation views.What do you need to do in the project settings before you can successfully build the HDB module?. Generate the HDI container. Assign a space. Change the schema name. Define a package.

You want to define a restricted column in an SAP HANA HDI calculation view.What do you need to define? Note: There are 2 correct answers to this question. A condition criterion. A reference to an existing measure. An aggregation method. An SAP HANA data type.

What should you consider when you set High Cardinality flag for a characteristic? Note: There are 2 correct answers to this question. You cannot use navigation attributes for this characteristic. You cannot use this characteristic as a navigation attribute for another characteristic. You cannot use this characteristic as an external characteristic in hierarchies. You cannot load more than 2 billion master data records for this characteristic.

What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct answers to this question. Integrate SAP HANA HDI calculation views. Create new calculated fields. Define new restricted key figures. Join two ABAP CDS views. Combine InfoProviders using Joins and Unions.

You create a report with SAP Crystal Reports for Enterprise and need an analysis view as a data source. Which tool can you use to create this analysis view?. SAP Analysis for Microsoft Office. SAP Crystal Reports for Enterprise. SAP BusinessObiects Web Intelligence. SAP Lumira, designer edition.

What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct answers to this question. The ABAP CDS views must be defined with the appropriate data extraction annotations. The Operational Data Provisioning Framework must be configured in SAP BW/4HANA. The ABAP CDS views must be released via the program RODPS_OS_EXPOSE for BW extraction. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.

What is the purpose of an architecture overview model?. To automatically generate the LSA++ architecture. To determine the sequence of projects. To identify the user groups and required authorizations. To identify the required data sources and transformations.

What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?. Request is canceled, first incorrect record is tracked, and target is not updated. Request is set to success, error stack is written, and valid records are updated. Request is set to failed, error stack is written, and valid records are updated. Request is canceled, records are not tracked, and target is not updated.

In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible?. The latest not-yet-activated request in the inbound table. Any older activated request in the inbound table. Any request in the active data table. The latest request in the active data table.

Which tasks are part of the Business Blueprint phase in SAP BW/4HANA project? Note there are 2 correct answers to this question. Activate SAP business content objects that comply with the LSA++ architecture. Analyze key performance indicators of the business processes. Associate an InfoObject to a field in an Open ODS view. Collect central and individual information requirements.

You want to create an HDI Calculation View (data category Dimension) and integrate it into HDI Calculation View (data category Cube with Star Join) of the same HDI container. What is the first required step you need to take?. Create a synonym for HDI Calculation View (data category Cube with Star Join). Create a synonym for the HDI Calculation View (data category Dimension). Create and build the HDI Calculation View (data category Dimension). Create and build the HDI Calculation View (data category Cube with Star Join).

Which of the following are possible delta-specific fields for a generic DataSource in SAP ERP? Note: There are 3 correct answers to this. Calendar day. Record mode. Time stamp. Numeric pointer. Request ID.

Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this question. Open Hub Destination. SAP HANA Analysis Process. DataStore Object (advanced). CompositeProvider. InfoSource.

You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA. Which objects are created when using the "Generate Data Flow" function in the Open ODS View editor? Note: There are 3 correct to this question. SAP HANA calculation view. Transformation. Data source. DataStore object (advanced). Composite Provider.

Which data deletion options are offered for a standard DataStore object (advanced)? Note: There are 3 correct answers to this question. Selection deletion including data of subsequent targets. Deletion of all data from active table only. Selective deletion of data. Request-based data deletion. Deletion of data from all tables.

You have already loaded data from a non-SAP system into SAP Data Warehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system. What do you need to use to combine the data?. BW Shell Migration. BW Remote Migration. SAP ABAP Connection. SAP BW/4HANA Model Transfer.

What are the reasons for implementing CompositeProviders? Note: There are 2 correct to this question. To persist combined data for reporting. To provide an interface for BW queries. To directly expose an external SAP HANA table for reporting. To provide a virtual data mart layer that combines existing BW models.

What are some of the advantages of using SAP BW/4HANA business content? Note: There are 2 correct answers to this question. Automatic generation of Analysis Authorizations during SAP BW/4HANA content activation. Ability to combine business content objects with custom-defined objects. Accelerated SAP BW/4HANA implementation using ready-made models. Automatic content activation during installation of SAP BW/4HANA.

You want to build an SAP HANA HDI calculation view of data category CUBE, but you get a "no measure defined" error.For the business requirement, a measure does not make sense. Besides changing the data category to DIMENSION, what do you have to do?. Switch from an aggregation node to a projection node. Switch from a projection node to an aggregation node. Switch from an aggregation node to a star join node. Switch from a projection node to a star join node.

How does SAP position SAP Data Warehouse Cloud in supporting business users?. Business users can allocate system resources without IT involvement. Business users can create agile models from different sources. Business users can generate SQL code that is pushed to SAP BW/4HANA. Business users can maintain process chains from SAP BW/4HANA dataflows.

You created a generic DataSource in SAP ERP, but did not release the DataSource for Operational Data Provisioning (ODP) What is the effect in SAP BW/4HANA?. The ODP DataSource can be generated using the DataFlow generation feature. The ODP DataSource cannot be replicated using ODP_SAP source system type. The ODP DataSource has to be created using the ODP_HANA source system type. The ODP DataSource has to be created using the ODP_SAP source system type.

What can you leverage using the live data connections of SAP Analytics Cloud with SAP BW/4HANA? Note: There are 2 correct answers to this question. BW data models for analysis. Existing authorization concepts. BW data models for planning scenarios. Process chain streaming functionality.

What are some of the variable types in a BW query that can use the processing type SAP HANA Exit? Note: There are 2 correct answers to this question. Formula. Text. Characteristic value. Hierarchy node.

For a report, you would like to highlight the deviation from predefined threshold values for a key figure. Which BW query feature do you use?. Reference cell. Key figure property. Exception. Condition.

Which join types can you use in a CompositeProvider? Note: There are 3 correct to this question. Full Outer join. Hierarchy join. Inner join. Referential join. Text join.

You are following a top-down method for your SAP BW/4HANA modeling project. What is your first task?. Check available sources in the SAP ERP system. Collect reporting requirements. Activate SAP Business Content. Determine if physical or logical objects will be needed.

You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question. Information. Design Rules. Components. Analysis.

Which objects' values can be affected by the key date in BW query? Note: There are 3 correct answers to this question. Hierarchies. Basic key figures. Navigation attributes. Display attributes. Time characteristics.

What is the recommended cold data tiering option with SAP BW/4HANA? There are 2 correct answers to this. SAP IQ database. Hadoop cluster. SAP Data Warehouse Cloud. SAP HANA extension node.

Which are the purposes of the Open Operational Data Store layer in the layered scalable architecture (LSA++) of SAP BW/4HANA? Note: There are 2 correct answers to this question. Real-time reporting on source system data without staging. Harmonization of data from several source systems. Transformations on data based on business logic. Initial staging of source system data.

How can the delta merge process be initiated in SAP BW/4HANA? Note: There are 2 correct answers to this question. By using a specific process type in a process chain. By setting a specific flag in the transformation. By using the SAP BW/4HANA data load monitor. By setting a specific flag in the data transfer process.

You notice that an SAP ERP ODP_SAP DataSource is delivering values into the first persistent data layer in SAP BW/4HANA.Which options do you have to analyze a potential extractor issue? Note: There are 2 correct answers to this question. Use the transaction ODQMON (Monitor Delta Queues) in SAP BW/4HANA. Check entries in the table RSDDSTATEXTRACT in SAP ERP. Use the transaction RSA3 (Extractor checker) in SAP ERP. Use the program in RODPS_REPL_TEST in SAP ERP.

Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question. Display text nodes. Expand to level. Time dependency. Position of child nodes. Sort direction.

Why is the start process a special type of process in a process chain? Note: There are 2 correct answers to this question. It is the only process that can be scheduled without a predecessor. It can be a successor of another process. Only one start process is allowed for each process chain. It can be re-used in other process chain.

You use InfoObject B as a display attribute for InfoObject A. Which object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A? Note: There are 3 correct answers to this question. InfoObiect B is defined as a Key Figure. Conversion Routine "ALPHA" is set in InfoObject A. Data Type "Character String" is set in InfoObiect A. Attribute Only is set in InfoObiect B. High Cardinality is set in InfoObiect B.

What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA? Note: There are 2 correct answers to this question. There must be no BW analysis authorizations defined that use any of the cost centers. There must be no BW query that uses cost center as a free characteristic. There must be no hierarchy for the cost centers. There must be no transaction data referring to the cost centers.

You want to run a BW query, but you only have partial authorization for the data selection. What happens related to the BW query in this scenario?. The BW query starts and shows an error message. The BW query starts and the unauthorized values are 0. The BW query starts and only the authorized data is displayed. The BW query does not start running.

In a BW query with cells, you need to overwrite the initial definition of a cell. For which cell types does this option exist? Note: There are 2 correct answers to this question. Help cell. Selection cell. Reference cell. Formula cell.

Which disadvantages should you keep in mind when you set the High Cardinality flag for a characteristic? Note: There are 2 correct answers to this question. You cannot use navigation attributes for this characteristic. You cannot load more than 2 billion master data records for this characteristic. You cannot use this characteristic as a navigation attribute for another characteristic. SID numbers are created at runtime which might negatively affect the reporting performance.

What are benefits of using an InfoSource in a data flow? Note: There are 2 correct to this question. Splitting a complex transformation into simple parts without storing intermediate data. Reducing the number of data transfer processes (DTP). Enabling a data transfer process (DTP) to execute multiple sequential transformations. Storing the extraction delta information of the data source file.

You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? Note: There are 2 correct answers to this question. Calculation View of type Dimension. InfoObject of type Characteristic. Open ODS view of type Master Data. Open ODS view of type Facts.

You have an existing field-based data flow that follows the LSA++ concept. To meet a new urgent business requirement for a field, you want to leverage a hierarchy of an existing characteristic without changing the transformation. How can you achieve this? Note: There are 2 correct answers to this question. Add the characteristic to the DataStore object (advanced). Associate the filed with the characteristic in the Open ODS View. Associate the new field with the characteristic in the CompositeProvider. Assign hierarchy properties to the field in the BW Query.

You have created an HDI Calculation View. You would like to integrate that into an SAP BW/4HANA CompositeProvider. Which SAP BW/4HANA customizing parameters referring to "Settings for consumption of HANA Views" are available to implement this scenario? Note: There are 2 correct answers to this question. External SAP HANA View. SAP Hana Repository. Hybrid Mode. HANA Deployment Infrastructure (HDI).

The Database Explorer in the Web IDE for SAP HANA provides a data file import wizard to create a table in SAP HANA from a flat file. What are possible actions after the system suggests the target structure? Note: There are 3 correct answers to this question. Switch the table type between row store and column store. Adjust the suggested data type of the target table fields. Remove leading zeroes for a target table field. Change the order of the fields in the target table. Define sorting properties for a target table field.

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum). If you keep the default settings of the BW query, what is presented regarding the result rows?. Only one result row with the sales revenue sum of all 100 customers. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers. Only one result row with the sales revenue sum of the top 10 customers. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of all 100 customers.

Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View? Note: There are 2 correct answers to this question. Composite Provider. Open ODS view. BW query. Semantic group object.

You want to access data from a table residing in an external database using an SAP HANA SDA remote source. Which other SAP HANA element is required to access its data?. Virtual Table. Table Function. Flowgraph. Replication Task.

Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project? Note: There are 3 correct answers to this question. Specify necessary data conversion. Check the availability of data. Design the data layer concept. Monitor batch jobs and data volume. Implement transport routes and layers.

For which use case would you need to model a transitive attribute?. Load attributes using enhanced master data update. Generate a transient provider for a BW query on master data attributes. Store time-dependent snapshots of master data attributes. Report on navigational attributes of navigational attributes.

Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question. ABAP class method. SAP query. Database view. HDI Calculation View. ABAP function module.

Where is the button that automatically generates a process chain?. In the Process Chain Editor app. In the Process Variant Editor app. In the editor of the Data Flow object. In the SAP GUI transaction for Process Chain Maintenance.

Which node types are only available for graphical modeling of SAP HANA HDI Calculation Views (XS Advanced), but not for SAP HANA Calculation Views (XS Classic)? Note: There are 2 correct answers to this question. Aggregation. Intersect. Graph. Rank.

You need to derive an architecture overview model from a key figure matrix. Which is the first step you need to take?. Identify sources. Analyze storage requirements. Define data marts. Identify transformations.

What foundation is necessary to use SAP S/4HANA embedded analytics?. ABAP CDS view based virtual data model. Generated external SAP HANA Calculation Views. SAP HANA optimized business content. SAP Agile Data Preparation.

When loading master data for a material, you want to look at the new values before they are released for reporting. How can you make this possible? Note: There are 2 correct to this question. When you define the attributes of the material characteristic, select the "Time Dependent" setting. When you define the data transfer process, select the "Set manually" setting for "Overall status of request". When you define the data transfer process, select the "Get All New Data in Source Request by Request" setting. When you define the material characteristic, select the "Enhanced Master data update" setting.

Using SAP HANA as modeling focus, you want to combine data from different sources. Which technique can you use?. SAP HANA HDI Calculation views. ABAP CDS views. AMDPs (ABAP Managed Database Procedures). BAPls (Business Application Programming Interface).

How does SAP position SAP Datasphere in supporting business users? Note: There are 3 correct answers to this question. Business users can allocate system resources without IT involvement. Business users can upload their own CSV files. Business users can create restricted and calculated columns based on existing models. Business users can create agile models from different sources. Business users can leverage embedded analytic Fiori apps for data analysis.

What are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA? Note: There are 2 correct answers to this question. Support of cluster and pool tables. Log-based replication. Real-time and scheduled data replication. Virtualization capabilities.

InfoObiect CITY is defined as a display attribute for InfoObiect CUSTOMER, and InfoObject COUNTRY is defined as a display attribute for InfoObiect CITY. In a master data report you want to display the COUNTRY of a CUSTOMER. Which options do you have to realize this scenario? Note: There are 3 correct answers to this question. Add COUNTRY as a transitive attribute for CUSTOMER in Info Object definition. Combine CUSTOMER, CITY, and COUNTRY in an Open ODS View using a sequence of associations. Combine CUSTOMER, CITY, and COUNTRY in a Composite Provider using a sequence of left outer join operators. Include CUSTOMER to the rows in the BW Query on CUSTOMER and activate the Universal Display Hierarchy setting. Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.

Why do you set Read access Type to "SAP HANA View" in a BW InfoObject?. To generate an SAP HANA calculation view, data category Dimension. To use the InfoObject as an association within an Open ODS view. To report master data attributes which are defined in calculation views. To enable parallel loading of master data texts.

You use a measure with semantic type "Amount with Currency Code" in your SAP HANA HDI calculation view. Which kind of currency reference can be assigned to the measure? Note: There are 2 correct answers to this question. A column from another SAP HANA view. A variable in the same SAP HANA view. Another column of the same SAP HANA view. A fixed currency from table TCURC.

Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct answers to this question. Changing context menu entries. Displaying data simultaneously in a table and a chart. Creating bookmarks for a navigation state. Including more than one data source. Dragging measures in and out of the report.

Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (advanced)? Note: There are 2 correct answers to this question. SAP Data Services. SAP Landscape Transformation Replication Server. SAP Process Integration. SAP Data Warehouse Cloud.

You create a Data Store object (advanced) using the "Data Mart DataStore Object" modeling property. Which behaviors are specific to this modeling property? Note: There are 2 correct answers to this question. The change log table will be filled only after data activation. Reporting is done based on a union of the inbound and active tables. Query results are shown only when data has been activated. The records are treated as if all characteristics are in the key.

With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which technical namespace is assigned to identify the new SAP ERP-related business content?. ICPMBI. /BW4/. ?????. ISFA/.

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

Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question. Use fewer drill-down characteristics in the initial view. Use characteristic filters that overlap. Use exclude functions in the restricted key figures. Use include functions in the restricted key figures. Use mandatory characteristic value variables.

You want to set up the replication process for the SAP Landscape Transformation Replication Server. Which actions can you define for a specific table? Note: There are 3 correct answers to this question. Change or enrich the table structure. Apply customizing settings to the database redo logs. Convert Unicode to non-Unicode. Apply mapping rules during the replication. Set the reading type and portion sizes.

You created a generic DataSource in SAP ERP. How can you enable your generic Data Source to be used as an ODP SAP DataSource in SAP BW/4HANA in case it is not available by default?. Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource. Release the DataSource in SAP BW/4HANA for ODP. Generate the PSA table of the DataSource in SAP BW/4HANA. Add a subscription in SAP ERP using the program RODPS_REPL_TEST.

Your company manufactures products with country-specific serial numbers, For this scenario, you have created 3 custom characteristics with the technical names "PRODUCT, "COUNTRY" and "SERIAL_NO". How do you need to model the characteristic "PRODUCT" to store different attribute values to serial numbers?. Use "COUNTRY" as a navigation attribute for "PRODUCT". Use "COUNTRY" as compounding characteristic for "PRODUCT". Use "SERIAL_NO" as compounding characteristic for "PRODUCT". Use "SERIAL_NO" as a transitive attribute for "PRODUCT".

Which development object needs to be built to generate an HDI Container?. Package. Space. SQL script procedure. HDB module.

Why should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question. To move the most recent data from disk to memory. To improve the read performance of InfoProviders. To decrease memory consumption. To combine the query cache from different executions.

What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question. By using a query (update value set by query). By referencing a table. By using a transformation and data transfer process (DTP). By entering the values manually. By accessing an SAP HANA HDI Calculation View of data category Dimension.

In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data's language-dependent texts (right table) using a text join. What should you select to restrict the result set to the logon language?. The join cardinality between both tables. The language column in the right table. The language column in the left table. The logon language in the left table.

What are benefits of separating master data from transactional data in SAP BW/4HANA?Note: There are 3 correct answers to this question. Reducing the number of data transfer processes. Allowing different data load frequency. Ensuring referential integrity on your transactional data. Providing language-dependent master data texts. Avoiding generation of SID values.

Which features of an SAP BW/4HANA InfoObject are intended to reduce physical data storage space? Note: There are 2 correct answers to this question. Compounding characteristic. Transitive attribute. Reference characteristic. Enhanced master data update.

For test purposes, you want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non-SAP source system.Which approach should you consider for rapid prototyping?. Field-based modeling. Business content activation. InfoObiect based modeling. Generate Data Flow.

Which objects in SAP BW4/HANA allow you to use both fields and InfoObjects in their definition? Note: there are 3 correct answers to this question. InfoObject Type Key Figure. Open ODS View. DataStore Object (advanced). BAdl Provider. CompositeProvider.