Get 2022 Free SAP C_BW4HANA_27 Exam Practice Materials Collection [Q45-Q68]

5/5 - (1 vote)

Get 2022 Free SAP C_BW4HANA_27 Exam Practice Materials Collection

Get Latest and 100% Accurate C_BW4HANA_27 Exam Questions

SAP C_BW4HANA_27 Exam Syllabus Topics:

Topic	Details
Topic 1	Use InfoObjects and InfoProviders with SAP BW 4HANA 2.x Create and execute a BW query with SAP BW 4HANA 2.x
Topic 2	Analyze data with analytics tools such as Lumira, SAC, and Analysis for Office SAP BW 4HANA Data Flow
Topic 3	Describe SAP BW 4HANA 2.x model options and recommend best practice standards like LSA++ SAP BW 4HANA Modeling
Topic 4	Define the terms and basic concepts of SAP BW 4HANA 2.x Native SAP HANA Modeling

NO.45 Your customer is using a pure SAP HANA native data warehouse approach. Which tools should the customer install?
Note: There are 2 correct answers to this question.

SAP solutions for enterprise information management

BW Modeling Tools

SAP Information Steward

Process Chain Monitoring app

NO.46 Which join types can you use in a CompositeProvider? Note: There are 3 correct Answers to this question.

Inner join

Text join

Full Outer join

Hierarchy join

Referential join

NO.47 Which of the following methods supports the SAP HANA data virtualization approach with OBDC technology?

SAP HANA smart data access

SAP HANA smart data integration

SAP Landscape Transformation Replication Server

SAP Data Services

NO.48 Which tables belong to the hierarchy for characteristic OCOUNTRY? Note: There are 3 correct answers to this question.

/BIC/QCOUNTRY

D/BIC/KCOUNTRY

/BIC/ICOUNTRY

/BIC/PCOUNTRY

D/BIC/HCOUNTRY

NO.49 In which sequence can you create a reusable key figure structure?
There are 2 correct answers to this question.

1. Apply filters to a key figure structure in SAP Analysis for Microsoft Office.
2. Save the structure as a global structure.

1. Create a new structure in the context menu of a calculated key figure.
2. Save the structure as a global structure.

1. Create a new structure in the context menu of an InfoProvider.
2. Add key figures, selections, and formulas.

1. Create a new structure with key figures, selections, and formulas in a query.
2. Save the structure as a global structure.

NO.50 Which variables types allow filter values to be determined based on the user’s authorizations? Note: There are 2 correct answers to this question.

Characteristic value variable

Formula variable

Hierarchy node variable

Hierarchy variable

NO.51 Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correct Answers to this question.

SAP query

ABAP function module

HDI Calculation View

ABAP class method

Database view

NO.52 You are following a top-down method for your SAP BW/4HANA modeling project. What would be your first task?

Determine if physical or logical objects will be needed

Determine enhancements of SAP Business Content

Check available sources in the SAP ERP system

Collect reporting requirements

NO.53 What can you achieve with rule groups in an SAP BW transformation?
There are 2 correct answers to this question.

Characteristics with the same key figure mapping are grouped.

One record in the source creates a record in the target for each rule group.

Records of the source are grouped to decrease the number of records in the target.

Key figures with the same characteristic mapping are grouped.

NO.54 Which objects can you associate with a source field that is defined as a characteristic within an Open ODS view?
Note: There are 2 correct answers to this question.

SAP BW InfoObject

Open ODS view type Master Data for Attributes

Open ODS view type Facts

Open ODS view type Master Data for Hierarchies

NO.55 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_ENTITY_COUNTER

SDI_RECORD_MODE

SDI_CHANGE_TYPE

SDI_CHANGE_SEQUENCE

SDI_CHANGE_TIME

NO.56 Which query property do you set to minimize the initial run time for the query read mode?

Read all data at once.

Read data individually from InfoProvider.

Cache is inactive.

Read data when you navigate or expand hierarchies.

NO.57 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?

/0SAP/

/SFA/

/IMO/

/BW4/

NO.58 Which modeling function is possible in modeling with an SAP HANA Calculation View that is not possible in modeling with a CompositeProvider?

Use aggregation for datasets

Generate a rank column

Create a calculated column

Combine datasets by union

NO.59 Your main BW query contains a characteristic value variable with a replacement path from a query. When is the pre-query executed?

Each time the main query is executed, before the filter values are applied.

Each time the main query is executed, after the filter values are applied.

Directly after a predefined broadcasting event was triggered to calculate the pre-query.

Directly after data is loaded to the InfoProvider of the pre-query.

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

NO.61 Which features of an SAP BW/4HANA InfoObject are intended to reduce the physical data volume?
Note: There are 2 correct Answers to this question.

Transitive attribute

Compounding characteristic

Reference characteristic

Enhanced master data update

NO.62 You want to build an SAP HANA calculation view of data category CUBE, but you get the “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 an aggregation node to a projection node.

Switch from an aggregation node to a star join node.

Switch from a projection node to an aggregation node.

NO.63 You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued. Which join properties do you assign to the required join type?

Inner join with Dynamic Join properties

Referential join with Temporal Join properties

Inner join with Temporal Join properties

Referential join with Dynamic Join properties

NO.64 You need to determine the number of customers in each country that have revenue in 2018. What is the reference InfoObject in an exception aggregation?

Counter

Customer

Country

Year

NO.65 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 request in the change log table

The latest not-yet-activated request in the inbound table

Any older activated request in the inbound table

NO.66 What are benefits of using an InfoSource in a data flow? Note: There are 2 correct Answers to this question.

Connecting sequential transformations in the data flow without storing the data again

Reducing the number of data transfer processes (DTP)

Storing the extraction delta information of the data source file

Reducing the number of transformations for scenarios with many sources and targets

NO.67 To achieve an urgent business requirement, you choose the field-based modeling approach, but you also want to leverage a characteristic hierarchy. On which level does LSA++ architecture recommend the appropriate InfoObject to be associated?

In the SAP BW Open ODS view

In the SAP BW InfoSource

In the SAP BW DataStore object (advanced)

In the SAP BW CompositeProvider

NO.68 Which data deletion options are offered for a standard DataStore object (advanced)? Note: There are 3 correct Answers to this question.

Deletion of all data from active table only

Request-based data deletion

Deletion of data from all tables

Selective deletion of data

Selection deletion including data of subsequent targets

Loading …