EFH_ola7

In which type of node can you create calculated columns? There are 2 correct answers to this question. Rank node. Union node. Graph node. Projection node.

Why do you assign semantic types to measures or attributes in calculation views? Please choose the correct answer. To allow client applications to present data in appropriate formats. To ensure consistency across calculation views. To provide meaningful value help when using variables. To enable the activation of the calculation view.

Which of the following features analyze dependencies between models? There are 2 correct answers to this question. Data lineage. Column lineage. Impact analysis. Mapping Analysis.

You have Model B that is based on Model A. You have NOT built any of the models yet. You delete Model A. What happens during the build? There are 2 correct answers to this question. The build of the entire HDB module is successful. The build of Model B is successful. You get an error when you build the entire HDB module. You get a build error when you build Model B.

Which scenario is supported to base an analytic privilege on a hierarchy defined on an attribute column? Please choose the correct answer. Create a classical analytic privilege based on a level hierarchy. Create a classical analytic privilege based on a parent-child hierarchy. Create an SQL analytic privilege based on a level hierarchy. Create an SQL analytic privilege based on a parent-child hierarchy.

Which generated output column uses hierarchies? Please choose the correct answer. Rank Column. Node Column. Restricted Column. Calculated Column.

Why do we still need a persistent layer? There are 2 correct answers to this question. To store data that has been unloaded from memory. To hold the delta store for newly arrived records. To enable full database recovery if we have a power failure. To store data that is frequently used.

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

What do you need for Active/Active (read-enabled) mode? There are 2 correct answers to this question. Log replication. Extended storage. Disaster recovery. Multitenant Database Containers (MDC).

The relational model of SAP HANA Live is built using which type of views? Please choose the correct answer. Scripted calculation views. Calculation views of data category cube with star join. Calculation views of data category cube without star join. Analytic views and attribute views.

Identify the principles that you need to follow during modeling. There are 2 correct answers to this question. You should perform calculations before aggregation. You should create joins on key columns. You should push data processing to the client as much as possible. You should reduce data transfer between the views by applying filters as low down as possible.

Why did SAP decide to use CDS for S/4HANA Analytics and not SAP HANA Live? There are 2 correct answers to this question. More use cases are available with CDS than with SAP HANA Live. Deeper BI functionality is available with CDS compared to SAP HANA Live. CDS is tied to the application layer for better control of complete source code transportation. Calculation views cannot be used with S/4HANA tables.

Your newly created analytic privilege does NOT want to build. What must you do? Please choose the correct answer. Grant rights to the _SYS_REPO user. Assign the ::access role to the HDI container user. Change the Apply Privileges property of the view. Change the analytic privilege to use an SQL Expression.

Which are features of a calculated column? There are 2 correct answers to this question. It’s a column in the result set. Its calculations are persisted. It’s created in the output area. It’s created in the Semantics node.

Which of the following node types can you use to build a dimension view? There are 3 correct answers to this question. Star join node. Aggregation node. Data foundation node. Semantics node. Union node.

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

You have Model B that is based on Model A. You have successfully built both models. You delete Model B. What happens during the build? There are 2 correct answers to this question. Model B gets deleted from the HDI container. You get a build error when you build Model A. The build of the entire HDB module is successful. The build of Model A is successful. You get an error when you build the entire HDB module.

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. Total number of records returned by the node. Time taken by the join. Tables used by the join in the node. Suggested filter for the tables in the Join node.

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

In SAP HANA Text Analysis, why would you use the ‘Voice of Customer’ dictionary? Please choose the correct answer. To extract the sentiment from customer feedback on social media. To extract common entities such as company, country, currencies, and so on, found in documents. To identify close matches in words and expressions, to catch misspellings. To identify the problem which customers are facing.

What are features of SAP S/4HANA? There are 2 correct answers to this question. Optimized for SAP HANA but maintains compatibility with other platforms. Embedded Analytics. Rewritten ABAP code optimized for SAP HANA. SAP HANA Live provides real time operational analytics.

