SAP HANA - C_HAMOD_2404

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question. Control the flow logic using IF-THEN-ELSE conditions. Break up large statements by using variables. Choose declarative language instead of imperative language. Use dynamic SQL.

Why would you use the Transparent Filter property in a calculation view?. To prevent filtered columns from producing incorrect aggregation results. To improve filter performance in join node. To ignore a filter applied to a hidden column. To allow filter push-down in stacked calculation views.

What is generated when you build/deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question. Metadata to enable consumption by external tools. An SQL execution plan. A column view in a container. Cached results to improve read performance.

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 versions of attributes. To provide additional time-related navigation possibilities. To add a temporal condition to a join to find matching records from two tables based on a date.

Why would you enable Debug Query mode in a calculation view?. To set breakpoints and step through the execution. To understand how tables are partitioned. To check which database engines are invoked. To identify data sources that are not accessed by a query.

You have created a calculation view query snapshot and you want to generate an interface view. What is the purpose of the generated input parameter of the interface view?. To evaluate the analytic privileges of different users who access the snapshot table. To define the selection criteria used during the scheduled insertion of records into the snapshot table. To map the attributes of the interface view to the original calculation view attributes. To allow the user to select whether to run a query on the snapshot table or on the original calculation view.

How can you define a variable that presents its value help hierarchically? Note: There are 2 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.

Why might you use the Keep Flag property in an aggregation node?. To exclude columns that are NOT requested by a query to avoid incorrect results. 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. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query.

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

Which type of join supports a temporal condition in a calculation view?. Inner join. Left outer join. Text join. Referential join.

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February. What is the optimal way to do this?. Use a minus node. Use an intersect node. Use a union node. Use an aggregation node.

What can you identify using Performance Analysis mode? Note: There are 2 correct answers to this question. Usage statistics of the calculation view. Expected memory consumption. Information about join cardinality. Joins that are defined on calculated columns.

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?. 5. 6. 2. 9.

What are possible consequences of unfolding? Note: There are 2 correct answers to this question. Query processing time improves. SQL compilation time increases. Results are read from static cache. Count-distinct results are incorrect.

In a calculated column, which object do you use to process a dynamic value in an expression?. Variable. Table function. Procedure. Input Parameter.

Why would you partition a table in an SAP HANA database? Note: There are 2 correct answers to this question. To improve data replication performance on large row tables. To improve response time when multiple users access the same table. To improve query performance when accessing large column tables. To overcome the 2 billion record limit.

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note: There are 2 correct answers to this question. To ensure specific columns are NOT exposed to the reporting tool. To avoid exposing sensitive columns when defining calculated columns. To remove a column that is also used as a Label column. To prevent passing columns in stacked calculation views.

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?. Filters. Calculated columns. Joins. Data sources of unions.

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

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question. The hierarchy must be exposed by a CUBE calculation view with star join. The hierarchy must be a parent-child hierarchy. The hierarchy must be a shared hierarchy. The hierarchy must be defined as a local hierarchy.

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?. Create a filter expression that uses an OR operator. Implement a union node and map each year as a separate column. Create 3 calculated columns. Create a restricted column for each year.

You combine two tables in a join node using multiple columns in each table. Why do you enable the dynamic join option? Note: There are 2 correct answers to this question. 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 uses only the join columns requested in the query. To ensure that the aggregation always happens after the join execution. To allow data analysis at different levels of granularity with the same calculation view.

What is a restricted measure?. A measure that can be consumed by a CUBE and not a DIMENSION. A measure that can only be displayed by those with necessary privileges. A measure that cannot be referenced by a calculated column. A measure that is filtered by one or more attribute values.

Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question. To pass variable values to external value help views. To push down filters to the lowest level calculation views. To assign variables to one or more attributes. To convert the data types of input parameters.

