C_HANAIMP_11 Exam Questions
100 real C_HANAIMP_11 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1
Which security settings can you apply in analytic privileges?
- Question #2
In a fuzzy search, when would you perform a freestyle search?
- Question #3
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...
- Question #4
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?
- Question #5
In SAP HANA, which join type yields the same results as a referential join when fields from both tables are selected?
- Question #6
What is the advantage of reporting directly from column tables?
- Question #7
Which SAP tool would you use for data cleansing before data is loaded into SAP HANA?
- Question #8
What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA?
- Question #9
Which of the following nodes can you use when you create a calculation view with the SAP HANA studio graphical interface?
- Question #10
Which transaction is used for releasing extractors specified by the customers in SLT?
- Question #11
Which feature is supported by the backup and recovery process within the standard delivery of SAP HANA?
- Question #12
How can you improve the performance of a scripted calculation view?
- Question #13
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?
- Question #14
Which of the following must you avoid to ensure your calculation view uses only the calculation engine?
- Question #15
Which of the following are characteristics of using a Rapid Deployment Solution (RDS), such asOperational Reporting for SAP HANA?
- Question #16
You want to create a customer segmentation on your SAP HANA data. Which of the following do you use?
- Question #17
When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services?
- Question #18
Which of the following remote data sources can you access with SAP HANA smart data access?
- Question #19
You need to create an SAP HANA data model based on a star schema. Which SAP HANA engine is recommended for analytical purposes?
- Question #20
Which SAP HANA model is recommended for reporting purposes where read operations on mass data are required?
- Question #21
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...
- Question #22
If you want to create or drop tables in a schema, which privilege type do you need?
- Question #23
How can you improve the quality of your information model design?
- Question #24
If you notice, Unique Constraint Error while loading flat file then
- Question #25
In which tool can you create information spaces for reporting?
- Question #26
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?
- Question #27
How can you generate documentation of your information models?
- Question #28
Which of the following are direct outputs of an analytic view?
- Question #29
When you use SAP Landscape Transformation (SLT) replication, which of the following can you set up in the advanced replication settings?
- Question #30
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?
- Question #31
What does SAP HANA smart data integration use for data provisioning?
- Question #32
In which engines is an analytic view executed that contains a calculated column?
- Question #33
When you activate a procedure, in which schema is the procedure stored?
- Question #34
Which engine is used for calculation and aggregation based on star schema
- Question #35
What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?
- Question #36
When you activate an analytic view, a column view is created. In which schema is this column view stored?
- Question #37
Which of the following can you use as sources for the vocabulary in a decision table?
- Question #38
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?
- Question #39
Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server?
- Question #40
Which SAP BusinessObjects tools require an SAP BusinessObjects semantic layer (universe) to access data in SAP HANA?
- Question #41
How can you restrict SAP HANA modeling users from viewing sensitive data?
- Question #42
When working with your data models, which of the following do you use to get detailed information about tables, number of rows, and partitioning?
- Question #43
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...
- Question #44
What are advantages of implementing SAP HANA using an SAP rapid-deployment solution over a traditional implementation project?
- Question #45
Which of the following are required to build a SQLScript calculation view?
- Question #46
What are characteristics of a constraint filter?
- Question #47
What type of calculation would you create to ensure the fastest calculation performance?
- Question #48
A calculation view that joins one fact table with dimension tables performs slowly. Which of the following can you do to improve performance?
- Question #49
Which view need be considered in development for read operations on mass data required?
- Question #50
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...