PMIA

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

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

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. Union. Aggregation. Join.

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

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?. Your function refers to a scalar function. You did NOT define a valid table type. You did not define at least one input parameter. Your function includes a TRUNCATE statement.

Why would you implement active / active read-enabled mode?. To provide offline access to data. To synchronize query results with operational data. To enhance security for data access. To improve query performance.

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

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. 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 is successful.The second build is successful. The first build fails.The second build fails. The first build is successful.The second build fails. The first build fails.The second build is successful.

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

What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question. 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. Only one column can be included in the join condition. It is restricted to one DIMENSION in a star join node.

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question. Julian. Gregorian. Factory. Fiscal.

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 a DROP statement in an SQL console connected to the HDI container. Build the project that contained the deleted design-time file. Execute the refactor function for the calculation view. Build the folder that contained the deleted design-time file.

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

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

Why would you create SQL in calculation views?. To implement custom logic. To provide an alternative to graphical modeling. To enable write capabilities. To fine-tune performance.

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

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

You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?. Local Git repository -> Staging area -> Working directory. Working directory -> Local Git repository -> Staging area. Staging area -> Working directory -> Local Git repository. Working directory -> Staging area -> Local Git repository.

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. Authorization. Synonym. SQL view. Remote Source.

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?. Label column. Show lineage. Impact analysis. Where used.

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

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 level hierarchy and assign it to the variable.Ensure the variable's reference column is the leaf level 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 top level of the hierarchy.

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

Which of the following are usually not required In the data model of SAP S/4HANA?Note: There are 2 correct answers to this question. Stored aggregates. Views. Partitions. Indexes.

What are some best practices when developing calculation views?Note: There are 2 correct answers to this question. Include all data flow logic within one calculation view. Model star schemas using a sequence of join nodes. Avoid defining joins on calculated columns. Aggregate at the lowest possible node.

What is the SQL keyword used to process input parameters defined in a calculation view?. Hint. Placeholder. Where. Set.

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

Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question. Extension Node. Persistent memory. Native Storage Extension. Dynamic Tiering. Active / active read-enabled mode.

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. Use the SQL Analyzer to identify the tables used. Enable Debug Query mode to identify the columns used. Explore the number of used columns in the Performance Analysis mode. Preview the data results in the calculation view.

You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?. Write and execute a custom SQL query in the SQL Console. Select and deselect columns from the output mapping. Set the HIDE property for columns NOT required. Select Data Preview for the calculation view.

Why might you use the Keep Flag property in an aggregation node?. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query. To retain the correct aggregation behavior in stacked views. To include columns that are NOT requested by a query but are essential for the correct result. To exclude columns that are NOT requested by a query to avoid incorrect results.

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

Why do we use Git when modeling calculation views?Note: There are 2 correct answers to this question. To manage versions of source files. To display dependencies in stacked scenarios. To automate the build process. To enable collaboration between developers.

Why do you create calculation views of data category DIMENSION with type TIME?. 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. To store historical versions of attributes. To provide the time intervals required by time-dependent parent-child hierarchies.

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

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

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

Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?. They could modify the database. They call multiple processing engines. They introduce potential security risks. They can limit parallelization of query execution.

Why would you create a multistore table?. To implement a table that combines the features of row and column store. To enable partitioning of the table across different storage tiers. To improve read performance when the table is accessed by simultaneous applications. To evenly distribute the data across all available server nodes.

What are some of the restrictions that apply when defining parallelization blocks in calculation views?Note: There are 2 correct answers to this question. The block must start with a node that defines a table as a data source. Multiple blocks can only be defined within a single calculation view. The block must only have one start node. Only one block can be defined across a stack of 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 hierarchies. To define a filter. To generate a calculated column. To generate a restricted column.

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?. Define a restricted column in a union node. In the union node, map both source customer name columns to one target column. Include an aggregation node above the union node. Add an intersect node above the union node.

What does SAP HANA provide to support full stack native application development?Note: There are 2 correct answers to this question. Code editors and debugger. Support for automated regression testing. Source code version management tool. Incident tracking tools.

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?. Procedure. Scalar function. Anonymous block. Table function.

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 any columns in the cache setting. The cache data retention period has expired. The query requests only a subset of the cached results. You did not define a filter in the cache setting.