You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?. You already mapped the input parameters in another calculation view. The names of the input parameters do not match. You selected the wrong parameter mapping TYPE. Your source calculation view is of type DIMENSION.

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 an aggregation node in a CUBE calculation view. • Use a star join node to join the DIMENSIONS to the resulting fact table. • Combine the transaction tables using a join node in a CUBE calculation view. • Combine the DIMENSIONS using another join node. • Use a star join node to combine both resulting fact and dimension tables. • Combine the transaction tables using a star join node in a CUBE calculation view. • Use a join node to join the DIMENSIONS to the resulting fact table. • Combine the transaction tables using a join node in a CUBE calculation view. • Use a star join node to join the DIMENSIONS to the resulting fact table.

You want to join two tables in a calculation view. Why do you use a non-equi join?. Join columns have different data types. Join columns need to be ignored when NOT requested by the query. The join condition is not represented by matching values. The number of joined columns is different in each table.

Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question. Row table. Scalar function. Procedure. Table function.

Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and 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?. Projection. Aggregation. Join. Union.

What are the key steps to implement currency conversion in a calculation view?. • Assign semantic type. • Enable the measure for conversion. • Choose client, source and target currencies. • Choose conversion date and rate type. • 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. • Enable the measure for conversion. • Choose client, source, and target currencies. • Choose conversion date and rate type. • Build the conversion rule.

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources. How do you check if pruning occurs? Note: There are 2 correct answers to this question. Enable the Debug Query mode to identify the source columns used. Use the SQL Analyzer to identify the tables used. Observe which columns are mapped using the Performance Analysis mode. Check the SQL query generated by the Data Preview.

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?. To ensure semantic correctness. To hide columns that are not required. To force filters to apply at the lowest node. To avoid duplicate rows in the output.

Why would you choose to implement a referential join?. To automate the setting of cardinality rules. To develop a series of linked joins. To reuse the settings of an existing join. To ignore unnecessary data sources.

What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question. Assign them to a parent determined by an expression. Define them as additional root nodes. Assign them to an existing node at the root level. Assign them to a leaf level node.

What can you do with shared hierarchies? Note: There are 2 correct answers to this question. Provide reusable hierarchies for drilldown in a CUBE without star join. Provide reusable hierarchies for drilldown in a CUBE with star join. Access hierarchies created in external schemas. Enable SQL SELECT statements to access hierarchies.

You have products that appear in table A and sometimes also in table B. What would you use to find products only appearing in table A?. A minus node between table A and table B. An intersect node between table A and table B. A right outer join node between table A and table B. A left outer join node between table A and table B.

What is a calculation view query snapshot?. A record of the query statement executed on a calculation view. The stored results of a query on a calculation view. A bookmark of a frequently used navigation state of a query result. The results of a query generated by a front end tool on a calculation view.

You set the Null Handling property for an attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR?. <empty string>. "Null". "ס". "2".

What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question. Only one column can be included in the join condition. It is restricted to one DIMENSION in a star join node. It must appear in the last DIMENSION in the star join node. It CANNOT be mixed in the same star join node with other join types.

What is the default top view node for a calculation view of type CUBE?. PROJECTION. UNION. AGGREGATION. HIERARCHY.

Which of the following are standard options provided to define analytic privileges? Note: There are 3 correct answers to this question. Hierarchy function. Attributes. Dynamic. SQL expression. Graph.

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?. A SELECT privilege and an Analytic Privilege (Country United States) on the CUBE calculation view. A SELECT privilege and an Analytic Privilege (Country United States) on the DIMENSION calculation view. SELECT privileges and Analytic Privileges (Country United States) on both views. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country= United States) on the DIMENSION calculation view.

When you build/deploy a flowgraph, what can be generated? Note: There are 3 correct answers to this question. Replication Task. Procedure. Real-time Task. Batch Task. Function.

