| 1- Which of the following are usually no longer required in the architecture of SAPS/4HANA? Note: There are 2 correct answers to this question. Aggregates ABAP CDS Synonyms Indexes.
2- What do you use in the definition of a dynamic SQL analytic privilege? A procedure that returns the data access condition as an SQL expression. A table function that returns a list of allowed values. An organization hierarchy that provides role-based access to data. A scalar function that returns a list of the allowed values for each attribute.
3- 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? Delete the folder that contained the deleted design-time file. Build the folder that contained the deleted design-time file. Build the project that contained the deleted design-time file. Run a DELETE statement in an SQL console connected to the HDI container.
4- 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 . The hierarchy must be a local hierarchy. The hierarchy must be exposed by a calculation view of type CUBE with star join The hierarchy must be defined in a calculation view of type SQL ACCESSONLY. The hierarchy must be a shared hierarchy.
5- What can you extract using the standard text analysis configuration: Voice of the Customer? Note: There are 2 correct answers to this question.
Recommendations Sentiments Suggestions Requests.
6- In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?
You have a large row store table that is consumed in a view with a variable on COUNTRY column. You have a large column store table that is consumed in a view with a variable on COUNTRY column
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. .
7- 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? You selected the wrong parameter mapping TYPE. The names of the input parameters do not match. You already mapped the input parameters in another calculation view. Your source calculation view is of the type SQL Access Only. .
8- 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?
You need to update the project settings to reference the new revision. Your calculation views have not been built in the new version of the Web IDE. 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.
9- Why do you use the debug query mode in a calculation view? To observe the generated SQL for each node To highlight potential performance issues at design-time To measure the overall run-time of the query o check which database engines will be invoked by each node
10- When modeling in the Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?
Synonym Association Virtual Table Alias.
11-What restrictions apply to a Graph node that you include in a calculation view? It must be the first node in the dataflow. It must be the final node in the dataflow. Its data source must be provided by a projection node. It cannot be included in a calculation view of type dimension. .
12- What does a graph neighborhood search reveal? Edges that contain the same attributes Shortest path between vertices Vertices that are closely connected Vertices that contain the same attributes.
13 - 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?
Use a full outer join. Use a union node. Use an left outer join. Use an intersect node .
14 - You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block? Define a union node as the start of the parallelization block. Define a projection node as the end of the parallelization block. Assign tables as the only data sources in the nodes that start the parallelization block. Define a source column as partitioning value in the start node of the parallelization block. .
15 - 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 store historical version of attributes. To add a temporal condition to a join to find matching records from two tables based on a date.
To provide additional time-related navigation possibilities.
16 - Which tool do you use to display the generated SQL for each node of your calculation view? SQL Analyzer Debug Query Mode Plan Visualizer Performance Analysis Mode.
17 - What are the key steps to implement currency conversion in a calculation view? Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Build the conversion rule 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 Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type .
18- What do you use a hierarchy function for? Note: There are 3 correct answers. Calculate distance between root and each hierarchy node Identify hierarchy nodes that have no parent Count the number of siblings for each hierarchy node
Determine the shortest path between each pair of nodes Describe the relationship between nodes using attributes .
19 - Why do you build a calculation view of type SQL Access only? To enable SQL access to your hierarchies To provide a high-performance model when only attributes are required To provide a data source that can only be consumed by a function or procedure
To provide a data source that is only consumed by other calculation views .
20 - What does SAP HANA provide to support native application development Note: There are 3 correct answers. Embedded SAP Business Warehouse(BW) Project management tools Built- in application server Multiple development languages Choice of deployment to cloud or on-premise.
21- 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. The imported calculation view and its data source have different namespaces. The name space used within the calculation view to reference the table is different from the actual namespace in the identifier of this table. The .hdinamespace file specifies a different name space property than the one in the identifier of the calculation view. The hdinamespace specifies "sub-folder": "append'', so calculation views can only be created in sub-folders. .
22-Which of the following approaches improve the performance of joins in a cube calculation view? Note: There are 2 correct answers to this question. Use an inner join. Limit the number of joined columns. Implement pruning rules. Specify the join cardinality.
23- In a calculation view, where can you insert SQL code? Note: There are 3 correct answers to this question.
Hierarchy Filter expression Calculated column expression Input parameter Currency conversion.
24-Why do we support SQL development in SAP HANA data modeling projects?
To provide access to your data model to additional client tools. To support development of custom logic within calculation views. To make changes to the runtime objects of your calculation view with SQL. As an alternative to developing calculation views when high performance is essential.
25-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?
The masking is based on the column of a row table. You did not define masking in calculation view B. The UNMASKED privilege for calculation view A has been granted. The Account Number is based on the Integer datatype. .
26- Why does query performance decrease when the data volume of the delta storage is large? Note: There are 2 correct answers to this question.
The data is unstructured. The data is uncompressed. The data is stored in the warm tier. The data is NOT sorted.
27- 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?
9 2 5.
28-In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function? Synonym
Scalar function Table function Input parameter.
29-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.
To restrict data access for specific users or roles To hide individual patients in groups of similar records To provide partial value such as #34343#34## To add noise to the data to hide the actual values .
30-Why do you implement Active / active read-enabled mode? To enhance security for data access To provide offline access to data To improve query performance To synchronize query results with operational data.
31- Which of the following allows data replication? SAP HANA smart data access SAP HANA streaming analytics SAP HANA smart data integration SAP HANA smart data quality.
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?
Full outer joins are restricted to one dimension in a star join node. Full outer joins require cardinality to beset. Full outer joins CANNOT be mixed in the same star join node with other join types. Full outer joins are NOT available in the star join node. .
33- Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.
To convert the data types of input parameters To push down filters to the lowest level calculation views To pass variable values to external value help views To enable an input parameter in a calculation view .
34- Which of the following are warm tier Solutions Note: There are 3 correct answers? Active / active read-enabled mode
Native Storage Extension Extension Node Dynamic Tiering Persistent Memory .
35- What can you identify using the Performance Analysis Mode? Note: There are 2 correct answers to this question. Usage statistics of the calculation view Joins that are defined on calculated columns If the data is in the hot or warm storage tier Information about join cardinality.
36- 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. When the query requests PRODUCT_GROUP and PRODUCT_ID When the query requests only the PRODUCT_ID When the query requests PRODUCT_GROUP When Source A has no records.
37-Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question. Limit the number of stacked calculation views Avoid aggregating data early in the dataflow implement union pruning Partition large tables.
38- 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?
Export the HDB module -> Export the project Build the HDB module -> Build the project Activate the project -> Build the HDB module Build the project -> Build the HDB module.
39- 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. Call the SAP-provided PAL decision tree procedure from the table function Use dynamic SQL in the table function to generate the SQL code Copy and adapt the SQL code generated by a flow graph into the table function Build a flow graph and call it from the table function using input parameters .
40-In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?
Vertical disaggregation Horizontal disaggregation Vertical aggregation Horizontal aggregation.
41-In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?
Table function CDS view Procedure Virtual Table.
42-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?
Show lineage Database Explorer Where used Auto-map byname .
43-Why might you use the Keep Flag property in an aggregation node?
To cache the results of the aggregation node for drill-down To ensure that the aggregation behavior defined 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 correct aggregation behavior in stacked views. .
44-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? The build is successful, and you get the expected data. The build fails, and the table is dropped. The build fails but the table is not dropped. The build is successful, but the data preview is empty. .
45-Why do you use a hierarchy function node in a calculation view? To display value help using hierarchies To enable hierarchical navigation in reporting tools To generate additional Meta data that can be used for analysis of a hierarchy structure To assist the developer by visualizing hierarchies .
46-When would you develop an SQL procedure instead of a function? You need to implement Data Definition Language (DDL) statements. The code should modify data in the table. Optimal performance is apriority. You need to use conditional logic. You want to create a dynamic analytic privilege. .
47-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.
Synonym hdinamespacefile Authorization Project .
48-Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?
They can harm SQL optimization. NOT all reporting tools can consume the results. They introduce potential security risk. They call multiple processing engines.
49-In SAP Web IDE for SAP HANA, what can a flowgraph generate in a predictive analysis scenario? Note: There are 2 correct answers to this question.
Function Container Procedure Task.
50-What are the components of a custom text analysis? Note: There are 3 correct answers to this question. Rule set Python script Term Document Matrix Dictionary Configuration .
51-What are the components of a graph workspace? Note: There are 2 correct answers to this question. Dimension Vertex Edge Association.
52-Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation view? Analytic Privileges and SELECT privileges on the CUBE Calculation view A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view SELECT or Privileges and Analytic Privileges on both views.
53You want to join 2 tables in a calculation view. Why do you use a non-equijoin?
The number of joined columns is different in both tables. Join columns do not have the same datatype. The join condition is not represented by matching values. The cardinality is impossible to determine. .
54-Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question. SQL view Table function Scalar function Procedure Answer: A B .
55-Why do we use Git when modeling calculation views?
Develop conceptual prototypes Enable collaboration between developers Provide access to external schemas Control specifically object versioning.
56-Why might you use SAP HANA Graph with text analysis? To illustrate multi-point relationships between text entities To provide a visual method to build a custom text analysis To highlight similarities between documents using hierarchies To uncover the dependencies between parts of speech.
57-When you create a full text index, why do you specify FAST_PREPROCESS OFF? To avoid the generation of the term document matrix To prevent the creation of a fuzzy search index To generate text analysis results in multiple languages To enable a full linguistic search .
58-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?
Add a minus node above the union node. Add an intersect node above the union node. Include an aggregation node above the union node. In the union node, map both source customer name columns to one target column. .
59-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 screen shot? Create a restricted column for each year. Implement a union node and map each year as a separate column. Create 3 calculated columns. Create a filter expression that uses an OR operator.
60- Which type of join supports a temporal condition in a calculation view? Left outer join Text join Referential join Inner join.
61-Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?
D C A B.
62-What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI container? Database connection Wrapper Function Synonym.
63-How can you define a variable that presents its value help hierarchically? Note: There are2 correct answers to this question. Create a parent-child hierarchy and assign it to the variable. Ensure the variable's reference column is the parent attribute of the hierarchy. Create a parent-child hierarchy and assign it to the variable. Ensure the variable's reference column is the child attribute of the hierarchy.
Create a level hierarchy and assign it to the variable.
Ensure the variable's reference column is the leaf level of the hierarchy. Create a level hierarchy and assign it to the variable. Ensure the variable's reference column is the top level of the hierarchy. .
64-What type of data is relevant for SAP HANA Graph modeling? Highly-networked Timeseries Hierarchical data Forecast.
65-What is the disk storage layer used for? Note: There are 2 correct answers to this question. To unload the least-used data when the memory is full To improve the parallel processing of queries To store the data primarily used for transactional processing To enable data to be recovered if hardware fails.
66-In a calculation view, what is the purpose of a variable? To break up complex SQL into smaller steps To pass values between procedures and calculation views To provide a run-time attribute filter based on a user input To provide a dynamic value in a calculated column.
67-Why do you create a multi store table? To improve read performance when accessed by simultaneous applications To have the opt on to partition the table across different storage tiers To evenly distribute the data across all available server nodes To have a table that combines the characteristics of row and column stores.
68-Which is the correct syntax when you refer to an input parameter in a calculation view expression? $$Choose_Country$S :Choose_Country ..Choose_Country" @Choose_Country Answer: A .
69- 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 operations? The first build fails. The second build fails. The first build is successful. The second build is successful. The first build fails. The second build is successful. The first build is successful. The second build fails.
70-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.
The view will return the profit calculation for only the US A change to the data that is returned by the view Increased performance Decreased performance.
71-When using the CONTAINS predicate, what are the restrictions you must keep in mind? Note: There are 2 correct answers to this question.
Non-physical columns, such as calculated columns, are not search-relevant. The NOT (-) operator can only be specified directly after the OR operator. Wild cards * and ? are supported for text columns but not string columns. If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.
72-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? 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. 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 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. 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. .
73-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? Union Join Projection Aggregation.
74-What can you use SAP HANA smart data access for? Note: There are 2 correct answers to this question. To push down queries to data sources To expose data from remote tables To load and harmonize data from disparate sources To replicate remote data sources.
75-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?
You did NOT define a valid table type. Your function refers to a scalar function. You did not define at least one input parameter. Your function includes a TRUNCATE .
76-How can you optimize performance when writing SQL for use with calculation views? Note: There are 2 correct answers to this question.
Use declarative language instead of cursors Use calculation engine (CE) functions instead of plain SQL Control the flow logic using IF-THEN-ELSE conditions Increase parallelization by using variables to break up statements.
77-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. To allow data analysis at different levels of granularity with the same calculation view. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query. To ensure that the join execution only uses the join columns requested in the query. To improve execution time under specific query conditions. .
78-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.
The HDB module references a user-provided service that does not exist. You have assigned the project to a space that you do not have developer authorizations for. You have not built the project. The project is not assigned to a space.
79-In text processing, where do you use the Term Document Matrix? Text mining Linguistic extraction Fuzzy text search Fact and entity extraction.
80-Which types of data are used to represent spatial information? Note: There are 2correct answers to this question.
Column data Vector data Raster data Graph data.