C_HANAIMP_12 – SAP HANA Certification Made Easy

Test your skills by taking this questionnaire and to figure out if you are ready to get trained and certified in SAP HANA

1. What are characteristics of a constraint filter?
a. It is defined during the design time on a table.
b. It is applied on a table before the query execution.
c. It is applied on the result set of an SQL query.
d. It is defined during the runtime in the SQL query.

2. Which of the following are direct outputs of an analytic view?
a. Hierarchies
b. Private attributes
c. Restricted attributes
d. Measures
e. Attribute views

3. When you activate an analytic view, a column view is created. In which schema is this column view stored
a. _SYS_BIC
b. _SYS_BI
c. _SYS_REPO
d. _SYS

4. Which of the following SAP data provisioning methods provide copied transformation
a. SAP Data Services
b. SAP HANA start data access
c. SAP Replication Server
d. SAP HANA start data quality
e. C_HANAIMP_11

5. Which of the following are restrictions of the SAP HANA fat file upload
a. A table must have the say column order as the fat file when you append data.
b. The upload does not allow to change the column names of new Tables.
c. A new table must have a 1:1 mapping between the fat file columns and the table columns.
d. The upload prevents data type changes when appending data.

6. 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 the attribute view again. To which of the following do you connect the second join
a. To a shared attribute view
b. To a derived attribute view
c. To a new instance of the attribute view
d. To a copy of the attribute view

7. What must you do to enable currency conversions with a fixed currency in an analytic view?
a. Set the Enable for Conversion option
b. Create a measure with the measure type Siipie
c. Base the target currency on a currency column
d. Create the target currency using an input parameter

8. You create a graphical calculation view that is based on analytic views. What do you use to combine the data from the analytic views?
a. Referential join
b. Projection node
c. Aggregation node
d. Union

9. You modified an active analytic view in the SAP HANA studio and saved it without activating it. What is the consequence?
a. The inactive view is not available.
b. The inactive view is in “Read Only” mode.
c. The active view is not available.
d. The active view is in “Read Only mode.

10. When you activate a procedure, in which schema is the procedure stored
a. SYSTEM
b. _SYS_BIC
c. SYS_REPL
d. _SYS_BI

11. You want to create a graphical calculation view using the SAP HANA studio. Which steps are mandatory for this task?
a. Define a projection.
b. Write an SQL script.
c. Save and activate the view.
d. Define output fields.
e. Choose a data source.

12. What is the lowest level of granularity you can use in an analytic privilege?
a. An attribute
b. A view
c. An attribute value

13. What just you configure to directly access an SAP HANA analytic view using SAP Business Objects Analysis edition for Microsoft Office
a. RFC connection
b. SAP HANA Direct Extractor Connection (DXC)
c. Pre-delivered MODELING role
d. System DSN
14. Which of the following are characteristics of an operational data are based on SAP HANA
a. It is based on analytic demoralized data models
b. It uses real-the replication of the critical data
c. It runs directly on top of the operational data
d. It performs transformed data

15. C_HANAIMP_115 you have created an MS Excel report on SAP HANA data. On which of the following could you store the Excel file and take it available for other users
a. Shared network drive
b. SAP Business Objects Information Design Tool
c. SAP HANA database
d. SAP HANA studio Content node

16. How can you improve the performance of a report that is based on SAP HANA DATA?
a. B. Maintain appropriate constraint filters in SAP HANA.
b. C. Ensure that all calculations are pushed down to the SAP HANA database.
c. D. Gather new database statistics.

17. What is an example of a selective data load using SAP Landscape Transformation?
a. Selected data field values are randomized and loaded into SAP HANA.
b. Selected units or currencies are converted into recalculated amounts or values and loaded into SAP HANA.
c. Selected data for transformation is split into portions.
d. Selected data for a range of years is loaded into SAP HANA.

18. Which connection type is required from the SAP ERP system to SAP HANA to enable CO-PA side by side scenario
a. HTTP connection
b. JDBC
c. Secondary database connection
d. Remote Function Call

19. You need to create an SAP HANA data model based on a star schema. Which SAis HANA engine is reconceiled for analytical purposes?
a. Calculation engine
b. OLAP engine
c. Row store engine
d. Join engine

20. Which of the following actions just you perform in an SAP HANA system to transport content to another SAP HANA System
a. Generate and save an export fie to a shared directory.
b. Assign the content repository to a transport request.
c. Mass copy the content repository into the other SAP HANA system.
d. Assign the package to a delivery unit.