Why do we use Git when modeling calculation views?. To manage versions of source files. To enable collaboration between developers. To display dependencies in stacked scenarios. To automate the build process.

Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question. Avoid union pruning. Partition large tables. Aggregate data early in the data flow. Limit the number of stacked calculation views.

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question. To convert currencies. To generate a restricted column. To generate a calculated column. To define a filter. To generate hierarchies.

A cube calculation view consumes a dimension calculation view. You rename the design time file of the dimension view but do NOT choose the option to rename the runtime view and adjust the reference. Afterward, you perform the following operations: •A: Build/deploy the dimension calculation view as a single object. •B: Build/deploy the entire SAP HANA database module. What is the outcome of the build/deploy operations?. A is successful. B fails. A is successful. B is successful. A fails. B is successful. A fails. B fails.

Which of the following approaches might improve the performance of joins in a CUBE calculation view? Note: There are 2 correct answers to this question. Define join direction in a full outer join. Specify the join cardinality. Limit the number of joined columns. Use an inner join.

What are the characteristics of a SHARED replica table? Note: There are 3 correct answers to this question. You can choose your own replica table name. The replica table always stores real-time data. You do not need to create the physical replica table manually. You can toggle queries routing between remote table data and replica table data. The consuming application always references the virtual table.

What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question. Only one block can be defined across a stack of calculation views. The block must have only one start node. Multiple blocks can be defined only within a single calculation view. The block must start with a node that defines a table as a data source.

You have imported a new calculation view into a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to build the calculation view, the build fails with a namespace-related issue. What could be the reason? Note: There are 2 correct answers to this question. The imported calculation view and its data source have different namespaces. An .hdinamespace file is defined in the src folder that specifies a different namespace property than the one in the identifier of the calculation view. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table. The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question. To redirect queries on this calculation view to another one. To lock the calculation view from further modifications. To indicate that it should not be used as a data source to other calculation views. To warn developers that the calculation view is no longer supported.

In a calculation view, your table function node executes a table function that requires input parameters. How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question. Reference the output of a procedure. Map columns from lower nodes. Create and map an input parameter. Define constant values. Assign a hierarchy node.

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails. Which of the following could be a valid reason?. You did not define at least one input parameter. Your table function includes a DELETE statement. You did not define a valid table type. Your table function refers to a scalar function.

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you. When you preview calculation view A, what data do you see?. US for P1. US for P1 and GE for P1. US for P1 and P2, and GE for P1 and P2. US for P1 and P2, and GE for P2.

You deleted the design-time file of a calculation view in your HDB module. What is the recommended way to ensure that the corresponding runtime object is also removed from the database?. Execute the refactor function for the calculation view. Build the project that contained the deleted design-time file. Build the folder that contained the deleted design-time file. Execute a DROP statement in an SQL console connected to the HDI container.

Which project structure object corresponds to a unique HDI container?. A project. A space. An src folder. A database module.

What is the purpose of a remote subscription?. To assign a virtual table to a remote source. To update data in a local table based on changes made to a remote table. To be notified when remote data has changed. To establish a connection to the replication service.

In a data source node of a flowgraph, in addition to tables and views, which other objects can you define as the data source? Note: There are 3 correct answers to this question. calculation view. virtual table. table function. synonym. procedure.

Which of the following tasks are necessary to implement data replication? Note: There are 3 correct answers to this question. Create a remote subscription. Create a target table. Define a flowgraph. Enable the linked database feature. Create a virtual table.

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 a table located in an external schema within the same local database. Which of the following items do you need? Note: There are 2 correct answers to this question. Remote source. SQL view. Synonym. Authorization.

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 scalar function that returns a list of the allowed values for each attribute. A table function that returns a list of allowed values. An organization hierarchy that provides role-based access to data.

You have generated a calculation view properties file. What does it contain?. Documentation to support the calculation view. Descriptions of all objects defined in a calculation view. Dependencies between calculation views. All settings defined in a calculation view.

Your flowgraphs defines a template table as a data target. What triggers the generation of the template table?. Saving the flowgraph. Defining the flowgraph data target node. Running the flowgraph. Building/deploying the flowgraph.

