ciccio-pasticcio

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. Add an intersect node above the union node. Include an aggregation node above the union node. Define a restricted column in a union node.

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

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

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

You have products that appear in table A and sometimes they also appear in table B. You want to select the products that appear ONLY in table A. Which node type do you use?. Minus. Union. Intersect. Aggregation.

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 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 exclude columns that are NOT requested by a query to avoid incorrect results.

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

What is the default view node for a cube?. PROJECTION. SEMANTICS. UNION. AGGREGATION.

You have linked an underlying node to the star join node to define the data foundation. Which data source type can you then join to the data foundation?. CUBE calculation view. Table functions. Tables. DIMENSION calculation view.

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? Sales Projection January Company | Product | Quantity 001 | X | 10 002 | Y | 7 003 | X | 10 005 | Y | 8 Sales Projection February Company | Product | Quantity 001 | X | 10 002 | Y | 7 004 | X | 10 006 | Y | 8. Use a minus node. Use an intersect node. Use a union node. Use an aggregation node.

Which are types of calculation views? Note: There are 3 correct answers to this question. SEMANTIC. CUBE. CUBE WITH STAR JOIN. COMPOSITE. DIMENSION.

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 ensure specific columns are NOT exposed to the reporting tool. To remove a column that is also used as a Label 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 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.

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

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

Why would you choose to implement a referential join?. To automate the setting of cardinality rules. To define conditions for potential data source pruning. To reuse the settings of an existing join. To develop a series of linked joins.

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud. Why should you switch calculated column expression language from column engine to SQL?. To benefit from additional SQL optimizations. Incorrect aggregations may be generated. Column engine language is not supported. To define limits for query unfolding.

Using the table in the diagram, you need to create a CUBE calculation view. What is the simplest approach to create the output shown in the screenshot? Table A Country | Value France | 100 France | 200 Germany | 100 Germany | 100 Germany | 200 Germany | 100 UK | 200 Output A France | Germany | UK 300 | 500 | 200. Create a filter expression that users an OR operator. Create a restricted column for each country. Create 3 calculated columns. Implement a union node and map each country as a separate column.

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

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

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 could be the reason for this?. The names of the parameters do not match. You have chosen the mapping type VARIABLES instead of INPUT PARAMETERS. You already mapped the input parameters in another calculation view. Your source calculation views is of the type DIMENSION.

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

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 calculation view of type CUBE with star join. The hierarchy must be a shared hierarchy. The hierarchy must be a parent-child hierarchy. The hierarchy must be a local hierarchy.

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

What is the SQL keyword used to process input parameters defined in a calculation view?. PLACEHOLDER. WHERE. HINT. SET.

What is a restricted measure?. 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. A measure that cannot be referenced by a calculated column.

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

Why would 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 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.

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

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

Why would you write your SQL code in a procedure instead of a function? Note: There are 3 correct answers to this question. To generate multiple tabular output data sets. To process input parameters. To modify the content of a table. To develop a dynamic analytic privilege. To implement SQLScript syntax.

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. Define constant values. Reference the output of a procedure. Map columns from lower nodes. Assign a hierarchy node. Create and map an input parameter.

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. Your function includes a TRUNCATE statement. You did not define at least one input parameter.

Why would an SQL developer work with SQLScript? Note: There are 3 correct answers to this question. To implement conditional logic. To include ABAP syntax in the code. To pass parameters from calculation views. To exploit additional data types. To automate the generation of the code.

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

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

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

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

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

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. Limit the number of joined columns. Specify the join cardinality. Use an inner 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. Filters. Joins. Calculated columns.

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. Model star schemas using a sequence of join nodes. Avoid defining joins on calculated columns.

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 overcome the 2 billion record limit. To improve data replication performance on large row tables. To improve response time when multiple users access the same table.

What is the objective of calculation view instantiation?. Generate an optimized run-time model based on a calling query. Identify potential performance issues. Deploy a calculation view to a production system. Trace of the run-time of a calculation view.

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 identify data sources that are not accessed by a query. To check which database engines are invoked.

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.

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

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. <Table A> Order Id Date Customer Quantity <Table B> Customer City Country. The Country column is requested. Join cardinality is set :1. Integrity constraint is set to RIGHT. The Keep flag is activated for the Customer column.

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

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 which calculation view node do you implement column-based pruning?. Projection. Union. Aggregation. Join.