Learn SAP HANA from Industry Experts

21. How can you restrict SAP HANA modelling users from viewing sensitive data?
a. Use scrambled source data.
b. Remove SAP_DATA_ADMIN in the SQL privileges for the modelling users.
c. Use the pre-delivered MODELER role.
d. Remove ALTER SYSTEM in the system privileges for the modelling users.

22. You model hierarchies in attribute views. Which of the following technologies do you use to make these hierarchies? Available for reporting tools
a. JDBC
b. BICS
c. ODBO
d. ODBC
23. Which of the following can you use as sources for the vocabulary in a decision table?
a. Calculations views
b. Table types
c. Data models
d. Procedures
e. Physical Tables

24. Which of the following just an analytic view container
a. A measure
b. A calculated measure
c. A hierarchy
d. An attribute view

25. 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 rows with the required transaction type are displayed in the analytic view?
A. Create an input parameter
B. Create a filter on the Table
C. Create a calculated column
D. Create a restricted column

26. Which versions of your information models are visible on the History tab of the Moodier perspective in the SAP HANA Studio?
a. Only the last active version
b. All active and inactive versions
c. All active versions
d. The last active and inactive version

27. You want to load a large amount of source data (more than one billion rows) into SAP HANA for read-intensive Information models. Which is the Table type reconciled for this scenario?
A. Global temporary Table
B. Decision Table
C. Row Table
D. Column Table

28. Which of the following can you set up to enable the extraction of data from SAP Business Warehouse (BW) into SAP HANA?
a. SAP System Landscape Directory (SLD)
b. SAP Business Objects Data Services
c. SAP Landscape Transformation (SLT)
d. Open hub
e. SAP HANA Direct Extractor Connection (DXC)

29. What are the key benefits of using SAP Business Objects Explorer with SAP HANA?
a. You do not need to create your own queries to access information.
b. You can easily create your own queries to access information.
c. You can access information for data discovery intuitively.
d. You can execute ad-hoc business analytics quickly.
e. You can easily create an IDT business layer.

30. You are implementing the SAP CO-PA Accelerator to enable real-the profitability reporting. Which configuration steps just you done
a. Activate continuous data replication of Tables CE1xxxx, CE2xxxx, CE4xxxx.
b. Configure the SAP Business Objects Data Services replication jobs.
c. Install the SAP HANA database clients on all SAP ERP application servers.
d. Build attribute and analytic views in SAP HANA.
e. Create a secondary database connection in SAP ERP.

31. What is the advantage of reporting directly from column Tables
a. It provides multi-language support
b. It eliminates the need for additional modelling
c. It shifts complex calculations and logic to SAP HANA
d. It supports analytical privileges

32. In SAP HANA, which join type yields the same results as a referential join when fields from both Tables are selected?
a. Left outer join
b. Full outer join
c. Inner join
d. Temporal join

33. Which of the following tools can you use to monitor the query the from SAP HANA?
a. Central Management Console
b. Performance tab of the System Monitor
c. Event Viewer
d. SQL Trace

34. Which of the following can be part of an analytic view?
a. Query transformation
b. Unions
c. Logical joins
d. Data foundation
e. Attributes

35. Which of the following authentication methods are supported for Single Sign-On for SAP HANA?
a. Kerberos
b. LDAP over SSL
c. Secure Network Connection (SNC)
d. SAML CAS (Central Authentication Service)

36. Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?
a. Install SAP Business Warehouse Accelerator (BWA).
b. Perform a database migration from your current DB to SAP HANA DB.
c. Execute the report RS_BW_POST_MIGRATION.
d. Upgrade to at least SAP Net Weaver Business Warehouse 7.30 SP5.
e. Recreate SAP BW indexes after SAP HANA database migration.

37. What is the purpose of a template Table in SAP Business Objects Data Services?
a. To create pre-designed information models
b. To fill an existing target Table with new data
c. To read source data and perform data transformations
d. To create a target Table and fill this Table with data

38. Which of the following just you do in order to use SAP Business Objects Explorer on SAP HANA data
a. Create a delivery unit.
b. Create a business layer.
c. Create an information model.
d. Create an information space.

39. You have an SAP Net Weaver Business Warehouse (SAP Net Weaver BW) on SAP HANA system installed on multiple Nodes. Which of the following information objects are stored on the master node?
a. SAP Net Weaver BW master data Tables
b. Data Store Objects (DSOs)
c. ABAP system Tables
d. Persistent Staging Area (PSA) Tables

