C_HANAIMP_17 – SAP Certified Application Associate – SAP HANA 2.0 (SPS05) (80 Questions)

The “SAP Certified Application Associate – SAP HANA 2.0 (SPS05)” certification exam confirms that the applicant holds the knowledge necessary for the profile of a SAP HANA application consultant in the domain of SAP HANA 2.0 based on SPS05. This certification expands upon the fundamental knowledge acquired through relevant SAP HANA training and, preferably, practised within a SAP HANA project team, where the consultant really employs newly learned knowledge in projects.

Topic Areas

C_HANAIMP_17 – SAP Certified Application Associate – SAP HANA 2.0 (SPS05) exam covers the following topics:

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

Exam details:

Here is the List of MCQ’s (Multiple Choice Questions):(The correct answers are mentioned with *)

1. You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view. Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?
a. Show lineage*
b. Database Explorer
c. Where used
d. Auto-map byname

2. When using the CONTAINS predicate, what are the restrictions you must keep in mind? Note: There are 2 correct answers to this question.
a. Non-physical columns, such as calculated columns, are not search-relevant*
b. The NOT (-) operator can only be specified directly after the OR operator.
c. Wild cards * and ? are supported for text columns but not string columns*
d. If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.

3. What do you use in the definition of a dynamic SQL analytic privilege?
a. A procedure that returns the data access condition as an SQL expression.*
b. A table function that returns a list of allowed values.
c. An organization hierarchy that provides role-based access to data.
d. A scalar function that returns a list of the allowed values for each attribute.

4. Which of the following are usually no longer required in the architecture of SAPS/4HANA? Note: There are 2 correct answers to this question.
a. Aggregates
b. ABAP CDS*
c. Synonym s
d. Indexes

5. In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario? Note: There are 2 correct answers to this question.
a. Function
b. Container
c. Procedure*
d. Task*

6. Why might you use the Keep Flag property in an aggregation node?
a. To cache the results of the aggregation node for drill-down
b. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
c. To include columns that are NOT requested by a query but are essential for the correct result*
d. To retain the correct aggregation behavior in stacked views.

7. You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?
a. Define a union node as the start of the parallelization block.
b. Define a projection node as the end of the parallelization block.
c. Assign tables as the only data sources in the nodes that start the parallelization block.*
d. Define a source column as partitioning value in the start node of the parallelization block.

8. What are the key steps to implement currency conversion in a calculation view?
a. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Build the conversion rule
b. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view
c. Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column
d. Assign semantic type Enable the measure for conversion choose client, source and target currencies Choose conversion date and rate type*

9. You created a table function to remove previous records, sum the current total weekly working hours for each employee, and updated the personnel table. The build of the table function fails. Which of the following could be a valid reason?
a. You did NOT define a valid table type.
b. Your function refers to a scalar function.
c. You did not define at least one input parameter.
d. Your function includes a RUNCATE statement*

10. Which of the following allows data replication?
a. SAP HANA smart data access
b. SAP HANA streaming analytics
c. SAP HANA smart data integration*
d. SAP HANA smart data quality

11. A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query?

a. 6
b. 9*
c. 2
d. 5

12. What restrictions apply to a Graph node that you include in a calculation view?
a. It must be the first node in the dataflow.*
b. It must be the final node in the dataflow.
c. Its data source must be provided by a projection node.
d. It cannot be included in a calculation view of type dimension.

13. You combine two tables in a join using multiple columns in each table. Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.
a. To allow data analysis at different levels of granularity with the same calculation view.*
b. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query.
c. To ensure that the join execution only uses the join columns requested in the query.*
d. To improve execution time under specific query conditions.

14. Your Web IDE for SAP HANA was updated to a new version. You want to implement the new features of calculation view modeling in your existing calculation views. You open a graphical calculation view but the new features are not displayed.
What could be the reason for this?
a. You need to update the project settings to reference the new revision.*
b. Your calculation views have not been built in the new version of the Web IDE.
c. The calculation views have not been migrated to the new revision.
d. The .hdiconfig file has not been updated to the latest calculation view build plug-in.

