C_HANAIMP_13 SAP Certified Application Associate – SAP HANA 2.0 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 2.0.

1. You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to specify?
There are 2 correct answers to this question.
a) LANGUAGE SQLSCRIPT
b) WITH RESULTS VIEW
c) SEQUENTIAL EXECUTION
d) READS SQL DATA

2. Which of the following are reasons you should use Core Data Services (CDS) to create a schema? There are 2 correct answers to this question.
a) The database administrator might type the name wrong.
b) The database administrator should not get those privileges in the production system.
c) The focus is on the business requirements.
d) The focus is on the database administration requirements.

3. Which technologies does SAP HANA use to load more data into memory?
There are 3 correct answers to this question.
a) Eliminate indices
b) Use RAR compression
c) Use dictionary compression
d) Store data in column tables
Questions & Answers PDF P-3
e) Use multicore CPU parallelism

4. What does SAP HANA load when starting up and before indicating that it is ready?
There are 3 correct answers to this question.
a) All row tables
b) All system tables
c) All partitions
d) Some column tables
e) Some row tables

5. For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer.
a) Transactional data
b) Master data
c) Materialized cube data
d) Calculated data

6. What type of input parameters do you use to choose the data from a field in the current table?
Please choose the correct answer.
a) Direct
b) Derived from table
c) Value help
d) Column

7. What happens when you activate an information model? ?
There are 2 correct answers to this question.
a) It generates a runtime object.
b) It reverts to the active version.
c) It checks the validation rules.
d) It exports an active version.

8. You want to publish your business intelligence content directly to SAP Cloud for Analytics. Which tool do you use?
There are 2 correct answers to this question.
a) SAP Predictive Analytics
b) SAP Lumira
c) SAP Crystal Reports for Enterprise
d) SAP BusinessObjects Analysis, edition for Microsoft Office

9. Which text feature do you use to find sentiment in textual data?
Please choose the correct answer.
a) Full-text index
b) Fuzzy text search
c) Text analysis
d) Text mining

10. Global session variables can be used in SQLScript to share a scalar value between procedures and
functions that are running in the same session. The value of a global session variable is not visible
from another session.
Please choose the correct answer.
a) SET <key>= <value>;
b) SET <value>= <key>;
c) SET <key>= <global>;
d) SET <global>= <key>;

11. Modeling package Shops is a subpackage of package Regions.
You want to authorize a user to list the content of package Regions, but prevent listing the content of
package Shops. How can you achieve this?
Please choose the correct answer.
a) Refactor package Shops to another package.
b) Assign REPO.EXPORT only to package Shops.
c) Assign REPO.READ privilege only to package Regions.
d) Revoke analytic privileges for models in package Shops.

12. Which deployment scenario can you use to accelerate reporting from an old SAP R/3 4.6C system?
Please choose the correct answer.
a) SAP HANA as a database
b) SAP HANA as a platform
c) SAP HANA as a sidecar solution
d) SAP HANA multitenant database containers

13. You have logs from a website) How do you show the total number of website visitors that used a mobile phone?
There are 2 correct answers to this question.
a) Create a restricted column
b) Create an action
c) Create a filter expression
d) Create a rank column

14. For which data types does SAP HANA automatically create full-text indexes?
There are 3 correct answers to this question.
a) NVARCHAR
b) SHORTTEXT
c) BINTEXT
d) CLOB
e) TEXT

15. Refactoring is used with which of the following actions?
Please choose the correct answer.
a) Improving your modeling design
b) Translating
c) Transporting
d) Documenting
Answer: A

16. What node can you use to generate a column for use in sorting results?
Please choose the correct answer.
a) Aggregation node
b) Projection node
c) Rank node
d) Union node
Answer: C

17. What is the correct sequence for loading data with SAP Data Services?
Please choose the correct answer.
a) Extract Load Transform
b) Load Transform Extract
c) Load Extract Transform
d) Extract Transform Load
Answer: D

18. Where in the Systems view of SAP HANA studio can you create new SAP HANA models?
Please choose the correct answer.
a) In the schemas of the Catalog area
b) In the packages of the Catalog area
c) In the packages of the Content area
d) In the schemas of the Content area

19. What can be a remote data source for SAP HANA Remote Data Sync?
Please choose the correct answer.
a) UltraLite
b) Hadoop
c) SAP ASE
d) SAP IQ

20. Schema mapping is used during which process?
Please choose the correct answer.
a) Importing
b) Activation
c) Exporting
d) Validation

21. Which of the following data provisioning tools can provide a delta load of a table from the source system?
Please choose the correct answer.
a) SDS
b) SDA
c) DXC
d) Flat files

22. You are using the SAP HANA studio.
Which of the following SAP HANA modeling artifacts require the SAP HANA application function
modeler (AFM) to be installed? There are 3 correct answers to this question.
a) SAP HANA enterprise information manager (EIM) jobs
b) SAP HANA smart data streaming (SDS) projects
c) SAP HANA predictive analytics library (PAL) flows
d) SAP HANA extended application services (XS) programs
e) SAP HANA smart data access (SDA) queries

23. What can you use as data sources for a decision table? There are 2 correct answers to this question.
a) Table types
b) Scalar functions
c) CDS views
d) Calculation views

24. How do you move code to SAP HANA?
There are 2 correct answers to this question.
a) Delete the application server
b) Use stored procedures in SAP HANA
c) Use graphical data models in SAP HANA
d) Use row tables in SAP HANA

25. What are the values for X, Y, and Z?

