Online Access Free C_HANAIMP151 Practice Test

What are characteristics of a constraint filter?

• A.It is defined during the runtime in the SQL query.
• B.It is applied on the result set of an SQL query.
• C.It is applied on a table before the query execution.
• D.It is defined during the design time on a table.

Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?

• A.All active and inactive versions
• B.The last active and inactive version
• C.Only the last active version
• D.All active versions

You have to do reverse pivot transformations on large data tables before loading the data into SAP HANA.
Which of the following do you recommend to use?

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

You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this?

• A.Choose an attribute to define restricted values for it.
• B.Assign the analytic privilege to a user or role.
• C.Assign values to be restricted to a content table.
• D.Assign values to be restricted. Choose at least one information model to assign restrictions.
• E.Assign restricted values to the attribute view.

You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view?

• A.Join types
• B.Analytic views
• C.Attribute views
• D.Tables
• E.User privileges