Which of the following views can you extend with the SAP HANA Live Extension Assistant? There are 2 correct answers to this question. Query views with a union. Reuse views. All SAP-delivered views. Your own custom views. Query views.

Why would you create a procedure? There are 2 correct answers to this question. If you need to define a calculated column expression. If you need a mixture of scalar and tabular output parameters. If you need to insert records into a table. If you need to provide a data source to a graphical calculation view.

Refactoring is used with which of the following actions? Please choose the correct answer. Improving your modeling design. Deployment. Translating. Documenting.

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

In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario? (2). Container. Function. Procedure. Task.

You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create view that uses data from one ta-ble located in an external schema. (2) Which of the following items must you build?. HDB MODULE. Project. Authorization. Synonym.

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.

Which of the following are no longer required in the architecture of SAP S/4HANA? There are 2 correct answers to this question. Aggregates. Indexes. Column tables. Synonyms.

One SQL analytic privilege authorizes you to view data for Europe and the USA in the sales calculation view, and another one authorizes you to view data for Asia and the USA in the income calculation view. The income view uses the sales view as a data source. Both calculation views check SQL analytic privileges. What data can you visualize when consuming the income calculation view? (1). Data from Asia and the USA. Data from Europe, Asia, and the USA. Data from the USA. Data from Europe and the USA.

You want to star schema using calculating view. The measure are based on columns from two transaction table dimension calculation views pro-vide the attributes. What is the correct approach? Please choose the correct answer. 1. Combine the transaction table using a star join node in a calculation view of cube with star join 2. Use a star node to join the dimensions to the fact table. 1. Combine the transaction table using a star join node in a calculation view of cube with star join 2. Use an aggregation node to join the dimensions to the fact table. 1. Combine the transaction table using a join node in a calculation view of cube with star join 2. Use a star join node to join the dimensions to the fact table. 1. Combine the transaction table using an aggregation node in a calculation view of cube with star join 2. Use a star join node to join the dimensions to the fact table.

How does SAP HANA Live impact SAP Business Warehouse (SAP BW)? Please choose the correct answer. It makes SAP BW business content irrelevant. It adds more reporting tools to SAP BW. It simplifies SAP BW data modeling. It moves live, operational reporting to SAP HANA.

When can you expose a hierarchy that is defined in a calculation view for access with SQL? Please choose the correct answer. When the hierarchy is a local hierarchy. When the hierarchy is defined in a calculation view of DEFAULT. When the hierarchy is defined in a calculation view of type CUBE. When the hierarchy is a shared hierarchy.

In SAP Web IDE for SAP HANA, you created an SQL analytic privilege that secures your calculation view. You build the analytic privilege, but the build fails. What could be the reason? Please choose the correct answer. The Apply Privileges property of your calculation view was NOT defined correctly. Calculation views CANNOT be assigned to an analytic privilege. The Data Category property of your calculation view was NOT set correctly. You did NOT assign the analytic privilege to a role.

How does SAP S/4HANA embedded analytics differ from SAP HANA Live? There are 2 correct answers to this question. It uses SAP HANA calculation views. It uses ABAP CDS views. Authorizations are at the database level. Authorizations are at the application level.

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

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.

How can you define a variable that presents its value help hierarchically? There are 2 correct answers to this question. 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 reference column is the leaf level 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. Create a parent-child hierarchy and assign it to the variable Ensure the variables reference column is the parent attribute of the hierarchy.

When using the CONTAINS predicate, what are the restrictions you must you keep in mind? There are 3 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. If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables. Wild cards* and? Are supported for text columns but not string columns.

When you create a full text index, why do you specify FAST_PREPROCESS OFF? Please choose the correct answer. To prevent the creation of a fuzzy search index. To enable a full linguistic search. To avoid the generation of the term document matrix. To generate text analysis results in multiple languages.

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 namespac-es.

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? Please choose the correct answer. You do NOT create synonyms for the tables. You do NOT have write permissions to the personnel table. You did NOT define a valid table type. You CANNOT update records using a table function.

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.

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. Afterwards, you perform the following build ope-rations. Build the dimension calculation view as a single object Build the entire SAP HANA database module. What is the outcome of the build operations? Please choose the correct answer. The first build is successful. 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 fails The second build fails.

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.