Please choose the correct answer.
a) X = Customer 2, Y = 400, Z = 800.
b) X = Customer 1, Y = 400, Z = 400.
c) X = Customer 1, Y = 800, Z = 800.
d) X = Customer 2, Y = 200, Z = 400.

26. You are given an old government paper form with lines, blocks, and fields. You are asked to create a report that looks like this form. Which business intelligence tools do you use?
Please choose the correct answer.
a) SAP BusinessObjects Web Intelligence
b) SAP Crystal Reports for Enterprise
c) SAP BusinessObjects Design Studio
d) SAP Lumira

27. What character is used to terminate SQL statements?
Please choose the correct answer.
a) ? (question mark)
b) : (colon)
c) ; (semicolon)
d) . (period)

28. Which type of cloud solution is SAP HANA Enterprise Cloud (HEC) an exam- ple of?
Please choose the correct answer.
a) Platform as a Service (PaaS)
b) Infrastructure as a Service (IaaS)
c) Software as a Service (SaaS)
d) Managed Cloud as a Service (MCaaS)

29. In which deployment scenarios does security stay in the application server, and end-users do not log into the SAP HANA system?
There are 2 correct answers to this question.
a) SAP HANA as a platform with an SAP HANA XS application
b) SAP HANA as a database
c) SAP HANA as a sidecar solution
d) SAP HANA as an accelerator

30. In which SAP HANA solution do you eliminate stored data, like year-to-date figures?
Please choose the correct answer.
a) SAP BW on SAP HANA
b) SAP CRM on SAP HANA
c) SAP S/4HANA
d) SAP HANA Enterprise Cloud

31. Which of the following describe design-time objects?
There are 3 correct answers to this question.
a) Repository objects
b) Native objects
c) Catalog objects
d) Inactive
e) Active

32. What can you use to limit users to see only 2016 data?
There are 2 correct answers to this question.
a) An object privilege
b) A SQL analytic privilege
c) A view with a filter
d) A view with a restricted column

33. In which SAP HANA deployment scenarios will end users be created as users in the SAP HANA system?
There are 2 correct answers to this question.
a) SAP BW powered by SAP HANA
b) SAP S/4HANA
c) SAP HANA as a platform
d) SAP HANA Live

34. What can a variable be used for?
Please choose the correct answer.
a) Currency conversion
b) Calculated column expression
c) Call decision table in SQLScript
d) Filtering

35. The Data Provisioning Monitor provides a browser-based interface to monitor agents, tasks, design-time objects (flowgraphs and replication tasks), and remote subscriptions created in the SAP HANA system. After you take steps to set up this Data Provisioning Monitor.

Which of the following way you can view the Data Provisioning Monitors? There are 2 correct answers to this question
a) Enter the URL address of each monitor directly into a web browser.
b) Access smart data integration links in the SAP HANA cockpit.
c) Monitor Enterprise Semantic Services publications and the Entity Grid
d) Monitor CDS view integration links in the SAP HANA Studio.

36. What system privilege do you need to create a delivery unit?
Please choose the correct answer.
a) REPO.EXPORT
b) REPO.IMPORT
c) REPO.MAINTAIN_DELIVERY_UNITS
d) REPO.WORK_IN_FOREIGN_WORKSPACE

37. What type of load does SAP HANA perform when starting up?
Please choose the correct answer.
a) Lazy load
b) Complete load
c) Fast load
d) Log load

38. Which type of cloud solution is Amazon Web Services (AWS) an example of?
Please choose the correct answer.
a) Hybrid cloud
b) Public cloud
c) Private cloud
d) Community cloud

39. Where can you set the default value for the SAP client for the entire calcula- tion view?
Please choose the correct answer.
a) In the join node of the calculation view
b) In the semantic layer of the calculation view
c) In the default node of the calculation view
d) In the Window menu of SAP HANA studio

40. Which of the following are features of a data warehouse?
There are 3 correct answers to this question.
a) Consolidation
b) Data governance
c) Both OLTP and OLAP in one system
d) Real-time reporting
e) A full transactional history

41. What is the default node for a calculation view of type cube?
Please choose the correct answer.
a) Aggregation node
b) Projection node
c) Star join node
d) Join node

42. Which join type makes use of date ranges?
Please choose the correct answer.
a) Spatial join
b) Text join
c) Temporal join
d) Inner join

43. Which programming language do you use for streaming projects?
Please choose the correct answer.
a) CCL
b) JavaScript
c) SQL
d) SQLScript

44. What enables the delta buffer technique to speed up both reads and inserts in SAP HANA?
Please choose the correct answer.
a) Using column-based tables only
b) Using row-based tables only
c) Using both row-based and column-based tables
d) Using only the insert-only technique

45. With which statement can you call a table function?
There are 2 correct answers to this question.
a) CALL
b) INSERT INTO
c) SELECT
d) EXEC

46. What should you keep in mind when using dynamic SQL?
There are 2 correct answers to this question.
a) It is always bad for security.
b) It could be used for SQL injection.
c) You can dynamically change your data sources.
d) It delivers the best possible performance.

47. Which join types are available in a join node of a calculation view?
There are 2 correct answers to this question.
a) Referential joins
b) Spatial joins
c) Cross joins
d) Temporal joins

48. You want to reuse a decision table on multiple tables with a similar data structure) You design the decision table that passes a specific table name as an input parameter when you execute the decision table. What do you have to use in the data foundation to achieve this?
Please choose the correct answer.
a) A dynamic join
b) A scripted calculation view
c) A table type
d) A virtual table