40. You are building a calculations view and want to select data from an analytic view. How can you achieve batter Performance for this requirement?
a. Use CE functions
b. Use SQL statements
c. Use L programming
d. Use Table indexing

41. Where can you deploy the column view of a decision Table?
a. In SAP Visual Intelligence
b. In Microsoft Excel
c. In calculations views
d. In analytic views

42. A company loads data every night from several source systems into multiple Tables in SAP HANA using complex Transformation rules. The calculations view that joins these Tables performs unexpectedly slow. Which of the following could you investigate to be able to improve performance?
a. Whether the joins and transformations of the Tables can be moved to the data loading process of SAP Business Objects Data Services.
b. Whether an Info Cube compression is running.
c. Whether the calculations view needs to create large intermediate result sets.
d. Whether save points are written during execution.

43. Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute View and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by recalling it to ID_PRODUCT. Where in the attribute properties of ID_1 can you change this?
a. In the alias label
b. In the label
c. In the alias name
d. In the name

44. Union can be performed only at…
a. Analytic
b. Attribute
c. Calculations
d. Analytic / Calculations

45. You create a roué with the following command: CREATE ROLE “Info User” When you try to assign this role to user PETER with the following command: GRANT Info User to PETER you receive an error message “Invalid user privilege: INFOUSER”. What just you do to avoid this problem
a. Recreate the role with the command CREATE ROLE Info User.
b. Recreate user PETER with GRANT OPTION.
c. Grant the role the WITH ADMIN OPTION.
d. Recreate the role with the command CREATE ROLE INFOUSER.
e. Grant the role with the command GRANT “Info User” to PETER.

46. Which of the following nodes can you use when you create a calculations view with the SAP HANA studio graphical Interface?
a. Data Foundation
b. Aggregation
c. Join
d. Analytic Privilege

47. Which security settings can you apply in analytic privileges?
a. Grant access to analytic views.
b. Restrict access within an analytic view using measure values.
c. Restrict access within an analytic view using attribute values.
d. Restrict access to hierarchies.

48. Which of the following is used to make hierarchies available to reporting tool?
a. CE Functions
b. MDX
c. SQLScript
d. SQL

49. Which transaction is used for releasing extractors specified by the customers in SLT?
a. RODPS_OS_OPEN
b. RODPS_OS_CLOSE
c. RODPS_OS_EXPOSE
d. RODPS_OS

50. 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 out which objects depend on this view
a. History function
b. Auto Documentation function
c. Display XML function
d. Where-Used function

51. The company needs to load external data from a fat fie into SAP HAN
a. How can you do this?
b. SAP HANA Direct Extractor Connection (DXC)
c. SAP System Landscape Transformation (SLT)
d. SAP HANA SQL Import statement
e. SAP Business Objects Data Services

52. Which of the following can be grouped when multiple schemas exist in an SAP HANA DATABASE?
a. Information models
b. Data Tables
c. Packages
d. Users

53. How can you improve the performance of an information model?
a. Use generated columns.
b. Use analytic views wherever possible.
c. Use indexes on all measures.
d. Use attributes views wherever possible.
e. Use constraint fitters.

54. Which of the following are phases of an SAP rapid-deployment solution (RDS???)
a. Start
b. Blueprint
c. Deploy
d. Run
e. Realization

55. Which of the following automatically aggregates data
a. Analytic view
b. Calculations view
c. Column Table
d. Attribute view

56. Which of the following can you use as a source for a graphical calculations view?
a. Calculations view
b. SQL view
c. Decision Table
d. Table
e. Procedure

57. For which SAP HANA data types is a FULLTEXT index created automatically during Table creation
a. TEXT
b. SHORTTEXT
c. VARCHAR
d. NCLOB

58. Which of the following can you use to implement currency conversion in an information model?
a. A calculated column in a calculations view
b. A restricted column in an analytic view
c. A calculated column in an analytic view
d. A calculated column in an attribute view

59. 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?
a. Client filtering in the Delivery unit view.
b. Joins in information models.
c. Memory leaks.
d. Client filtering in SAP Landscape Transformation (SLT).

60. Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)
a. Ensure that replicated changes are kept within the logging Tables.
b. Record relevant changes in logging Tables.
c. Include only relevant Tables for DB recording.
d. DE cluster Table classes into a transparent format.
61. When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services
a. Upload data via the SAP HANA studio
b. Data filtering
c. Real-the replication
d. Data transformations