Which options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question. Assign them to a level below the root. Define an expression to determine a parent. Assign them to a node at the root level. Generate additional root nodes.

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. Use an inner join. Limit the number of joined columns. Specify the join cardinality. Define join direction in a full outer join.

You have imported a new calculation view in 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. 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. 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.

Why would you use the Transparent Filter property in a calculation view?. To avoid columns being unnecessarily used in an aggregation. To include columns that are NOT requested by a query. To apply filters that are hidden from the end user. To allow filter push-down in stacked calculation views.

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 defined in a calculation view of type SQL ACCESS ONLY. The hierarchy must be exposed by a calculation view of type CUBE with star join. The hierarchy must be a local hierarchy. The hierarchy must be a shared hierarchy.

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 assign variables to one or more attributes. To push down filters to the lowest level calculation views. To pass variable values to external value help views.

After importing a project in the workspace of the SAP Web IDE, you execute a build at the HDB module level. The build fails.What could be the reason?Note: There are 2 correct answers to this question. You have not defined the HDI build plug-in version. Your HDB module references a user-provided service that does not exist. You have not assigned the project to a space. You have not built the project yet.

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. Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Build the conversion rule. Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column.

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

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

Which are the components of SAP HANA Cloud?Note: There are 3 correct answers to this question. SAP Data Warehouse Cloud. SAP HANA Cloud data lake. Native Storage Extension. SAP Analytics Cloud. SAP HANA in-memory database.

What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question. Aggregates are not adjusted. New records are not read. Read performance decreases. Memory is not optimized.

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

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 a data source to a calculation view and try to build it.What do you observe in the SAP HANA database container?. The build fails and the table is dropped. The build fails and the table is not dropped. The build is successful and the data preview returns expected data. The build is successful but the data preview returns an error message.

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

Which of the following supports data replication?. SAP HANA smart data access. SAP HANA, streaming analytics option. SAP HANA smart data quality. SAP HANA smart data integration.

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

Why would you develop an SQL procedure instead of a function?Note: There are 3 correct answers to this question. You want to create a dynamic analytic privilege. A temporary table must be created within the code. Optimal performance is a priority. The code should modify data in a table. You need to use conditional logic.

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 ensure that the join execution only uses the join columns requested in the query. To ensure that the aggregation always happens after the join execution. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query. To allow data analysis at different levels of granularity with the same calculation view.

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 star join node in a calculation view of type cube with star join.Use the same star join node to connect the dimensions to the fact table. Combine the transaction tables using a join node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table. 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.

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

Which of the following are capabilities of SAP HANA smart data access?Note: There are 2 correct answers to this question. Replication of remote data. Push-down of queries to remote data sources. Exposure of real-time data from remote tables. Cleansing and harmonization of data from disparate sources.

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 prevent passing columns in stacked calculation views. To remove a column that is also used as a Label column.

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

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

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

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?. "?". "Null". "0". <empty string>.

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. Join cardinality is set :1. The Country column is requested. Integrity constraint is set to RIGHT. The Keep flag is activated for the Customer column.

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 union node. Use a minus node. Use an intersect node. Use an aggregation node.

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?. A SELECT privilege on the CUBE calculation view 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 and an Analytic Privilege (Country = United States) on the DIMENSION calculation view. A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view.

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

mYou 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 selected the wrong parameter mapping TYPE. Your source calculation view is of type DIMENSION. The names of the input parameters do not match. You already mapped the input parameters in another calculation view.

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

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 and P2, and GE for P2. US for P1 and GE for P1. US for P1. US for P1 and P2, and GE for P1 and P2.

You are building a new calculation view A that uses calculation view B, as shown in the diagram. When you preview the calculation view A, the Account Number is not masked.What could be the reason?. You previewed the data with the technical user in SAP Web IDE for SAP HANA. You did not define masking in calculation view A. The UNMASKED privilege for calculation view A has been granted. Analytic privilege _SYS_BI_CP_ALL has been assigned.