最新的SAP Application Associate認證 C-HANAIMP142考試題庫

問題1

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

A. Join

B. Union

C. Aggregation

D. Projection

正確答案: C,D

問題2

Which of the following are required to create an attribute view? (Choose two)

A. Join

B. Key Attribute

C. Default Schema

D. Data Foundation

正確答案: B,D

問題3

You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year.
How can you achieve this? (Choose two)

A. Use a CE function.

B. Use a calculated measure.

C. Use a calculated attribute.

D. Use a variable.

正確答案: A,B

問題4

An analytic view has a long runtime.
Which of the following can be a root cause for the bad performance? (Choose two)

A. The Calculation Before Aggregation flag is set.

B. The analytic view uses generated columns.

C. The analytic view uses calculated columns.

D. The Execute In option is set to SQL Engine.

正確答案: A,C

問題5

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

A. UNION

B. INTERSECT

C. INSERT

D. PROJECTION

正確答案: A,D

問題6

Which of the following tools can you use to monitor the query time from SAP HANA?

A. Performance tab of the System Monitor

B. Event Viewer

C. Central Management Console

D. SQL Trace

正確答案: D

問題7

Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)

A. Define an output structure for the attribute view.

B. Define an analytic view.

C. Define calculated attributes for the nodes of the hierarchy.

D. Define the data foundation.

E. Choose the type of hierarchy.

正確答案: A,D,E

問題8

You want to aggregate the grand total sales amount into 1 currency.
In which of the following cases would you select the Calculate Before Aggregation check-box? (Choose two)

A. When a line item table contains sales values in 1 currency

B. When an aggregate table by country contains sales values in 1 currency

C. When an aggregate table by country contains sales values in 3 different currencies

D. When a line item table contains sales values of 2 different currencies

正確答案: C,D

問題9

Which of the following objects would SAP HANA identify as the left object of a join in the graphical calculation view?

A. The object that is displayed on the left hand side in the join details panel.

B. The object that has its field identified first in the join output.

C. The object that is displayed on the left hand side in the graphical calculation view.

D. The object that is connected to the join node first.

正確答案: D

問題10

Which of the following objects can you use when you build an analytic view? (Choose three)

A. Attribute Views

B. Variables

C. Analytic Views

D. Hierarchies

E. Projections

正確答案: A,B,D

問題11

Which of the following SAP HANA schemas contains the runtime objects of activated views?

A. _SYS_BIC

B. _SYS_REPO

C. _SYS_BI

D. _SYS_STATISTICS

正確答案: A

問題12

Which of the following tasks must you perform before you build a business layer within the
SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA? (Choose three)

A. Build a relational connection to SAP HANA.

B. Build an OLAP connection to SAP HANA.

C. Build a data foundation.

D. Build a query to test the connection.

E. Publish the connection to CMS.

正確答案: A,C,E

問題13

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. Aggregation

C. Analytic Privilege

D. Data Foundation

正確答案: A,B

問題14

You have loaded data into SAP HANA using SAP BusinessObjects Data Services.
Where can you view that data? (Choose two)

A. In the Catalog node of SAP HANA studio

B. In the Content node of SAP HANA studio

C. In the SAP BusinessObjects Data Services table preview

D. In the SAP BusinessObjects Data Services job monitor

正確答案: A,C

最新的SAP Certified Application Associate - SAP HANA (Edition 2014) - C-HANAIMP142免費考試真題

最新更新

站內鏈接

聯系我們