C_HANAIMP131 Exam Questions

How can you import information models into SAP HANA using the Quick Launch view?

Which of the following describes an SAP HANA analytic view?

Which of the following steps do you have to execute to import models from one SAP HANA system (system1) to another SAP HANA system (system2)? (Choose three)

What is the advantage of reporting directly from column tables?

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)

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

Which of the following remote data sources can you access with SAP HANA smart data access? (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)

In an analytic view, you need two different logical joins from the data foundation to an attribute view. The analytic view already contains the attribute view but you have to use t...

Which of the following are restrictions of the SAP HANA flat file upload? (Choose two)

You have a table of transactional data with different transaction types. You want to create an analytic view for only one of the transaction types. How can you ensure that only row...

A corporation with over 15 000 cost centers would like to ensure that only the person responsible for the cost center may view salary information for individuals assigned to their...

Which SAP HANA privileges are used for administration tasks such as creating schemas?

You have created an input parameter in an information model. In which of the following can you use the input parameter?

A new user has implemented an SAP HANA data model. Which technical user requires select rights on the new user's schema?

What do you have to define in an attribute view to reduce the initial amount of data selected from the data foundation tables?

In a left outer join, the left table has one record and the right table has three records. What is the maximum number of records that you expect in the join result?

What are the consequences of executing the stop activity on the Data Provisioning view in the SAP HANA studio for a table that is currently replicated?

You modified an active analytic view in the SAP HANA studio and saved it without activating it. What is the consequence?

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

In a graphical calculation view you specify the default client to be dynamic. How is the client value determined when the view is used?

Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP BW) when migrating it to run on SAP HANA? (Choose three)

You have two analytic views. One contains actual data and the other one contains plan data. You want to combine the two result sets and keep actual and plan data on separate record...

In a calculation view you define a calculated column and set the Calculate Before Aggregation flag. Which of the following activities is mandatory to activate the view?

Which of the following tools can you use to load data into SAP HANA from SAP DataSource extractors? (Choose two)

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

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

Your data models use hierarchies. In which front end tool can you access these hierarchies? (Choose two)

Which of the following is a best practice in calculation views?

You want to use a UNION to combine two information objects in a calculation view. Which steps do you have to perform? (Choose two)

You are implementing the SAP CO-PA Accelerator to enable real-time profitability reporting. Which configuration steps must you do? (Choose three)

Which of the following tools use SQL to communicate with SAP HANA? (Choose three)

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

In a two system landscape, you want to transport SAP HANA information models from the source system to a target system. The source system has information objects that refer to phys...

In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure?

You receive an activation error in a scripted calculation view that uses the following function: CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A') What could be a reason for this er...

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

When you use SLT replication, which of the following determines the name of the SAP HANA schema where replicated data is stored?

You have been asked to create an SAP HANA attribute view using the tables Employee (left table) and Department (right table) shown in the attached diagram. Your view should contain...

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

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

You are using SAP NetWeaver Business Warehouse (SAP NetWeaver BW) in your company as the enterprise data warehouse. You want to use SAP NetWeaver BW as a data provisioning tool for...

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

Which of the following objects would SAP HANA identify as the left object of a join in the graphical calculation view?

Which of the following are advantages of running SAP HANA Live embedded in the SAP Business Suite? (Choose three)

In an SQLScript calculation view, one variable contains the records that are the result of a SELECT * statement from a database table with 10 fields. You want to use this variable...

How can you define conditions and actions in a decision table? (Choose three)

You want to model customer master data. Which of the following must you select? (Choose two)

Which of the following objects can you use when you build an analytic view? (Choose three)

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