49. What must be installed for PAL to work?
Please choose the correct answer.
a) SAP HANA BFL
b) SAP HANA AFL
c) SAP HANA AFM
d) SAP HANA SINA

50. What join type should you use to see all the suppliers?
Please choose the correct answer.
a) Left outer join
b) Right outer join
c) Inner join
d) Referential join

51. What does SAP HANA smart data integration use for data provisioning?
There are 3 correct answers to this question
a) SAP HANA smart data access
b) SAP HANA smart data streaming
c) Database triggers
d) Database logs
e) Real-time adapters

52. What does the C in ACID-compliant stand for?
Please choose the correct answer.
a) Complexity
b) Consistency
c) Complete
d) Constant

53. Which tasks are part of the migration tool workflow?
There are 2 correct answers to this question.
a) The tool requires a graphical calculation view as input.
b) The tool requires a script-based calculation view as input.
c) The tool produces only a table function.
d) The tool produces a table function linked to a graphical calculation view.

54. When do you always have both an active and an inactive version of an infor- mation model available in the SAP HANA development system?
Please choose the correct answer.
a) When you edit an existing model
b) When you create a new model
c) When validation of a model fails
d) When you selected Revert to Active on an inactive version

55. What is the preferred way to create a procedure?
Please choose the correct answer.
a) Use the CREATE PROCEDURE statement in the SQL Console.
b) Create a .procedure file.
c) Create a .hdbprocedure file.
d) Use the context menu of a package.

56. Where in SAP HANA studio can you unload a table’s data from memory?
Please choose the correct answer.
a) The context menu of the table
b) The list of export destinations
c) The data preview of the table
d) The table definition

57. In a graphical calculation view of type cube, two tables are joined on multiple columns in a join node.Most queries using the view have no problems, but one query always gets a query runtime error.
What is the cause of this error?
Please choose the correct answer.
a) The two tables do NOT have referential integrity.
b) An incorrect column was selected when the join was formed.
c) The language column is NOT specified in the join.
d) The two tables are joined with a dynamic join.

58. You execute the performance validations for a calculation view. Which columns are checked by the ‘Calculation in filter expression’ rule? Please choose the correct answer.
a) Generated columns
b) Numeric columns
c) Aggregated columns
d) Restricted columns

59. What PAL algorithm would you use to analyze shopping baskets?
Please choose the correct answer.
a) K-means
b) Decision tree
c) Apriori
d) Link prediction

60. To start and stop Data Provisioning tasks, which are the following privileges should users have to start or stop tasks?
There are 2 correct answers to this question
a) Start task: sap.hana.im.dp.monitor::StartTask
b) Stop task: sap.hana.io.dp.monitor::StopTask
c) Stop task: sap.hana.im.dp.monitor::StopTask
d) Start task: sap.hana.io.dp.monitor::StartTask

61. You are working with a currency measure) What is decimal shift used for?
Please choose the correct answer.
a) Increase the accuracy of the currency conversion
b) To undo the decimal adjustment for ABAP
c) For currencies with more than two decimal places
d) Avoid rounding errors during the conversion

62. In which subfolder of the _SYS_BIC schema do you find activated information models?
Please choose the correct answer.
a) Column Views
b) Procedures
c) Views
d) Functions

63. For what SQL keyword is the aggregation node the equivalent?
Please choose the correct answer.
a) ORDER BY
b) GROUP BY
c) DISTINCT
d) UNIQUE

64. What can be used to return multiple result sets?
There are 2 correct answers to this question.
a) Scalar function
b) Table function
c) Procedure
d) View

65. What SELECT statement is not recommended for use with column tables?
Please choose the correct answer.
a) SELECT *
b) SELECT with a time-travel clause
c) SELECT ALL
d) SELECT in a subquery

66. You rename a field in the semantics node to add clarity for end-users. What does SAP HANA use to keep track of what the original field name is?
Please choose the correct answer.
a) The label column property
b) The mapping property
c) The label property
d) The name property

67. You want to use a web-based transport system on your Apple iPad) What tool do you use?
Please choose the correct answer.
a) SAP Solution Manager
b) SAP HANA Application Lifecycle Manager
c) Developer mode
d) CTS

68. What performance techniques should you implement to improve join performance?
There are 3 correct answers to this question.
a) Use unions instead of joins for combining large data sets.
b) Always specify the cardinality of a join.
c) Join as many tables as possible in an analytic view’s data foundation.
d) Use left outer joins instead of right outer joins.
e) Always mark joins as dynamic to improve performance.

69. Which features are similar between an analytic view and a calculation view of type cube with star join?
There are 3 correct answers to this question.
a) Fact tables
b) Spatial joins
c) Temporal joins
d) Referential joins
e) Star join nodes

70. What SQL construct do you use to return multiple result sets from a single SQL statement?
There are 2 correct answers to this question.
a) GROUPING SETS
b) SELECT subquery
c) JOIN
d) UNION

71. Which words are associated with the log volume?
There are 2 correct answers to this question.
a) Synchronous
b) Transaction manager
c) Page manager
d) Savepoint

72. You created a user-defined function with a return type of BIGINT. What type of function have you created?
Please choose the correct answer.
a) SQL function
b) Scalar function
c) Table function
d) Window function

73. You have created a SQL analytic privilege on an information view. Where do you tell the view to enable SQL analytic privileges?
Please choose the correct answer.
a) In the semantic node of the information model
b) In the restrictions settings of the SQL analytic privilege
c) In the SAP HANA studio preferences
d) In the migration tool

