The Below List of 100 REAL TIME SAP HANA Interview Questions and Answers Prepared by 6+ Years of Lead SAP HANA Developer
1. Which of the following is NOT a replication method for data replication from a source system to SAP Hana?
a. ETL based
b. Trigger based
c. Time based
d. Log based
Answer: c
2. Which of the following statements are true?
a. There are four types of information views: attribute view, analytic view, hierarchy view and calculation view. All these views are non-materialized views.
b. An analytic view is used to model data that includes measures.
c. Calculated attributes are derived from one or more existing attributes or constants.
d. Calculation views can include measures and be used for multidimensional reporting or can contain no measures and used for list-type of reporting
Answer: d
3. HANA supports which of the following hierarchies?
a. Time Based hierarchies
b. Level Hierarchies
c. Parent/Child Hierarchies
d. Matrix organization Hierarchies
Ans: b, c
4. SAP HANA modeler is a graphical data modeling tool which allows you to design analytical models and later analytical privileges, that governs the access to those models. Which of the following represents a logic flow of activities?
a. Import source system metadata -> Create Information Models -> Provision Data -> Deploy -> Consume
b. Import source system metadata -> Provision Data ->Create Information Models -> Deploy -> Consume
c. Import source system metadata -> Provision Data -> Deploy -> Create Information Models -> Consume
d. Import source system metadata -> Deploy ->Create Information Models -> Provision Data -> Consume
Ans: b
5. The two queries below, which is more efficient?
a. Matmoves = SELECT * FROM MSEG
FOR EACH matmove in matmoves
IF matmove.whichPlant = “I” THEN
Plant_text = SELECT plant_text FROM WERKS WHERE id = matmove.plant
ELSE
Plant_text = SELECT plant_text FROM WERKS_EXT WHERE id=matmove.
plant
END
b. If which_plant = “I” THEN
Plant_text = plant_int_text
ELSE
Plant_text = plant_ext_text
Ans: b
6 Which of the following statements are true?
a. One table may appear in exactly one schema
b. It is possible to grant authorizations on a table level.
c. Authorizations granted on a schema are automatically propagated to all objects within the schema
Ans: c
8. 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?
A. In the universe
B. In the Web Intelligence report
C. In the analytic view
D. In the calculation view using an attribute value variable
Ans: C
9. What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? (Choose three)
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.
Ans: A,C,D
10. Which of the following properties of a derived attribute view can you modify?
A. Description
B. Description mapping
C. Calculated attributes
D. Filters
Ans: A
11. How can you evaluate the speed of a calculation within the database? (Choose two)
A. Use the Data Preview function in the SAP HANA studio.
B. Execute a Web Intelligence report and check the duration of the previous refresh.
C. Execute an information space using SAP Business Objects Explorer.
D. Write and execute an appropriate SQL statement.
Ans: A,D
12. If you want to create or drop tables in a schema, which privilege type do you need?
A. SYSTEM
B. ANALYTIC
C. PACKAGE
D. SQL
Ans: D
13. Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?
A. Crystal Reports
B. Dashboards
C. Explorer
D. WebIntelligence
Ans: D
14. Which new connection type is available as of SAP BusinessObjects Data Services 4.0?
A. Operational Data Provider
B. BAPI function calls
C. IDOCs
D. Read table via ABAP data flows
Ans: A
15. Which of the following tasks must you perform before you build a business layer within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA?
A. Publish the connection to CMS.
B. Build a query to test the connection.
C. Build a relational connection to SAP HANA.
D. Build an OLAP connection to SAP HANA.
E. Build a data foundation.
Ans: A,C,E
16. Which delivered role is mandatory for a system administrator in SAP HANA?
A. SYS_ADMIN
B. CONTENT_ADMIN
C. SAP_ALL
D. IC MODELER
Ans: B
17. What are benefits of using a business layer on top of SAP HANA? (Choose two)
A. An extra layer of granular security
B. Improved database calculation speed
C. Fast throughput via BICS connectivity
D. Users can use business names instead of technical names
Ans: A,D
18. SAP HANA database is ____
A. A sort of SAP GUI used to access SAP servers.
B. A general purpose ANSI compliant in-memory database.
C. Used to store mountains of OLAP data.
D. A hardware product made by hardware manufacturers.
Ans: B
19. What is SAP HANA Appliance?
A. It is a combination of software from SAP and certified hardware from vendors like Dell, IBM, Cisco, Fujitsu.
B. It is a piece of hardware from vendors like Dell, IBM, Cisco, Fujitsu.
C. Is solely produced by SAP AG only.
D. It is a combination of BI, BOBJ and HANA.
Ans: A
20. What BI standards does HANA support? (3 correct answers)
A. ODBC
B. JDBC
C. MDX
D. MIME
Ans: A, B, C
21. Can SAP HANA database be used by any application, other than SAP?
A. Yes
B. No
Ans: B
22. SAP HANA server can be accessed by _______.
A. SAP GUI
B. Any web browser
C. Only Internet Explorer
D. HANA Studio
Ans: D
23. What method is used to extract tables from ECC server in real time?
A. SLT based table data provisioning
B. Information Design Tool (IDT)
C. BI R3 extraction services
D. None of the above
Ans: A
24. Which one of the following are components of SAP HANA Studio?
A. Navigator
B. Job Log
C. Where-Used List
D. All of the above
Ans: D
25. How many perspectives are available in SAP HANA Studio (SPS03)?
A. 4
B. 8
C. 9
D. 10
Ans: B
26. Which perspective is used to create joins?
A. Administration & Modeling
B. Debug & Modelling
C. Modeler
D. All of the above
Ans: C
27. The SAP HANA system can be created within _____
A. Modeler
B. Resource
C. Navigator
D. SAP GUI
Ans: C
28. Can we create multiple connections to the same SAP HANA system?
A. Yes
B. No
Ans: A
29. The login user who has maximum authorizations in a SAP HANA database is ______
A. SYS
B. SYSTEM
C. Administrator
D. Root
Ans: B
30. Can the attribute views be created with 1 table?
A. Yes
B. No
Ans: A
31. By default, the maximum number of rows displayed from a table is ______
A. 1000
B. 5000
C. Unlimited
D. None of the Above
Ans: B
32. For faster reads, SAP HANA reads the tables column wise.
A. True
B. False
Ans: A
33. Using SAP HANA Studio, table can be _______, ________, _______ (3 correct answers)
A. Created manually
B. Created using SQL
C. Replicated from other systems
D. Just copied from other systems
Ans: A,B,C
34. When Administration Console is the perspective selected, which of the following can be viewed under HANA system?
A. Catalog
B. Content
C. Both of them
D. None of them
Ans: A
35. Ultimately, SAP HANA database will replace all databases used in BI/BW, ECC and all other SAP Systems.
A. True
B. False
Ans: A
36. In the SAP HANA Studio the physical tables are stored ______
A. Under Catalogs
B. Under Content
C. In both
D. Nowhere
Ans: A
37. When deleting a table, what options can be selected? (2 correct answers)
A. Delete Catalog Object
B. Delete All Rows
C. Drop The Table
D. All of the above
Ans: A,B
38. Users are created under ______.
A. Catalog
B. Content
C. Any of them
D. None of them
Ans: A
39. Can SAP HANA run on SUSE Linux?
A. Yes
B. No
Ans: A
40. The option to send a table from Quality Assurance System to Production System is _______.
A. Use CTS+
B. Use Import from Quality Assurance System
C. Use Export from Quality Assurance System
D. Use Transport Management System
41. To create a user, we have to ________.
A. Use T-Code SU01
B. Use T-Code SU10
C. Use Users folder under Authorization in Catalog
D. Use Users folder under Authorization in Content
Ans: C
42. Which user has privileges to Root Package?
A. SYS
B. SYSTEM
C. Both of the above
D. Administrator
Ans: B
43. Which role is specifically assigned to a user involved in creating views?
A. SAPSR3_POWER_USER
B. PUBLIC
C. MODELING
D. None of the above
Ans: C
44. SAP HANA system is memory based and persistent storage is not necessary.
A. True
B. False
Ans: B
45. SAP HANA contains OLAP data (only) in the memory.
A. True
B. False
Ans: B
46. When you are creating a SAP HANA system in the SAP HANA Studio, a user should be used as the logon user. SYSTEM can be the only user for this
purpose.
A. True
B. False
Ans: B
47. If you have only one SAP HANA system physically, then you can create only one HANA system icon in the SAP HANA Studio.
A. True
B. False
Ans: B
48. SAP HANA database is ______.
A. Oracle based
B. Sybase based
C. MS SQL based
D. Informix based
Ans: B
49. Joins are created under ______.
A. Content
B. Catalog
C. Schema
D. Authorization
Ans: A
50. In SAP HANA Studio, HANA systems can be created under nested folders identical to the departments in your company.
A. True
B. False
Ans: A
51. How can you import information models into SAP HANA using the Quick Launch view?
A. Choose the Redeploy button.
B. Choose Import -> SAP HANA Content -> Delivery Unit.
C. Choose Data Provisioning -> Load.
D. Choose Import -> SAP HANA Content -> Import Data From Local File.
Answer: B
52. Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?
A. Only the last active version
B. The last active and inactive versions
C. All active and inactive versions
D. All active versions
Answer: D
53. Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system?
A. Generate and save an export file.
B. Mass copy the content repository into the other SAP HANA system.
C. Assign the package to a delivery unit.
D. Assign the content repository to a transport request.
Answer: A, C
54. 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 available for reporting.
B. The active view is in "read-only" mode.
C. The inactive view is in "read-only" mode.
D. The active view is not available for reporting.
Answer: B
55. 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. Where-used function
C. Auto Documentation function
D. Display XML function
Answer: B, C
56. Which of the following can be grouped inside a single schema in an SAP HANA database?
A. Information models
B. Packages
C. Users
D. Database tables
Answer: D
57. 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)?
A. Export the models from system1.
B. Create a delivery unit on system1.
C. Create a delivery unit on system2.
D. Import the models into system2.
E. Create a schema on system2.
Answer: A, B, D
58. Which of the following SAP HANA schemas contains the runtime objects of activated views?
A. _SYS_STATISTICS
B. _SYS_REPO
C. _SYS_BI
D. _SYS_BIC
Answer: D
59. 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 could you use?
A. Python-based text analysis scripts
B. Full-text search UI toolkit
C. Application function libraries
D. Fuzzy search
Answer: A
60. Which of the following can be grouped inside a single schema in an SAP HANA database?
A. Information models
B. Packages
C. Users
D. Database tables
Answer: D
61. Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server?
A. Create repositories in the source system
B. Write data to the SAP HANA system using the DB connection
C. Map database structures between SAP HANA and the source system
D. Schedule replication processes
Answer: C, D
62. Which of the following is used to make hierarchies available to reporting tools?
A. CE Functions
B. MDX
C. SQLScript
D. SQL
Answer: B
63. 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)
Answer: B, D
64. You have set up replication from SAP ERP using SAP Landscape Transformation (SLT). You notice that the information models do not show the latest data from ERP. What do you check to investigate this?
A. Activation status of the information models
B. Transaction SAP ERP Data Modeler (SD11)
C. Transaction LTR on SLT
D. Data Provisioning view in SAP HANA studio
Answer: C, D
65. When must you create a calculation view in SAP HANA?
A. When you need to create a star schema
B. When key figures (measures) span across tables
C. When you need calculations before aggregations
D. When you need analytic operations like aggregation
Answer: B
66. 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
Answer: D
67. You want to create a custom attribute in addition to your data model. How can you achieve this?
A. Create the attribute as a calculated attribute within the analytic view
B. Create the attribute and add it to the appropriate system table manually
C. Create the attribute as a calculated measure within the attribute view
D. Create the attribute as a restricted attribute within the calculation view
Answer: A
68. You modify an existing view. How can you determine which models are affected by this change?
A. Use the audit trail
B. Use the History feature for the changed model
C. Use the "Where-Used List" feature for the changed model
D. Use the "Auto Documentation" to compare the object version of the changed model
Answer: C
69. Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?
A. Data Provisioning => SAP HANA system setup => Modeling => Consumption
B. SAP HANA system setup => Modeling => Data Provisioning => Consumption
C. SAP HANA system setup => Data Provisioning => Modeling => Consumption
D. SAP HANA system setup => Data Provisioning => Consumption => Modeling
Answer: C
70. Which of the following are benefits of implementing SAP HANA?
A. SAP HANA provides real-time analytics
B. SAP HANA performs much faster than the standard SAP ERP
C. SAP HANA provides pre-configured BI Content
D. SAP HANA combines OLTP and OLAP in one system
E. SAP HANA replaces SAP BW
Answer: A, B, D
71. A calculation view that joins one fact table with dimension tables performs slowly.
Which of the following can you do to improve performance?
A. Turn the calculation view into an analytic view
B. Turn the calculation view into a simple calculation view
C. Load the calculation view into memory
D. Load the calculation view into the _SYS_BI schema
Answer: A
72. 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?
A. SAP Landscape Transformation (SLT)
B. SAP BusinessObjects Data Services 4.0
C. SAP HANA Direct Extractor Connection (DXC)
D. SAP System Landscape Directory (SLD)
Answer: B
73. 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?
A. Use a pre-defined prompt based on a self-join in the business layer
B. Use input from a Web Intelligence report passed to a variable in an information model
C. Use a dynamic transformation rule during data provisioning
D. Use a prompt in the query of the Web Intelligence report
Answer: B
74. Your SAP BusinessObjects report runs slowly. Which of the following actions could improve the performance?
A. Restrict data by using variables in the information model
B. Tune the Array Fetch Size parameter of the universe
C. Move calculated measures from the information model to the report
D. Join all the analytic views with each other in the business layer
Answer: A, B
75. 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 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 BusinessObjects Data Services
B. Whether an InfoCube compression is running
C. Whether the calculation view needs to create large intermediate result sets
D. Whether savepoints are written during execution
Answer: A, C
76. How can you improve the performance of a report that is based on SAP HANA data?
A. Ensure that all SAP HANA tables are in the same schema
B. Maintain appropriate constraint filters in SAP HANA
C. Ensure that all calculations are pushed down to the SAP HANA database
D. Gather new database statistics
Answer: B, C
77. 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)
Answer: B, D
78. When you load data from SAP ECC using SAP BusinessObjects Data Services, where would you create an ABAP data flow?
A. In a query transformation
B. In a batch job
C. In the ABAP editor (transaction SE38)
D. In the Job overview (transaction SM37)
Answer: B
79. When must you create a calculation view in SAP HANA?
A. When you need to perform join operations
B. When you need calculations before aggregations
C. When key figures span across tables
D. When you need to perform a union of base tables
Answer: C, D
80. In which of the following can you use a FOR loop over your data?
A. Monitoring View
B. Calculation View
C. Analytic View
D. Attribute View
Answer: B
 |
