Online Access Free C-HANAIMP-1 Exam Questions

You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement?

• A.Use table indexing
• B.Use CE functions
• C.Use SQL statements
• D.Use L programming

During loading of data into SAP HANA you want to filter the source data.
Where can you apply the filters? (Choose two)

• A.In a row generation transformation in SAP BusinessObjects Data Services
• B.In a query transformation in SAP BusinessObjects Data Services
• C.In an ABAP code rule in SAP Landscape Transformation (SLT)
• D.In a SQL WHERE clause in SAP Landscape Transformation (SLT)

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 calculation view using an attribute value variable
• B.In the analytic view
• C.In the Web Intelligence report
• D.In the universe

What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA? (Choose three)

• A.You can perform real-time data replication.
• B.You can use the same hardware.
• C.You can load unstructured data into SAP HAN
• D.You can use BI Content extractors or function modules.
• E.You can merge data streams.

What does the following SQL statement do?
SELECT
SCORE() as SCORE, PRODUCT_NAME, *
FROM
PRODUCT_ITEMS
WHERE
CONTAINS(*,'Paper', FUZZY(0.8))
ORDER BY
PRODUCT_NAME

• A.It performs a fuzzy search on the PRODUCT_NAME column in the PRODUCT_ITEMS table for the term 'Paper'.
• B.It performs a fuzzy search of all columns in the PRODUCT_ITEMS table for the term 'Paper'.
• C.It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'.
• D.It performs a fuzzy search count on the number of columns in the PRODUCT_NAME table that contain the term 'Paper'.