74. Which modeling views are fading out and are not available in the SAP HANA web-based
development workbench?
There are 2 correct answers to this question.
a) Analytic views
b) Scripted calculation views
c) Graphical calculation views
d) Attribute views

Learn SAP HANA 2.0 from Industry Experts

75. If we change the transaction “Laura buys 10 apples” to “Laura buys 10 green apples,” how would we store the color green?
Please choose the correct answer.
a) Store green as an attribute
b) Store green as a measure
c) Store green as a spatial data type
d) Store green as a CDS view

76. Which tab in SAP HANA studio shows validation check errors?
Please choose the correct answer.
a) Problems
b) Properties
c) History
d) Job Log

77. You created a procedure without defining the security option. Which user’s authorizations are checked when the procedure is executed in production?
Please choose the correct answer.
a) The user calling the function
b) The system administrator that transported the procedure
c) The _SYS_REPO user
d) The developer that created the procedure

78. You have a discussion with board members of a company. They want your recommendation on a business intelligence tool that they can use on their Apple iPad to display KPI dashboards. They also want a WYSIWYG design environment that allows scripting, should it be required.
Which tool do you recommend?
Please choose the correct answer.
a) SAP BusinessObjects Design Studio
b) SAP Lumira
c) SAP Crystal Reports for Enterprise
d) SAP BusinessObjects Web Intelligence

79. You have a list of map locations for clinics. The government wants to build a new clinic but wants to build it where there is the greatest need.
You need to find the largest distance between any two clinics. With your current knowledge, how do you do this?
Please choose the correct answer.
a) Use a temporal join to find the distance between clinics. Use a union with constant values to
“pivot” the values.
b) Use a spatial join to find the distance between clinics. Use a level hierarchy for drill-down.
c) Use a dynamic join to find the longest distance between clinics. Use a ranking to find the top 10 values.
d) Use a spatial join to find the distance between clinics. Use an aggregation with the maximum
option.

80. What information can you find in the Visualize Plan tool?
There are 2 correct answers to this question.
a) The execution engines used
b) The number of records returned in each step
c) The time taken for each step
d) The SQL Plan Cache

81. You create a full-text index. For what text feature clause do you need to specify a configuration?
Please choose the correct answer.
a) SEARCH ONLY
b) FUZZY SEARCH INDEX
c) TEXT MINING
d) TEXT ANALYSIS

82. You want to rename an information view with the SAP HANA Modeler without losing its existing behavior. What are the next steps after the renaming utility has finished?
There are 2 correct answers to this question.
a) Adjust references to the information view in table functions.
b) Adjust references to the information view in graphical calculation views.
c) Adjust references to the information view in analytic views.
d) Adjust references to the information view in procedures.

83.In which SAP HANA studio perspective do you find the Quick View tab options?
Please choose the correct answer.
a) Administration perspective
b) Developer perspective
c) Modeler perspective
d) Plan visualizer perspective

84. What engine executes the spatial queries?
Please choose the correct answer.
a) Calculation
b) OLAP
c) Join
d) SQL

85. The company’s board members want to run simulations on the year-end financial data) What do you use to build this for them?
Please choose the correct answer.
a) A parent-child hierarchy
b) A variable
c) An expression
d) A decision table

85. The entity is the core artifact for persistence-model definition using the CDS syntax. You create a database entity as a design-time file in the SAP HANA repository.
Which are the following prerequisites to create an entity in CDS (core data services)?
There are 2 correct answers to this question
a) You must have access to an SAP HANA system
b) You must have already created a development workspace and a project.
c) You must have access to the schema for the CDS catalog objects
d) You must have deployed to the schema for the CDS catalog objects

86. As what are most of the views in SAP HANA Live created?
Please choose the correct answer.
a) Table functions
b) Calculation views
c) CDS data sources
d) Cubes

87. What artifacts do you use in the output area of a decision table node?
There are 2 correct answers to this question.
a) Input parameters
b) Restrictions
c) Actions
d) Conditions

88. Where is SAP HANA Live installed?
Please choose the correct answer.
a) On SLT
b) On the SAP ERP application server
c) In the reporting tool
d) In the SAP HANA database

89. In the SAP HANA modeler, what object does the ‘Rename and Adjust References’ feature apply to?
Please choose the correct answer.
a) A column in an information view
b) A node in an information view
c) An information view
d) An input parameter in an information view

90. What combination enabled real-time computing?
Please choose the correct answer.
a) In-memory technology with solid-state disks
b) In-memory technology and multi-core CPUs
c) Multicore CPUs and solid-state disks
d) Multicore CPUs with large level 1 cache

91. What API would you use in SAP HANA SPS 11/12 to display search results in an ABAP system?
Please choose the correct answer.
a) The esh_search procedure
b) SAP HANA Simple Info Access API (SINA)
c) SAP HANA Text Mining XS JavaScript API
d) SAP HANA Text Analysis XS JavaScript API

92. What do you create to find the number of unique items sold per shop?
Please choose the correct answer.
a) A calculation view with a restricted column in an aggregation node
b) A calculation view with a counter in a projection node
c) A calculation view with a counter in an aggregation node
d) An analytic view with a calculated column in a star join node

93. In which sequence is SAP ERP data exposed to a reporting tool using SAP HANA Live?
Please choose the correct answer.
a) – The reporting tool reads a private view.
– The private view is based on a query view.
– The query view is based on a table function.
b) – The reporting tool reads a query view.
– The query view is based on a reuse view.
– The reuse view is based on physical tables.
c) – The reporting tool reads a value help view.
– The value help view is based on a reuse view.
– The reuse view is based on a query view.
d) – The reporting tool reads a reuse view.
– The reuse view is based on a query view.
– The query view is based on physical tables.