What restrictions apply to a graph node that you include in a calculation view? Please choose the correct answer. It must be the first node in the data flow. It must be the final node in the data flow. It cannot be included in a calculation view of type dimension. Its data sources must be provided by a projection node.

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.

In text processing, where do you use the Term Document Matrix? Please choose 2 correct answers. Linguistic extraction. Text mining. Fact and entity extraction. Fuzzy text search.

Why do you use the query debug mode in a calculation view? Please choose the correct answer. To observe the generated SQL for each node. To check which database engines will be invoked by each node?. To check if SAP HANA can paralyze the entire query. To measure the overall run-time of the query.

Which of the following techniques can you use to improve the perfor-mance of calculation views? There are 2 correct answers to this question. Avoid aggregating data early in the data flow. Partition large tables. Minimize layering of calculation views. Implement union pruning.

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? There are 2 correct answers to this question. Assign the project to a space to which you have developer authorizations. Explicitly build the HDB module instead of the project. Ensure that you have only one HDB module in your project. Ensure that the name of your HDB module is included in the corresponding schema names.

From where does the Extract Semantics feature get the definition of hierar- chies? Please choose the correct answer. From the current calculation view. From the table data sources. From the underlying dimension views. From the SQL view data sources.

Why might you use the keep flag in an aggregation node? Please choose the correct answer. To retain the results of the aggregation node for reuse in a drill-down based on hierarchy. To include columns that are NOT requested by a query but are essential for the correct result. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query.

Question: What can you extract using the standard text analysis configuration: Voice of the Customer? There are 2 correct answers to this question. Sentiments. Recommendations. Suggestions. Requests.

Question: You have a table with two columns, CUSTOMER NAME and COUNTRY NAME, In which Italian customers are stored. You have an identical table in which you store French customers. What type of calculation view should you create to combine the customers in to two columns that mirror the structure of the sources tables? Please choose the correct answer. Calculation view of dimension type with a union node. Calculation view of dimension type with a join node. Calculation view of cube type with a join node. Calculation view of cube type with a union node.

What can you identify using the performance Analysis Mode? There are 2 correct answers to this question. Information about join cardinality. Joins that are based on calculated columns. Usage statistics of the calculation view. Longest running query step.

In SAP HANA Series Data processing, what is the definition of a profile? Please choose the correct answer. A variant of data set, such as actual, forecast, or long-term plan. The values that you are storing, such as temperature, en-ergy consumption, or speed. The granularity of time intervals, such as day, hour, or mi-nute. The object you collect data against, such as house, buid-ling, or town.

In a calculation view, what is the purpose of a variable? Please choose the correct answer. 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 capture the interim result of a calculation in an expression.

Why do you create calculation views of data category DIMENSION with type TIME? Please choose the correct answer. To apply automatic adjustment 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. To provide the time intervals required by time-dependent parent-child hierarchies.

What can you discover using Data Lineage? Please choose the correct answer. Access statistics. Underlying calculation views and tables. Frequency of load. Data changes since last refresh.

What can you use SAP HANA smart data access for? There are 2 correct answers to this question. To load harmonize data from disparate sources. To expose data from remote tables. To push down queries to data sources. To replicate remote data sources.

Which of the following approaches can be used to implement union pruning? Note: There are 2 correct answers to this question. Define a constant value for each data source in the Union node. Define a restricted column and include it in both data sources of a union. Define the cardinality between the data sources. Define union pruning conditions in a pruning configuration table.

In your calculation view, you need to define a custom data source using SQL Script. In which object do you write your SQL Script? Please choose the correct answer. Table function. Scalar function. CDS View. Procedure.

What is a multistore table? Please choose the correct answer. A table that can distribute its partitions across memory and extended storage tiers. A table that can hold data in row and column orientation. A table that can be shared across multiple instances of HANA. A table that can be shared across multiple instances of SAP HANA Cockpit.