You run a CREATE REMOTE SOURCE SQL statement to create a smart data integration remote source, but the statement fails. What could be the reason? Note: There are 2 correct answers to this question. You do not have the CREATE REMOTE SOURCE privilege on the remote system. The credentials clause defines TYPE 'PASSWORD' but does not specify a technical user. The remote system is not reached through the company network. The specified adapter is not registered with your SAP HANA system.

In an XS Advanced project, what is the purpose of the .hdiconfig file?. To specify the namespace rules applicable to the names of database objects. To specify which HDI plug-ins are available. To specify an external schema in which calculation views will get their data. To specify in which space the container should be deployed.

In a flowgraph, which node do you use to select only the required columns from a data source and to filter specific rows?. Projection. Pivot. Aggregate. Case.

Why would you use an anonymous block when writing SQLScript?. To execute a statement without creating entries in the database log. To hide the actual tables by using aliases in the code. To check the results without applying user privileges. To test your code without generating a logic container.

Why do you nest flowgraphs? Note: There are 2 correct answers to this question. To reduce flowgraph maintenance. To start multiple flowgraphs at the same time. To improve flowgraph performance. To access additional node types.

Why would you implement SQL in calculation views? Note: There are 2 correct answers to this question. To implement custom functions. To fine-tune performance. To increase the possibilities for consumption. To define dynamic analytic privileges.

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question. Define filters on calculated columns. Aggregate at the lowest possible node. Include all data flow logic within one calculation view. Avoid defining joins on calculated columns.

You create a user-provided service to access tables in external schemas. In which file type do you assign the user-provided service to your database module?. .mtar. hdiconfig. .yaml. .namespace.

Which of the following are characteristics of the OPTIMIZED linked database feature? Note: There are 2 correct answers to this question. The metadata of remote tables is cached on the target system. Hidden virtual tables are automatically created on the target system. The source and target system must be SAP HANA. A database name is used in an SQL statement to identify the remote object.

What privileges do you need to create a virtual table referencing a remote SAP HANA table? Note: There are 2 correct answers to this question. ALTER on the remote source. CREATE VIRTUAL TABLE on the remote source. CREATE ANY on the target schema. SELECT on the source object.

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used. What might be the reason for this?. You did not define a filter in the cache setting. Your cache setting does not specify any columns. The query requests only a subset of the cached results. The cache data retention period has expired.

You are deploying a new calculation view, A, that uses calculation view B, as shown in the diagram. When you preview calculation view A, the account number is not masked. What could be the reason?. You did not define masking in calculation view A. The UNMASKED privilege has NOT been granted at the schema level. The type of the Account_Number column is VARCHAR. You previewed the data with the technical user in the SAP HANA modeling tool.

In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?. Scalar function. Procedure. Anonymous block. Table function.

Which tool generates and runs the SQL for a specific node of your calculation view?. Database explorer. Debug Query mode. SQL analyzer. Explain plan.

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question. The Keep flag is activated for the Customer column. Join cardinality is set :1. Integrity constraint is set to RIGHT. The Country column is requested.

You are creating a procedure to be consumed in a DYNAMIC analytic privilege. What must you consider? Note: There are 2 correct answers to this question. The procedure should be defined as read-only. The procedure should return a table with the list of allowed values. The procedure should have the value DEFINER for the security mode. The procedure should include an input parameter to specify the user ID.

What performance technique should you implement to improve the performance of SAP HANA information views?. Implement union pruning conditions. Supply reporting tools with all the data in one transfer. Build single large views. Output as many fields as possible.

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?. The build is successful but the is NOT present. The build is successful and the table and its data are present. The build fails and the table is NOT present.

What are features of Business Suite on SAP HANA? There are 2 correct answers to this question. Embedded Analytics. Massive performance improvement. ABAP is replaced with JAVA. Combine operational analytics and transaction processing.