94. Which SAP HANA column types are part of an SAP HANA graph workspace?
There are 2 correct answers to this question.
a) Source vertex column
b) Edge key column
c) Calculated column
d) Generated column

95. Which export option can you use to make backups of your own information models?
Please choose the correct answer.
a) CTS
b) Delivery units
c) Developer mode
d) SAP Support mode

96. What do you have to assign to users to allow single sign-on?
Please choose the correct answer.
a) SQL analytic privileges
b) Kerberos authentication
c) TRUST ADMIN system privilege
d) Application privileges

97. For what tasks would you use the Where-Used feature in SAP HANA?
Please choose the correct answer.
a) To find all places a transport is imported
b) To find all places where translations exist
c) To find all places a user updated information models
d) To find all places an information model is used

98. What statement is allowed in a user-defined function?
There are 2 correct answers to this question.
a) COMMIT
b) EXEC
c) INSERT
d) JOIN

99. Which are features of a calculated column?
There are 2 correct answers to this question.
a) It is a column in the result set
b) Its calculations are persisted
c) It is created in the output area
d) It is created in the semantics node

100. Which can a level hierarchy do?
Please choose the correct answer.
a) Have time-dependency
b) Be used for a bill of materials structure
c) Enable drill-down in a value help list
d) Show variable deepness in the data

101. Which of the following database terms are used when providing OLAP data with hierarchies?
There are 3 correct answers to this question.
a) ODBC
b) ODBO
c) BICS
d) JDBC
e) MDX

102. What is the recommended way to create full-text indexes going forward?
Please choose the correct answer.
a) User-defined functions
b) Procedures
c) Core Data Services
d) SQL statements in the SQL Console

103. You need a business intelligence tool that is Microsoft Excel-based and can use parent-child hierarchies. Which tool do you use?
Please choose the correct answer.
a) SAP Lumira
b) SAP BusinessObjects Design Studio
c) SAP BusinessObjects Web Intelligence
d) SAP BusinessObjects Analysis, edition for OLAP

104. What variable type do you use if you want to allow the user to choose dates from 2011 to 2014?
Please choose the correct answer.
a) Single value
b) Interval
c) Range
d) Multiple entries

105. Which of the following VDM views can be called by applications and reports?
There are 2 correct answers to this question.
a) Reuse views
b) Value help views
c) Private views
d) Query views

106. Which business intelligence tools use BICS connectivity to SAP HANA?
There are 2 correct answers to this question.
a) Microsoft Excel
b) SAP BusinessObjects Analysis, edition for Microsoft Office
c) SAP Lumira
d) SAP BusinessObjects Design Studio

107. What are the advantages of columnar storage?
There are 2 correct answers to this question.
a) Improved compression
b) Improved data reading performance
c) Improved data writing performance
d) Improved performance when all fields are selected

108. You get the following requirements from a customer: They have a lot of purchasing data in their SAP system which they wish to analyze in SAP HANA.They want to have reports every morning showing the total expenditure per department. Their SAP BW developers have not yet had any SAP HANA training. Which data provisioning tool would you recommend?

Please choose the correct answer.
a) SLT
b) SDA
c) EIM
d) DXC

109. Look at Figure You are selling books that have been translated into various languages. What join type should you use?

Please choose the correct answer.
a) Left outer join
b) Text join
c) Temporal join
d) Referential join

110. Where can you create a filter expression?
Please choose the correct answer.
a) In an aggregation node
b) In a data foundation node
c) In a projection node
d) In the semantics node

111. What do you use in a SQL query to sort fuzzy text search results by relevance?
Please choose the correct answer.
a) RANK()
b) SCORE()
c) SORT BY
d) TOP

112. What can you do in the Raw tab of the data preview in SAP HANA studio?
There are 2 correct answers to this question.
a) Sort the entire data result set and show the top 200 records.
b) Show all distinct values in the entire data result set.
c) Create a graph while analyzing the entire data result set.
d) Export the entire data result set to your local machine.

113. What should you keep in mind about user-defined functions?
Please choose the correct answer.
a) They can use imperative logic.
b) They can commit transactions.
c) They can use dynamic SQL.
d) They can call procedures.

114. You create a graphical calculation view that is consumed in ABAP.
What setting in the currency semantics dialog box ensures that a currency column is interpreted correctly in the ABAP layer? Please choose the correct answer.
a) Decimal shift back
b) Conversion
c) Rounding
d) Decimal shift

115. Prior to modeling in SAP HANA, you want to check whether a table is row-based or column-based. How can you do this in the SAP HANA studio?
There are 2 correct answers to this question.
a) View the icon of the table.
b) Select the Open Definition option.
c) Select the Open Content option.
d) Select the Open Data Preview option.

116. What should you keep in mind about procedures?
There are 3 correct answers to this question.
a) They can call views.
b) They are NOT open to SQL injection.
c) They must return values.
d) They may have input parameters.
e) They can call table functions.

117. Which actions do refactoring typically use?
There are 2 correct answers to this question.
a) Transporting
b) Deleting
c) Moving
d) Renaming

118. What information can you find in Performance Analysis Mode when you view the analysis for a join node?
There are 2 correct answers to this question.
a) The suggested filter for the tables in the join node
b) The total number of records returned by the node
c) The time taken by the join
d) The tables used by the join in the node

119. Which of the following terms are associated with an operational system?
There are 2 correct answers to this question.
a) OLTP
b) OLAP
c) Transactional
d) Data warehouse

