Practice Free C_BW4H_214 Exam Online Questions
You create a generic DataSource in SAP ERP. "
How can you enable your generic DataSource to be used as an ODP_SAP DataSource in SAP BW/4HANA in casa it is not available by default?"
- A . Release the DataSource in SAP BW/4HANA for ODP
- B . Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource
- C . Generate the PSA table of the DataSource in SAP BW/4HANA
- D . Add a subscription in SAP ERP using the program RODPS_REPL_TEST.
For which use case would you need to model a transitive attribute?
- A . Report on navigational attributes of navigational attributes
- B . Store time-dependent snapshots of master data attributes
- C . Load attribute using the enhanced master data update
- D . Generate a transient provider for a BW query on master data attribute
You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question.
- A . Analysis
- B . Components
- C . Information
- D . Design Rules
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?
- A . Customer Exit
- B . Manual Input with offset value
- C . Replacement Path
- D . Manuel Input with default value
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?
- A . Switch from an aggregation node to a star join node
- B . Switch from an aggregation node to a projection node
- C . Switch form a projection node to an aggregation node
- D . Switch from a projection node to a star join node
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?
- A . Only one result row with the sales revenue sum of all 100 customers
- B . Only one result row with the sales revenue sum of the top 10 customers
- C . 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
- D . 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
What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?
- A . 7
- B . 10
- C . 3
- D . 5
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."
- A . Combine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations.
- B . Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.
- C . Combine CUSTOMER, CITY and COUNTRY in a Composite Provider using a sequence of left outer join operators.
- D . Include CUSTOMER to rows in the BW Query on CUSTOMER and activate the Universal Display Hierarchy setting.
- E . Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.
What foundation is necessary to use SAP S/4HANA embedded analytics?
- A . SAP HANA optimized business content
- B . SAP Agile Data Preparation
- C . Generated external SAP HANA Calculation Views
- D . ABAP CDS view based virtual data model.
"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?
- A . SID values are not stored for InfoObject ADDRESS
- B . SID values are generated when data for infoObject ADDRESS is loadet
- C . SID values are generated when InfoObject CITY is activated
- D . SID values are generated when InfoObject ADDRESS is activated.