Question 1

A new Sheet tab in Excel is copied from an existing tab that contains a Smart View query, but clickingRefresh does not refresh the data and the Smart View (Point of View) POV bar does not display.Which additional step is required to pull data in the new tab and change the POV?

Options :

A : Disconnect from the Smart View connection, and relog in.

B : Activate the Connection.

C : Close out of Excel, and relog in to Smart View.

D : Change one of the Row or Column dimension members and click Refresh.

Answer: B

Question 2

Where in Data Integration do you specify the default member for the Multi-GAAP dimension?

Options :

A : Workbench

B : Options tab of the Application Details dialog box

C : Execute Integration dialog box

D : Location Attributes section of the Create Integration dialog box

Answer: B

Question 3

Which three scenarios result in foreign currency translation during the default consolidation process? (Choosethree.)

Options :

A : A base entity currency has a parent entity with a matching default currency.

B : A base entity currency has a parent entity with a different default currency.

C : A parent entity has the same default currency as its parent.

D : A parent entity has a different currency from its parent.

E : A shared entity has a parent with a different currency.

Answer: B,D,E

Question 4

For business processes that use the Make Period and Movement Dense feature, which statement is FALSE?

Options :

A : Account is a Sparse dimension.

B : The View dimension stores only periodic data.

C : All parent members in the Account dimension must have a Solve Order value of 58.

D : You cannot add member formulas to members of the Movement dimension.

Answer: C

Question 5

Three child entities – P, Q, and R – of a mid-level parent entity – AceCo – have account receivables in theamounts of 10, 20, and 30, respectively.Which statement contains conditions for all three entities that would cause the account receivable balanceamount at AceCo not to be 60?

Options :

A : P has the same currency as AceCo, Q is 100% owned, and R has 10 of the 30 as an intercompanyreceivable balance with another division that is not a descendant of AceCo.

B : P has the same currency as AceCo, Q is 90% owned, and R has 10 of the 30 as an intercompanyreceivable balance with another division that is not a descendant of AceCo.

C : P has a different currency than AceCo, Q is 40% owned, and R has 10 of the 30 as an intercompanyreceivable balance with Q.

D : P has a different currency than AceCo, Q is 100% owned, and R has 10 of the 30 as an intercompanyreceivable balance with Q.

Answer: C