120. What performance technique should you implement to improve join performance?
Please choose the correct answer.
a) Use joins instead of unions for combining large data sets.
b) Join on key fields between tables in a dimension view.
c) Do NOT use dynamic joins if you require optimal performance.
d) Always use referential joins in a star join views.

121. You have a view with two tables, joined by a left outer join. If you redesign the view and accidentally swap the two tables around, what should you do to the join?
Please choose the correct answer.
a) Keep the left outer join.
b) Change the join to a text join.
c) Change the join to a right outer join.
d) Change the join to a referential join.

122. Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge?
There are 2 correct answers to this question.
a) Creating business intelligence content with SAP BusinessObjects Design Studio
b) Creating a composite provider in SAP BW
c) Creating a report in SAP Crystal Reports for Enterprise
d) Creating a REST web service in the SAP HANA XS engine

123. In which programming languages can you create procedures in SAP HANA?
There are 2 correct answers to this question.
a) SQLScript
b) L
c) JavaScript
d) R

124. Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution?
There are 3 correct answers to this question.
a) Partitioning
b) Disaster recovery
c) High availability
d) Failover
e) Backups

125. What performance technique should you implement to improve the performance of SAP HANA information views that include SQLScript?
Please choose the correct answer.
a) Use imperative logic.
b) Use SELECT *.
c) Break large statements into smaller steps.
d) Use dynamic SQL

126. You want to use a table to store results for each session but do not want to recreate the table for every session. What type of table should you create?
Please choose the correct answer.
a) History column table
b) Global temporary table
c) Local temporary table
d) Virtual table

127. In which type of node can you create calculated columns?
There are 2 correct answers to this question.
a) Rank node
b) Union node
c) Join node
d) Projection node

128. What SAP HANA information object does AFM create?
Please choose the correct answer.
a) Attribute view
b) Calculation view
c) Table function
d) Procedure

129. You have a list of map locations for clinics. The government wants to build a new clinic but wants to build it where there is the greatest need. You need to find the largest distance between any two clinics. With your current knowledge, how do you do this?
Please choose the correct answer.
a) Use a spatial join to find the distance between clinics. Use a level hierarchy for drill-down.
b) Use a spatial join to find the distance between clinics. Use an aggregation with the maximum
option.
c) Use a temporal join to find the distance between clinics. Use a union with constant values to
“pivot” the values.
d) Use a dynamic join to find the longest distance between clinics. Use a ranking to find the top 10 values.

130. Which tables do you need for currency conversion? Please choose the correct answer.
a) DD07*
b) TCUR*
c) BICS*
d) SHINE*

131. A referential join gives the same results as which other join type?
Please choose the correct answer.
a) Inner join
b) Left outer join
c) Spatial join
d) Star join

132. In what type of view can you use fuzzy text search directly?
Please choose the correct answer.
a) Analytic views
b) Calculation views of type dimension
c) Calculation views of type cube
d) Attribute views

133. A company sends out a lot of quotes. Some customers accept the quotes, and they’re invoiced) The company asks you to find a list of the customers that did NOT accept the quotes.
How do you find the customers that received quotes but did NOT receive invoices?
Please choose the correct answer.
a) Use a right outer join. Filter to show only the NULL values on the right table.
b) Use a left outer join. Filter to show only customers on the right table.
c) Use a left outer join. Filter to show only the NULL values on the right table.
d) Use a right outer join. Filter to show only customers on the left table.

134. You created a user-defined function with the INVOKER security option. Which user’s authorizations are checked when the function is executed?
Please choose the correct answer.
a) The owner of the function
b) The _SYS_REPO user
c) The SYSTEM user
d) The user calling the function

135. You are writing SQLScript code for handling sensitive data) What statement is prone to SQL injection?
Please choose the correct answer.
a) CREATE TYPE
b) INSERT INTO
c) GRANT
d) EXEC

136. You want to build a hierarchy on a time-based data structure) What type of hierarchy do you use? Please choose the correct answer.
a) Parent-child hierarchy
b) Level hierarchy
c) Ragged hierarchy
d) Unbalanced hierarchy

137. You build a financial report for the company’s board members that allows them to choose if they want the report to be in euros or dollars. What do you use?
Please choose the correct answer.
a) An input parameter from an aggregation node
b) A variable from the semantics node
c) A variable from a projection node
d) An input parameter from the semantics node

138. What feature is similar between an attribute view and a calculation view of type dimension?
Please choose the correct answer.
a) Full outer join
b) Fuzzy text search attributes
c) Derived views
d) Left outer join

139. You are writing a mobile application for the World Series. You have details about all the baseball players and the baseball scores for all the previous matches. How do you use the data of the player information and the scores? Please choose the correct answer.
a) Both the player information and the scores are used as master data.
b) Both the player information and the scores are used as transactional data.
c) The player information is used as master data, and the scores are used as transactional data.
d) The player information is used as transactional data, and the scores are used as master data.

140. You are creating a currency conversion. What options do you have for the Target Currency field? There are 3 correct answers to this question.
a) Select a fixed currency
b) Select a column
c) Use the Derived from Table option
d) Use an input parameter
e) Select a table type

141. You have to build a parent-child hierarchy. What type of join do you expect to use?
Please choose the correct answer.
a) Relational join
b) Temporal join
c) Dynamic join
d) Self-join

142. Which engine do most SAP HANA Live views use? Please choose the correct answer.
a) SQL engine
b) OLAP engine
c) Join engine
d) Calculation engine

143. Where do you create a variable?
Please choose the correct answer.
a) In the context menu of a package
b) In the semantics node
c) In the output area of a join node
d) In the scenario area of an aggregate node

