SAP Certified Application Associate - SAP HANA (Edition 2015) - C_HANAIMP151 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A calculation view that joins one fact table with dimension tables performs slowly.
Which of the following can you do to improve performance?

A. Turn the calculation view into a simple calculation view. B. Load the calculation view into memory. C. Load the calculation view into the _SYS_BI schema. D. Turn the calculation view into an analytic view.

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA?

A. It allows re-use of your available SAP BW application servers. B. The sizing of your current SAP BW application servers remains valid. C. The system usage is the same as an equivalent SAP BW on non-SAP databases. D. It allows co-deployment of the SAP BW application server on the SAP HANA database hardware. E. It eliminates the need to upgrade to the latest SAP BW application version.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 3

You want to restrict access to SAP HANA information models based on user groups. The models are accessed through an SAP BusinessObjects report.
In which of the following can you implement these restrictions?

A. The universe B. The restricted measures C. The schema mapping D. The analytic privileges

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

In a graphical calculation view you specify the default client to be dynamic.
How is the client value determined when the view is used?

A. By executing a procedure in the user's own schema B. By applying the filtering conditions on the client field C. By reading the client of the tables in the view D. By checking the session client of the user accessing the view

Discussion 0

Correct Answer: D Vote an answer

Question 5

An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution.
Which of the following could you check to resolve the error?

A. The business layer B. The SAP HANA information model C. The business view D. The Web Intelligence report variables

Discussion 0

Correct Answer: A,B Vote an answer

Question 6

What are characteristics of a constraint filter?

A. It is applied on the result set of an SQL query. B. It is defined during the design time on a table. C. It is defined during the runtime in the SQL query. D. It is applied on a table before the query execution.

Discussion 0

Correct Answer: B,D Vote an answer

Question 7

In which engines is an analytic view executed that contains a calculated column?

A. Calculation engine B. Join engine C. OLAP engine D. Row store engine

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

In a fuzzy search, when would you perform a freestyle search?

A. When you want to search with a high fuzziness threshold B. When you want to search in multiple columns C. When you want to search with a low fuzziness threshold D. When you want to search in only one column

Discussion 0

Correct Answer: B Vote an answer

Question 9

How can you improve the performance of a scripted calculation view?

A. Combine analytic views using a CE_JOIN function B. Read data from column tables using nested SELECT statements C. Convert SQL code to equivalent CE functions D. Combine data from the row store and column store

Discussion 0

Correct Answer: C Vote an answer

Question 10

What does SAP HANA smart data integration use for data provisioning?

A. Database triggers B. Database logs C. SAP HANA smart data access D. Real-time adapters E. SAP HANA smart data streaming

Discussion 0

Correct Answer: B,C,D Vote an answer

Question 11

You modify an existing view. How can you determine which models are affected by this
change?

A. Use the "Auto Documentation" to compare the object version of the changed model. B. Use the "Where-Used List" feature for the changed model. C. Use the audit trail. D. Use the History feature for the changed model.

Discussion 0

Correct Answer: B Vote an answer

Question 12

Which of the following are characteristics of using a Rapid Deployment Solution (RDS), such asOperational Reporting for SAP HANA?

A. Relevant tables are replicated. B. SAP will create information models based on customer requirements. C. Pre-designed information models are imported into SAP HANA. D. Customized tables and columns are replicated.

Discussion 0

Correct Answer: A,C Vote an answer

Question 13

Which of the following remote data sources can you access with SAP HANA smart data access?

A. SAP Sybase Adaptive Service Enterprise B. Apache Hadoop C. Teradata Database D. Microsoft SQL Server E. SAP NetWeaver Business Warehouse

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 14

You have created several information models. A colleague has to create new tables in the existing schema and extend your information models.
Which privileges do you give to your colleague?

A. Package privileges B. Object privileges C. Analytic privileges D. System privileges

Discussion 0

Correct Answer: A,B Vote an answer