15. A calculation view consumes the data sources shown in the graphic. You want to identify which companies SQLd products in January 2018 AND February 2018. What is the optimal way to do this?
a. Use a full outer join.
b. Use a union node.
c. Use a left outer join.
d. Use an intersect node*

16. Which of the following approaches improve the performance of joins in a cube calculation view? Note: There are 2 correct answers to this question.
a. Use an inner join.
b. Limit the number of joined columns.*
c. Implement pruning rules.
d. Specify the join cardinality.*

17. Why do we use Git when modeling calculation views?
a. Develop conceptual prototypes
b. Enable collaboration between developers
c. Provide access to external schemas
d. Control specifically object versioning*

18. In a calculation view, where can you insert SQL code? Note: There are 3 correct answers to this question.
a. Hierarchy
b. Filter expression*
c. Calculated column expression *
d. Input parameter*
e. Currency conversion

19. You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view? Note: There are 2 correct answers to this question.
a. To restrict data access for specific users or roles
b. To hide individual patients in groups of similar records*
c. To provide partial value such as #34343#34##
d. To add noise to the data to hide the actual values*

20. In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?
a. You have a large row store table that is consumed in a view with a variable on COUNTRY column.
b. You have a large column store table that is consumed in a view with a variable on COUNTRY column.*
c. You have a dedicated table lo generate the lists of help values for an input parameter.
d. Your stacked model consists of multiple calculation views.

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

21. You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data from one table located in an external schema. Which of the following items must you build?
Note: There are 2 correct answers to this question.
a. Synonym*
b. .hdinamespacefil e
c. Authorization*
d. Project

22. You created a table using the SQL conSQLe inside the HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it. What do you observe in the SAP HANA database container?
a. The build is successful, and you get the expected data.
b. The build fails, and the table is dropped.
c. The build fails but the table is not dropped.
d. The build is successful, but the data preview is empty.*

23. Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output from the screenshot?

a. Create a restricted column for each year.*
b. Implement a union node and map each year as a separate column.
c. Create 3 calculated columns.
d. Create a filter expression that uses an OR operator.

24. What are the components of a custom text analysis? Note: There are 3 correct answers to this question.
a. Rule set*
b. Python script
c. Term Document Matrix.
d. Dictionary e. Configuration

25. Why do you create a multi store table?
a. To improve read performance when accessed by simultaneous applications
b. To have the opt on to partition the table across different storage tiers*
c. To evenly distribute the data across all available server nodes
d. To have a table that combines the characteristics of row and column stores

26. Why do you build a calculation view of type SQL Access only?
a. To enable SQL access to your hierarchies
b. To provide a high-performance model when only attributes are required
c. To provide a data source that can only be consumed by a function or procedure
d. To provide a data source that is only consumed by other calculation views*

27. Why do you create calculation views of data category DIMENSION with type TIME?
a. To provide the time intervals required by time-dependent parent-child hierarchies.
b. To store historical version of attributes.
c. To add a temporal condition to a join to find matching records from two tables based on a date.
d. To provide additional time-related navigation possibilities*

28. After importing a project in the workspace of the Web IDE, you try to build the HDB module. The build fails. What could be the reason? Note: There are 2 correct answers.
a. The HDB module references a user-provided service that does not exist.*
b. You have assigned the project to a space that you do not have developer authorizations for.*
c. You have not built the project.
d. The project is not assigned to a space.

29. Why might you use SAP HANA Graph with text analysis?
a. To illustrate multi-point relationships between text entities
b. To provide a visual method to build a custom text analysis*
c. To highlight similarities between documents using hierarchies
d. To uncover the dependencies between parts of speech

30. You want to join 2 tables in a calculation view. Why do you use a non-equijoin?
a. The number of joined columns is different in both tables.
b. Join columns do not have the same datatype.
c. The join condition is not represented by matching values.*
d. The cardinality is impossible to determine

