C-HANAIMP142 by SAP Valid Free Exam Practice Test

Question 1

Which of the following nodes do you use to implement filters in a graphical calculation view? (Choose two)

A. Join B. Aggregation C. Projection D. Union

Correct Answer: B,C

Question 2

You implemented SAP-delivered business content on SAP HANA. When you try to activate the business content the activation fails.
What could be a reason for this?

A. The schema mapping was not set up correctly. B. You have not created a calculation view to expose the data to the users. C. The import of business content was performed with the _SYS_REPO user. D. The data has not been loaded into SAP HANA memory yet.

Correct Answer: A

Question 3

Which of the following data provisioning tasks can you perform in the SAP HANA studio? (Choose three)

A. Configure remote sources for SAP HANA smart data access. B. Start replication of tables for SAP Landscape Transformation (SLT). C. Activate the SAP Web Dispatcher service for SAP HANA Direct Extractor Connection (DXC). D. Create replication configurations for SAP Landscape Transformation (SLT). E. Create an SAP ECC extractor datastore for SAP Data Services.

Correct Answer: A,B,C

Question 4

You want to investigate the runtime of a SELECT statement against an analytic view.
Which of the following tools do you use to analyze the model performance, including transferred data?

A. Load graph B. SQL Debugger C. Plan visualizer D. SQL Editor

Correct Answer: C

Question 5

Your data models use hierarchies.
In which of the following front end tools can you access these hierarchies? (Choose three)

A. SAP BusinessObjects Dashboards B. SAP Crystal Reports 2011 C. SAP Lumira D. SAP BusinessObjects Analysis, edition for Microsoft Office E. SAP BusinessObjects Analysis, edition for OLAP

Correct Answer: C,D,E

Question 6

You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a data provisioning tool for SAP HANA without disturbing your BW reporting.
Which of the following are SAP recommended actions? (Choose two)

A. Create new InfoObjects for the SAP HANA InfoProviders. B. Write data back from SAP HANA into the replicated SAP NetWeaver BW tables. C. Schedule the real-time data loads into SAP HANA. D. Automate the ETL processes in SAP NetWeaver using process chains.

Correct Answer: A,D

Question 7

You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view? (Choose three)

A. Tables B. Analytic views C. Join types D. User privileges E. Attribute views

Correct Answer: A,C,E

Question 8

You discover row count discrepancies between source data and SAP HANA information models.
Which of the following can you investigate to find the source of the discrepancies? (Choose two)

A. Joins in information models. B. Client filtering in the Delivery unit view. C. Memory leaks. D. Client filtering in SAP Landscape Transformation (SLT).

Correct Answer: A,D

Question 9

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 applying the filtering conditions on the client field. B. By reading the client of the tables in the view. C. By executing a procedure in the user's own schema. D. By checking the session client of the user accessing the view.

Correct Answer: D

Question 10

Which data provisioning method can you use to load data from SAP business content DataSources into SAP HANA? (Choose two)

A. SAP Landscape Directory (SLD) B. SAP Direct Extractor Connection (DXC) C. SAP BusinessObjects Data Services D. SAP Landscape Transformation (SLT)

Correct Answer: B,C

Question 11

You have two analytic views: one contains actual data and the other contains plan data. You want to combine the two result sets and keep actual and plan data on separate records.
In the SAP HANA studio, which of the following can you use to achieve this?

A. JOIN in an analytic view B. UNION in a calculation view C. PROJECTION in a calculation view D. JOIN in a graphical calculation view

Correct Answer: B

Question 12

Which security settings can you apply in analytic privileges? (Choose two)

A. Restrict access within an analytic view using attribute values. B. Restrict access to hierarchies. C. Restrict access within an analytic view using measure values. D. Grant access to analytic views.

Correct Answer: A,D

Question 13

You have imported models from the development system. What is the recommended way to activate dependent models in SAP HANA?

A. Use the Where-Used List function. B. Use the Cascade Activate function. C. Activate each view manually. D. Use the Activate with History function.

Correct Answer: B

Question 14

Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface? (Choose two)

A. Join B. Analytic Privilege C. Aggregation D. Data Foundation

Correct Answer: A,C

SAP Certified Application Associate - SAP HANA (Edition 2014) - C-HANAIMP142 Exam Practice Test