What do you use a hierarchy function for? Note:There are 3 correct answers.

• A.Calculate distance between root and each hierarchy node
• B.Count the number of siblings for each hierarchy node
• C.Describe the relationship between nodes using attributes
• D.Identify hierarchy nodes that have no parent
• E.Determine the shortest path between each pair of nodes

Comment: *

Name: *

Email: *

Verification: *

Your calculation view consumes one data source which includes the following columns :
SALES_ORDER_ID, PRODUCT_ID, QUANTITY & 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.Join
• C.Aggregation
• D.Projection

Comment: *

Name: *

Email: *

Verification: *

When would you develop an SQL procedure instead of a function?

• A.You want to create a dynamic analytic privilege.
• B.You need to implement Data Definition Language (DDL) statements.
• C.The code should modify data in the table.
• D.Optimal performance is apriority.
• E.You need to use conditional logic.

Comment: *

Name: *

Email: *

Verification: *

You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?
There are 2 correct answers to this question.
Response:

• A.To provide partial values such as #3434 3#34##
• B.To restrict data access for specific users or roles
• C.To hide individual patients in groups of similar records
• D.To add noise to the data to hide the actual values

Comment: *

Name: *

Email: *

Verification: *

You have a calculation view which includes nodes as shown in the graphic. You decide to select the "Ignore Multiple Output for Filters" checkbox on Projection Node 3. What might the effects of this be?
Note: There are 2 correct answers to this question

• A.The view will return the profit calculation for only the US
• B.Increased performance
• C.Decreased performance
• D.A change to the data that is returned by the view

Comment: *

Name: *

Email: *

Verification: *