31. How can you optimize performance when writing SQL for use with calculation views? Note: There are 2 correct answers to this question.
a. Use declarative language instead of cursors*
b. Use calculation engine (CE) functions instead of plain SQL
c. Control the flow logic using IF-THEN-ELSE conditions
d. Increase parallelization by using variables to break up statements*

32. In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join. You did NOT set cardinality of the data sources. Why will this NOT work?
a. Full outer joins are restricted to one dimension in a star join node.*
b. Full outer joins require cardinality to beset.
c. Full outer joins CANNOT be mixed in the same star join node with other join types.
d. Full outer joins are NOT available in the star join node.

33. You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. The same customer can exist in both tables. How do you ensure that each customer appears only once in the results?
a. Add a minus node above the union node.
b. Add an intersect node above the union node.
c. Include an aggregation node above the union node.*
d. In the union node, map both source customer name columns to one target column.

34. Why do you use the debug query mode in a calculation view?
a. To observe the generated SQL for each node*
b. To highlight potential performance issues at design-time
c. To measure the overall run-time of the query
d. To check which database engines will be invoked by each node

35. What is the disk storage layer used for? Note: There are 2 correct answers to this question.
a. To unload the least-used data when the memory is full*
b. To improve the parallel processing of queries
c. To store the data primarily used for transactional processing
d. To enable data to be recovered if hardware fails*

36. How can you define a variable that presents its value help hierarchically? Note: There are 2 correct answers to this question.
a. Create a parent-child hierarchy and assign it to the variable. Ensure the variable’s reference column is the parent attribute of the hierarchy.
b. Create a parent-child hierarchy and assign it to the variable. Ensure the variable’s reference column is the child attribute of the hierarchy.
c. Create a level hierarchy and assign it to the variable. Ensure the variable’s reference column is the leaf level of the hierarchy.*
d. Create a level hierarchy and assign it to the variable. Ensure the variable’s reference column is the top level of the hierarchy.

37. In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?
a. Table function*
b. CDS view
c. Procedure
d. Virtual Table

38. What can you use SAP HANA smart data access for? Note: There are 2 correct answers to this question.
a. To push down queries to data sources*
b. To expose data from remote tables*
c. To load and harmonize data from disparate sources
d. To replicate remote data sources

39. You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met? Note: There are 2 correct answers.
a. The hierarchy must be a local hierarchy.
b. The hierarchy must be exposed by a calculation view of type CUBE with star join.*
c. The hierarchy must be defined in a calculation view of type SQL ACCESSONLY.
d. The hierarchy must be a shared hierarchy.*

40. You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.
What is the correct approach?
a. Combine the transaction tables using a join node in a calculation view of type cube. Use the multi-join capability of the join node to connect the transactional tables with the dimension calculation views.
b. Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use a join node to join the dimensions to the fact table.
c. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.
d. Combine the transaction tables using a join node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.*

41. Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.
a. To convert the data types of input parameters
b. To push down filters to the lowest level calculation views*
c. To pass variable values to external value help views*
d. To enable an input parameter in a calculation view

42. Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question.
a. SQL view*
b. Table function*
c. Scalar function
d. Procedure

43. What are the components of a graph workspace? Note: There are 2 correct answers to this question.
a. Dimension n
b. Vertex*
c. Edge*
d. Association

44. What can you identify using the Performance Analysis Mode? Note: There are 2 correct answers to this question.
a. Usage statistics of the calculation view
b. Joins that are defined on calculated columns*
c. If the data is in the hot or warm storage tier
d. Information about join cardinality*

45. What type of data is relevant for SAP HANA Graph modeling?
a. Highly-networked*
b. Timeseries
c. Hierarchical data
d. Forecast

46. Why does query performance decrease when the data volume of the delta storage is large?
Note: There are 2 correct answers to this question.
a. The data is unstructured.
b. The data is uncompressed.*
c. The data is stored in the warm tier.
d. The data is NOT sorted.*

47. Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question.
a. Limit the number of stacked calculation views*
b. Avoid aggregating data early in the dataflow
c. Implement union pruning*
d. Partition large tables*

