New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium SAP C_HANAIMP_18 Dumps Questions Answers

SAP Certified Application Associate - SAP HANA 2.0 SPS06 Questions and Answers

Question 1

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

Options:

A.

Count-distinct results are incorrect

B.

Results are read from static cache

C.

Query processing time improves

D.

SQL compilation time increases

Buy Now
Question 2

Why might you use the Keep Flag property in an aggregation node?

Options:

A.

To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

B.

To retain the correct aggregation behavior in stacked views

C.

To include columns that are NOT requested by a query but are essential for the correct result

D.

To exclude columns that are NOT requested by a query to avoid incorrect results

Question 3

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

Options:

A.

Partition large tables.

B.

Limit the number of stacked calculation views.

C.

Implement union pruning.

D.

Avoid aggregating data early in the data flow.

Question 4

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

Options:

A.

An organization hierarchy that provides role-based access to data.

B.

A table function that returns a list of allowed values.

C.

A scalar function that returns a list of the allowed values for each attribute.

D.

A procedure that returns the data access condition as an SQL expression.

Question 5

Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

Options:

A.

Dynamic

B.

Hierarchy function

C.

SQL expression

D.

Attributes

E.

Graph

Question 6

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

Options:

A.

Expected memory consumption

B.

Usage statistics of the calculation view

C.

Joins that are defined on calculated columns

D.

Information about join cardinality

Question 7

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

Options:

A.

To ensure specific columns are NOT exposed to the reporting tool

B.

To avoid exposing sensitive columns when defining calculated columns

C.

To prevent passing columns in stacked calculation views

D.

To remove a column that is also used as a Label column

Question 8

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

Options:

A.

You have not defined the HDI build plug-in version.

B.

Your HDB module references a user-provided service that does not exist.

C.

You have not assigned the project to a space.

D.

You have not built the project yet.

Question 9

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

Options:

A.

Execute a DROP statement in an SQL console connected to the HDI container.

B.

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

C.

Execute the refactor function for the calculation view.

D.

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

Question 10

Which are the components of SAP HANA Cloud?Note: There are 3 correct answers to this question.

Options:

A.

SAP Data Warehouse Cloud

B.

SAP HANA Cloud data lake

C.

Native Storage Extension

D.

SAP Analytics Cloud

E.

SAP HANA in-memory database

Question 11

Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question.

Options:

A.

Extension Node

B.

Persistent memory

C.

Native Storage Extension

D.

Dynamic Tiering

E.

Active / active read-enabled mode

Question 12

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to build the calculation view, the build fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

Options:

A.

The imported calculation view and its data source have different namespaces.

B.

The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

C.

The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

D.

An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.