144. Which of the following node types can you use to build an analytic view?
There are 3 correct answers to this question.
a) Star join node
b) Aggregation node
c) Data foundation node
d) Semantics node
e) Union node

145. To what subset of SQL does the SELECT statement belong?
Please choose the correct answer.
a) DML
b) DDL
c) DCL
d) DQL

146. The SAP HANA Direct Extractor Connection (DXC) provides SAP HANA with out-of-the-box
foundational data models based on SAP Business Suite entities.
Which are the following characteristics match with SAP HANA DXC?
There are 3 correct answers to this question
a) Batch-driven data acquisition and considered as a form of extraction
b) Reduces complexity of data modeling tasks
c) No additional server or application needed in a system landscape
d) Scale down the timelines for SAP HANA implementation projects
e) Provides a mechanism to properly handle data from all landscape processing

147. In which direction do you build calculation views when including the source tables in join nodes?
Please choose the correct answer.
a) From the join nodes up to the semantic node
b) From the semantic node up to the default node
c) From the join node down to the default node
d) From the semantic node down to the join nodes

148. Which of the following are examples of validation rules?
There are 2 correct answers to this question.
a) Check that tables contain data
b) Check formulas in calculated columns
c) Check that attribute views have a key attribute specified
d) Check that graphical calculation views have no orphan nodes

149. What PAL algorithm category can you use for supervised learning?
Please choose the correct answer.
a) Classification
b) Clustering
c) Association
d) Social network analysis

150. Of which SAP HANA process are the transaction manager and page manager a part?
Please choose the correct answer.
a) SAP HANA XS server
b) Statistics server
c) Index server
d) Name server

151. What information is available when you use the Explain Plan functionality on an SQL statement?
There are 2 correct answers to this question.
a) Estimated number of records
b) Estimated execution time
c) Execution engines
d) Operator names

152. What can you use to limit the number of records produced by a calculation view?
There are 3 correct answers to this question.
a) SAP client restrictions
b) Domain fix values
c) Filter expressions
d) Restricted columns
e) Generated columns

153. What performance techniques should you implement to improve the performance of SAP HANA information views?
There are 3 correct answers to this question.
a) Perform calculation before aggregation in your analytic views.
b) Minimize the transfer of data between the execution engines.
c) Investigate partitioning of large tables.
d) Apply filters as late as possible.
e) Push down aggregations to SAP HANA.

154. What is used in SQL to indicate that there is no value?
Please choose the correct answer.
a) Zero
b) Empty quotes
c) NULL
d) Spaces

155. What paradigm describes the SQL language?
Please choose the correct answer.
a) Set-oriented
b) Object-oriented
c) Procedural
d) Application-focused

156. Which are valid descriptions of delivery units?
There are 2 correct answers to this question.
a) Always consist of one package
b) Are used to transport runtime objects
c) Can be exported
d) Can be imported

157. What node is used to link dimension views to a data foundation (fact tables)?
Please choose the correct answer.
a) Join node
b) Projection node
c) Union node
d) Star join node

158. Which development tools are available for creating SAP HANA information models?
There are 2 correct answers to this question.
a) Java-based Eclipse tool
b) Web-based development tool
c) iPad app for development
d) Java applet in the browser

Register for the Live webinar on SAP HANA 2.0  by Industry Experts

159. Which spatial data formats can you import into SAP HANA?
There are 2 correct answers to this question.
a) Scalable Vector Graphic (SVG)
b) Well Known Text (WKT)
c) ESRI shapefiles
d) GeoJSON

160. What do you use a Transient Provider for?
Please choose the correct answer.
a) To use an SAP HANA calculation view in Microsoft Excel
b) To expose an SAP HANA calculation view as an OData web service
c) To expose an SAP BW information object inside SAP HANA
d) To use an SAP HANA calculation view in the SAP BW application

161. Which SAP HANA studio function displays the views that will be affected when you rename an attribute view?
Please choose the correct answer.
a) Neighbor
b) Where-used list
c) Properties
d) Tables used

162. In which SAP HANA views will you find measures?
There are 2 correct answers to this question.
a) Attribute views
b) Calculation view of type cube with star join
c) Calculation view of type cube
d) Database views

163. What does the migration tool allow you to migrate?
Please choose the correct answer.
a) XML analytic privileges to table functions
b) XML analytic privileges to SQL analytic privileges
c) SQL analytic privileges to XML analytic privileges
d) Object privileges to SQL analytic privileges

164. Which of the following SAP data provisioning methods provide complex transformations?
There are 2 correct answers to this question
a) SAP Data Services
b) SAP HANA smart data access
c) SAP Replication Server
d) SAP HANA smart data quality

165. Which of following are features associated with SAP HANA Live?
There are 2 correct answers to this question.
a) A new data warehouse
b) Hundreds of predeveloped views
c) Web-based tools
d) Precalculated aggregates stored in cubes

166. You have two calculation views for viewing manufactured products. The WORLD calculation view shows worldwide information.
The INDIA calculation view is built on top of the WORLD calculation view and shows information for Indian products.
What privilege must you assign to see your department’s specific data in a report built on the INDIA calculation view?
Please choose the correct answer.
a) An analytic privilege on the WORLD calculation view
b) An analytic privilege on the INDIA calculation view
c) An analytic privilege on both calculation views
d) An object privilege on the WORLD calculation view