48. You have imported a new calculation view in a folder that contains a .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a namespace-related issue and the build fails. What could be the reason? Note: There are 2 correct answers.
a. The imported calculation view and its data source have different namespaces.*
b. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.*
c. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view.
d. The hdinamespace specifies “sub-folder”: “append”, so calculation views can only be created in sub-folders.

49. Why do you implement Active / active read-enabled mode?
a. To enhance security for data access
b. To provide offline access to data
c. To improve query performance
d. To synchronize query results with operational data*

50. Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation view?

a. Analytic Privileges and SELECT privileges on the CUBE Calculation view
b. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view
c. A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view*
d. SELECT or Privileges and Analytic Privileges on both views

Join SAP Learner Community on Linkedin – https://www.linkedin.com/showcase/sap-learner-community

51. Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?
a. They can harm SQL optimization.
b. NOT all reporting tools can consume the results.
c. They introduce potential security risk.*
d. They call multiple processing engines

52. What does SAP HANA provide to support native application development Note: There are 3 correct answers?
a. Embedded SAP Business Warehouse(BW)
b. Project management tools
c. Built-in application server*
d. Multiple development languages*
e. Choice of deployment to cloud or on-premise*

53. Which tool do you use to display the generated SQL for each node of your calculation view?
a. SQL Analyzer
b. Debug Query Mode*
c. Plan Visualizer
d. Performance Analysis Mode

54. You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect?
Note: There are 2 correct answers to this question.
a. When the query requests PRODUCT_GROUP and PRODUCT_ID
b. When the query requests only the PRODUCT_ID
c. When the query requests PRODUCT_GROUP*
d. When Source A has no records*

55. You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views belong to the same project. Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

a. Export the HDB module -> Export the project
b. Build the HDB module -> Build the project
c. Activate the project -> Build the HDB module
d. Build the project -> Build the HDB module*

56. You have a calculation view which includes nodes as shown in the graphic. You decide to select the “Ignore Multiple Output for Filters” check box on Projection Node 3. What might the effects of this be? Note: There are 2 correct answers to this question
a. The view will return the profit calculation for only the US*
b. A change to the data that is returned by the view
c. Increased performance*
d. Decreased performance

57. What does a graph neighborhood search reveal?
a. Edges that contain the same attributes
b. Shortest path between vertices
c. Vertices that are closely connected*
d. Vertices that contain the same attributes

58. Which types of data are used to represent spatial information? Note: There are 2correct answers to this question.

a. Column data
b. Vector data*
c. Raster data*
d. Graph data

59. You want to map an input parameter of the calculation view A to the input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameter of the calculation view B is not proposed to you as a source parameter. What might be the reason for this?
a. You selected the wrong parameter mapping TYPE.
b. The names of the input parameters do not match.
c. You already mapped the input parameters in another calculation view.*
d. Your source calculation view is of the type SQL Access Only.

60. In text processing, where do you use the Term Document Matrix?
a. Text mining*
b. Linguistic extraction
c. Fuzzy text search
d. Fact and entity extraction

61. What can you extract using the standard text analysis configuration: Voice of the Customer? Note: There are 2 correct answers to this question.
a. Recommendatio ns
b. Sentiments*
c. Suggestio ns
d. Requests*

62. When would you develop an SQL procedure instead of a function?
a. You need to implement Data Definition Language (DDL) statements.
b. The code should modify data in the table.*
c. Optimal performance is apriority.
d. You need to use conditional logic.
e. You want to create a dynamic analytic privilege.

63. Which of the following are warm tier Solutions Note: There are 3 correct answers?
a. Active / active read-enabled mode
b. Native Storage Extension
c. Extension Node*
d. Dynamic Tiering*
e. Persistent Memory*

64. What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI container?
a. Database connection
b. Wrapper
c. Function*
d. Synonym

65. Why do we support SQL development in SAP HANA data modeling projects?
a. To provide access to your data model to additional client tools.
b. To support development of custom logic within calculation views.*
c. To make changes to the runtime objects of your calculation view with SQL.
d. As an alternative to developing calculation views when high performance is essential.

