Online Access Free C-HANAIMP142 Practice Test

You want to allow another developer to access the information models in one of your packages.
What privilege do you have to assign to this user to allow access?

• A.REPO.MAINTAIN_NATIVE_PACKAGES for the package
• B.SELECT on _SYS_REPO with the grant option
• C.SELECT on _SYS_REPO
• D.REPO.READ for the package

What is the function of an aggregation node in a calculation view?

• A.It joins the result sets from different data sources.
• B.It provides grouping of filter criteria.
• C.It calculates the sum, minimum, or maximum values for selected columns.
• D.It allows grouping of columns required for your information model.

Your information model needs real-time access to external data stored in Microsoft SQL Server 2011.
How can you implement this scenario in SAP HANA? (Choose two)

• A.Create a virtual table and use it in a calculation view
• B.Create a virtual table and use it in attribute view
• C.Perform replication using SAP Replication Server
• D.Create a batch job in SAP Data Services

Which of the following CE functions can you use to query an analytic view directly?

• A.CE_OLAP_VIEW
• B.CE_JOIN_VIEW
• C.CE_AGGREGATION
• D.CE_CALC

You work with an information model on SAP HANA that contains sales data for all regions.
Which of the following modeling techniques can you use to define re-usable columns per region?

• A.Input parameters
• B.Constraint filters
• C.Analytic privileges
• D.Restricted columns