C-BW4HANA-27

Which tasks are part of the business Blueprint and Data Model Definition Note: There are 3 correct answers to this question. Check the availability of data. Specify necessary data conversion. Implement transport routes and layers. Monitor batch jobs and data volume. Design the data layer concept.

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

You have created a custom characteristic with the technical name “COSTOBJ”. Depending on the controlling area, you need to have different attribute values assigned. Compound characteristic “COSTOBJ” with the characteristic for Controlling Area. Define Controlling Area as a navigation attribute for the characteristic “COSTOBJ”. Join the characteristic “COSTOBJ” and the characteristic for Controlling Area in a BW query. Compound the characteristic for Controlling Area with the characteristic “COSTOBJ”.

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

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 Agile Data Preparation. SAP HANA optimized business content.

What can you leverage using the live data connections of SAP Analytics Cloud with SAP BW/4HANA?. Process chain streaming functionality. Existing authorization concepts. BW data models for analysis. BW data models for planning scenarios.

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

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

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 mandatory characteristic value variables. Use characteristic filter that overlap.

What is required before you can integrate an HDI Calculation View container?. Create a synonym for the HDI Calculation View (data category Dimension). Build the design time file of the HDI Calculation View (data category..). Create a synonym for the HDI Calculation View (cata category Cube). Build the runtime object of the HDI Calculation View (data category..).

Which features does SAP Analysis for Microsoft Office provide? There are 3 answers to this question. 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. Include more than one data source.

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 a successor of another process. It is the only process that can be scheduled without a predecessor. It can be re-used in other process chains.

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

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 “Set manually” setting. When you define the attribute of the material characteristic, select the “Time Dependent” setting. When you define the data transfer process, select the “Get All New Data Request by Request” setting. When you define the material characteristic, select the “Enhanced Master Data Update” setting.

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

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 the possible actions after the system suggests the target structure? Note: There are 3 correct answers to this question. Define sorting properties for a target table field. Change the order of the fields in the target table. Switch the table between row store and column store. Remove leading zeroes for a target table field. Adjust the suggested data type of the target table fields.

Which interface do you use to create a BW InfoObject with access type “SAP HANA View”. Embedded SAP GUI in SAP HANA studio. SAP HANA modeler perspective in SAP HANA studio. BW modeling perspective in SAP HANA Studio. SAP BW/4HANA Cockpit.

You want to set up the replication process for the SAP Landscape Transformation 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. Change or enrich the table structure. Set the reading type and portion sizes. Apply customizing setting to the database redo logs.

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

What is the recommended cold data tiering option with SAP BW/4HANA?. Hadoop cluster. SAP HANA extension node. SAP Data Warehouse Cloud. SAP IQ Database.

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

You use a measure with semantic type “Amount with Currency Code” in your SAP HANA 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. A fixed currency from table TCURC. Another column of the same SAP HANA view.

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? Note: There are 2 correct answers to this question. Check entries in the table RSDDSTATEXTRACT in SAP ERP. Use the program RODPS_REPL_TEST in SAP ERP. Use the transaction ODQMON (Monitor Delta Queues) in SAP BW/4HANA. Use the transaction RSA3 (Extractor Checker) in SAP ERP.

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenues (key figure 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 100 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 the other 90 customers. Only one result row with the sales revenue sum of all 100 customers.

Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data?. Flexible Enterprise Data Warehouse Core layer. Data acquisition layer. Open operational data store layer. Virtual data mart layer.

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. SID numbers are created at runtime which might negatively affect the reporting performance. 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.

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

In a BW query with cells, you need to overwite 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.

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

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

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

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 logon language in the left table. The language column in the left table. The language column in the right table.

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

What are some of the prerequisies 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 appropiate 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. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.

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

Which of the following are possible delta-specific fields for a generic Data Source in SAP BW/4HANA? Note: There are 3 correct answers to this question. Time stamp. Request ID. Numeric pointer. Calendar day. Record mode.

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

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. ADD. ABR. AIM. AIE.

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

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 yo have to realize the scenario? Note: There are 3 correct answers to this question. Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition. Generate external views for CUSTOMER, CITY and COUNTRY and join them in another calculation view. Combine CUSTOMER, CITY, and COUNTRY in a CompositeProvider 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 -. Combine CUSTOMER, CITY and COUNTRY in an Open ODS View using a sequence of associations -.

Which node types are only available for graphical modeling of SAP HANA HDI Calculation view? Note: There are 2 correct answers to this question. Intersect. Graph. Aggregation. Rank.

Which SAP BW/4HANA objects can be used as sources of a data transfer process Note: There are 3 correct answers to this question. Open Hub Destination. SAP HANA Analysis Process. Composite Provider. Data Store object. Infosource.

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

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 0CALMONTH. Which processing type do you use?. Replacement Path. Manual Input with default value. Manual Input with offset value. Customer Exit.

Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?. Smart discovery. Forecasting. Smart predict. Search to insight.