In a calculated column, which object do you use to process a dynamic value in an expression?
A. Procedure
B. Table function
C. Input Parameter
D. Variable
正解:D
質問 2:
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. .mtar
B. .hdiconfig
C. .namespace
D. .yaml
正解:D
質問 3:
Why would you choose to implement a referential join?
A. To develop a series of linked joins
B. To define conditions for potential data source pruning
C. To automate the setting of cardinality rules
D. To reuse the settings of an existing join
正解:C
質問 4:
Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?
A. Join
B. Aggregation
C. Projection
D. Union
正解:D
質問 5:
Referring to the diagram,
which privileges would a user require to view United States data when querying the CUBE calculation view?
A. SELECT privileges and Analytic Privileges (Country = United States) on both views
B. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
C. A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
D. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
正解:B
質問 6:
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
質問 7:
Why might you use the Keep Flag property in an aggregation node?
A. To exclude columns that are NOT requested by a query to avoid incorrect results
B. To include columns that are NOT requested by a query but are essential for the correct result
C. To retain the correct aggregation behavior in stacked views
D. To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
正解:B
質問 8:
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. Map columns from lower nodes.
B. Reference the output of a procedure.
C. Assign a hierarchy node.
D. Define constant values.
E. Create and map an input parameter
正解:A,D,E
質問 9:
What is the SQL keyword used to process input parameters defined in a calculation view?
A. PLACEHOLDER
B. WHERE
C. SET
D. HINT
正解:A