You set up in currency conversion in a calculation view. When your currency conversion fails, what could you choose to populate the target column? There are 2 correct answers to this question. <EMPTY>. Null. THE source amount. A DEFAULT value.

Why do you build a calculation view of type DEFAULT? Please choose the correct answer. 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. To provide a leaner model when only attributes are required.

In which parts of a SELECT statement can you include the ST_Within spatial predicate? Note: There are 2 correct answers to this question. WHERE clause. GROUP BY clause. JOIN condition. HAVING clause.

Why does SAP issue warnings about the use of imperative or procedural SQL Script statements? Please choose the correct answer. They are deprecated. They introduce security risks due to SQL injection. They can harm SQL optimization. NOT all reporting tools can consume the results.

What development tool is available for creating SAP HANA XSA and HDI information models? Please choose the correct answer. SAP HANA Studio. Database Explorer. SAP Web IDE for SAP HANA. SAP HANA Web-Based Development Workbench.

In SAP HANA Series Data processing, what is the definition of a profile? Please choose the correct answer. 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 against, such as house, buidling, or town. A variant of data set, such as actual, forecast, or long-term plan.

In SAP BW, when we refer to mixed modeling, what do we mean? Please choose the correct answer. Integration of models from BW on non-HANA databases combined with SAP HANA optimized BWmodels. Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views. Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views. Integration of SAP NetWeaver Components into complex SAP HANA BW models.

Your calculation view includes the following 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? Please choose the correct answer. Join. Union. Projection. Aggregation.

What conditions must be met before you can implement time dependency on a hierarchy in a calculation view? There are 2 correct answers to this question. 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.

What do SAP S/4HANA embedded analytics and SAP HANA Live have in common? There are 3 correct answers to this question. They can be extended by customers. They are built using ABAP CDS. Their data access is controlled using analytic privileges. They expose operational data from SAP Sources. They are built an maintained by SAP.

Why do you use SAP HANA Graph? Please choose the correct answer. To push down graphic processing of the database. To access advanced chart types from calculation views. To develop a dashboard to present KPIs. To model highly-networked entities.

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? Please choose the correct answer. 6 Rows. 2 ROWS. 9 Rows. 8 Rows.

An SAP HANA Live model is displayed as in invalid view in the list of models in the SAP HANA Live browser. What could be the reason? There are 2 correct answers to this question. The model has been deleted. The model's underlying table is not fully replicated. The model is missing an underlying table. The model is missing a dependent view.

You create a hierarchy in a dimension calculation view. You then consume this dimension calculation view with star join in a cube calculation view. How do you allow SQL access to the hierarchy? (1). 1.Enable SQL access in the view properties of the dimension calculation view. 2.Obtain generated node names in local hierarchies. 1.Enable SQL access in the view properties of the cube calculation view with star join. 2.Obtain generated node names in local hierarchies. 1.Enable SQL access in the view properties of the dimension calculation view. 2.Obtain generated node names in shared hierarchies. 1.Enable SQL access in the view properties of the cube calculation view with star join. 2.Obtain generated node names in shared hierarchies.

A partitioned column table is present 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? Please choose the correct answer. All the partitions but ONLY the required columns. ONLY the required partitions and all the columns. Should have chosen. ONLY the required columns and the required partitions.

What conditions must be met to ensure the Dynamic join feature works properly? There are 2 correct answers to this question. At least one joined column must be specified in the query. Cardinality must be set. Multiple columns must be defined in the join. The join must be defined on key columns.

A column in your table will be used for text search. Why do you define the column as a text type instead of a string type? (1). To allow processing of multiple languages. To enable a linguistic analysis. To enable lower memory consumption. To enable the full set of SQL operations.

What are the components of a graph workspace? There are 2 correct answers to this question. Partition. Vertex. Edge. Space.

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? Mapping Required Calculation View A Input parameter Calculation View B Input parameter Please choose the correct answer. You already mapped the input parameters in another calculation view. Your source calculation view is of the type DEFAULT. You selected the wrong parameter mapping TYPE. You did not push the Auto Map button.

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

