IMPANAH

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 did not define masking in calculation view A. Analytic privilege _SYS_BI_CP_ALLL has been assigned. You previewed the data with the technical user in SAP Web IDE for SAP HANA. The UNMASK privilege for calculation view A has been granted.

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

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

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

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

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

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

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

"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. The Keep flag is activated for the Customer column. Integrity constraint is set to RIGHT.

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query request all columns of the rank node. How many rows are in the output of your query?. 2. 6. 9. 5.

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

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

"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 the other calculations views. To warn developers that the calculation view is no longer supported. To ensure it is not exposed to reporting tools for consumption. To lock the calculation view from further modifications.

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

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

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

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

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

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 folder that contained the deleted design-time file. Build the project that contained the deleted design-time file. Execute the refactor function for the calculation view.

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

Why do you create calculation views of data category DIMENSION with type TIME?. To provide additional time-related navigation possibilities. To provide the time intervals required by time-dependent parent-child hiearchies. To store historical versions of attributes. To add a temporal condition to a join to find matching records from two tables based on a date.

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

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

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

"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. Remote source. SQL view. Synonym.

What are the key steps to implement currency conversion in a calculation view?. "Enable the measure for conversion Choose cliente, source, and target currencies Choose conversion date and rate type Build the conversion rule". "Assign semantic type Choose cliente, source, and target currencies Choose conversion date and rate type Define an expression in a calculated column". "Assign semantic type Enable the measure for conversion Choose cliente, source, and target currencies Choose conversion date and rate type". "Assign semantic type Choose cliente, source, and target currencies Choose conversion date and rate type Define an expression in a calculated column".

"You create a table function to remove historic records, sum the current total weekly working hours for each employe 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 a valid table type. You did not define at least one input parameter. You function refers to a scalar function. You function includes a TRUNCATE statement.

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

"In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option the 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 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".

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

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 summarizard data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY*PRICE. In wich type of node do you define the calculation to display the correct result?. Aggregation. Join. Projection. Union.

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

Why might you use the Keep Flag property in an aggregation node?. 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 overriden by a query. To retain the correct aggregation behavior in stacked views. To exclude columns that are NOT requested by a query to avoid incorrect results.

Which tyoe of join supports a temporal condition in a calculation view?. Text Join. Left outer join. Referential join. inner Join.

You want create a star schema using calculation view. The measures are based on columns from two transactions tables. Dimension calculation views provide the attributes. What is the correct approach?. "Combines the transaction tables using a 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.". "Combines the transaction tables using a star 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.". "Combines 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.". "Combines 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.".

"What are some best practices for writting 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. Use dynamic SQL. Control the flow logic using IF-THEN-ELSE conditions.

"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. You have not assigned the project to a space. Your HDB module references a user-provided service that does not exist. You have not built the project yet.

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. Ananymous block. Table function. Procedure.

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

"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 inthe query. To force the calculation at the relevant level of granularity, even if this level is not the gripuping level defined by the query. To allow data analysis at differet levels of granularity with the same calculation view. To ensure that the aggregation always happens after the join execution.

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

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

"You created a table and instead 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 is successful and the data preview returns expected data. The build is successful but the data preview returns an error message. The build fails and the table is not dropped.

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

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

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

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

"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 prevent passing columns in stacked calculation views. To avoid exposing sensitive columns when defining calculated columns. To remove a column that is also used as a Label Column. To ensure specific columns are NOT exposed to the reporting tool.

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

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

"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 chil attributte of the hierarchy". "Create a level hierarchy and assign it to the variable Ensiure the variable's reference column is the top level of the hierarchy". "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".

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

"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 CANNOT be mixed in the same star join node with other join types. It is restricted to one DIMENSION in a star join node. Only one column can be included in the join condition. It must appear in the last DIMENSION in the star join node.

"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. Generate additional root nodes. Assign them to a node at the root level.

"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. Aggregate at the lowest possible node. Avoid defining joins on calculated columns. Model star schemas using a sequence of join nodes.

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

"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 funcyion of SAP Web IDE for SAP HANA do you use to chech where the output colum ns originate from??". Impact analysis. Show lineage. Where used. Label column.

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

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

"You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes on 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 .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. The imported calculation view and its data source have different namespaces. The namespaces uses within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

"Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question. ". 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. To pass variable values to external value help views.

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

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

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

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

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

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

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. Alias. Association. Synonym.

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

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

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

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

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

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

"You cerated a calculation view that combines two tabkes in a join node. To improve the runtime of your calculation view, you use a referential joun to prune data sources. How do you check if prunning occurs? Note: There are 2 correct answers to this question.". Preview the data results in the calculation view. Explore the number of used columns in the Performance Analysis mode. Use the SQL Analyzer to identify the tables used. Enable Debud Query mode to identify the columns used.