Free SAP Certified Application Associate – SAP HANA 2.0 (SPS05) Exam C_HANAIMP_17 Exam Practice Test

What do you use in the definition of a dynamic SQL analytic privilege?

• A procedure that returns the data access condition as an SQL expression.
• A table function that returns a list of allowed values.
• An organization hierarchy that provides role-based access to data.
• A scalar function that returns a list of the allowed values for each attribute.

In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

• Table function
• CDS view
• Procedure
• Virtual Table

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

• Limit the number of stacked calculation views
• Avoid aggregating data early in the dataflow
• Implement union pruning
• Partition large tables

After importing a project in the workspace of the Web IDE, you try to build the HDB module. The build fails. What could be the reason?Note: There are 2 correct answers.

• The HDB module references a user-provided service that does not exist.
• You have assigned the project to a space that you do not have developer authorizations for.
• You have not built the project.
• The project is not assigned to a space.

In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?

• Vertical disaggregation
• Horizontal disaggregation
• Vertical aggregation
• Horizontal aggregation

You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?Note: There are 2 correct answers to this question.

• To restrict data access for specific users or roles
• To hide individual patients in groups of similar records
• To provide partial value such as #34343#34##
• To add noise to the data to hide the actual values

In text processing, where do you use the Term Document Matrix?

• Text mining
• Linguistic extraction
• Fuzzy text search
• Fact and entity extraction

When would you develop an SQL procedure instead of a function?

• You need to implement Data Definition Language (DDL) statements.
• The code should modify data in the table.
• Optimal performance is apriority.
• You need to use conditional logic.
• You want to create a dynamic analytic privilege.

In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join. You did NOT set cardinality of the data sources. Why will this NOT work?

• Full outer joins are restricted to one dimension in a star join node.
• Full outer joins require cardinality to beset.
• Full outer joins CANNOT be mixed in the same star join node with other join types.
• Full outer joins are NOT available in the star join node.

Your Web IDE for SAP HANA was updated to a new version. You want to implement the new features of calculation view modeling in your existing calculation views. You open a graphical calculation view but the newfeatures are not displayed.What could be the reason for this?

• You need to update the project settings to reference the new revision.
• Your calculation views have not been built in the new version of the Web IDE.
• The calculation views have not been migrated to the new revision.
• The .hdiconfig file has not been updated to the latest calculation view build plug-in.