- All Exams Instant Download
Why do you enable the dynamic join option?
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 queryB . To ensure...
What might be the reason for this?
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 . The cache data retention period has expired.B . You did not define any columns in the cache setting.C ....
Why would you choose an HDI-shared service plan instead of a schema service plan? Note: There are 3 correct answers to this question.
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...
In which type of object do you write your code?
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 functionB . Table functionC . Anonymous blockD . ProcedureView AnswerAnswer: B
Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?
Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?A . They can limit parallelization of query execution.B . They introduce potential security risks.C . They could modify the database.D . They call multiple processing engines.View AnswerAnswer: B
What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.
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 ....
Why should you switch calculated column expression language from column engine to SQL?
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?A . To benefit from additional SQL optimizationsB . Incorrect aggregations may be generatedC . Column engine language is not supported.D . To define limits...
Why would you enable Debug Query mode in a calculation view?
Why would you enable Debug Query mode in a calculation view?A . To identify data sources that are not accessed by a queryB . To check which database engines are invokedC . To set breakpoints and step through the executionD . To understand how tables are partitionedView AnswerAnswer: A
What is a restricted measure?
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...
What is generated when you deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question.
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 performanceB . Metadata to enable consumption by external toolsC . An SQL execution planD . A column view in a containerView AnswerAnswer: A...
