Best Value Available! 2024 Realistic Verified Free C_BW4H_211 Exam Questions [Q17-Q36] : Exams Labs Braindumps : http://blog.examslabs.com

Q17. 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? Note: There are 3 correct answers to this question.

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

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

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

Connecting sequetial trnsformartions in the data flow without storing the data again

Reducing the numer od data transfer processes (DTP)

Storing the extraction delta information of the data source file

Q19. 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 data transfer process

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.

Q20. What is the purpose of an architecture overview model?

To identify the user groups and required authorizations

To automatically generate the LSA++ architecture

To determine the sequence of projects

To identify the required data sources.

Q21. In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell tupes can this be achieved?? Note: There are 2 correct answers to this question.

Selection cell

Reference cell

Formula cell

Help cell

Q22. 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 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 data transfer process, select the “Set manually” setting for “Overall status of request”.

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

Change the schema name

Generate the HDI container

Define a package

Assign a space

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

SDI_CHANGE_TIME

SDI_CHANGE_SEQUENCE

SDI_RECORD_MODE

SDI_CHANGE_TYPE

SDI_ENTITY_COUNTER

Q25. Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this question.

InfoSource

Open Hub Destination

DataStore Objetc (advanced)

CompositeProvider

SAP HANA Analysis Process

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

Create restricted columns

Provide default time characteristics

Persist transactional data

Combine master data and transactional data

Aggregate measures as a sum

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

Transformation

SAP HANA calculation view

Data source

DataStore object (advanced)

CompositeProvider

Q28. 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 mandatory characteristic value variables

Use include functions in the restricted key figures.

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

SDI_CHANGE_TYPE

SDI_CHANGE_TIME

Q30. Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use? Note: There are 2 correct answers to this question.

BAPIs (Business Application Programming Inetrface)

Calculation views

AMDPs (ABAP Manged Database Procedures)

Stored procedures

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

A condition criterion

An SAP HANA data type

An aggregation method

Q32. 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 the scenario? Note: There are 3 correct answer to this question.”

Combine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations.

Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.

Combine CUSTOMER, CITY and COUNTRY in a Composite Provider using a sequence of left outer join operators.

Include CUSTOMER to 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.

Q33. For a BW query, you want to have the first month of the curret quarter as a default value for an input-ready BW variable for the characteristic OCALMONTH. Which processing tyoe do you use?

Customer Exit

Manual Input with offset value

Replacement Path

Manuel Input with default value

Q34. What is the recommended cold data tiering option with SAP BW/4HANA?

SAP HANA extension node

SAP Data Warehouse Cloud

SAP IQ database

Hadoop cluster

Q35. You want to build an SAP HANA HDI 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 an aggregation node to a star join node

Switch from an aggregation node to a projection node

Switch form a projection node to an aggregation node

Switch from a projection node to a star join node

Q36. “What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 3 correct answer to this question.”

Ensuring referential integrity on your transactional data

Providing language dependent master data texts.

Reducing the number of data transfer processes

Allowing different data load frequency

Avoiding generation of SID values.