Practice Free C_BW4H_214 Exam Online Questions
Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct answers to this question.
- A . Changing context menu entries
- B . Dragging measures in and out of the report
- C . Displaying data simultaneously in a table and a chart
- D . Including more than one data source
- E . Creating bookmarks for a navigation state
Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project? Note: There are 3 correct answers to this question.
- A . Check the availability of data
- B . Specify necessary data conversion
- C . Implement transport routes and layers
- D . Monitor batch jobs and data volume
- E . Design the data layer concept
You would like to highlight the deviation from predefined threshold values for key figures actual revenue.
Which BW feature do you use?
- A . Structure
- B . Conditions
- C . Exceptions
- D . Calculated key figures
Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question
- A . Use fewer drill-down characteristics in the initial view
- B . Use characteristic filters that overlap
- C . Use exclude functions in the restricted key figures
- D . Use mandatory characteristic value variables
- E . Use include functions in the restricted key figures.
You are following a top-down method for your SAP BW/4HANA modeling project.
What would be your first task?
- A . Check available sources in the SAP ERP system
- B . Collect reporting requirements
- C . Determine if physical or logical objetcs will be needed
- D . Determine enhancements of SAP Business Content
You create a transformation from a DataSource to a DataMart Data Store 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.
- A . ABR
- B . ADD
- C . AIM
- D . AIE
What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.
- A . By using a transformation and data transfer process
- B . By entering the values manually
- C . By referencing a table
- D . By using a query
- E . By accessing an SAP HANA Calculation View of data category Dimension
You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different atribute values assigned.
How do you desing the model?
- A . Compound characteristic "COSTOBJ" with the characteristic for Controlling Area
- B . Compound the characteristic for Controlling Area with the characteristic "COSTOBJ"
- C . Define Controlling Areas as a navigation attribute for the characteristic "COSTOBJ"
- D . Define characteristic "COSTOBJ" as a navigation attribute for Controlling Area
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?
- A . The BW query starts and shows an error message
- B . The BW query does not start running
- C . The BW query starts and the unautohorized values are
- D . The BW query starts and only the authorized data is displayed
In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data’s language-dependent text (right table) using a text join.
What should you select to restrict the result set to the logon language?
- A . the language column in the left table
- B . the language column in the right table
- C . The logon language in the left table
- D . The join cardinality between both tables