最新的SAP C_HANAIMP_11免費考試真題

問題1

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

A. The SQL plan cache

B. The expensive statements trace

C. The System information tab of the Administration console

D. The statistics server warning for long running statements

E. The Central Management Console

正確答案: A,B,D

問題2

When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services?

A. Data transformations

B. Upload data via the SAP HANA studio

C. Real-time replication

D. Data filtering

正確答案: A,D

問題3

How can you improve the performance of an information model?

A. Use analytic views wherever possible.

B. Use generated columns.

C. Use constraint filters.

D. Use attribute views wherever possible.

E. Use indexes on all measures.

正確答案: A,B,C

問題4

Which of the following describes an SAP HANA analytic view?

A. It is a reusable object in attribute views.

B. It is a materialized set of data.

C. It is a set of tables joined together in a star schema.

D. It is a copy of data after transformation.

正確答案: C

問題5

Which of the following are characteristics of a referential join? (Choose two)

A. It requires referential integrity between right and left tables.

B. If a field is selected from the right table, it acts similar to a left outer join.

C. It assumes referential integrity between right and left tables.

D. If a field is selected from the right table, it acts similar to an inner join.

正確答案: C,D

問題6

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

A. Projection

B. Join

C. Union

D. Aggregation

正確答案: A,D

問題7

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 BusinessObjects Analysis, edition for Microsoft Office

C. SAP Crystal Reports 2011

D. SAP Lumira

E. SAP BusinessObjects Analysis, edition for OLAP

正確答案: B,D,E

問題8

You are experiencing performance problems with SAP BusinessObjects reports based on SAP HANA data. Which of the following can you do to increase performance? (Choose two)

A. Merge all relevant data into a consolidated report.

B. Use drill-down or linked reports.

C. Avoid aggregation and work on raw data.

D. Add only relevant data to the report queries.

正確答案: B,D

問題9

Which of the following are restrictions of the SAP HANA flat file upload?

A. A table must have the same column order as the flat file when you append data.

B. A new table must have a 1:1 mapping between the flat file columns and the table columns.

C. The upload does not allow to change the column names of new tables.

D. The upload prevents data type changes when appending data.

正確答案: B,D

問題10

You would like to authorize a user to see data in an analytic view only for company code 1000 and fiscal year 2000 or for company code 1005 and fiscal year 2005. Which of the following achieves this requirement?

A. One analytic privilege: company codes = 1000 and 1005, and fiscal years = 2000 and 2005

B. One analytic privilege: company code = 1000, fiscal year = 2000
One analytic privilege: company code = 1005, fiscal year = 2005

C. One analytic privilege: the combination of company code = 1000 and fiscal year = 2000, and the combination of company code = 1005 and fiscal year = 2005

D. One analytic privilege: company codes = 1000 and 1005
One analytic privilege: fiscal years = 2000 and 2005

正確答案: B

問題11

Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?
Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?

A. SAP HANA system setup ? Modeling ? Data Provisioning ? Consumption

B. Data Provisioning ? SAP HANA system setup ? Modeling ? Consumption

C. SAP HANA system setup ? Data Provisioning ? Consumption ? Modeling

D. SAP HANA system setup ? Data Provisioning ? Modeling ? Consumption

正確答案: D

問題12

Table SALES_TABLE contains the columns COUNTRY and SALES. Function calc_tax calculates sales tax based on input parameter SALES.
Using a scripted calculation view, how can you call the calc_tax function?

A. :V_tax = SELECT COUNTRY, CALL : calc_tax(SALES) AS TAX FROM :SALES_TABLE;

B. V_tax + SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;

C. v tax = CE PROJECTION (SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]);

D. v_tax=CE_PROJECTION(SALES_TABLE, ["COUNTR","calc_tax(SALES)"]);

正確答案: B

問題13

You have created two analytic views for actual and planned financial data. The data covers multiple years. You want to display the actual data, planned data, and their difference in three separate columns in a report. The difference column is a calculated column. How can you model this?

A. Create a calculation view.
Combine the analytic views in the calculation view using a UNION.

B. Create restricted columns for each year for the actual and planned columns in each analytic view.
Combine the analytic views in a new calculation view using a UNION.

C. Create an analytic view.
Combine the analytic views in the new analytic view using a referential join.

D. Create a calculation view.
Combine the analytic views in the calculation view using a UNION WITH CONSTANT VALUES.

正確答案: D

問題14

Where can you reactivate a user after too many invalid logon attempts? (Choose two)

A. In the user properties in the SAP HANA studio

B. In the SQL Console

C. In the INVAUD_CONNECT_ATTEMPS view

D. In the user-specific schema

正確答案: A,B

問題15

When you create a report in SAP BusinessObjects you notice that some columns of your SAP HANA information model are not available in the report. How can you make the columns available?

A. Add the columns to the business layer.

B. Add the columns to the source table in the catalog node in SAP HANA studio.

C. Add the columns to the query panel of the report.

D. Add the columns in SAP Landscape Transformation replication.

正確答案: A,C

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

聯系我們

站內鏈接

最新更新