Which types of calendar are available for time attribute views in SAP HANA? (Choose two)
A. Fiscal
B. Factory
C. Gregorian
D. Julian
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
When building a business layer to report on SAP HANA, what do you have to do if you want to display more than 5,000 rows?
A. Remove all filters from the analytic views.
B. Deactivate the Limit Size of Result Set parameter in the Central Management Console.
C. Set the Array Fetch Size parameter to the maximum in the relational connection.
D. Deactivate the Limit Size of Result Set parameter in the business layer.
You model hierarchies in attribute views. Which of the following technologies do you use to make these hierarchies available for reporting tools?
A. JDBC
B. BICS
C. ODBO
D. ODBC
What is one of the advantages of using SAP BusinessObjects Analysis, edition for Microsoft Office?
A. Direct access to attribute views in SAP HANA
B. Direct access to column tables in SAP HANA
C. Direct connection to SAP HANA via MDX
D. Direct connection to SAP HANA via BICS
You want to test the quality of SAP HANA data by using a set of results from the source system. How can you retrieve the required data from SAP HANA? (Choose three)
A. Use SAP Landscape Transformation (SLT).
B. Use the data preview in SAP HANA studio.
C. Use an SAP BusinessObjects client tool (such as Explorer or Web Intelligence).
D. Use the database schema _SYS_REPO.
E. Write and execute an appropriate SQL statement.
What are benefits of using a business layer on top of SAP HANA? (Choose two)
A. An extra layer of granular security
B. Improved database calculation speed
C. Fast throughput via BICS connectivity
D. Users can use business names instead of technical names
You develop a disaster recovery plan. What do you have to consider in case of a disk failure? (Choose three)
A. Configuration files can be restored automatically.
B. Savepoints can be backed up.
C. Log volumes can be backed up.
D. Non-committed transactions can be recovered.
E. Committed transactions can be recovered.
What is the behavior of a Text Table Join where language column SPRAS is available?
A. Left Outer Join
B. Right Outer Join
C. Inner Join
D. Referential Join
When you activate an analytic view, a column view is created. In which schema is this column view stored?
A. _SYS_BIC
B. _SYS_BI
C. _SYS_REPO
D. _SYS