Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.
A. When the table is accessed, all columns of a single record are processed.
B. The values in the columns are different. Therefore, data compression would NOT have much effect.
C. The table will be integrated into a native SAP HANA calculation view.
D. Aggregation and fast search is required for query execution.
Which source types can you use for a generic DataSource? Note: There are 2 correct answers to this question.
A. Function module
B. SAP HANA calculation view
C. DB view or table
D. Core data service view
For which activity do you use the key figure matrix?
A. List properties of the data sources.
B. Structure the information from the requirement analysis.
C. Allocate project resources.
D. Provide information on the relations between characteristics.
Which advantages does the SAP Lumira template for generic analysis provide? Note: There are 2 correct answers to this question.
A. You can create a bookmark to a navigation state and link it on any Web page.
B. You can compare two DataSources in one report.
C. You can use Visual Basic for Applications to improve the design.
D. You can use it for any BW query or SAP HANA calculation view.
When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.
A. The structure will contain formulas.
B. The structure will depend on the order of the row characteristics.
C. The structure exists in the source system.
D. The hierarchical structure will be time-dependent.
E. The query data will be restricted to a hierarchy node.
You loaded a 5 MB table from a source system to SAP BW/4HANA. How do you explain that the size of the table is reduced to 1 MB?
A. The target is defined as coiumn store without delta merge execution.
B. The target is defined as column store and a delta merge job was executed.
C. The target is defined as row store without delta merge execution.
D. The target is defined as row store and a delta merge job was executed.
You need to restrict a sales report to the products that make up 50% of the total revenue. Which BW query feature do you use?
A. Restricted key figure
D. Calculated key figure
You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider. What must you do first?
A. Create an Open ODS view with consumption properties to consume the data in the SAP BW/4HANA schema.
B. Connect an export DataSource from the exisiting CompositeProvider to the new CompositeProvider.
C. Set The CompositeProvider Can Be Added to Another CompositeProvider flag.
D. Assign consumption properties to the new SAP HANA calculation view.