Free SAP C_BW4H_214 Exam Dumps Questions & Answers

You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? Note: There are 2 correct answers to this question.

• A.  InfoObjetc of type Characteristic
• B.  Open ODS view of type Facts
• C.  Open ODS view of type Master Data
• D.  Calculation View of type Dimension

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

• A.  Referential join
• B.  Inner join
• C.  Hierarchy join
• D.  Text join
• E.  Full outer join

Which disadvantages should you keep in mind when you set the High Cardinality flag for a characteristic? Note: There are 2 correct answers to this question.

• A.  SID numbers are created at runtime which might negatively affetct the reporting performance
• B.  You cannot use navigation attributes for this characteristic
• C.  You cannot use this characteristic as a navigation attribute for another characteristic.
• D.  You cannot load more than 2 billion master data records for this characteristic

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.  Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.
• B.  Combine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations.
• C.  Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.
• D.  Include CUSTOMER to rows in the BW Query on CUSTOMER and activate the Universal Display Hierarchy setting.
• E.  Combine CUSTOMER, CITY and COUNTRY in a Composite Provider using a sequence of left outer join operators.

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.  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
• B.  Only one result row with the sales revenue sum of all 100 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 100 customers
• D.  Only one result row with the sales revenue sum of the top 10 customers