C_HANAIMP142 Exam Questions

In which order are views consumed by the SAP HANA Live virtual data model?

Which of the following CE functions can you use to query an analytic view directly?

Which privilege type do you have to assign to a role, when you want to provide row-level access to data?

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?

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

Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA?

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

Which of the following can you use to build the data foundation for an attribute view? (Choose two)

Which package privileges are required to extend an SAP HANA Live view? (Choose three)

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

An SAP BusinessObjects Web Intelligence report throws an SQL error during query execution. Which of the following could you check to resolve the error? (Choose two)

Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)? (Choose two)

Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?

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

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

Which types of calendar are available for time attribute views in SAP HANA? (Choose two)

What must you configure to directly access an SAP HANA analytic view using SAP BusinessObjects Analysis edition for Microsoft Office?

Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA? (Choose three)

Which SAP BusinessObjects tool do you use to visualize real-time key performance indicators with simu-lations?

Which tool do you use for real-time data provisioning into SAP HANA?

Which of the following must you do when you create an analytic view? (Choose three)

What is an example of a selective data load using SAP Landscape Transformation?

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

You are using SAP Landscape Transformation to replicate data into SAP HANA. Which of the following can you use to define the schema that the replicated data populates?

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

Which of the following are required elements when you create any type of hierarchy in SAP HANA? (Choose two)

Your customer requires real-time replication. Where do you select the tables to be replicated to SAP HANA?

Which of the following are phases of an SAP rapid-deployment solution (RDS)? (Choose three)

An analytic view has two columns, SHIP_TO_COUNTRY and SHIP_FROM_COUNTRY, that contain ISO country codes. You must replace these codes with the English country names by joining to t...

Which of the following properties of a derived attribute view can you modify?

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

Where can you deploy the column view of a decision table? (Choose two)

How can you create a computed column in an information model? (Choose two)

A customer wants to report on large amounts of SAP HANA data. The users want to drill from the top aggregation level to the lowest granularity and try different types of graphical...

Which delivered role is mandatory for a system administrator in SAP HANA?

You would like to authorize a user to select and delete data from a specific column table. The user should also be able to grant this authorization to other users. Which privilege...

In a reporting scenario you use an Opening Date attribute in the data foundation that contains information about your stores. You want to determine the number of years each store h...

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

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

You want to run a report on data with multiple currencies. You want to allow end users to select the target currency at run time. Which option does SAP recommend for defining the c...

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

You are building a calculation view and want to select data from an analytic view. How can you achieve better performance for this requirement?

A company needs to load external data from a flat file into SAP HANA. How can you do this? (Choose two)

Which tasks can you perform with the data provisioning view in the SAP HANA studio? (Choose two)

Which of the following are characteristics of an operational data mart based on SAP HANA? (Choose two)

Which of the following can you use as a source for a graphical calculation view? (Choose three)

You have a replicated an SAP ERP transaction table that contains a language field and a text table containing descriptions in various languages. You create an attribute view by joi...

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

What are benefits of using an SAP BusinessObjects business layer on top of SAP HANA? (Choose two)

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