Why would you enable Debug Query mode in a calculation view?
- A . To understand how tables are partitioned
- B . To set breakpoints and step through the execution
- C . To check which database engines are invoked
- D . To identify data sources that are not accessed by a query
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?
- A . You did not define any columns in the cache setting.
- B . The cache data retention period has expired.
- C . The query requests only a subset of the cached results.
- D . You did not define a filter in the cache setting.
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?
- A . "?"
- B . "Null"
- C . "0"
- D . <empty string>
Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question.
- A . Procedure
- B . Row table
- C . Scalar function
- D . Table function
Why should you define calculated column expressions using plain SQL and avoid using column engine language?
- A . To prevent queries from unfolding
- B . To access the full set of SQL functions
- C . To allow imperative statements
- D . To benefit from additional SQL optimizations
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 . Procedure
- B . Scalar function
- C . Anonymous block
- D . Table function
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 . Include an aggregation node above the union node.
- D . Add an intersect node above the union node.
Which options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.
- A . Assign them to a level below the root.
- B . Define an expression to determine a parent.
- C . Assign them to a node at the root level.
- D . Generate additional root nodes.
Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.
- A . To convert the data types of input parameters
- B . To assign variables to one or more attributes
- C . To push down filters to the lowest level calculation views
- D . To pass variable values to external value help views
Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?
- A . They could modify the database.
- B . They call multiple processing engines.
- C . They introduce potential security risks.
- D . They can limit parallelization of query execution.
C
1 1. Why would you implement active / active read-enabled mode?
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?
- A . You previewed the data with the technical user in SAP Web IDE for SAP HANA.
- B . You did not define masking in calculation view A.
- C . The UNMASKED privilege for calculation view A has been granted.
- D . Analytic privilege _SYS_BI_CP_ALL has been assigned.
What are the consequences of NOT executing a delta merge? Note: There are 2 correct answers to this question.
- A . Aggregates are not adjusted.
- B . New records are not read.
- C . Read performance decreases.
- D . Memory is not optimized.
What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.
- A . It must appear in the last DIMENSION in the star join node.
- B . It CANNOT be mixed in the same star join node with other join types.
- C . Only one column can be included in the join condition.
- D . It is restricted to one DIMENSION in a star join node.
What is a restricted measure?
- A . A measure that cannot be referenced by a calculated column.
- B . A measure that can only be displayed by those with necessary privileges.
- C . A measure that is filtered by one or more attribute values.
- D . A measure that can be consumed by a CUBE and not a DIMENSION.
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?
- A . The build fails and the table is dropped.
- B . The build fails and the table is not dropped.
- C . The build is successful and the data preview returns expected data.
- D . The build is successful but the data preview returns an error message.
In a calculation view, what is the purpose of a variable?
- A . To provide a dynamic value in a calculated column
- B . To break up complex SQL into smaller steps
- C . To filter an attribute at run-time based on a user input
- D . To pass values between procedures and calculation views
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 P2, and GE for P2
- B . US for P1 and GE for P1
- C . US for P1
- D . US for P1 and P2, and GE for P1 and P2
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?
- A . You selected the wrong parameter mapping TYPE.
- B . Your source calculation view is of type DIMENSION.
- C . The names of the input parameters do not match.
- D . You already mapped the input parameters in another calculation view.
Why would you set the "Ignore multiple outputs for filters" property in a calculation view?
- A . To ensure semantic correctness
- B . To force filters to apply at the lowest node
- C . To hide columns that are not required
- D . To avoid duplicate rows in the output
B
2 1. What is generated when you deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question.
Why would you create a multistore table?
- A . To implement a table that combines the features of row and column store
- B . To enable partitioning of the table across different storage tiers
- C . To improve read performance when the table is accessed by simultaneous applications
- D . To evenly distribute the data across all available server nodes
Why would you build a calculation view of type SQL Access only?
- A . To enable SQL access to your hierarchies
- B . To provide a data source that can only be consumed by a function or procedure
- C . To provide a high performance model when only attributes are required
- D . To provide a data source that is only consumed by other calculation views
In an XS Advanced project, what is the purpose of the .hdiconfig file?
- A . To specify an external schema in which calculation views will get their data
- B . To specify which HDI plug-ins are available
- C . To specify the namespace rules applicable to the name of database objects
- D . To specify in which space the container should be deployed
Which of the following supports data replication?
- A . SAP HANA smart data access
- B . SAP HANA, streaming analytics option
- C . SAP HANA smart data quality
- D . SAP HANA smart data integration
When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?
- A . Virtual Table
- B . Synonym
- C . Association
- D . Alias
Which are the components of SAP HANA Cloud? Note: There are 3 correct answers to this question.
- A . SAP Data Warehouse Cloud
- B . SAP HANA Cloud data lake
- C . Native Storage Extension
- D . SAP Analytics Cloud
- E . SAP HANA in-memory database
Which calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question.
- A . Julian
- B . Gregorian
- C . Factory
- D . Fiscal
You want to join two tables in a calculation view.
Why do you use a non-equi join?
- A . Join columns need to be ignored when NOT requested by the query.
- B . Join columns have different data types.
- C . The number of joined columns is different in each table.
- D . The join condition is not represented by matching values.
Why might you use the Keep Flag property in an aggregation node?
- A . To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
- B . To retain the correct aggregation behavior in stacked views
- C . To include columns that are NOT requested by a query but are essential for the correct result
- D . To exclude columns that are NOT requested by a query to avoid incorrect results