A calculation view consumes the data sources shown in the graphic. You want to identify which companies SQLd products in January 2018 AND February 2018. What is the optimal way to do this?
A. Use a full outer join.
B. Use a union node.
C. Use an left outer join.
D. Use an intersect node
Your Web IDE for SAP HANA was updated to a new version. You want to implement the new features of calculation view modeling in your existing calculation views. You open a graphical calculation view but the new features are not displayed.
What could be the reason for this?
A. You need to update the project settings to reference the new revision.
B. Your calculation views have not been built in the new version of the Web IDE.
C. The calculation views have not been migrated to the new revision.
D. The .hdiconfig file has not been updated to the latest calculation view build plug-in.
Why do you create a multi store table?
A. To improve read performance when accessed by simultaneous applications
B. To have the opt on to partition the table across different storage tiers
C. To evenly distribute the data across all available server nodes
D. To have a table that combines the characteristics of row and column stores
You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?
A. Define a union node as the start of the parallelization block.
B. Define a projection node as the end of the parallelization block.
C. Assign tables as the only data sources in the nodes that start the parallelization block.
D. Define a source column as partitioning value in the start node of the parallelization block.
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. Limit the number of stacked calculation views
B. Avoid aggregating data early in the dataflow
C. Implement union pruning
D. Partition large tables
Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation view?
A. Analytic Privileges and SELECT privileges on the CUBE Calculation view
B. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view
C. A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view
D. SELECT or Privileges and Analytic Privileges on both views
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 function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?
A. Show lineage
B. Database Explorer
C. Where used
D. Auto-map byname
Which of the following results are generated when you query this temporal hierarchy using a time-validity period interval of March to May?
A. D
B. C
C. A
D. B
Which of the following allows data replication?
A. SAP HANA smart data access
B. SAP HANA streaming analytics
C. SAP HANA smart data integration
D. SAP HANA smart data quality
Why do you build a calculation view of type SQL Access only?
A. To enable SQL access to your hierarchies
B. To provide a high-performance model when only attributes are required
C. To provide a data source that can only be consumed by a function or procedure
D. To provide a data source that is only consumed by other calculation views