biología

You define a remote subscription of type USERT in a SAP HANA smart data integration real-time update scenario. Which fields are added to the datasource automatically? 3 correct. SDI_ENTITY_COUNTER. SDI_RECORD_MODE. SDI_CHANGE_SEQUENCE. SDI_CHANGE_TYPE. SDI_CHANGE_TIME.

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

You use a measure with semantic type "Amount with currency mode" in your SAP HANA HDI calculation view. Which kind of currency reference can be assigned to the measure? 2 correct. a column from another SAP HANA view. another column of the same SAP HANA view. a variable in the same SAP HANA view. a fixed currency from table TCURC.

Which SAP BW/4HANA objects support the feature of generating an external SAP HANA view? 2 correct. open ODS view. BW query. CompositeProvider. semantic group object.

Which of the augmented analytics smart features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?. smart predict. smart predict. search to insight. predictive forecast.

you create a data store object (advanced) using the "Data mart Datastore object" modeling property. Which behaviors are specific to this modeling property? 2 correct. the records are treated as if all characteristics are in the key. reporting is done based on a union of the inbound and active tables. query results are shown only when data has been activated. the change log table will be filled only after data activation.

Which disadvantages should you keep in mind when ypu set the High Cardinality flag for a characteristic? 2 correct. SID numbers are created at runtime which might negatively affect the reporting performance. 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. you cannot use navigation attributes for this characteristic.

what are the benefits of separating master data from transactional data in SAP BW/4HANA? 3 correct. providing language-dependent master data texts. avoiding generation of SID values. ensuring referential integrity on your transactional data. allowing different data load frequency. reducing the number of DTP.

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

you are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP standard datasource 0FI_GL_14. Which transactions can be used to activate this datasource? 2 correct. RSO2 in the SAP source system. RSA5 in the SAP source system. RSA1 in the SAP BW/4HANA system. ODQMON in the SAP source system.

you want to build 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 a projection node to a star join node. switch from a projection node to an aggregation node. switch from an aggregation node to a projection node. switch from an aggregation node to a star join node.

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. determine if physical or logical objects will be needed. activate SAP business content. collect reporting requirements.

which source types are available to create a generic DataSource in SAP ERP? 3 correct. ABAP class method. database view. SAP query. ABAP function module. HDI calculation view.

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? 3 correct. transformation. SAP HANA calculation view. Data source. datastore object (advanced). CompositeProvider.

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 system suggests the target structure? 2 correct. switch the table type between row store and column store. change the order of the fields in the target table. define sorting properties for a target table field. remove leading zeroes for a target table field. adjust the suggested data type of the target table fields.

what is the request handling default setting for error handling in a DTP in SAP BW/4HANA?. request is canceled, first incorrect record is tracked, and target is not updated. 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, records are not tracked, and target is not updated.

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 offset value. manual input with default value. replacement path. customer exit.

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? 3 correct. data type "character string" is set in Infoobject A. Conversion routine "ALPHA" is set in Infoobject A. High cardinality is set in Infoobject B. Infoobject B is defined as a Key figure. Attribute only is set in Infoobject B.

where is the buttont that automatically generates a process chain?. in the SAP GUI transaction for Process Chain Maintenance. in the editor of the Data Flow object. in the process chain editor app. in the process variant editor app.

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

Which external hierarchy properties can be changed in the query definition? 3 correct. position of child nodes. time dependency. sort direction. display text nodes. expand to level.

what are some of the advantages of using SAP BW/4HANA business content? 2 correct. 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.

in an SAP HANA smart data integration flowgraph, which transformation options are available? 3 correct. combine datasets. split datasets. call an ABAP function module. include a stored procedure. run an SAP HANA analysis process.

you defined a condition in a BW query for the top 10 to 100 customers based on sales revenue (KF of aggregation type Sum). If you keep the default settings of the BW query, what is presented regarding the result rows?. 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. only one result row with the sales revenue of all 100 customers.

you want to define a restricted column in an SAP HANA HDI calculation view. what do you need to define? 2 correct. a reference to an existing measure. a condition criterion. an SAP HANA data type. an aggregation method.

what does a composite provider allow you to do in SAP BW/4HANA? 3 correct. combine infoproviders using joins and unions. create new calculated fields. define new restricted key figures. integrate SAP HANA HDI calculation views. join two ABAP CDS views.

