sample test for 214

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. Harmonization of data from several source systems. Real-time reporting on source system data without staging. Transformations on data based on business logic. Initial staging of source system data.

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.

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 Remote Migration. BW Shell Migration. SAP BW/4HANA Model Transfer. SAP ABAP Connection.

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

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 RS02 (Maintain Generic DataSource) in the SAP source system. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system. Transaction RSA1 (Bl Content) in the SAP BW/4HANA system. Transaction ODQMON (Monitor Delta Queues) in the SAP source system.

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

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

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?. 10. 7. 3. 5.

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 cannot be replicated using ODP_SAP source system type. The ODP DataSource has to be created using the ODP_SAP source system type. The ODP DataSource can be generated using the DataFlow generation feature. The ODP DataSource has to be created using the ODP_HANA source system type.

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 reference to an existing measure. An aggregation method. An SAP HANA data type. A condition criterion.

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 BusinessObiects Web Intelligence. SAP Analysis for Microsoft Office. SAP Lumira, designer edition. SAP Crystal Reports for Enterprise.

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.

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

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?. Assign a space. Change the schema name. Generate the HDI container. Define a package.

How does SAP position SAP Data Warehouse Cloud in supporting business users?. Business users can maintain process chains from SAP BW/4HANA dataflows. 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 allocate system resources without IT involvement.

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

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. Open operational data store layer. Data acquisition layer. Virtual data mart layer. Flexible Enterprise Data Warehouse Core layer.

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

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. Hierarchy node. Text. Characteristic value.

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

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. Another column of the same SAP HANA view. A fixed currency from table TCURC. A variable in the same SAP HANA view. A column from another SAP HANA view.

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

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

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. Open ODS view of type Master Data. Calculation View of type Dimension. Open ODS view of type Facts. InfoObject of type Characteristic.

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?. Create a synonym for the HDI Calculation View (data category Cube with Star Join). Build the design time file of the HDI Calculation View (data category Dimension) to generate a runtime object. Create a synonym for the HDI Calculation View (data category Dimension). Build the runtime object of the HDI Calculation View (data category Cube with Star Join) to generate a design time file.

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. Enhancing existing SAP HANA content models. Leveraging SQL in-house knowledge. Loading snapshots or deltas from different sources on a periodic basis. Reporting on a harmonized set of master data.

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.

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 combine master data and transactional data. You can persist transactional data. You can provide default time characteristics. You can aggregate measures as a sum. You can create restricted columns.

You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different attribute values assigned. How do you design the model?. Compound characteristic "COSTOBJ" with the characteristic for Controlling Area. Compound the characteristic for Controlling Area with the characteristic "COSTOBJ". Define characteristic "COSTOBJ" as a navigation attribute for Controlling Area. Define Controlling Area as a navigation attribute for the characteristic "COSTOBJ".

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 answers to this question. When you define the data transfer process, select the "Get All New Data in Source Request by Request" setting. When you define the data transfer process, select the "Set manually" setting for "Overall status of request". When you define the attributes of the material characteristic, select the "Time Dependent" setting. When you define the material characteristic, select the "Enhanced Master data update" setting.

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 InfoObiect ADDRESS is activated. SID values are generated when InfoObiect CITY is activated. SID values are generated when data for InfoObiect ADDRESS is loaded. SID values are not stored for InfoObiect ADDRESS.

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

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

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. Open ODS View. BW Query. Data Store object (advanced).

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

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

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

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

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

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_RECORD_MODE. SDI_CHANGE_TYPE. SDI_CHANGE_SEQUENCE. SDI_ENTITY_COUNTER. SDI_CHANGE_TIME.

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. Assign hierarchy properties to the field in the BW Query. Associate the filed with the characteristic in the Open ODS View. Associate the new field with the characteristic in the CompositeProvider. Add the characteristic to the DataStore object (advanced).

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

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?. InfoObiect based modeling. Business content activation. Field-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. BAdl Provider. Open ODS View. DataStore Object (advanced). InfoObject Type Key Figure. CompositeProvider.

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 query that uses cost center as a free characteristic. There must be no transaction data referring to the cost centers. There must be no hierarchy for the cost centers. There must be no BW analysis authorizations defined that use any of the cost centers.

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

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. Reporting is done based on a union of the inbound and active tables. The records are treated as if all characteristics are in the key. The change log table will be filled only after data activation. Query results are shown only when data has been activated.

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 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. Activate SAP Business Content. Determine if physical or logical objects will be needed. Collect reporting requirements.

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. DataStore Object (advanced). Open Hub Destination. CompositeProvider. InfoSource. SAP HANA Analysis Process.

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 and build the HDI Calculation View (data category Dimension). Create and build the HDI Calculation View (data category Cube with Star Join). Create a synonym for the HDI Calculation View (data category Dimension).

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

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

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 "SERIAL_NO" as a transitive attribute for "PRODUCT". Use "COUNTRY" as a navigation attribute for "PRODUCT". Use "SERIAL_NO" as compounding characteristic for "PRODUCT". Use "COUNTRY" as compounding characteristic for "PRODUCT".

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

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 answers to this question. *DataSource with Delta Management method AIE; *DataSource Object (advanced) type Data Mart; *Update method Summation. *DataSource with Delta Management method ABR; *DataSource Object (advanced) type Data Mart; *Update method Summation. *DataSource with Delta Management method ABR; *DataSource Object (advanced) type Standard; *Update method Summation. *DataSource with Delta Management method ADD; *DataSource Object (advanced) type Standard; *Update method Move. *DataSource with Delta Management method ABR; *DataSource Object (advanced) type Standard; *Update method Move.

