Online Access Free C_HANAIMP151 Practice Test

You create a role with the following command: CREATE ROLE "InfoUser"
When you try to assign this role to user PETER with the following command:
GRANT InfoUser to PETER you receive an error message "Invalid user privilege: INFOUSER".
What must you do to avoid this problem?

• A.Recreate the role with the command CREATE ROLE InfoUser.
• B.Grant the role the WITH ADMIN OPTION.
• C.Recreate user PETER with GRANT OPTION.
• D.Recreate the role with the command CREATE ROLE INFOUSER.
• E.Grant the role with the command GRANT "InfoUser" to PETER.

What is the behavior of a Text Table Join where language column SPRAS is available?

• A.Left Outer Join
• B.Referential Join
• C.Right Outer Join
• D.Inner Join

Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA?

• A.SAP BusinessObjects Data Services
• B.SAP Landscape Transformation (SLT)
• C.SAP System Landscape Directory (SLD)
• D.SAP HANA Direct Extractor Connection (DXC)
• E.Open hub

Which type of connection does Direct Extractor Connection (DXC) use to transfer data to SAP HANA?

• A.RFC connection
• B.http connection
• C.Secondary database connection
• D.ODBC connection

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