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 a filter in the cache setting.
B. The query requests only a subset of the cached results.
C. The cache data retention period has expired.
D. You did not define any columns in the cache setting.
正解:D
質問 2:
Why would you create shared hierarchies? Note: There are 2 correct answers to this question.
A. To provide reusable hierarchies for drilldown in a CUBE with star schema
B. To access hierarchies created in external schemas
C. To provide reusable hierarchies for drilldown in a CUBE without star schema
D. To enable SQL SELECT statements to access hierarchies
正解:A,D
質問 3:
Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?
A. They call multiple processing engines.
B. They could modify the database.
C. They can limit parallelization of query execution.
D. They introduce potential security risks.
正解:D
質問 4:
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. Table partitions
B. Stored procedures
C. Indexes
D. Pre-calculated aggregates
正解:C,D
質問 5:
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.
正解:D
質問 6:
Why would you create calculation views of data category DIMENSION with type TIME?
A. To provide additional time-related navigation possibilities
B. To store historical versions of attributes
C. To provide the time intervals required by time-dependent parent-child hierarchies
D. To add a temporal condition to a join to find matching records from two tables based on a date
正解:A
質問 7:
In a calculation view, what is the purpose of a variable?
A. To filter an attribute at runtime based on a user input
B. To pass values between procedures and calculation views
C. To break up complex SQL into smaller steps
D. To provide a dynamic value in a calculated column
正解:C
Satou -
習問題を掲載しているので本番でも動じない実力を養うことができます。Pass4Testさんのおかげです