Which of the following operations can you use when you create a calculation view using the SAP HANA studio graphical interface? (Choose two)
A. PROJECTION
B. UNION
C. INTERSECT
D. INSERT
What is the purpose of the savepoint process in SAP HANA?
A. Save changed data to the persistent storage when a transaction is committed.
B. Save logs to persistent storage when a transaction is committed.
C. Save changed data and logs to the persistent storage on a regular basis.
D. Free-up memory by saving less used data to the persistent storage.
You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?
A. In the universe
B. In the Web Intelligence report
C. In the analytic view
D. In the calculation view using an attribute value variable
How can you evaluate the speed of a calculation within the database? (Choose two)
A. Use the Data Preview function in the SAP HANA studio.
B. Execute a Web Intelligence report and check the duration of the previous refresh.
C. Execute an information space using SAP BusinessObjects Explorer.
D. Write and execute an appropriate SQL statement.
You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view? (Choose three)
A. Join types
B. Attribute views
C. User privileges
D. Tables
E. Analytic views
When must you create a calculation view in SAP HANA?
A. When you need to create a star schema
B. When key figures span across tables
C. When you need calculations before aggregations
D. When you need analytic operations like aggregation
Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server? (Choose two)
A. Create repositories in the source system.
B. Write data to the SAP HANA system using the DB connection.
C. Map database structures between SAP HANA and the source system.
D. Schedule replication processes.
Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?
A. Define the number of background work processes in SLT.
B. Define an RFC connection from SLT to SAP HANA.
C. Define a DB connection from SLT to the source system.
D. Define the number of jobs to be used for data replication.
Your customer has the following reporting requirements:
Real-time profitability reporting on large-scale data volumes On-the-fly analysis of profitability data at any level of granularity, aggregation, and dimension Cost allocation reports with significantly faster processing time
Which application do you recommend?
A. SAP Bank Analyzer with SAP HANA
B. SAP Deposits Management with SAP HANA
C. SAP HANA CO-PA Accelerator
D. SAP HANA for Banking
Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)
A. Define an output structure for the attribute view.
B. Define the data foundation.
C. Choose the type of hierarchy.
D. Define calculated attributes for the nodes of the hierarchy.
E. Define an analytic view.