[2026] SAP Certified Application Associate - SAP HANA (Edition 2016)

문제1

Where can you deploy the column view of a decision table?

A. In analytic views

B. In SAP Visual Intelligence

C. In calculation views

D. In Microsoft Excel

정답: B,C

문제2

When you try to delete an attribute view you receive the error message "One or more objects are dependent upon this object".
Which of the following functions can you use to find out which objects depend on this view?

A. History function

B. Where-Used function

C. Auto Documentation function

D. Display XML function

정답: B,C

문제3

You want to use an extractor to build a model in SAP HANA. Which table can you use to view detailed information about the extractor?

A. RSOLTPSOURCE

B. ROOSOURCE

C. RODELTAM

D. BSEG

정답: B

문제4

Which of the following are characteristics of an agile data mart running on SAP HANA? (Choose two)

A. Transformed application data is stored in the database.

B. Queries run on highly normalized application data.

C. Application data is transformed at query runtime.

D. Application data is transformed before loading.

정답: A,D

문제5

How can you analyze a performance issue in the execution of an SQL statement using the SQL Console? (Choose two)

A. Query the table "SYS"."CACHE_P_QUERIES_"' after the execution of the SQL statement.

B. Use the Explain Plan command from the right-click menu in the SQL Console.

C. Use the Prepare Statement command from the right-click menu in the SQL Console.

D. Use EXPLAIN PLAN in the SQL statement and query the EXPLAIN_PLAN_TABLE.

정답: B,D

문제6

Which tool do you use for real-time data provisioning into SAP HANA?

A. SAP Landscape Transformation (SLT)

B. SAP BusinessObjects Data Federation Administration

C. SAP BusinessObjects Data Services

D. SAP Direct Extractor Connection (DXC)

정답: A

문제7

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 an aggregate table by country contains sales values in 3 different currencies

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

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

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

정답: A,C

문제8

What are characteristics of a constraint filter?

A. It is applied on a table before the query execution.

B. It is defined during the runtime in the SQL query.

C. It is applied on the result set of an SQL query.

D. It is defined during the design time on a table.

정답: A,D

문제9

You have created a graphical calculation view with a large number of columns.
Which of the following do you use to ensure that only required columns are shown when querying the created view? (Choose two)

A. Projection nodes

B. The Hidden checkbox in the semantics area

C. The Type selection in the semantics area

D. Function CE_PROJECTION

정답: A,B

문제10

What must you do to enable currency conversions with a fixed currency in an analytic view?

A. Create a measure with the measure type Simple.

B. Create the target currency using an input parameter.

C. Base the target currency on a currency column.

D. Set the Enable for Conversion option.

정답: D

문제11

You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can you implement this security strategy?

A. By assigning SQL privileges to the necessary users

B. By assigning Package privileges to the necessary users

C. By assigning System privileges to the necessary users

D. By assigning Analytic privileges to the necessary users

정답: D

문제12

You want to implement an SAP HANA data model based on tables in a new schema that you just created. Which technical user requires select rights on your new schema?

A. _SYS_SECURITY

B. _SYS_BIC

C. _SYS_BI

D. _SYS_REPO

정답: D

문제13

Which of the following must an analytic view contain?

A. A calculated measure

B. A hierarchy

C. An attribute view

D. A measure

정답: D

문제14

You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?

A. In the Web Intelligence report

B. In the analytic view

C. In the universe

D. In the calculation view using an attribute value variable

정답: B

SAP Certified Application Associate - SAP HANA (Edition 2016) - C_HANAIMP_11무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트