In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure?
A. SUM
B. COUNT
C. MIN
D. MAX
Which privilege type do you have to assign to a role, when you want to provide row-level access to data?
A. ANALYTIC
B. SQL
C. SYSTEM
D. PACKAGE
How can you improve the quality of your information model design? (Choose three.)
A. Design your views to be reusable.
B. Use 'case' or 'if statements whenever possible.
C. Modularize your views.
D. Avoid duplications in your modeling
E. Use row-based database expressions
Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?
A. Information model recovery
B. Automatic backup of archiving log files scheduled within SAP HANA
C. Point-in-time recovery
D. Incremental backup
An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution. Which of the following could you check to resolve the error? (Choose two.)
A. The Web Intelligence report variables
B. The business view
C. The SAP HANA information model
D. The business layer
Which of the following describes an SAP HANA analytic view?
A. It is a set of tables joined together in a star schema.
B. It is a copy of data after transformation.
C. It is a materialized set of data.
D. It is a reusable object in attribute views.
Which of the following tools can you use to load data into SAP HANA from SAP DataSource extractors? (Choose two.)
A. SAP Landscape Transformation Server
B. SAP Sybase Replication Server
C. SAP Direct Extractor Connection
D. SAP Data Services
In which of the following can you use a FOR loop over your data?
A. Analytic View
B. Monitoring View
C. Calculation View
D. Analytic View
Which new connection type is available as of SAP BusinessObjects Data Services 4.0?
A. Operational Data Provider
B. Read table via ABAP data flows
C. IDOCs
D. BAPI function calls
In an SAP S/4HANA system, you have two profit centers with the same profit center code and the same validity period, but different names. What does this indicate about the configuration of the profit centers?
A. They are defined in separate company codes.
B. They are defined in separate controlling areas.
C. They are assigned to different functional areas.
Which information model can you use with measures from multiple fact tables?
A. Analytic view
B. Calculation view
C. Attribute view
D. Analytic privilege
Which of the following are advantages of running SAP HANA Live embedded in the SAP Business Suite? (Choose three.)
A. It allows using generic virtual data models
B. It provides real-time replication
C. It provides real-time operational reporting
D. It uses the generic capabilities of SAP HANA such as the XS Engine
E. It runs in older versions of the SAP Business Suite
Is it possible to post a value directly to a standalone profit center?
A. Yes
B. No
For which SAP HANA data types is a FULLTEXT index created automatically during table creation? (Choose two.)
A. NCLOB
B. VARCHAR
C. TEXT
D. SHORTTEXT
How can you improve the performance of an information model? (Choose three.)
A. Use analytic views wherever possible.
B. Use attribute views wherever possible.
C. Use constraint filters.
D. Use generated columns.
E. Use indexes on all measures.