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

문제1

Your information model needs real-time access to external data stored in Microsoft SQL Server 2011.
How can you implement this scenario in SAP HANA? (Choose two)

A. Create a batch job in SAP Data Services

B. Create a virtual table and use it in attribute view

C. Perform replication using SAP Replication Server

D. Create a virtual table and use it in a calculation view

정답: C,D

문제2

How can you evaluate the speed of a calculation within the database? (Choose two)

A. Write and execute an appropriate SQL statement.

B. Use the Data Preview function in the SAP HANA studio.

C. Execute a Web Intelligence report and check the duration of the previous refresh.

D. Execute an information space using SAP BusinessObjects Explorer.

정답: A,B

문제3

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

A. Use the audit trail.

B. Use the "Where-Used List" feature for the changed model.

C. Use the "Auto Documentation" to compare the object version of the changed model.

D. Use the History feature for the changed model.

정답: B

문제4

You created a model on a table XYZ.PRODUCTS. You successfully activated the model. When you run the data preview you receive an error message "Insufficient privilege. Not authorized".
Which of the following 4 statements do you execute to resolve the error before you reactivate the model?

A. GRANT SELECT on SCHEMA XYZ to _SYS_REPO

B. GRANT SELECT on PRODUCTS to _SYS_REPO WITH GRANT OPTION

C. GRANT SELECT on PRODUCTS to _SYS_BIC

D. GRANT SELECT on SCHEMA XYZ to _SYS_BIC WITH GRANT OPTION

정답: B

문제5

Which information model can you use with measures from multiple fact tables?

A. Attribute view

B. Calculation view

C. Analytic privilege

D. Analytic view

정답: B

문제6

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

문제7

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

A. Load the calculation view into memory.

B. Load the calculation view into the _SYS_BI schema.

C. Turn the calculation view into a simple calculation view.

D. Turn the calculation view into an analytic view.

정답: D

문제8

Which connectivity options can you use to create a SAP BusinessObjects universe on SAP HANA? (Choose two)

A. Relational connection using BICS

B. Relational connection using MDX

C. OLAP connection using MDX

D. Relational connection using ODBC

E. Relational connection using JDBC

정답: D,E

문제9

Which technologies use trigger-based replication? (Choose two)

A. Standard SQL database replication

B. Test Data Migration Server (TDMS)

C. Near Zero Downtime

D. ABAP extractors

정답: B,C

문제10

Which of the following are direct outputs of an analytic view? (Choose three)

A. Hierarchies

B. Restricted attributes

C. Measures

D. Attribute views

E. Private attributes

정답: C,D,E

문제11

Which connectivity combination between MS Excel and SAP HANA provides multidimensional reporting capabilities?

A. ODBO connector via SQL requests to analytic or calculation views

B. ODBC connector via MDX requests to analytic or calculation views

C. ODBO connector via MDX requests to analytic or calculation views

D. ODBO connector via MDX requests to column tables

정답: C

문제12

Which of the following would you use to determine the engines that are used when an information model is queried? (Choose two)

A. SQL plan cache

B. Visualize plan

C. Timeline

D. Explain plan

정답: B,D

문제13

Which of the following can you check to investigate the query time in SAP HANA?
(Choose three)

A. The statistics server warning for long running statements

B. The SQL plan cache

C. The expensive statements trace

D. The System information tab of the Administration console

E. The Central Management Console

정답: A,B,C

문제14

How can you improve the performance of a report that is based on SAP HANA data? (Choose two)

A. Maintain appropriate constraint filters in SAP HANA.

B. Ensure that all SAP HANA tables are in the same schema.

C. Ensure that all calculations are pushed down to the SAP HANA database.

D. Gather new database statistics.

정답: A,C

SAP Certified Application Associate - SAP HANA (Edition 2014) - C-HANAIMP142무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트