In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.
- A . To ensure it is not exposed to reporting tools for consumption
- B . To indicate that it should not be used as a data source to other calculation views
- C . To warn developers that the calculation view is no longer supported
- D . To lock the calculation view from further modifications
What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.
- A . Model star schemas using a sequence of join nodes.
- B . Aggregate at the lowest possible node.
- C . Include all data flow logic within one calculation view.
- D . Avoid defining joins on calculated columns.
Why would you create calculation views of data category DIMENSION with type TIME?
- A . To provide additional time-related navigation possibilities
- B . To add a temporal condition to a join to find matching records from two tables based on a date
- C . To store historical versions of attributes
- D . To provide the time intervals required by time-dependent parent-child hierarchies
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?
- A . .hdiconfig
- B . .mtar
- C . .yaml
- D . .namespace
What are some of the typical roles in an SAP HANA Cloud implementation? Note: There are 2 correct answers to this question.
- A . Data architect
- B . Modeler
- C . Kubernetes expert
- D . ABAP developer
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 . <empty string>
- B . "?"
- C . "0"
- D . "Null"
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.
At which levels of a project structure can you execute a deploy operation? Note: There are 2 correct answers to this question.
- A . Individual source file
- B . Entire workspace
- C . Sub-folder of a database module
- D . Individual container
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.
- A . Pre-calculated aggregates
- B . Indexes
- C . Stored procedures
- D . Table partitions
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
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
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
Which calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question.
- A . Fiscal
- B . Julian
- C . Gregorian
- D . Factory
Which components are part of SAP HANA Cloud? Note: There are 2 correct answers to this question.
- A . SAP Analytics Cloud
- B . Data lake
- C . SAP HANA database
- D . SAP Enterprise Architecture Designer
What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.
- A . Higher data compression rates
- B . Improved write performance on frequent updates
- C . Additional indexes are used
- D . Parallel access is improved
- E . Higher performance for query operations
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.
Why would you use the Transparent Filter property in a calculation view?
- A . To include columns that are NOT requested by a query
- B . To avoid columns being unnecessarily used in an aggregation
- C . To apply filters that are hidden from the end user
- D . To allow filter push-down in stacked calculation views
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 is restricted to one DIMENSION in a star join node.
- C . It CANNOT be mixed in the same star join node with other join types.
- D . Only one column can be included in the join condition.
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.
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?
- A . Use a union node.
- B . Use an intersect node.
- C . Use an aggregation node.
- D . Use a minus node
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 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 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?
- A . You previewed the data with the technical user in SAP Business Application Studio.
- B . You did not define masking in calculation view A.
- C . The UNMASKED privilege has NOT been granted at the schema level.
- D . The type of the Account_Number column is VARCHAR.
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?
- A . The first deployment is successful. The second deployment fails.
- B . The first deployment is successful. The second deployment is successful.
- C . The first deployment fails. The second deployment fails.
- D . The first deployment fails. The second deployment is successful.
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.
- A . Define constant values.
- B . Assign a hierarchy node.
- C . Reference the output of a procedure.
- D . Map columns from lower nodes.
- E . Create and map an input parameter
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.
- A . To prevent passing columns in stacked calculation views
- B . To ensure specific columns are NOT exposed to the reporting tool
- C . To remove a column that is also used as a Label column
- D . To avoid exposing sensitive columns when defining calculated columns
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
In a database module, 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 in which space the container should be deployed
- D . To specify the namespace rules applicable to the name of database objects
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?
- A . Deploy the folder that contained the deleted design-time file.
- B . Execute a DROP statement in an SQL Console connected to the HDI container.
- C . Deploy the project that contained the deleted design-time file.
- D . Execute the refactor function for the calculation view.
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.
- A . The hierarchy must be exposed by a calculation view of type CUBE with star join.
- B . The hierarchy must be a shared hierarchy.
- C . The hierarchy must be a local hierarchy.
- D . The hierarchy must be a parent-child hierarchy.