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

When you create a full text index, why do you specify FAST_PREPROCESS OFF?

• To avoid the generation of the term document matrix
• To prevent the creation of a fuzzy search index
• To generate text analysis results in multiple languages
• To enable a full linguistic search

You created a table using the SQL conSQLe inside the HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it. What do you observe inthe SAP HANA database container?

• The build is successful, and you get the expected data.
• The build fails, and the table is dropped.
• The build fails but the table is not dropped.
• The build is successful, but the data preview is empty.

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.

What restrictions apply to a Graph node that you include in a calculation view?

• It must be the first node in the dataflow.
• It must be the final node in the dataflow.
• Its data source must be provided by a projection node.
• It cannot be included in a calculation view of type dimension.

Which tool do you use to display the generated SQL for each node of your calculation view?

• SQL Analyzer
• Debug Query Mode
• Plan Visualizer
• Performance Analysis Mode

Which of the following are warm tier Solutions Note: There are 3 correct answers?

• Active / active read-enabled mode
• Native Storage Extension
• Extension Node
• Dynamic Tiering
• Persistent Memory

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

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

You combine two tables in a join using multiple columns in each table. Why do you enable the dynamic join option?Note: There are 2 correct answers to this question.

• To allow data analysis at different levels of granularity with the same calculation view.
• To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query.
• To ensure that the join execution only uses the join columns requested in the query.
• To improve execution time under specific query conditions.

You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?

• Define a union node as the start of the parallelization block.
• Define a projection node as the end of the parallelization block.
• Assign tables as the only data sources in the nodes that start the parallelization block.
• Define a source column as partitioning value in the start node of the parallelization block.

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.