SAP Certified Application Associate - SAP HANA 2.0 (SPS05) - C_HANAIMP

Question 1

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

A. The imported calculation view and its data source have different namespaces. B. The name space 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 sub-folders. D. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view.

Discussion 0

Correct Answer: A,B Vote an answer

Question 2

What is the disk storage layer used for?
Note: There are 2 correct answers to this question.

A. To enable data to be recovered if hardware fails B. To improve the parallel processing of queries C. To unload the least-used data when the memory is full D. To store the data primarily used for transactional processing

Discussion 0

Correct Answer: A,C Vote an answer

Question 3

Why do you use a hierarchy function node in a calculation view?

A. To generate additional Meta data that can be used for analysis of a hierarchy structure B. To display value help using hierarchies C. To assist the developer by visualizing hierarchies D. To enable hierarchical navigation in reporting tools

Discussion 0

Correct Answer: A Vote an answer

Question 4

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?

A. The first build is successful.
The second build fails. B. The first build is successful.
The second build is successful. C. The first build fails.
The second build fails. D. The first build fails.
The second build is successful.

Discussion 0

Correct Answer: B Vote an answer

Question 5

What are the components of a graph workspace?
Note: There are 2 correct answers to this question.

A. Edge B. Vertex C. Association D. Dimension

Discussion 0

Correct Answer: A,B Vote an answer

Question 6

Which of the following allows data replication?

A. SAP HANA smart data integration B. SAP HANA streaming analytics C. SAP HANA smart data quality D. SAP HANA smart data access

Discussion 0

Correct Answer: A Vote an answer

Question 7

What are the key steps to implement currency conversion in a calculation view?

A. Enable the measure for conversion
Choose client, source and target currencies Choose conversion date and rate type Build the conversion rule B. Enable the measure for conversion
Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view C. Assign semantic type
Enable the measure for conversion
Choose client, source and target currencies Choose conversion date and rate type D. Assign semantic type
Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column

Discussion 0

Correct Answer: C Vote an answer

Question 8

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation view?

A. SELECT or Privileges and Analytic Privileges on both views B. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view C. A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view D. Analytic Privileges and SELECT privileges on the CUBE Calculation view

Discussion 0

Correct Answer: C Vote an answer

Question 9

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?

A. Use a full outer join. B. Use an left outer join. C. Use an intersect node D. Use a union node.

Discussion 0

Correct Answer: C Vote an answer

SAP Certified Application Associate - SAP HANA 2.0 (SPS05) - C_HANAIMP_17 FREE EXAM DUMPS QUESTIONS & ANSWERS