Which of the following features of an XS Advanced application are provided by an HDB module? There are 2 correct answers to this question. User interface. Persistence layer. Business logic. Virtual data modeling.

Why should you define calculated column expressions using plain SQL and avoid using column engine language?. To allow imperative statements. To prevent queries from unfolding. To access the full set of SQL functions. To benefit from additional SQL optimizations.

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 key date parameter must be derived from an input parameter. The hierarchy must be a level hierarchy. The hierarchy must be enabled for SQL access.

What should you use to create tables in an HDI container? There are 2 correct answers to this question. Core Data Services (CDS). SAP Enterprise Architecture Designer. Database Explorer. SQL Console.

You want to implement parallelization in a calculation view. Which restrictions apply to the parallelization block? There are 3 correct answers to this question. Only one start node can be defined. It must begin with a data source of the type table. A partitioning column must be defined. You can define only one per calculation view. Only one block can be defined across a calculation view stack.

Which of the following can a level hierarchy do?. Show variable deepness in the data. Be used for a bill of materials (BOM) structure. Enable drilldown in a value help list. Have time-dependency.

Why do you create a time dimension calculation view?. To provide date-based help values for a DIRECT type input parameter. To enhance a calculation view with a drilldown on a time hierarchy. To enable time dependency on parent-child hierarchies. To support temporal joins in a cube calculation view with star schema.

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

You created a calculated column in a star join view for a table containing the number of units ordered, the price per unit, and the number of units in stock. You get the wrong results. What could be the problem?. You mistyped the calculated column expression. You did NOT enable the Keep Flag. You chose the SQL expression syntax. You did NOT enable the currency conversion.

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

Where can you create a filter expression?. Aggregation node. Semantics node. Data foundation node. Projection node.

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as 3 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 the data preview is empty. The build fails and the table is dropped. The build fails and the table is not dropped. The build is successful and you get the expected data.

In Web IDE for SAP HANA, what can I create in a HDB module? There are 3 correct answers to this question. Calculation View. HTML file. Synonym. Analytic Privilege. Flowgraph.

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 effects of this action? There are 3 correct answers to this question. Variables can no longer be used by this calculation view. users MAY NO LONGER see the most current data in the output. 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.

Which version of CDS is used by S/4HANA?. Both ​​​ABAP CDS and ​​HANA CDS. ABAP CDS. HANA CDS. None of these.

Which of the following data provisioning tools can provide a delta load of a table from the source system?. SDA. SAP HANA streaming analytics. Flat files. SAP Landscape Transformation Replication Server.

In your calculation view, you CANNOT enable a hierarchy for time dependency. What could be the reason for this?. You did NOT reference a DIMENSION of the type TIME. The hierarchy is a level type. You did NOT include a history column table. The hierarchy is a parent-child type.

What is the persistent storage layer used for? There are 2 correct answers to this question. To improve the parallel processing of queries. To unload the least-used data when the memory is full. To enable data to be recovered if hardware fails. To store the data primarily used for transaction processing.

Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?. They call multiple processing engines. They could modify the database. They can harm SQL optimization. They introduce potential security risks.

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

Which generated output column uses hierarchies?. Restricted Column. Rank Column. Calculated Column. Node Column.

Of which SAP HANA process are the transaction manager and page manager a part?. Index server. Name server. Statistics server. Application server.

What SQL construct do you use to return multiple result sets from a single SQL statement?. GROUPING SETS. JOIN. UNION. SELECT subquery.

What type of file would you create in the SAP Web IDE for SAP HANA to do data cleaning?. .hdbtabledata. .hdbcds. .hdbgraphworkspace. .hdbflowgraph.

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 store data that is frequently used. To enable full database recovery if we have a power failure.

What are the benefits of SQL development in calculation view modeling?. To enable changes to data sources. To implement custom logic. To develop models for optimal performance. To provide an alternative to graphical modeling.

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