SAP SAP Certifications C_TBW50H_75 Questions & Answers

• Question 41:

  Which of the following are Best Practice options for storing data in a BW system running on SAP HANA?

  A. Store the bulk of the data on disk for retrieval when required (warm data)

  B. Store the most relevant data in a compressed column store (hot data)

  C. Split the most relevant data by date and store between an uncompressed column store and tables stored on disk (warm data)

  D. Store all data in compressed column stores to maximize performance (hot data)

  E. Move less important data into an external storage system (cool data)

  Correct Answer: ABE

• Question 42:

  Identify issue affecting query performance that you, as a BI administrator, are responsible for officially.

  A. Query design

  B. CPU selection

  C. Aggregates

  D. Memory utilization and availability

  Correct Answer: C

• Question 43:

  Identify issue affecting query performance that you, as a BI administrator, are responsible for.

  A. Compression

  B. Data model

  C. Web page design and Java scripting

  D. Read mode

  Correct Answer: ABD

• Question 44:

  Database statistic is the same thing as BI Statistics. Determine whether the statement is True or False.

  A. True

  B. False

  Correct Answer: B

• Question 45:

  SAP HANA provides a choice of row or column storage types. Determine whether this statement is true or false.

  A. True

  B. False

  Correct Answer: A

• Question 46:

  Modeling with SAP HANA, you can use a virtual table in a view. Which of the following are advantages of this virtual data model?

  A. Fewer objects are needed

  B. The model is highly flexible

  C. The data footprint is reduced

  D. Data is only replicated once

  E. The data is always up to date

  Correct Answer: ABCE

• Question 47:

  The concept of storage separation in SAP HANA means that delta data is stored on disk to minimize the demand on main memory. Determine whether this statement is true or false.

  A. True

  B. False

  Correct Answer: B

• Question 48:

  Why are DataStore Objects so important? Choose the correct answer(s).

  A. They can overwrite data.

  B. They store detailed data leaving Infocubes to store aggregated data.

  C. They allow for raw uncleansed data to be stored for 3 months.

  D. They easily integrate in the data flow.

  Correct Answer: ABD

• Question 49:

  Which of the following statements are true?

  A. InfoSets joni more than one target to a logical set for reporting.

  B. RDA supports operational reporting.

  C. VirtualProviders can cause a load on the OLTP system and BI at the same time.

  D. You have more to learn.

  Correct Answer: ABCD

• Question 50:

  What are some typical administration tasks?

  A. Remodeling

  B. Request Archiving

  C. Document indexing

  D. System settings

  Correct Answer: ABCD