167. What issue do you have to address after you have migrated your old views to calculation views?
Please choose the correct answer.
a) Change filters on table columns to filter expressions
b) Unhide the hidden fields in the semantics node
c) Manually migrate the base view for derived views
d) Check the analytic privileges for star join situations

168. Which of the following statements describe a standard SAP system landscape used for transports?
Please choose the correct answer.
a) It consists of only a quality assurance and a production system.
b) The quality assurance system is normally a recent copy of the production system.
c) Transports go from production to quality assurance.
d) You perform development in the quality assurance system.

169. Which of the following SAP data provisioning tools can provide real-time data provisioning?
There are 3 correct answers to this question.
a) SDI
b) SAP Data Services
c) SRS
d) DXC
e) SLT

170. What statement do you have to run before you can return table results from a procedure?
Please choose the correct answer.
a) CREATE TABLE TYPE
b) CREATE TYPE
c) CREATE TABLE
d) CREATE VIEW

171. What is a new and recommended way to work with SQL and SQLScript?
Please choose the correct answer.
a) Use CE functions rather than SQL syntax.
b) Use .procedure files rather than creating SQL and SQLScript via the package context menu.
c) Use table functions rather than scripted calculation views.
d) Create runtime objects rather than design-time objects.

172. What do you call the data displayed in the data foundation of an SAP HANA information view?
Please choose the correct answer.
a) Facets
b) Measures
c) Characteristics
d) Key figures

173. You want to retrieve data from a web application. Which of the following could you use?
There are 3 correct answers to this question.
a) JSON
b) REST
c) JDBC
d) BICS
e) OData

174. You created a calculated column in an analytic view for a table containing the number of units ordered, the price per unit, and the number of units in stock.
You get the wrong results in your results. What could be the problem?
Please choose the correct answer.
a) You mistyped the calculated column expression
b) You chose the SQL expression syntax
c) You did NOT enable calculation before aggregation
d) You did NOT enable the currency conversion

175. Which data provisioning tools can use SAP HANA adapters?
There are 2 correct answers to this question.
a) SDA
b) SDS
c) SDI
SRS

176. Which are the recommended assignments in SAP HANA?
There are 2 correct answers to this question.
a) Privileges to users
b) Roles to users
c) Roles to roles
d) Roles to privileges

177. Which of the following data provisioning tools can you use to read data directly from Twitter?
There are 3 correct answers to this question.
a) SRS
b) SAP HANA XS engine
c) SAP Data Services
d) SDI
e) SDA

178. What technique is used to convert record updates into insert statements in the delta buffer? Please choose the correct answer.
a) Unsorted inserts
b) Insert-only
c) Sorted inserts
d) Parallelism

179. Which types of calculation views can you create?
There are 2 correct answers to this question.
a) Standard
b) Derived
c) Materialized
d) Time-based

180. Why would you implement the SAP HANA Data Warehousing Foundation?
Please choose the correct answer.
a) To add OLAP data warehousing capabilities to SAP HANA
b) To implement an SQL-driven approach to data warehousing
c) To improve the loading and reporting performance of SAP Business Warehouse
d) To enable reporting on SAP HANA data using the full suite of SAP Business Objects

181. What are the rules for defining a stepparent in a hierarchy?
There are 2 correct answers to this question.
a) A stepparent only applies to parent-child hierarchies.
b) The stepparent node must already exist in the hierarchy at any level.
c) The stepparent node ID must be entered according to the node style you selected for the
hierarchy.
d) The stepparent node must already exist in the hierarchy at the root level.

182. Why should you use variables in SQL Script?
There are 2 correct answers to this question.
a) To implement flow control logic
b) To support processing push-down
c) To increase parallelization opportunities
d) To improve code readability

183. What are the features of dynamic analytic privileges?
There are 2 correct answers to this question.
a) Reuse the same analytic privilege for several users who need to access different data
b) Filter the data based on a variable entered by the user when they query the view
c) Change the filter condition in the underlying tables and views
d) Filter the condition based on a variable entered by the user when they query the view question.

184. Why do you create a time dimension calculation view?
Please choose the correct answer.
a) To support temporal joins in a cube calculation view with star schema
b) To enhance a calculation view with a drill-down on a time hierarchy
c) To provide date-based help values for a DIRECT type input parameter
d) To enable time dependency on parent-child hierarchies

185. Which of the following are characteristics of SAP HANA Smart Data Streaming?
Please choose the correct answer.
a) It uses databases queries
b) It is a standalone product for use with any target system.
c) It acts based on combinations of events
d) It provides reports and analysis on the received data.

186. You imported the following objects. Which of them always require activity from you before they can be built?
There are 2 correct answers to this question.
a) Synonyms definition
b) Multi-target application
c) Logical schema definition
d) SAP HANA database module

187. In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function?
There are 2 correct answers to this question.
a) The input parameter must be set to mandatory.
b) The generated value can be overwritten at runtime.
c) The function can return multiple values
d) The function must be of the type scalar.

188. Which of the following benefits characterize the use of a design-time filter?
There are 3 correct answers to this question.
a) It reduces the result set of data.
b) The filter is applied on the result set of a query.
c) It is defined on the runtime in the SQL query.
d) The filter is applied to the table before the query is executed.
e) It is applied before a table join is executed.

189. Why did SAP decide to use CDS for S/4HANA Analytics and not SAP HANA Live?
Please choose the correct answer.
a) More use cases are available with CDS than with SAP HANA Live.
b) Deeper BI functionality is available with CDS compared to SAP HANA Live.
c) CDS is tied to the application layer for better control of complete source code transportation.
d) Calculation views cannot be used with S/4HANA tables.

Click here to Download Answers