C_HANAIMP142 Exam Questions

Which security settings can you apply in analytic privileges? (Choose two)

In a fuzzy search, when would you perform a freestyle search?

You want to repeatedly load data from a flat file into SAP HANA with SAP Data Services. The target table is not available in SAP HANA and must be recreated with every scheduled dat...

You have created an MS Excel report on SAP HANA data. On which of the following could you store the Excel file and make it available for other users?

In SAP HANA, which join type yields the same results as a referential join when fields from both tables are selected?

What is the advantage of reporting directly from column tables?

Which SAP tool would you use for data cleansing before data is loaded into SAP HANA?

What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? (Choose three)

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

Which transaction is used for releasing extractors specified by the customers in SLT?

Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?

How can you improve the performance of a scripted calculation view?

You want to aggregate the grand total sales amount into one currency. In which of the following cases would you perform the calculation before aggregation? (Choose two)

Which of the following must you avoid to ensure your calculation view uses only the calculation engine? (Choose three)

Which of the following are characteristics of using a Rapid Deployment Solution (RDS), such asOperational Reporting for SAP HANA? (Choose two)

You want to create a customer segmentation on your SAP HANA data. Which of the following do you use?

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

Which of the following remote data sources can you access with SAP HANA smart data access? (Choose three)

You need to create an SAP HANA data model based on a star schema. Which SAP HANA engine is recommended for analytical purposes?

Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?

You have created an information space in SAP BusinessObjects Explorer but the information space is not available on the Home page. How can you make the information space available...

If you want to create or drop tables in a schema, which privilege type do you need?

How can you improve the quality of your information model design? (Choose three)

If you notice, Unique Constraint Error while loading flat file then

In which tool can you create information spaces for reporting?

You have to extract entities such as persons, countries, products, and places from business text such as PDF files. Which of the following tools in SAP HANA can you use?

How can you generate documentation of your information models? (Choose two)

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

When you use SAP Landscape Transformation (SLT) replication, which of the following can you set up in the advanced replication settings? (Choose two)

When building a business layer to report on SAP HANA, what do you have to do if you want to display more than 5,000 rows?

What does SAP HANA smart data integration use for data provisioning? (Choose three)

In which engines is an analytic view executed that contains a calculated column? (Choose two)

When you activate a procedure, in which schema is the procedure stored?

Which engine is used for calculation and aggregation based on star schema

What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?

When you activate an analytic view, a column view is created. In which schema is this column view stored?

Which of the following can you use as sources for the vocabulary in a decision table? (Choose three)

User A has to set up tables and views in a database schema that is owned by user B. Which of the following privilege must you grant?

Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server? (Choose two)

Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (universe) to access data in SAP HANA? (Choose three)

How can you restrict SAP HANA modeling users from viewing sensitive data?

When working with your data models, which of the following do you use to get detailed information about tables, number of rows, and partitioning? (Choose two)

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

What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project? (Choose three)

Which of the following are required to build a SQLScript calculation view? (Choose two)

What are characteristics of a constraint filter? (Choose two)

What type of calculation would you create to ensure the fastest calculation performance?

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

Which view need be considered in development for read operations on mass data required?

Two attribute views in the same analytic view contain the same column name (ID from attribute view Customer and ID from attribute view Product). In the output, the system automatic...