C_HANAIMP142 Exam Questions

Your customer has the following reporting requirements: - Real-time profitability reporting on large-scale data volumes - On-the-fly analysis of profitability data at any level of...

Which of the following describes an SAP HANA analytic view?

Which of the following are required to create an attribute view? (Choose two)

You develop a disaster recovery plan. What do you have to consider in case of a disk failure? (Choose three)

Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANA data? (Choose two)

You discover row count discrepancies between source data and SAP HANA information models. Which of the following can you investigate to find the source of the discrepancies? (Choos...

What is the lowest level of granularity you can use in an analytic privilege?

During loading of data into SAP HANA you want to filter the source data. Where can you apply the filters? (Choose two)

You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year. Where do you apply the filter for optimal performance?

Which view in SAP HANA studio do you use to add additional users?

Which of the following is used to make hierarchies available to reporting tools?

You want to create a custom attribute in addition to your data model. How can you achieve this?

What must you do to enable currency conversions with a fixed currency in an analytic view?

You want to create a sales analysis by combining your customer master data with your transactional sales data. How do you model your data to ensure best performance?

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database? (Choose three)

Which connectivity combination between MS Excel and SAP HANA provides multidimensional reporting capabilities?

You have an SAP HANA productive system with sensitive data.How can you restrict modeling users from viewing this data? (Choose two)

Your customer wants to use SAP BusinessObjects Data Services to migrate and transform large volumes of data to SAP HANA. What do you recommend?

You have made modifications to an information model within a delivery unit. You want to export the model to an SAP HANA target system. In the Schema Mapping dialog, where do you de...

Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system? (Choose two)

You have to do reverse pivot transformations on large data tables before loading the data into SAP HANA. Which of the following do you recommend to use?

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

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

What does the following SQL statement do? SELECT SCORE() as SCORE, PRODUCT_NAME, * FROM PRODUCT_ITEMS WHERE CONTAINS(*,'Paper', FUZZY(0.8)) ORDER BY PRODUCT_NAME

Which of the following automatically aggregates data? (Choose two)

A company wants to use SAP BusinessObjects reporting tools. They cannot use Adobe Flash. They require scheduled, ready-made reports. Which reporting tool do you recommend? (Choose...

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

A company loads data every night from several source systems into multiple tables in SAP HANA using complex transformation rules. The calculation view that joins these tables perfo...

You are running an SAP BusinessObjects Web Intelligence report that fetches data from an analytic view. Which of the following 4 components is used by SAP HANA to provide data for...

Which connectivity options can you use to create a SAP BusinessObjects universe on SAP HANA? (Choose two)

You want to restrict access to SAP HANA information models based on user groups. The models are accessed through an SAP BusinessObjects report. In which of the following can you im...

You need to run a Web Intelligence report that requires data from SAP HANA filtered for a specific year based on ad hoc user input. For best performance, how would you achieve this...

You want to retrieve data from SAP HANA and restrict access to certain data columns for specific user groups. Where can you implement this?

In which View, client queries can be less optimized and could significantly be slower compare to other models?

How can you improve the performance of an information model?

You want to design a model in SAP HANA. Which of the following modeling constructs do you use to create an analytic view? (Choose three)

For which SAP HANA data types is a FULLTEXT index created automatically during table creation? (Choose two)

You want to broadcast reports that use data from SAP HANA. Which SAP BusinessObjects tool do you use?

Which CE function do you use to implement an inner join between two tables on a list of join attributes?

You want to add a column to a calculation view that displays the year-to-date revenue of the current fiscal year. How can you achieve this? (Choose two)

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

You create a business layer in the SAP BusinessObjects Information Design Tool (IDT). Which of the following could you add to the data foundation? (Choose two)

You modify an existing view. How can you determine which models are affected by this change?

Which connection type is required from the SAP ERP system to SAP HANA to enable CO- PA side by side scenario?

What are the advantages of using SAP BusinessObjects Data Services to load data into SAP HANA? (Choose three)

Which of the following tasks are prerequisites for creating a hierarchy in SAP HANA? (Choose three)

Which reporting tool can you use to display native parent-child hierarchies from SAP HANA?

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

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

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?