66. In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?
a. Vertical disaggregation
b. Horizontal disaggregation
c. Vertical aggregation
d. Horizontal aggregation*

67. What do you use a hierarchy function for? Note: There are 3 correct answers.
a. Calculate distance between root and each hierarchy node*
b. Identify hierarchy nodes that have no parent
c. Count the number of siblings for each hierarchy node*
d. Determine the shortest path between each pair of nodes
e. Describe the relationship between nodes using attributes*

68. Which is the correct syntax when you refer to an input parameter in a calculation view expression?
a. $$Choose_Country$S*
b. :Choose_Country
c. ..Choose_Country”
d. @Choose_Country

69. In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function?
a. Synonym
b. Scalar function
c. Table function*
d. Input parameter

70. When modeling in the Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?
a. Synonym*
b. Association
c. Virtual Table
d. Alias

Join SAP Learner Community on Linkedin – https://www.linkedin.com/showcase/sap-learner-community

71. You are building a new calculation view B that uses calculation view A as a data source. In the Semantics node of calculation view A, you define a mask for the first 10 digits of a 15 digit Account Number. When you preview calculation view B, the Account Number is not masked.
Why do you see the Account Number unmasked?
a. The masking is based on the column of a row table.
b. You did not define masking in calculation view B.
c. The UNMASKED privilege for calculation view A has been granted.*
d. The Account Number is based on the Integer datatype.

72. When you create a full text index, why do you specify FAST_PREPROCESS OFF?
a. To avoid the generation of the term document matrix
b. To prevent the creation of a fuzzy search index
c. To generate text analysis results in multiple languages
d. To enable a full linguistic search*

73. In a calculation view, what is the purpose of a variable?
a. To break up complex SQL into smaller steps*
b. To pass values between procedures and calculation views
c. To provide a run-time attribute filter based on a user input*
d. To provide a dynamic value in a calculated column

74. Which type of join supports a temporal condition in a calculation view?
a. Left outer join
b. Text join
c. Referential join
d. Inner join*

75. Your calculation view consumes one data source which includes the following columns
: SALES_ORDER_ID, PRODUCT_ID, QUANTITY & PRICE. In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY • PRICE. In which type of node do you define the calculation to display the correct result?
a. Union
b. Join
c. Projection*
d. Aggregation

76. You deleted the design-time file of a calculation view in your HDB module.
Which of the following is the optimal way to ensure that the corresponding runtime object is also removed from the database?
a. Delete the folder that contained the deleted design-time file.
b. Build the folder that contained the deleted design- time file. *
c. Build the project that contained the deleted design-time file.*
d. Run a DELETE statement in an SQL console connected to the HDI container.

77. In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. Afterward, you perform the following build operations:
Build the dimension calculation view as a single object.
Build the entire SAP HANA database module. What is the outcome of the build perations?
a. The first build fails. The second build fails.
b. The first build is successful. The second build is successful.*
c. The first build fails. The second build is successful.
d. The first build is successful. The second build fails.

78. How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.
a. Call the SAP-provided PAL decision tree procedure from the table function
b. Use dynamic SQL in the table function to generate the SQL code
c. Copy and adapt the SQL code generated by a flow graph into the table function
d. Build a flow graph and call it from the table function using input parameters

79. Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?

a. D*
b. C
c. A
d. B

80. Why do you use a hierarchy function node in a calculation view?
a. To display value help using hierarchies
b. To enable hierarchical navigation in reporting tools
c. To generate additional Meta data that can be used for analysis of a hierarchy structure*
d. To assist the developer by visualizing hierarchies

Hope these MCQ’s will help you with your SAP certification.

Good Luck!!

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

Join SAP Learner Community on Linkedin – https://www.linkedin.com/showcase/sap-learner-community

Visit our website – https://wwwzarantech.com

P_SECAUTH_21 – SAP Certified Technology Professional – System Security Architect (80 Questions)

C_GRCAC_12 – SAP Certified Application Associate – SAP Access Control 12.0 (90 Questions)