In a calculation view, which object type do you assign to a projection mode to consume a predictive analysis library (PAL) function? Please choose the correct answer. synonym. Table function. Scalar function. Input parameter.

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

In your rank node, why do you set the dynamic partition element flag? Please choose the correct answer. To determine the partitioning logic using an SQL expression. To define time dependency on a partition. To determine the ranking threshold value base on an input parameter. To generate the ranking partition based on the column selected in the query.

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? Please choose the correct answer. 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.

Which of the following views can be extended by using the SAP HANA Live extension assistant? There are 2 correct answers to this question. A custom view. A query view. A private view. A reuse view.

In an XSA/HDI environment, which of the following is used for source version control of calculation views? Please choose the correct answer. SAP HANA studio. CTS (Change Transport System). CMS (Change Management System). Open-source Git.

Which type of join supports a temporal conditions in a calculation view? Please choose the correct answer. Text join. Referential join. Inner join. Left outer join.

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? Please choose the correct answer. Create a filter expression that uses an OR operator. Create a restricted column for each year. Implement a union node and map each year as a separate column.

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? Please choose the correct answer. Impact Analysis. Database explorer. Show lineage. Where used.

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? Please choose the correct answer. Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers. Contribute: Please send the correct answers with reference text/link on feedback@erpprep.com to get up to 50% cashback. Set the Transparent Filter property for STATE. Set STATE as an aggregated column. Set the Keep Flag property for both SHIRT_ID and PROMO_LEVEL. Set the Dynamic Partition flag for SHIRT_ID and PROMO_LEVEL.

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

You created a table using the SQL console inside the HANA deployment infrastructure (HD) container of project You export project and re-import it with a different project name to same database. What do you observe the SAP HANA database module? Please choose the correct answer. The build fails and the table is NOT present. The build is successful but the is NOT present. The build is successful and the table and its data are present.

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? There are 2 correct answers to this question. To hide individual patients in groups of similar records. To restrict data access for specific users or roles. To add noise to the data to hide the actual values. To provide partial values such as #3434 3#34##.

In a calculation view, where can you use SQL? There are 3 correct answers to this question. Union pruning conditions. Filter expression. Calculated column expression. Input parameter. Aggregation node.

How could you improve the performance of joins in cube calculation views? (2). Join on calculated columns. Avoid the use of referential joins. Specify the cardinality of the join. Reduce the number of columns used in the join.

What does SQL script provide to extend standard SQL?. 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.

Which technologies does SAP HANA use to load more data into memory? There are 3 correct answers to this question. Use ZIP compression. Store data in column tables. Eliminate indices. Use multicore CPU parallelism. Use dictionary compression.

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

Which hierarchies can you enable for SQL access? Please choose the correct answer. Level hierarchies in a calculation view of type cube. Local hierarchies in a star join view. Time-dependent hierarchies in a dimension view. Shared hierarchies in a star join view.

In which direction do you build calculation views when including the source tables in Join nodes? Please choose the correct answer. From the Join nodes up to the semantics node. From the Semantics node up to the default node. From the Join node down to the default node. From the Semantics node down to the Join nodes.

A referential join gives the same results as which other join type? Please choose the correct answer. Star join. Left outer join. Inner join. Spatial join.

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

What performance techniques should you implement to improve join performance? There are 3 correct answers to this question. Use unions instead of joins for combining large datasets. Use left outer joins instead of right outer joins. Always specify the cardinality of a join. Join as many tables as possible in a star join view's data foundation. Always mark joins as dynamic to improve performance.

What are components of SAP HANA EIM?. SDQ. SDA. SDI. SDS.

What phrase describes the main table area in the delta merge scenario?. Row store. Unsorted inserts. Write-optimized. Read-optimized.

What can be used to return multiple result sets? Please choose the correct answer. Scalar function. Table function. Procedure. View.