Online Access Free C_HAMOD_2404 Practice Test

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.Execute the refactor function for the calculation view.
• B.Build the folder that contained the deleted design-time file.
• C.Build the project that contained the deleted design-time file.
• D.Execute a DROP statement in an SQL console connected to the HDI container.

What are the characteristics of a SHARED replica table? Note: There are 3 correct answers to this question.

• A.You do not need to create the physical replica table manually
• B.You can toggle queries routing between remote table data and replica table data
• C.You can choose your own replica table name
• D.The consuming application always references the virtual table
• E.The replica table always stores real-time data

How can you define a variable that presents its value help hierarchically? Note: There are 2 correct answers to this question.

• A.Create a level hierarchy and assign it to the variable.
  *Ensure the variable's reference column is the leaf level of the hierarchy.
• B.Create a parent-child hierarchy and assign it to the variable.
  *Ensure the variable's reference column is the parent attribute of the hierarchy.
• C.Create a parent-child hierarchy and assign it to the variable.
  *Ensure the variable's reference column is the child attribute of the hierarchy.
• D.Create a level hierarchy and assign it to the variable.
  *Ensure the variable's reference column is the top level of the hierarchy.

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.Union
• B.Aggregation
• C.Projection
• D.Join

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 a parent-child hierarchy.
• B.The hierarchy must be a shared hierarchy.
• C.The hierarchy must be defined as a local hierarchy.
• D.The hierarchy must be exposed by a CUBE calculation view with star join.