| SAP HANA Multiple Choice Questions and Answers |
1. Which of the following is NOT a replication method for data replication from a source system to SAP Hana?
a. ETL based
b. Trigger based
c. Time based
d. Log based
Answer: c
2. Which of the following statements are true?
a. There are four types of information views: attribute view, analytic view, hierarchy view and calculation view. All these views are non-materialized views.
b. An analytic view is used to model data that includes measures.
c. Calculated attributes are derived from one or more existing attributes or constants.
d. Calculation views can include measures and be used for multidimensional reporting or can contain no measures and used for list-type of reporting
Answer: d
3. HANA supports which of the following hierarchies?
a. Time Based hierarchies
b. Level Hierarchies
c. Parent/Child Hierarchies
d. Matrix organization Hierarchies
Ans: b, c
4. SAP HANA modeler is a graphical data modeling tool which allows you to design analytical models and later analytical privileges, that governs the access to those models. Which of the following represents a logic flow of activities?
a. Import source system metadata -> Create Information Models -> Provision Data -> Deploy -> Consume
b. Import source system metadata -> Provision Data ->Create Information Models -> Deploy -> Consume
c. Import source system metadata -> Provision Data -> Deploy -> Create Information Models -> Consume
d. Import source system metadata -> Deploy ->Create Information Models -> Provision Data -> Consume
Ans: b
5. The two queries below, which is more efficient?
a. Matmoves = SELECT * FROM MSEG
FOR EACH matmove in matmoves
IF matmove.whichPlant = “I” THEN
Plant_text = SELECT plant_text FROM WERKS WHERE id = matmove.plant
ELSE
Plant_text = SELECT plant_text FROM WERKS_EXT WHERE id=matmove.
plant
END
b. If which_plant = “I” THEN
Plant_text = plant_int_text
ELSE
Plant_text = plant_ext_text
Ans: b
6 Which of the following statements are true?
a. One table may appear in exactly one schema
b. It is possible to grant authorizations on a table level.
c. Authorizations granted on a schema are automatically propagated to all objects within the schema
Ans: c
8. 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?
A. In the universe
B. In the Web Intelligence report
C. In the analytic view
D. In the calculation view using an attribute value variable
Ans: C
9. What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? (Choose three)
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.
Ans: A,C,D
10. Which of the following properties of a derived attribute view can you modify?
A. Description
B. Description mapping
C. Calculated attributes
D. Filters
Ans: A
11. How can you evaluate the speed of a calculation within the database? (Choose two)
A. Use the Data Preview function in the SAP HANA studio.
B. Execute a Web Intelligence report and check the duration of the previous refresh.
C. Execute an information space using SAP Business Objects Explorer.
D. Write and execute an appropriate SQL statement.
Ans: A,D
12. If you want to create or drop tables in a schema, which privilege type do you need?
A. SYSTEM
B. ANALYTIC
C. PACKAGE
D. SQL
Ans: D
13. Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?
A. Crystal Reports
B. Dashboards
C. Explorer
D. WebIntelligence
Ans: D
14. Which new connection type is available as of SAP BusinessObjects Data Services 4.0?
A. Operational Data Provider
B. BAPI function calls
C. IDOCs
D. Read table via ABAP data flows
Ans: A
15. Which of the following tasks must you perform before you build a business layer within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA?
A. Publish the connection to CMS.
B. Build a query to test the connection.
C. Build a relational connection to SAP HANA.
D. Build an OLAP connection to SAP HANA.
E. Build a data foundation.
Ans: A,C,E
16. Which delivered role is mandatory for a system administrator in SAP HANA?
A. SYS_ADMIN
B. CONTENT_ADMIN
C. SAP_ALL
D. IC MODELER
Ans: B
17. What are benefits of using a business layer on top of SAP HANA? (Choose two)
A. An extra layer of granular security
B. Improved database calculation speed
C. Fast throughput via BICS connectivity
D. Users can use business names instead of technical names
Ans: A,D
18. SAP HANA database is ____
A. A sort of SAP GUI used to access SAP servers.
B. A general purpose ANSI compliant in-memory database.
C. Used to store mountains of OLAP data.
D. A hardware product made by hardware manufacturers.
Ans: B
19. What is SAP HANA Appliance?
A. It is a combination of software from SAP and certified hardware from vendors like Dell, IBM, Cisco, Fujitsu.
B. It is a piece of hardware from vendors like Dell, IBM, Cisco, Fujitsu.
C. Is solely produced by SAP AG only.
D. It is a combination of BI, BOBJ and HANA.
Ans: A
20. What BI standards does HANA support? (3 correct answers)
A. ODBC
B. JDBC
C. MDX
D. MIME
Ans: A, B, C
21. Can SAP HANA database be used by any application, other than SAP?
A. Yes
B. No
Ans: B
22. SAP HANA server can be accessed by _______.
A. SAP GUI
B. Any web browser
C. Only Internet Explorer
D. HANA Studio
Ans: D
23. What method is used to extract tables from ECC server in real time?
A. SLT based table data provisioning
B. Information Design Tool (IDT)
C. BI R3 extraction services
D. None of the above
Ans: A
24. Which one of the following are components of SAP HANA Studio?
A. Navigator
B. Job Log
C. Where-Used List
D. All of the above
Ans: D
25. How many perspectives are available in SAP HANA Studio (SPS03)?
A. 4
B. 8
C. 9
D. 10
Ans: B
26. Which perspective is used to create joins?
A. Administration & Modeling
B. Debug & Modelling
C. Modeler
D. All of the above
Ans: C
27. The SAP HANA system can be created within _____
A. Modeler
B. Resource
C. Navigator
D. SAP GUI
Ans: C
28. Can we create multiple connections to the same SAP HANA system?
A. Yes
B. No
Ans: A
29. The login user who has maximum authorizations in a SAP HANA database is ______
A. SYS
B. SYSTEM
C. Administrator
D. Root
Ans: B
30. Can the attribute views be created with 1 table?
A. Yes
B. No
Ans: A
31. By default, the maximum number of rows displayed from a table is ______
A. 1000
B. 5000
C. Unlimited
D. None of the Above
Ans: B
32. For faster reads, SAP HANA reads the tables column wise.
A. True
B. False
Ans: A
33. Using SAP HANA Studio, table can be _______, ________, _______ (3 correct answers)
A. Created manually
B. Created using SQL
C. Replicated from other systems
D. Just copied from other systems
Ans: A,B,C
34. When Administration Console is the perspective selected, which of the following can be viewed under HANA system?
A. Catalog
B. Content
C. Both of them
D. None of them
Ans: A
35. Ultimately, SAP HANA database will replace all databases used in BI/BW, ECC and all other SAP Systems.
A. True
B. False
Ans: A
36. In the SAP HANA Studio the physical tables are stored ______
A. Under Catalogs
B. Under Content
C. In both
D. Nowhere
Ans: A
37. When deleting a table, what options can be selected? (2 correct answers)
A. Delete Catalog Object
B. Delete All Rows
C. Drop The Table
D. All of the above
Ans: A,B
38. Users are created under ______.
A. Catalog
B. Content
C. Any of them
D. None of them
Ans: A
39. Can SAP HANA run on SUSE Linux?
A. Yes
B. No
Ans: A
40. The option to send a table from Quality Assurance System to Production System is _______.
A. Use CTS+
B. Use Import from Quality Assurance System
C. Use Export from Quality Assurance System
D. Use Transport Management System
41. To create a user, we have to ________.
A. Use T-Code SU01
B. Use T-Code SU10
C. Use Users folder under Authorization in Catalog
D. Use Users folder under Authorization in Content
Ans: C
42. Which user has privileges to Root Package?
A. SYS
B. SYSTEM
C. Both of the above
D. Administrator
Ans: B
43. Which role is specifically assigned to a user involved in creating views?
A. SAPSR3_POWER_USER
B. PUBLIC
C. MODELING
D. None of the above
Ans: C
44. SAP HANA system is memory based and persistent storage is not necessary.
A. True
B. False
Ans: B
45. SAP HANA contains OLAP data (only) in the memory.
A. True
B. False
Ans: B
46. When you are creating a SAP HANA system in the SAP HANA Studio, a user should be used as the logon user. SYSTEM can be the only user for this
purpose.
A. True
B. False
Ans: B
47. If you have only one SAP HANA system physically, then you can create only one HANA system icon in the SAP HANA Studio.
A. True
B. False
Ans: B
48. SAP HANA database is ______.
A. Oracle based
B. Sybase based
C. MS SQL based
D. Informix based
Ans: B
49. Joins are created under ______.
A. Content
B. Catalog
C. Schema
D. Authorization
Ans: A
50. In SAP HANA Studio, HANA systems can be created under nested folders identical to the departments in your company.
A. True
B. False
Ans: A
51. How can you import information models into SAP HANA using the Quick Launch view?
A. Choose the Redeploy button.
B. Choose Import -> SAP HANA Content -> Delivery Unit.
C. Choose Data Provisioning -> Load.
D. Choose Import -> SAP HANA Content -> Import Data From Local File.
Answer: B
52. Which versions of your information models are visible on the History tab of the Modeler perspective in the SAP HANA studio?
A. Only the last active version
B. The last active and inactive versions
C. All active and inactive versions
D. All active versions
Answer: D
53. Which of the following actions must you perform in an SAP HANA system to transport content to another SAP HANA system?
A. Generate and save an export file.
B. Mass copy the content repository into the other SAP HANA system.
C. Assign the package to a delivery unit.
D. Assign the content repository to a transport request.
Answer: A, C
54. 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 available for reporting.
B. The active view is in "read-only" mode.
C. The inactive view is in "read-only" mode.
D. The active view is not available for reporting.
Answer: B
55. 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. Where-used function
C. Auto Documentation function
D. Display XML function
Answer: B, C
56. Which of the following can be grouped inside a single schema in an SAP HANA database?
A. Information models
B. Packages
C. Users
D. Database tables
Answer: D
57. 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)?
A. Export the models from system1.
B. Create a delivery unit on system1.
C. Create a delivery unit on system2.
D. Import the models into system2.
E. Create a schema on system2.
Answer: A, B, D
58. Which of the following SAP HANA schemas contains the runtime objects of activated views?
A. _SYS_STATISTICS
B. _SYS_REPO
C. _SYS_BI
D. _SYS_BIC
Answer: D
59. 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 could you use?
A. Python-based text analysis scripts
B. Full-text search UI toolkit
C. Application function libraries
D. Fuzzy search
Answer: A
60. Which of the following can be grouped inside a single schema in an SAP HANA database?
A. Information models
B. Packages
C. Users
D. Database tables
Answer: D
61. Which of the following are functions of the controller in the SAP Landscape Transformation (SLT) server?
A. Create repositories in the source system
B. Write data to the SAP HANA system using the DB connection
C. Map database structures between SAP HANA and the source system
D. Schedule replication processes
Answer: C, D
62. Which of the following is used to make hierarchies available to reporting tools?
A. CE Functions
B. MDX
C. SQLScript
D. SQL
Answer: B
63. 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)
Answer: B, D
64. You have set up replication from SAP ERP using SAP Landscape Transformation (SLT). You notice that the information models do not show the latest data from ERP. What do you check to investigate this?
A. Activation status of the information models
B. Transaction SAP ERP Data Modeler (SD11)
C. Transaction LTR on SLT
D. Data Provisioning view in SAP HANA studio
Answer: C, D
65. When must you create a calculation view in SAP HANA?
A. When you need to create a star schema
B. When key figures (measures) span across tables
C. When you need calculations before aggregations
D. When you need analytic operations like aggregation
Answer: B
66. 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
Answer: D
67. You want to create a custom attribute in addition to your data model. How can you achieve this?
A. Create the attribute as a calculated attribute within the analytic view
B. Create the attribute and add it to the appropriate system table manually
C. Create the attribute as a calculated measure within the attribute view
D. Create the attribute as a restricted attribute within the calculation view
Answer: A
68. You modify an existing view. How can you determine which models are affected by this change?
A. Use the audit trail
B. Use the History feature for the changed model
C. Use the "Where-Used List" feature for the changed model
D. Use the "Auto Documentation" to compare the object version of the changed model
Answer: C
69. Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?
A. Data Provisioning => SAP HANA system setup => Modeling => Consumption
B. SAP HANA system setup => Modeling => Data Provisioning => Consumption
C. SAP HANA system setup => Data Provisioning => Modeling => Consumption
D. SAP HANA system setup => Data Provisioning => Consumption => Modeling
Answer: C
70. Which of the following are benefits of implementing SAP HANA?
A. SAP HANA provides real-time analytics
B. SAP HANA performs much faster than the standard SAP ERP
C. SAP HANA provides pre-configured BI Content
D. SAP HANA combines OLTP and OLAP in one system
E. SAP HANA replaces SAP BW
Answer: A, B, D
71. A calculation view that joins one fact table with dimension tables performs slowly.
Which of the following can you do to improve performance?
A. Turn the calculation view into an analytic view
B. Turn the calculation view into a simple calculation view
C. Load the calculation view into memory
D. Load the calculation view into the _SYS_BI schema
Answer: A
72. 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?
A. SAP Landscape Transformation (SLT)
B. SAP BusinessObjects Data Services 4.0
C. SAP HANA Direct Extractor Connection (DXC)
D. SAP System Landscape Directory (SLD)
Answer: B
73. 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?
A. Use a pre-defined prompt based on a self-join in the business layer
B. Use input from a Web Intelligence report passed to a variable in an information model
C. Use a dynamic transformation rule during data provisioning
D. Use a prompt in the query of the Web Intelligence report
Answer: B
74. Your SAP BusinessObjects report runs slowly. Which of the following actions could improve the performance?
A. Restrict data by using variables in the information model
B. Tune the Array Fetch Size parameter of the universe
C. Move calculated measures from the information model to the report
D. Join all the analytic views with each other in the business layer
Answer: A, B
75. 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 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 BusinessObjects Data Services
B. Whether an InfoCube compression is running
C. Whether the calculation view needs to create large intermediate result sets
D. Whether savepoints are written during execution
Answer: A, C
76. How can you improve the performance of a report that is based on SAP HANA data?
A. Ensure that all SAP HANA tables are in the same schema
B. Maintain appropriate constraint filters in SAP HANA
C. Ensure that all calculations are pushed down to the SAP HANA database
D. Gather new database statistics
Answer: B, C
77. 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)
Answer: B, D
78. When you load data from SAP ECC using SAP BusinessObjects Data Services, where would you create an ABAP data flow?
A. In a query transformation
B. In a batch job
C. In the ABAP editor (transaction SE38)
D. In the Job overview (transaction SM37)
Answer: B
79. When must you create a calculation view in SAP HANA?
A. When you need to perform join operations
B. When you need calculations before aggregations
C. When key figures span across tables
D. When you need to perform a union of base tables
Answer: C, D
80. In which of the following can you use a FOR loop over your data?
A. Monitoring View
B. Calculation View
C. Analytic View
D. Attribute View
Answer: B
No comments:
Post a Comment