which interface do you use to create a BW Infoobject with access type "SAP HANA view?. embedded SAP GUI in SAP HANA studio. SAP BW/4HANA cockpit. BW modeling perspective in SAP HANA studio. SAP HANA modeler perspective in SAP HANA studio.

which development object needs to be built to generate an HDI container?. SQL script procedure. HDB module. O package. space.

why should you run an SAP HANA delta merge? 2 correct. to improve the read performance of Infoproviders. to move the most recent data from disk to meomty. 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)? 3 correct. by referencing a table. by using a query (update value set by query). by entering the values manually. by accessing an SAP HANA HDI calculation view of data category Dimension. by using a transformation and DTP.

Infoobject CITY is defined as a display attribute for Infoobject CUSTOMER, and Infoobject COUNTRY is defined as a display attribute for Infoobject CITY. in a master data report you want to display the COUNTRY of a CUSTOMER. Which options do you have to realize this scenario? 3 correct. generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view. include CUSTOMER to the rows in the BW query on CUSTOMER and activate the Universal Display Hierarchy setting. Add COUNTRY as a transitive attribute for CUSTOMER in Infoobject 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.

which features of an SAP BW/4HANA infoobject are intended to reduce physical data storage space? 2 correct. reference characteristic. transitive attribute. enhanced master data update. compounding 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 of 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. 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 Cube with Star join).

what can you leverage using the live data connections of SAP analytics cloud with SAP BW/4HANA? 2 correct. process chain streaming functionality. BW data models for analysis. existing authorizations concepts. BW data models for planning scenarios.

for which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus? 2 correct. reporting on a harmonized set of master data. enhancing existing SAP HANA content models. leveraging SAP in-house knowledge. loading snapshots or deltas from different sources on a periodic basis.

which objects can be affected by the key date in a BW query? 3 correct. navigation attributes. key figures. display attributes. conditions. hierarchies.

you notice than 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? 2 correct. use the transaction RSA3 in SAP ERP. check entries in the table RSDDSTATEXTRACT in SAP ERP. use the program RODPS_REPL_TEST iN SAP ERP. use the transaction EDQMON (monitor delta queues) in SAP BW/4HANA.

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 AFO. SAP BusinessObjects Web intelligence. SAP Lumira, designer edition. SAP crystal reports for enterprise.

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

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?. add a subscription in SAP ERP using the program RODPS_REPL_TEST. run the program RODP_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.

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

which layer of the layered scalable architecture /LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data? 3 correct. virtual data mart layer. data acquisition layer. open operational data store layer. flexible enterprise data warehouse core layer.

you have an existing field-based adata 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 Infoobject?. Data Store object (advanced). CompositeProvider. Open ODS view. BW query.

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

in SAP Web IDE for SAP HANA, you have imported a project including HDB module with calculation views. what do you need to do in the project settings before you can successfully build the HDB module?. change the schema name. generate de HDI container. define a package. assign a space.

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

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

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

how can the delta merge process be initiated in SAP BW/4HANA? 2 correct. by setting a specific flag in the DTP. by using the SAP BW/4HANA data load monitor. by setting a specific flag in the transformation. by using a specific process type in a process chain.

what are some of the variable types in a BW query that can use the processing type SAP HANA exit? 2 correct. hierarchy node. formula. text. characteristic value.

in a BW query with cells, you need to overwrite the initial definition of a cell. for which cell types does this option exist? 2 correct. selection cell. formula cell. help cell. reference cell.

what are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? 2 correct. the Operational Data Provisioning Framework must be configured in SAP BW/4HANA. the ABAP CDS views must be defined with the appropriate data extraction annotations. the ABAP CDS views must be released via the program RODPS_OS_EXPOSE for BW extraction. an ODP source system with contexts ODP_CDS must be created in SAP BW/4HANA.

using SAP HANA as modeling focus, you want to combine data from different sources. which technique can you use?. ABAP CDS views. BAPIs. SAP HANA HDI Calculation Views. AMDPs.

which join types can you use in a CompositeProvider? 3 correct. referential join. inner join. hierarchy join. text join. full outer join.

