最新的SAP Application Associate認證 C_HANAIMP_12考試題庫

問題1

What join type should you use to see all the suppliers?
Please choose the correct answer.
Response:

A. Left outer join

B. Inner join

C. Referential join

D. Right outer join

正確答案: D

問題2

Which of the following are features of a data warehouse?
There are 3 correct answers to this question.
Response:

A. Data governance

B. Real-time reporting

C. Consolidation

D. A full transactional history

E. Both OLTP and OLAP in one system

正確答案: A,C,D

問題3

What must be installed for PAL to work?
Please choose the correct answer.
Response:

A. SAP HANA SINA

B. SAP HANA AFL

C. SAP HANA AFM

D. SAP HANA BFL

正確答案: B

問題4

What technique is used to convert record updates into insert statements in the delta buffer?
Please choose the correct answer.

A. Sorted inserts

B. Parallelism

C. Unsorted inserts

D. Insert-only

正確答案: D

問題5

Which of the following SAP data provisioning methods provide complex transformations?
There are 2 correct answers to this question

A. SAP HANA smart data quality

B. SAP Data Services

C. SAP HANA smart data access

D. SAP Replication Server

正確答案: A,B

問題6

You build a financial report for the company's board members that allows them to choose if they want the report to be in euros or dollars. What do you use?
Please choose the correct answer.
Response:

A. An input parameter from an aggregation node

B. An input parameter from the semantics node

C. A variable from a projection node

D. A variable from the semantics node

正確答案: B

問題7

You have a list of map locations for clinics. The government wants to build a new clinic, but wants to build it where there is the greatest need.
You need to find the largest distance between any two clinics. With your current knowledge, how do you do this?
Please choose the correct answer.
Response:

A. Use a dynamic join to find the longest distance between clinics. Use a ranking to find the top 10 values.

B. Use a spatial join to find the distance between clinics. Use a level hierarchy for drilldown.

C. Use a spatial join to find the distance between clinics. Use an aggregation with the maximum option.

D. Use a temporal join to find the distance between clinics. Use a union with constant values to "pivot" the values.

正確答案: C

問題8

For which data types does SAP HANA automatically create full-text indexes?
There are 3 correct answers to this question.
Response:

A. TEXT

B. CLOB

C. NVARCHAR

D. SHORTTEXT

E. BINTEXT

正確答案: A,D,E

問題9

You get the following requirements from a customer: They have a lot of purchasing data in their SAP system which they wish to analyze in SAP HAN

A. SLT

B. They want to have reports every morning showing the total expenditure per department.
Their SAP BW developers have not yet had any SAP HANA training.
Which data provisioning tool would you recommend?
Please choose the correct answer.
Response:

C. SDA

D. EIM

E. DXC

正確答案: D

問題10

Which of the following database terms are used when providing OLAP data with hierarchies?
There are 3 correct answers to this question.
Response:

A. BICS

B. JDBC

C. ODBO

D. MDX

E. ODBC

正確答案: A,C,D

問題11

For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer.
Response:

A. Transactional data

B. Calculated data

C. Materialized cube data

D. Master data

正確答案: D

最新的SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12) - C_HANAIMP_12免費考試真題

最新更新

站內鏈接

聯系我們