Oracle Oracle Certifications 1Z0-1082-20 Questions & Answers

• Question 41:

  Which two are valid statements about the Balance and Rule dimensions?

  A. Rule names are assigned as aliases to the rule number members In the Rule dimension.

  B. Data is loaded to the member Input in the Balance dimension.

  C. Data Is loaded to the member Input In the Rule dimension.

  D. The Balance dimension is considered a POV dimension.

  E. Data for the members Allocation In and Allocation. Out are populated by Profitability and Cost Management rules.

  Correct Answer: BC

• Question 42:

  Which custom calculation formula Is syntactically correct?

  A. [Adjustment In]= ([Input], [Rule]) * .15;

  B. [Adjustment In]= ([Input], (Rule]) * .15

  C. [Adjustment In]:= ([Input], [Rule]) * .15;

  D. [Adjustment In]:= [Input],[Rule] *.15

  E. (Adjustment In)= (Input, Rule) - .15;

  Correct Answer: A

• Question 43:

  Which three are valid functions of logic accounts In Data Management?

  A. Logic accounts allow the mapping of a source account based on its value (conditional mapping).

  B. Logic accounts can perform arithmetic operations on source values (arithmetic mapping).

  C. Logic accounts determine how the source fields are stored In the Data Management staging tables (storing mapping).

  D. Simple logic groups enable you to derive logic items front any combination of dimensions (derived mapping).

  E. Logic accounts allow the mapping of one source account to multiple target accounts (statistical mapping).

  Correct Answer: BCE

• Question 44:

  Which two are valid statements about Profitability and Cost Management application requirements?

  A. Changes to Profitability and Cost Management dimensions must be deployed to the underlying Essbase database before running allocations.

  B. You must have access to a separate instance of Oracle Analytics Cloud (Essbase) to use as the underlying data storage for Profitability and Cost Management.

  C. You can configure the underlying Essbase database as either a Block Storage (BSO) type or Aggregate Storage (ASO) type.

  D. Applications must have a Point of View with Year, Period, and Scenario dimensions.

  E. An EPM Cloud service instance can support only one Profitability and Cost Management application at a time.

  Correct Answer: BD

• Question 45:

  Which three are steps to create an allocation rule?

  A. populate the driver basis dimensions

  B. select the execution method

  C. populate the allocation formula

  D. populate the destination dimensions

  E. populate the source dimensions

  Correct Answer: BDE

• Question 46:

  Which two statements are true about allocation offset for allocation rules?

  A. Offsets are written to the Allocation Offset member of the Balance dimension, in combination with the other dimension members defined for the offset.

  B. Defining an allocation offset Is optional.

  C. The offset location defines the member to hold any unallocated data from the source.

  D. By default, offsets are written to the source.

  Correct Answer: BC

• Question 47:

  Assume that the proper data permissions have been assigned In Profitability and Cost Management. Which two actions can you perform In Smart View?

  A. Display Analysis Views and Profit Curves that you created in Profitability and Cost Management in an Excel spreadsheet.

  B. Create reusable Smart Queries to use for ad hoc reporting and analysis In Excel.

  C. Update driver data in Excel and submit the changes back to Profitability and Cost Management.

  D. Update dimension members and properties In Excel and submit the changes back to Profitability and Cost Management.

  Correct Answer: BD

• Question 48:

  Which statement Is FALSE about Dimension Management In Profitability and Cost Management?

  A. You can manually edit Business, Attribute, and Point of View dimensions.

  B. System dimensions ore not displayed In Dimension Management.

  C. Profitability and Cost Management uses dimensions and members created In Oracle Essbase.

  D. Dimensions are imported using flat files or the Data Management feature.

  Correct Answer: C

• Question 49:

  Which types of dimensions do you use to define model views?

  A. Business dimensions only

  B. Business dimensions, POV dimensions

  C. Business dimensions, POV dimensions. System dimensions

  D. POV dimensions. System dimensions

  Correct Answer: C

• Question 50:

  Which statement Is FALSE about data grants?

  A. They can be assigned to groups or individual users.

  B. They can be assigned to Service Administrators or Power Users.

  C. They are used to control what dimensions and members can be accessed by the assigned users.

  D. They generate security filters in Essbase when the database is deployed.

  Correct Answer: C