which node types are only available for graphical modeling for SAP HANA HDI calculation views (XS advanced), but not for SAP HANA calculation views (XS Classic)? 2 correct. rank. aggregation. graph. intersect.

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

you want to set up the replication process for the SAP Landscape Transformation Replication Server. which actions can you define for a specific table? 3 correct. apply mapping rules during the replication. change or enrich the table structure. set the reading type and portion sizes. apply customizing settings to the database redo logs. convert unicode to non-unicode.

you created an open ODS view of type Facts. which object type can you associate with a view field in the characteristics folder? 2 correct. InfoObject of type characteristic. open ODS view of type Master Data. calculation view of type Dimension. open ODS view of type Facts.

which of the following are possible delta-specific fields for a generic Datasource in SAP ERP? 3 correct. record mode. numeric pointer. request ID. time stamp. calendar day.

you have created a custom characteristic with the technical name "COSTOBJ". depending of the controlling area, you need to have different attribute values assigned. how do you design the model?. compound the characteristic for Controlling Area with the characteristic "COSTOBJ". define characteristic "COSTOBJ" as a navigation attribute for Controlling Area. compound characteristic "COSTOBJ" with the characteristic for Controlling Area. define Controlling Area as a navigation attribute for the characteristic "COSTOBJ".

what foundation is necessary to use SAP S/4HANA embedded analytics?. generated external SAP HANA calculation views. SAP Agile Data Preparation. SAP HANA optimized business content. ABAP CDS view based virtual data model.

what is the recommended cold data tiering option with SAP BW/4HANA? 2 correct. SAP HANA extension node. SAP Data Warehouse Cloud. SAP IQ database. Hadoop cluster.

which recommendations should you follow to optimize BW query performance? 3 correct. use fewer drill-down characteristics in the initial view. use mandatory characteristic value variables. use exclude functions in the restricted key figures. use characteristic filters that overlap. use include functions in the restricted key figures.

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 a rapid prototyping?. field-based modeling. InfoObject based modeling. business content activation. O Generate Data flow.

which features does SAP AFO provide? 3 correct. including more than one data source. creating bookmarks for a navigation state. changing context menu entries. dragging measures in and out of the report. displaying data simultaneously in a table and a chart.

you create a transformation from a Datasource to a DataMart ADSO. all key figures are updated as Sum. which delta methods indicate that de DataSource provides consistent information for this target? 2 correct. ADD. ABR. AIE. AIM.

which data deletion options are offered for a strandard aDSO? 3 correct. request-based data deletion. selective deletion of data. deletion of all data from active table only. selection deletion including data of subsequent targets. deletion of data from all tables.

why is the start process a special type of process in a process chain? 2 correct. 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 chains.

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 BusinessObjects Web Intelligence.

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 dhouls you select to restrict the result set to the logon language?. the language column in the right table. the logon language in the left table. the language column in the left table. the join cardinality between both tables.

what are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA? 2 correct. support of cluster and pool tables. log-based replication. virtualization capabilities. real-time and scheduled data replication.

which SAP solutions can leverage the Write Interface for aDSOs to push data into the inbound table of aDSOs? 2 correct. SAP Data Services. SAP Process Integration. SAP Landscape Transformation Replication Server. SAP Data Warehouse Cloud.

for a report, you would like to highlight the deviation from a predefined threshold values for a key figure. which BW query feature do you use?. reference cell. exception. condition. key figure property.

you open an SAP AFO workbook. on which Design Panel tabs can you verify the filter values? 2 correct. design rules. information. analysis. components.

what are the benefits of using an InfoSource in a data flow? 2 correct. reducing the number of DTPs. enabling a DTP to execute multiple sequential transformations. storing the extraction delta information of the data source file. splitting a complex transformation into simple parts without storing intermediate data.

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

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? 2 correct. when you define the DTP, select the "get all new data in source request by request" setting. 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. when you define the DTP, select the "Set manually" setting for "Overall status of request".

which SAP BW/4HANA objects can be used as sources of a DTP? 3 correct. Composite Provider. InfoSource. Open Hub Destination. SAP HANA Analysis Process. aDSO.

which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project? 3 correct. monitor batch jobs and data volume. check the availability of data. design the data layer concept. implement transport routes and layers. specify necessary data conversion.