1- You set up currency conversion in a calculation view.
When your currency conversion failed, what could you choose to populate the target column? 2 correctas - The source amount - A default value - Null - <EMPTY>.
2- How could you improve the performance of joins in cube calculation views?
Note: these are 2 correct answers to this question. - Avoid the use of referential joins. - Reduce the number of columns used in the join. - Specify the cardinally of the join - Join on calculated columns.
3- Why do you use SAP HANA Graph? - To develop a dashboard to present KPIs - To access advanced chart types from calculation views - To push down graphic processing to the database - To model highly networked entities.
4- What can you use SAP HANA smart data access for?
Note: these are 2 correct answers to this question. - To load and harmonize data from disparate sources. - To push down queries to data sources. - To expose data from remote tables - To replicate remote data sources.
5- Which of the following are no longer required in the architecture of SAP S/4HANA?
Note: these are 2 correct answers to this question. - Column tables - Indexes - Aggregates - Synonyms.
6- Your calculation view includes the followings: SALES_ORDER_ID and ITEM as attributes, and QUANTITY and PRICE as measures.
You create a calculated column, ITEM_TOTAL, with the formula QUANTITY * PRICE.
In which node do you define the calculation to display the correct aggregated result? - Union - Aggregation - Projection - Join.
7- In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA? - You have a large column store table that is consumed in a view with a variable on COUNTRY column. - Your stacked model consists of multiple calculation views - Your column table´s delta store is frequently larger than its main store. - You have a large row store table that is consumed a view with a variable on COUNTRY column.
8- When can you expose a hierarchy that is defined in a calculation view for access with SQL? - When the hierarchy is a local hierarchy - When the hierarchy is a shared hierarchy - When the hierarchy is defined in a calculation view of type CUBE - When the hierarchy is defined in a calculation view of type DEFAULT.
9- You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables Dimension calculation view provide the attributes.
What is the correct approach? - Combine the transaction tables using a star join node in a calculation view of type cube with star join.
Use an aggregation node to join the dimensions to the fact table. - 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. - 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. - 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.
10- Which of the following techniques can you use to improve the performance of calculation views?
Note: these are 2 correct answers to this question. - Partition large tables - Implement union pruning - Avoid aggregating data early in the data flow - Minimize layering of calculation view.
11- Refering to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation View? - A SELECT privilege on the CUBE and an analytic Privilege (Country = United States) on the DIMENSION Calculation View - Analytic Privileges and SELECT Privileges on the CUBE Calculation View - SELECT Privileges and Analytics Privileges on both views - A SELECT Privilege and an Analytic Privileges.
12- An SAP HANA Live model is displayed as an invalid view in the list of models in the SAP HANA Live browser.
What could be the reason? 2 correctas
- The model has been deleted. - The model is missing an underlying table. - The model´s underlying table is not fully replicated - The model is missing a dependent view.
13- When using the CONTAINS predicate, what are the restrictions you must you keep in mind? 2 correctas. - Non-physical columns, such as calculated columns, are not search relevant. - If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only of the tables. - Wild cards * and ? are supported for text columns but not string columns - The NOT (-) operator can only be specified directly after the OR operator.
14- Why might you use SAP HANA Graph with text analysis? - To uncover the dependencies between parts of sèech - To highlight similarities between documents using hierarchies - To illustrate multi-point relationships between text entities - To provide a visual method to build a custom text analysis.
15- What restrictions apply to a Graph mode that you include in a calculation view? - It must be the first mode in the data flow - Its data source must be provided by a projection mode - It must be the final mode in the data flow - It cannot be included in a calculation view of type dimension.
16- What do SAP S/4HANA embedded analytics and SAP HANA live have in common?
Note: these are 3 correct answers to this question. - They are built using ABAP CDS - They expose operational data from SAP services - Their data access is controlled using analytic privileges - They are built and maintained by SAP - They can be extended by customers.
17- 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? - Your source calculation view is of the type DEFAULT - You did not push the Auto Map button - You already mapped the input parameters in another calculation view - You selected the wrong parameter mapping TYPE.
18- When you create a full text index, why do you specify FAST_PREPROCESS OFF? - To generate text analysis results in multiple languages - To avoid the generation of the term document matrix - To enable a full linguistic search - To prevent the creation of a fluzzy search index.
19- Why do you use the query debug mode in a calculation view? - To check if SAP HANA can parallelize the entire query - To measure the overall run-time of the query - To observe the generated SQL for each node - To check which database engines will be involved by each node.
20- In your rank mode, why do you set the dynamic partition element flag? - To define the ranking threshold value based on an input parameters - To generate the ranking partition based on the columns selected in the query - To define time dependency on a partition - To determine the partitioning logic using an SQL expression.
21- Which types of data are used to represent spatial information? 2 correct - Rasted data - Column data - Vector data - Graph data.
22- You created a table function to sum the total weekly working hours for each employee and update the personnel table. You CANNOT activate the table function.
What could be the problem? - You did NOT define a valid table type - You do NOT have write permissions to the personnel table - You CANNOT update records using a table function - You did NOT create synonyms for the table.
23- In a calculation view, what is the purpose of a variable? - To pass values between procedures and calculation views - To provide a run-time attribute filter based on a user input - To break up complex SQL into smaller steps - To capture the interim result of a calculation in an expression.
24- Which type of join supports a temporal condition in a calculation view? - Referential join - Text join - Left outer join - Inner join.
25- In text processing, where do you use the Term Document Matrix? - Text mining - Fact and entity extraction - Linguistic extraction - Fuzzy text search.
26- You are a data analysis working with medical records that contain confidential patient information.
Why do you use the anonymization node in a calculation view? 2 correct - To restrict data access for specific users or roles - To provide partial value such as #3434 3#34## - To add noise to the data to hide the actual values - To hide individual patients in groups of similar records.
27- What can you determine using the hierarchy function in a calculation view?
3 correctas - Source attributes of a composite hierarchy node - Number of siblings for a hierarchy node - Distance between root and each hierarchy node - Hierarchy nodes that have no parent - Time interval of hierarchy nodes.
28- Why might you use the keep flag in an aggregation node? - To ensure that the aggregation behavior delined in the aggregation node for a measure CANNOT be overridden by a query - To include columns that are NOT requested by a query but are essential for the correct result - To retain the results of the aggregation node for reuse in a drill-down based on a hierarchy.
29- You want to join 2 tables in a calculation view
When would you use non-equi join? - The join is part of start join - The cardinality is 1:n - The cardinality is impossible to determine - The join requires a < (less than) operator.
30- Why does SAP issue warnings about the use of imperative of procedural SQL Script statements? - They are deprecated - NOT all reporting tools can consume the results - They introduce security risks due to SQL injection - They can ham SQL optimization.
31- In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can build the SAP HANA database (HDB) module successfully?
2 correctas - Ensure that you have only one HDB module in your project - Assign the project to a space to which you have developer authorizations - Explicitly build the HDB module instead of the project - Ensure that the name of your HDB module is included in the corresponding schema name.
32- 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?
- Where used - Show lineage - Impact analysis - Database explorer.
33- What can you extract using the standard text analysis configuration: Voice of the Customer? 2 correctas - Sentiments - Request - Recommendation - Suggestions.
34- In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval? Please choose the correct answer. - Horizontal disaggregation - Vertical aggregation - Vertical disaggregation - Horizontal aggregation.
35- You are building a cube calculation view with an aggregation node that calculates total sales, based on the data shown in the graphic.
The price may vary based on SHIRT_ID and PROMO_LEVEL only. The calculation is Total Sales = PRICE * QUANTITY.
How do you ensure accurate results, regardless of the column in the query output? - Set the Keep Flag property for both SHIRT_ID and PROMO_LEVEL - Set the Dynamic Partition flag for SHIRT_ID and PROMO_LEVEL - Set the Transparent Filter property for STATE - Set STATE as an aggregated column.
36- How can you optimize performance when writing SQL for use with calculation views? 2 correctas - Use calculation engine (CE) functions instead of plain SQL - Increase paralization by using variables to break up statements - Control the flow logic using IF-THEN-ELSE conditions - Use declarative language instead of cursors.
37- Why would you use the XS Advanced Migration Assistant? 2 correctas - To convert attribute views to CDS views - To convert Studio-developed objects for use with Web IDE for SAP HANA - To move HDI-developed calculation views to repository packages - To convert analytic views to calculation views.
38- In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario? (2) - Container - Function - Procedure - Task.
39- You require faster performance for a frequently queried calculation view. You have just enabled the Static Results Cache for this calculation view with a cache period 120 minutes.
What are the effects of this action? 3 correctas - Additional memory will be consumed by the calculation view - CPU usage for the calculation view will be reduced - Updating of the underlying tables in the calculation view will be delayed for 120 minutes - Users may no longer see the most current data in the output - Variables can no longer be used by this calculation view.
40- On a weekly basis, you need to extract and transform data from multiple sources such as SAP ERP Microsoft Excel and Apache Hadoop and load the data into SAP HANA. Which tools can you use? There are 2 correct answers to this question. - SAP HANA smart data access - SAP HANA smart data integration - SAP Data Services - SAP Landscape Transformation Replication Server.
41- How can you define a variable that presents its value help hierarchically? 2 correctas - Create a parent-child hierarchy and assign it to the variable
Ensure the variables reference column is the parent attribute of the hierarch - Create a level hierarchy and assign it to the variable
Ensure the variables reference column is the leaf level of the hierarchy. - Create a parent-child hierarchy and assign it to the variable
Ensure the variables reference column is the child attribute of the hierarchy - Create a level hierarchy and assign it to the variable
Ensure the variables references column is the top level of the hierarchy.
42- You have two tables with two columns CUSTOMER_NAME and COUNTRY_NAME, one with Italian customers and other with French customers. What type of calculation view should you create to combine customers? - Dimension type with join node - Cube with join node - Cube with union node - Dimension with union node.
43- Which are views of the SAP supplied virtual data model of Embedded Analytics? There are 2 correct answers to this question. Response: - Composite - Calculation - Basic - Attribute.
44- What conditions must be met before you can implement time dependency on a hierarchy in a calculation view? - The hierarchy must be a parent-child hierarchy - The hierarchy must be a level hierarchy - The key date parameter must be derived from an input parameter - The hierarchy must be enabled for SQL access .
45- Your calculation view presents employee names which must only be seen by managers. All other employees should see the employee name in the format M### G###
Which steps are required to implement this? 2 correctas
- Create an SQL expression to define the concealing logic for the column - Set the column to ‘hidden’ in the calculation view - Assign the UNMASK privilege to the managers for the calculation view - Include an anonymization node in the calculation view.
46- Using a calculation view containing the projections shown in the graphic, how would you identify which companies sold products in January 2018 AND February 2018? Please choose the correct answer. - User an intersect node - Use a full outer join - Use an left outer join - Use a union node.
47- In SAP HANA Series Data processing, what is the definition of a profile? - The granularity of time intervals, such as day, hour, or minute - The values that you are storing, such as temperature, energy consumption, or speed - The object you collect data agained, such as house, building, or town - A variant of the data set, such as actual, forecast, or long-term plan.
48- What can you identify using the performance Analysis Mode? - Longest running query step - Joins that are based on calculated columns - Usage statistics of the calculation view - Information about join cardinality.
49- What is the persistent storage layer used for? There are 2 correct answers to this question. - To enable data to be recovered if hardware fails - TO improve the parallel processing of queries - To store the data primarily used for transaction processing - To unload the least-used data when the memory is full.
50- Which of the following data sources can you include in a graphical calculation view? 2 correctas - SQL view - Table function - Procedures - Scalar function.
51- What conditions must be met to ensure the Dynamic Join feature works properly? 2 correctas - At least one joined column must be specified in the query - Multiple columns must be defined in the join - Cardinality must be set - The join must be defined on key columns.
52- You have assigned analytic privileges to users as shown in the diagram. What data can be viewed by the users? There are 2 correct answers to this question. - User 2 can view United States for 2017 - User 1 can view any year for United States - User 1 can view Canada for 2018 - User 2 can view any year for United States.
53- You are building a new calculation view, A, which includes a projection node that refers to another calculation view, B.
Why would you use the Extract Semantics feature? - To improve the performance of calculation view A by only referencing the semantics of calculation view B and not duplicating it. - To automatically map the input parameters from calculation view B to an input parameter of calculation view A - To apply the semantics of calculation view B to the semantics of calculation view A - To set the semantics of calculation view A to the default values.
54- In your calculation view, you need to define a custom data source using SQL Script.
In which object do you write your SQL Script? - CDS view - Table function - Procedure - Scalar function.
55- What are the components of a graph workspace? 2 correctas - Space - Edge - Vertex - Partition.
56- You join two tables using a referential join and set the cardinality to 1..n
What type of join is executed at runtime if your query does NOT request columns from the right table? - Left outer join - Right outer join - Full outer join - Inner join.
57- What does a graph neighborhood reveal? Please choose the correct answer. - Vertices that are closely connected - Shortest path between vertices - Vertices that contain the same attributes - Strongly connected Vertices.
58- When modeling in the Web IDE for SAP HANA, which object do you build provide access to tables in external schemas? - Container - Analytic privileges - Synonym - Role.
59- Why do you use parameter mapping in a calculation view? 2 correctas - To push down filters to the lowest level calculation views - To pass a value from a variable to an input parameter - To convert the data types of input parameters - To pass variable values to external value help views.
60- Before deploying your calculation views to a PROD environment, which sequence of steps is required? Please choose the correct answer. - Build the HDB module -> Build the project - Activate the project -> Build the HDB module - Build the project -> Build the HDB module - Export the HDB module -> Export the project.
61- why do you create calculation views of data category DIMENSION with type TIME? - To provide the time intervals required by time-dependent parent-child hierarchies - To apply automatic adjustments to unequal time snapshots on series data - To enable time-dependent master data attributes to be consumed in a star schema - To provide additional time-related navigation possibilities.
62- A calculation view includes a rank node that users 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? - 8 rows - 6 rows - 9 rows - 2 rows.
63- Which of the following views can be extended by using the SAP HANA Live extension assistant? 2 correctas - A custom view - A private view - A reuse view - A query view.
64- When modeling a decision tree, what are the stages of the learning phase? 3 correctas - Connecting - Trainning - Validation - Testing - Rejecting.
65- In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. Afterwards, 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 operations?
- The first build is successful
The second build is successful - The first build is successful.
The second build fails. - The first build fails
The second build fails - The first build fails
The second build is successful.
66- In an XSA / HDI environment, where do you find run-time object? - Database user schema - Repository package - Container schema - _SYS_BIC schema.
67- Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output form the screenshot? - Implement a union node and map each year as a separate column - Create a restricted column for each year - Create a filter expression that uses an OR operator.
68- You created a table using the SQL console inside the HANA Deployment Infrastructure (HDI) container of your project. You export your project and re-import it whit a different project name to the same database
What do you observe in the SAP HANA database module?
- The build is successful and the table and its data are present - The build is successful but the table is NOT present - The build fails and the table is NOT present.
69- Which of the following must you consider when you define namespaces in an SAP HANA database (HDB) module? There are 3 correct answers to this question. - The namespace defined in a design-time object must match the namespace properties of the folder in which it is located - Modeling content should be created before the namespace rules have been defined - Synonyms can have different namespaces - A namespace is a mandatory component of the object identifier - Two different objects can have the same name if they are assigned to different namespaces.
70- In an XSA / HDI environment, which of the following is used for source version control of calculation views? - SAP HANA studio - Open-source Git - CMS (Change Management System) - CTS (Change Transport System).
71- Why do you build a calculation view of type DEFAULT? - To provide a leaner model when only attributes are required - To support optimized multidimensional reporting - To ensure all reporting tools can consume the calculation view - To provide a data source that is only consumed by other calculation views.
72- What does SQL script provide to extend standard SQL? 2 correctas - Feature to encourage processing in the database - Integrated source code version management - Additional data types for the definition of text and spatial data - Support for ABAP Syntax.
73- Why do you use a hierarchy function node in a calculation view - To convert parent-child hierarchies to level hierarchies - To generate additional meta data that can be used for analysis of a hierarchy structure - To enable hierarchical navigation in reporting tools - To display value help using hierarchies.
74- You have a calculation view which includes nodes as shown in the graphic. You decide to select the “ignore multiple output for filters” checkbox on projection node.
What might the effects of this be? 2 correctas:
- Increased performance - A change to the data that is returned by the view - The view will return the profit calculation for only the US - Decreased performance.
75- In a calculation view, where can you use SQL? 3 correctas - Calculated column expression - Filter expression - Input parameter - Aggregation node - Union pruning condition.
76- Why do you create a multistore table? - To have the option to partition table across different storage tiers - To improve read performance when accessed by simultaneous application. - To have a table than combines the characteristics of row and column stores - To evently distribute the data across all available server nodes.
77- 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…
Which of the following items must you build? 2 correct answers to this question.
- Authorization - HDB module - Synonym - Project.
78- A partitioned column table is prevent only in the persistent layer of an SAP HANA system.
Which columns and partitions are loaded into memory when the table is accessed by an application?
- ONLY the required columns and the required partitions - ONLY the required partitions and all the columns - All the partitions but ONLY the required columns.
79 - 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? - Full outer joins CANNOT be mixed on the same star join node with other join types - Full outer joins require to be set - Full outer joins restricted to one dimension in a star join node. - Full outer joins are NOT available in the star join node.
80- In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function? - Scalar function - Table function - Input parameter - Synonym.