Why would you use the SQL analyzer? Note: There are 2 correct answers to this question. To preview data at the node level of a calculation view. To display the execution time of a calculation view. To warn of potential performance issues related to calculated columns. To identify the root data sources of a function.

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

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 deploy the calculation view, the deployment fails with a namespace-related issue. What could be the reason? Note: There are 2 correct answers to this question. An .hdinamespace file is defined in the SRC folder that specifies a different namespace properly that 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 imported calculation view and its data source have different namespaces. The .hdinamespace specifies “sub-folder”:”append”, so calculation views can only be created in subfolders.

In Business Application Studio, 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 deploy operations: • Deploy the DIMENSION calculation view as a single object. • Deploy the entire SAP HANA database module. What is the outcome of the deploy operations?. The first deployment is successful. The second deployment fails. The first deployment fails. The second deployment is successful. The first deployment is successful. The second deployment is successful. The first deployment fails. The second deployment fails.

In a database module, 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.

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

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?. .hdiconfig. .namespace. .yaml. .mtar.

At which levels of a project structure can you execute a deploy operation? Note: There are 2 correct answers to this question. Individual source file. Sub-folder of a database module. Individual container. Entire workspace.

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

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

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

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

What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question. Additional indexes are used. Higher performance for query operations. Parallel access is improved. Higher data compression rates. Improved write performance on frequent updates.

What are some of the typical tasks performed by the SAP HANA Cloud modeler role? Note: There are 2 correct answers to this question. Develop calculation views. Create graph workspaces. Develop SAP Fiori apps. Configure data tiering.

Why would you choose an HDI-shared service plan instead of a schema service plan? Note: There are 3 correct answers to this question. You want to create database objects using source files. You want to develop calculation views. You want to use synonyms to access external data. You want to use SAP Business Application Studio. You want to use containers to isolate objects.

What is the recommended tool for developing cloud foundry applications?. SAP HANA Cloud Central. SAP Business Application Studio. SAP HANA Web IDE. SAP HANA cockpit.

What are some of the typical roles in an SAP HANA Cloud implementation? Note: There are 2 correct answers to this question. Data architect. ABAP developer. Kubernetes expert. Modeler.

When is the first column store compression executed?. When partitions are regenerated. When a delta merge is triggered. When a backup is started. When the table is created.

Which components are part of SAP HANA Cloud? Note: There are 2 correct answers to this question. SAP Analytics Cloud. Data lake. SAP HANA database. SAP Data Warehouse Cloud.

A new version of SAP HANA Cloud, SAP HANA database is available from today. If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?. 3 months. 2 weeks. 1 year. 7 months.

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? Note: There are 2 correct answers to this question. Table partitions. Stored procedures. Indexes. Pre-calculated aggregates.

In SAP HANA Cloud, which tasks are handled by the cloud provider? Note: There are 3 correct answers to this question. Backing up the operating system and the database software. Tuning the database to run optimally on the underlying operating system, and hardware. Managing users, roles, and permissions in the database. Installing, configuring, and upgrading the operating system. Sizing, provisioning, and monitoring the database.

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

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view? DIMENSION Calculation View with Attribute Country [Secured with Analytic Privileges] -> CUBE Calculation View with Attribute Country [Not secured with Analytic Privileges] -> USER. A SELECT privilege on the CUBE calculation view 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. 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.

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

You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn’t working as expected. What could be the reason? Note: There are 2 correct answers to this question. You defined more than one output parameter. The procedure is write-enabled. The output parameter is defined as NVARCHAR. No input parameter is specified.

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? Country | Product | Sales US | P1 | 100 US | P2 | 50 GE | P1 | 80 GE | P2 | 60 <Calc View B> [Analytic Privilege 1: Country = US] [Analytic Privilege 2: Country = US or GE, Product = P2] <Calc View A> [Analytic Privilege 3: Product = P1]. US for P1 and P2, and GE for P1 and P2. US for P1 and GE for P1. US for P1 and P2, and GE for P2. US for P1.

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

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?. The UNMASKED privilege has NOT been granted at the schema level. You did not define masking in calculation view A. You previewed the data with the technical user in SAP Business Application Studio. The type of the Account_Number column is VARCHAR.