C-HANAIMP-1 무료 덤프문제 온라인 액세스

You have created an analytic view and an analytic privilege that filters on 3 attributes:
-Sales region = "West"
-Sales channel = "Online", "Retail"
-Product category = "Electronics".
After granting the analytic privilege to a user, what data can the user see?
A)

B)

C)

D)

• A.Exhibit B
• B.Exhibit A
• C.Exhibit D
• D.Exhibit C

What is an example of a selective data load using SAP Landscape Transformation?

• A.Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.
• B.Selected data field values are randomized and loaded into SAP HAN
• C.Selected data for a range of years is loaded into SAP HANA.
• D.Selected data for transformation is split into portions.

When you create a report in SAP BusinessObjects you notice that some columns of your SAP HANA information model are not available in the report.
How can you make the columns available? (Choose two)

• A.Add the columns to the business layer.
• B.Add the columns in SAP Landscape Transformation replication.
• C.Add the columns to the source table in the catalog node in SAP HANA studio.
• D.Add the columns to the query panel of the report.

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 count on the number of columns in the PRODUCT_NAME table that contain the term 'Paper'.
• D.It performs a fuzzy search on all columns in the PRODUCT_NAME table for the term 'Paper'.

Which types of calendar are available for time attribute views in SAP HANA? (Choose two)

• A.Julian
• B.Gregorian
• C.Fiscal
• D.Factory