What is the SQL keyword used to process input parameters defined in a calculation view?
- A . WHERE
- B . PLACEHOLDER
- C . HINT
- D . SET
What is a restricted measure?
- A . A measure that can be consumed by a CUBE and not a DIMENSION.
- B . A measure that is filtered by one or more attribute values.
- C . A measure that can only be displayed by those with necessary privileges.
- D . A measure that cannot be referenced by a calculated column.
What is generated when you deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question.
- A . Cached results to improve read performance
- B . Metadata to enable consumption by external tools
- C . An SQL execution plan
- D . A column view in a container
You have defined a pruning configuration table in a calculation view.
What are you attempting to prune from the query execution?
- A . Calculated columns
- B . Filters
- C . Joins
- D . Data sources of unions
What are the consequences of NOT executing a delta merge? Note: There are 2 correct answers to this question.
- A . Read performance decreases.
- B . New records are not read.
- C . Memory is not optimized.
- D . Aggregates are not adjusted.
In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.
- A . To generate hierarchies
- B . To define a filter
- C . To convert currencies
- D . To generate a restricted column
- E . To generate a calculated column
You want to join two tables in a calculation view.
Why do you use a non-equi join?
- A . Join columns have different data types.
- B . The number of joined columns is different in each table.
- C . Join columns need to be ignored when NOT requested by the query.
- D . The join condition is not represented by matching values.
Why would you set the "Ignore multiple outputs for filters" property in a calculation view?
- A . To ensure semantic correctness
- B . To hide columns that are not required
- C . To avoid duplicate rows in the output
- D . To force filters to apply at the lowest node
Why would you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.
- A . To pass variable values to external value help views
- B . To assign variables to one or more attributes
- C . To push down filters to the lowest level calculation views
- D . To convert the data types of input parameters
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?
- A . Define a restricted column in a union node.
- B . In the union node, map both source customer name columns to one target column.
- C . Add an intersect node above the union node.
- D . Include an aggregation node above the union node.
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?
- A . US for P1 and GE for P1
- B . US for P1 and P2, and GE for P1 and P2
- C . US for P1
- D . US for P1 and P2, and GE for P2
Referring to the diagram,
which privileges would a user require to view United States data when querying the CUBE calculation view?
- A . A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
- B . A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
- C . A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
- D . SELECT privileges and Analytic Privileges (Country = United States) on both views
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?
- A . Set the HIDE property for columns NOT required.
- B . Write and execute a custom SQL query in the SQL Console.
- C . Select Data Preview for the calculation view.
- D . Select and deselect columns from the output mapping.
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?
- A . 7 months
- B . 3 months
- C . 2 weeks
- D . 1 year
Why would you enable Debug Query mode in a calculation view?
- A . To identify data sources that are not accessed by a query
- B . To check which database engines are invoked
- C . To set breakpoints and step through the execution
- D . To understand how tables are partitioned
Which tool generates and executes the SQL for a specific node of your calculation view?
- A . Debug Query mode
- B . Explain plan
- C . SQL analyzer
- D . Database explorer
Why would you create SQL in calculation views?
- A . To implement custom logic
- B . To provide an alternative to graphical modeling
- C . To fine-tune performance
- D . To enable write capabilities
What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.
- A . Define an expression to determine a parent.
- B . Generate additional root nodes.
- C . Assign them to a level below the root.
- D . Assign them to a node at the root level.
Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.
- A . To warn of potential performance issues related to calculated columns
- B . To display the execution time of a calculation view
- C . To identify the root data sources of a function
- D . To preview data at the node level of a calculation view
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?
- A . Scalar function
- B . Table function
- C . Anonymous block
- D . Procedure
You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?
- A . Staging area -> Working directory -> Local Git repository
- B . Working directory -> Staging area -> Local Git repository
- C . Working directory -> Local Git repository -> Staging area
- D . Local Git repository -> Staging area -> Working directory
Why would you choose an HDI-shared service plan instead of a schema service plan? Note: There are 3 correct answers to this question.
- A . You want to use SAP Business Application Studio.
- B . You want to use containers to isolate objects.
- C . You want to develop calculation views.
- D . You want to create database objects using source files.
- E . You want to use synonyms to access external data.
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.
- A . To ensure that the join execution only uses the join columns requested in the query
- B . To ensure that the aggregation always happens after the join execution
- C . To allow data analysis at different levels of granularity with the same calculation view
- D . To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question.
- A . Avoid aggregating data early in the data flow.
- B . Partition large tables.
- C . Limit the number of stacked calculation views.
- D . Implement union pruning.
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.
- A . Specify the join cardinality
- B . Limit the number of joined columns
- C . Use an inner join
- D . Define join direction in a full outer join