62. Which type of connection does Direct Extractor Connection (DXC) use to transfer data to SAP HANA?
a. RFC connection
b. Secondary database connection
c. http connection
d. ODBC connection

63. A calculations view that joins one fact Table with dimension Tables performs slowly. Which of the following can you do to improve performance?
a. Turn the calculations view into an analytic view.
b. Turn the calculations view into a simple calculations view.
c. Load the calculations view into memory.
d. Load the calculations view into the _SYS_BI schema.

64. In SAP ERP there are more than 50,000 application Tables. How do you determine the relevant SAP ERP Tables To? Replicate in SAP HANA and their dependencies
a. Use SAP ERP Data Moodier (transaction SD11).
b. Use SAP ERP ABAP Dictionary Maintenance (transaction SE11).
c. Use the SAP ERP Tables and Indexes Monitor (transaction DB02).
d. Use SAP ERP Data Browser (transaction SE16).

65. In a fuzzy search, when would you perform a freestyle search?
a. When you want to search with a low fuzziness threshold
b. When you want to search in only one column
c. When you want to search in multiple columns
d. When you want to search with a high fuzziness threshold

66. Which engine is used for calculations and aggregation based on star schema
a. Join Engine
b. Calculations Engine
c. SQL Optimizer Engine
d. OLAP Engine

67. You have two analytic views. One contains actual data and the other one contains plan data a. You want to combine the two result sets and keep actual and plan data on separate records. In the SAP HANA studio, which of the following can you use to achieve this?
a. JOIN in a calculations view
b. JOIN in an analytic view
c. UNION in a calculations view
d. PROJECTION in a calculations view

68. Which of the following are advantages of running SAP HANA Live embedded in the SAP Business Suite?
a. It uses the generic capabilities of SAP HANA such as the XS Engine
b. It provides real-the operational reporting
c. It allows using generic virtual data models
d. It provides real-the replication
e. It runs in older versions of the SAP Business Suite

69. Which of the following are required elements when you create any type of hierarchy in SAP HANA
a. A child node
b. An analytic view
c. A data foundation
d. An attribute view

70. Which of the following criteria indicate that you should store data in row Tables
a. the Tables have a large number of columns.
b. the Tables requires frequent write access.
c. The information models search the Table based on the values of a few columns.
d. The information models frequently needs to access complete records.

71. How can you create a computed column in information modeller?
a. Create a calculated attribute within a calculations view.
b. Create a counter in an analytic view.
c. Create a restricted measure in a calculations view.
d. Create a restricted measure in an analytic view.

72. When you create a report in SAP Business Objects 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 in SAP Landscape Transformation replication.
b. Add the columns to the query pane of the report.
c. Add the columns to the source Table in the catalog node in SAP HANA studio.
d. Add the columns to the business layer.

73. Which SAP Business Objects tools require an SAP Business Objects semantic layer (universe) to access data in SAP HANA?
a. Crystal Reports 2011
b. Crystal Reports for Enterprise
c. Dashboards
d. Analysis office v1.1
e. Web Intelligence

74. You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this?
a. Assign restricted values to the attribute view.
b. Assign values to be restricted. Choose at least one infuriation model to assign restrictions.
c. Assign the analytic privilege to a user or role.
d. Assign values to be restricted to a content Table.
e. Choose an attribute to define restricted values for it.

75. Which data provisioning method can you use to load data from SAP business content Data Sources into SAP HANA?
a. SAP Landscape Transformation (SLT)
b. SAP Landscape Directory (SLD)
c. SAP Direct Extractor Connection (DXC)
d. SAP Business Objects Data Services

76. You want to use an extractor to build a model in SAP HANA. Which Table can you use to view detailed infuriation about the extractor?
a. BSEG
b. RODELTAM
c. ROOSOURCE
d. RSOLTPSOURCE

77. Which of the following describes an SAP HANA analytic view?
a. It is a set of Tables joined together in a star schema.
b. B. It is a copy of data after transformation.
c. C. It is a reusable object in attribute views.
d. D. It is a materialized set of data.

78. When you use SLT replication, which of the following determines the name of the SAP HANA schema where replicated Data is stored
a. The name of the secondary database connection
b. The name of the replication configuration
c. The name of the source system schema
d. The name of the RFC connection

Click here to Download the Answers