Free SAP Certified Associate – Reporting – Modeling and Data Acquisition with SAP BW/4HANA Exam C_BW4H_211 Exam Practice Test

Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.

• Position of child nodes
• Expand to level
• Time dependency
• Sort direction
• Allow temporal hierarchy join

You create a report with SAP Crystal Reports for Enteprise and need an analysis view as a data source. Which tool can you use to create this analysis view?

• SAP BusinessObjetc Web Intelligence
• SAP Lumira, designer edition
• SAP Crustal Reportis for Enterprise
• SAP Analysis for Microsoft Office

You are involved in an SAP BW/4HANA project focusin on General Ledger reporting and want to use the SAP ERP Estandar 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 RSA1 (BI Content) in the SAP BW/4HANA system
• Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system
• Transaction RS02 (Maintain Generic DataSource) in the SAP source system
• Transaction ODQMON (Monitor Delta Queues) in the SAP Source system

You create a DataStore Object(advanced) using the Data Mart DataStore Object modeling property. Which behaviors are specific to this modelling property? Note: There are 2 correct answers to this question.

• The change log table will be filled only after data activation
• Reporting is done based on a union of the inbound and active tables
• Query result are shown only when data has been activated
• The records are treated as if all characteristics are in the key.

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

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

You would like to highlight the deviation from predefined threshold values for key figures actual revenue. Which BW feature do you use?

• Structure
• Conditions
• Exceptions
• Calculated key figures

In the Web IDE for SAP HANA workspace, you have imported a project including an HDB module with calculation views. What do you need to do in the project sittings before you can successfully build the HDB module?

• Enter an organization
• Reset the project type
• Assign a space
• Define a package

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

What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct Answers to this question.Combine Infoprovider using Join and UnionsJoin two ABAP CDS viewsDefine new restricted key figuresCreate new calculated fields IntegrateSAP HANA HDI calculation views.

• Combine InfoProviders using Join and Unions: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider is an InfoProvider that combines data from several analytic indexes or from other InfoProviders (by union or inner join or left outer join), and makes this data available for reporting and analysis. Storing the data in BW Accelerator or in an SAP HANA database also ensures faster access to data in the query12.
• Define new restricted key figures: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can define new restricted key figures based on the existing key figures of the underlying InfoProviders. Restricted key figures are key figures that are restricted by one or more characteristics13.
• Integrate SAP HANA HDI calculation views: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can integrate SAP HANA HDI calculation views as part of its data sources, using a virtual table or an external SAP HANA view. This can enable mixed modeling scenarios that leverage both SAP BW/4HANA and SAP HANA capabilities14.