You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect 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 program in RODPS_REPL_TEST in SAP ERP. Use the transaction RSA3 (Extractor checker) in SAP ERP. Use the transaction ODQMON (Monitor Delta Queues) in SAP BW/4HANA. Check entries in the table RSDDSTATEXTRACT in SAP ERP.

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 the top 10 customers. One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers. Only one result row with the sales revenue sum of all 100 customers. 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.

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

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

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. Reference cell. Help cell. Formula cell. Selection cell.

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/.

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

Which tasks are part of the Business Blueprint phase in SAP BW/4HANA project? Note there are 2 correct answers to this question. 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. Activate SAP business content objects that comply with the LSA++ architecture.

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. 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. 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.

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

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

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 this characteristic as a navigation attribute for another characteristic. You cannot use navigation attributes for this characteristic. You cannot load more than 2 billion master data records for this characteristic. SID numbers are created at runtime which might negatively affect the reporting performance.

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?. Release the DataSource in SAP BW/4HANA for ODP. Add a subscription in SAP ERP using the program RODPS_REPL_TEST. Generate the PSA table of the DataSource in SAP BW/4HANA. Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource.

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

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. Change the order of the fields in the target table. Switch the table type between row store and column store. Define sorting properties for a target table field. Adjust the suggested data type of the target table fields. Remove leading zeroes for a target table field.

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 logon language in the left table. The join cardinality between both tables. The language column in the right table. The language column in the left table.

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. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA. 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.

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. Automatic content activation during installation of SAP BW/4HANA. Accelerated SAP BW/4HANA implementation using ready-made models.

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

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. Real-time and scheduled data replication. Virtualization capabilities. Support of cluster and pool tables. Log-based replication.

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

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. Check the availability of data. Design the data layer concept. Monitor batch jobs and data volume. Specify necessary data conversion. Implement transport routes and layers.

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

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?. Table Function. Replication Task. Virtual Table. Flowgraph.

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

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 an aggregation node to a star join node. Switch from a projection node to a star join node. Switch from a projection node to an aggregation node.

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. SAP Hana Repository. Hybrid Mode. HANA Deployment Infrastructure (HDI). External SAP HANA View.

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 answers to this question. AIM. ABR. AIE. ADD.

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. Convert Unicode to non-Unicode. Apply mapping rules during the replication. Apply customizing settings to the database redo logs. Set the reading type and portion sizes. Change or enrich the table structure.

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 Landscape Transformation Replication Server. SAP Data Services. SAP Process Integration. SAP Data Warehouse Cloud.

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 answers to this question. Composite Provider. Transformation. Data source. SAP HANA calculation view. DataStore object (advanced).

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. Manual Input with offset value. Customer Exit. Replacement Path.

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. Data Type "Character String" is set in InfoObiect A. InfoObiect B is defined as a Key Figure. High Cardinality is set in InfoObiect B. Attribute Only is set in InfoObiect B. Conversion Routine "ALPHA" is set in InfoObject A.

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 only the authorized data is displayed. The BW query starts and the unauthorized values are 0. The BW query does not start running.

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. Database view. SAP query. HDI Calculation View. ABAP function module.

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

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

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. Analysis. Information. Design Rules. Components.

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. The latest request in the active data table. Any request in the active data table.

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. Existing authorization concepts. BW data models for analysis. BW data models for planning scenarios. Process chain streaming functionality.