Exit demo C_HANAIMP_17 SAP Certified Application Associate - SAP HANA 2.0 (SPS05) PDF format · free preview

In this set

Single choice 49

Multiple choice 31

Free demo preview

10 sample questions

Full product includes 80 questions.

Purchase the full set to unlock every question in your account.

PDF & Online Q&As

PDF + online access Study in your browser or print a clean PDF copy.

Answer key included Check your choices while you study.

Reviewed content Question sets are maintained for exam prep use.

15 years online A long-standing team focused on exam Q&A products.

SAP C_HANAIMP_17 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/c-hanaimp-17.html

Question 1

Single choice

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.

What is the correct approach?

Combine the transaction tables using a join node in a calculation view of type cube.
Use the multi-join capability of the join node to connect the transactional tables with the dimension calculation views.

Combine the transaction tables using a star join node in a calculation view of type cube with star join.
Use a join node to join the dimensions to the fact table.

Combine the transaction tables using an aggregation node in a calculation view of type cube with star

join.
Use a star join node to join the dimensions to the fact table.

Combine the transaction tables using a join node in a calculation view of type cube with star join.
Use a star join node to join the dimensions to the fact table.

Question 2

Single choice

A calculation view consumes the data sources shown in the graphic. You want to identify which companies SQLd products in January 2018 AND February 2018.

What is the optimal way to do this?

Use a full outer join.

Use a union node.

Use an left outer join.

Use an intersect node

Question 3

Single choice

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view.
Afterward, you perform the following build operations:

*Build the dimension calculation view as a single object.

*Build the entire SAP HANA database module.

What is the outcome of the build operations?

The first build fails.
The second build fails.

The first build is successful.
The second build is successful.

The first build fails.
The second build is successful.

The first build is successful.

The second build fails.

Question 4

Multiple choice

What do you use a hierarchy function for? Note: There are 3 correct answers.

Calculate distance between root and each hierarchy node

Identify hierarchy nodes that have no parent

Count the number of siblings for each hierarchy node

Determine the shortest path between each pair of nodes

Describe the relationship between nodes using attributes

Question 5

Multiple choice

You import a project that includes an SAP HANA database(HDB) module to your workspace. You need to create a calculation view that uses data from one table located in an external schema. Which of the following items must you build?

Note: There are 2 correct answers to this question.

Synonym

.hdinamespacefile

Authorization

Project

Question 6

Multiple choice

When using the CONTAINS predicate, what are the restrictions you must keep in mind? Note: There are 2 correct answers to this question.

Non-physical columns, such as calculated columns, are not search-relevant.

The NOT (-) operator can only be specified directly after the OR operator.

Wild cards * and ? are supported for text columns but not string columns.

If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.

Question 7

Multiple choice

You deleted the design-time file of a calculation view in your HDB module.

Which of the following is the optimal way to ensure that the corresponding runtime object is also removed from the database? Note: There are 2 correct answers to this question.

Delete the folder that contained the deleted design-time file.

Build the folder that contained the deleted design-time file.

Build the project that contained the deleted design-time file.

Run a DELETE statement in an SQL console connected to the HDI container.

Question 8

Single choice

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 in the 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.

Question 9

Single choice

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.

Question 10

Single choice

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 new features 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.

Showing 10 of 80 questions · Unlock the full set