SAP SAP Certifications C_TBW50H_75 Questions & Answers

• Question 21:

  Which of the following is required to perform currency conversion in an SAP HANA information model?

  A. An innerjoin is required between the Open ODS View measures and the exchange rate table

  B. A set of technical tables are required to store currencies and exchange rate types and rates

  C. Setting a semantic type to a measure so the amount always includes a currency

  D. Storing the currency and the exchange rate on the day of the transaction will improve performance

  E. An interface to define how the currency conversion should be processed

  Correct Answer: BCE

• Question 22:

  Temporal conditions can be defined on columns of the following data types: timestamp, date, and text. Determine Whether this statement is true or false.

  A. True

  B. False

  Correct Answer: B

• Question 23:

  Which of the following are the correct terminology about hierarchies? Choose the correct answers.

  A. An entity in a hierarchy is called a node

  B. Nodes that have no parents are called orphan nodes

  C. Nodes that have no children nodes are called leaf nodes or leaves

  D. A relationship between a node and its parent node is called a family tree

  E. A hierarchy with leaves on different levels is an unbalanced hierarchy

  Correct Answer: ACE

• Question 24:

  Business Content available for SAP BW on SAP HANA uses the LSA++ design concept with a DataSource, a Corporate Memory, and a persistent propagator ADSO. Determine Whether this statement is true or false.

  A. True

  B. False

  Correct Answer: B

• Question 25:

  Open ODS Views enable you to define SAP BW data models for objects like database tables, database views or BW DataSources (for direct access). Determine Whether this statement is true or false.

  A. True

  B. False

  Correct Answer: A

• Question 26:

  Data model definition is an activity carried out in the realization phase of a BW Project. Determine Whether this statement is true or false.

  A. True

  B. False

  Correct Answer: B

• Question 27:

  In developing a logical data model, SAP Best Practice is to build the model using a top-down, key figure approach or a bottom--up DataSource approach. Determine Whether this statement is true or false.

  A. True

  B. False

  Correct Answer: A

• Question 28:

  Business Content available for SAP BW on SAP HANA uses the LSA++ design concept with a DataSource, a Corporate Memory and a persistent propagator ADSO. Determine Whether this statement is true or false.

  A. True

  B. False

  Correct Answer: A

• Question 29:

  Which of the following statements are true regarding the difference between compounding and concatenation?

  A. Compounding is easier to filter in queries because the objects are separate whereas with concatenation, the key string needs to be masked

  B. Compounding is easier for users to understand because it is based on a 1:1 object mapping but concatenation is more complex for users to understand and decipher

  C. Concatenation uses a single key value but compounding uses more than one

  D. Adding key fields in concatenation is easier because only the transformation needs to be changed but in compounding structures need to be changed and data re-loaded

  E. Compounding is supported in the definition of the lnfoObject whereas concatenation requires the creation of new database tables

  Correct Answer: ABCD

• Question 30:

  Which of the following are ways in which joins can be made using SAP BW on SAP HANA?

  A. A BW lnfoSet can be used to create a temporal join

  B. A native SAP HANA calculation view can perform inner and outerjoins

  C. An Advanced DSO can create joins between master data and transaction data

  D. BW Composite Provider can provide inner and outer joins

  E. Transformations can perform joins of multiple DataSources

  Correct Answer: ABD