Oracle Oracle Certifications 1Z0-532 Questions & Answers

• Question 31:

  Identify the three true statements. The EPMA import files for metadata_______. (Choose three.)

  A. Contains sections for Dimensions, Dimension Associations, Hierarchies, and Members

  B. Requires the Dimensions, Dimension Associations, Hierarchies, and Members section to create a dimension

  C. Expects the Hierarchies section to be in Parent/Child format

  D. Requires that all members must be declared in the Members section before they can be added to the HIERARCHIES section

  E. Has it that the header, file_format = ads version =1.0, is optional for the import file

  Correct Answer: ACE

• Question 32:

  Given the following syntax in a business rule:

  

  Identify the subroutine.

  A. Calculate ()

  B. strview

  C. Hs.Exp

  D. DIFFERENCE

  E. Hs.SCENARIO.DEFAULTVIEW( " ")

  Correct Answer: D

  Reference: https://docs.oracle.com/cd/E57185_01/HFMAD/ch12s01s03s04.html

• Question 33:

  Identify the three true statements about Dimension Associations in EPMA. (Choose three.)

  A. Dimension associations are used when a property in one dimension is associated with the members in another dimension.

  B. The Security Class dimension is associated with the Security Class property only in an Account and Entity.

  C. The Alias dimension is associated with the Alias property for Account, Entity, and Scenario dimensions.

  D. The Currency dimension is associated with the Currency property of the Account dimension.

  E. A Plug Account from the Account dimension can be associated with the Account dimension.

  Correct Answer: ACD

• Question 34:

  Identify the two true statements about rule types in FM. (Choose two.)

  A. The Dynamic rule type allows you to calculate both parent and base accounts.

  B. The NoInput rule type prevents users from entering data into specific cells or slices of cells using Hs.Nolnput.

  C. Calculate, Dynamic, Allocation, Input, No Input, Translate, Consolidate, Transactions, and Equity pickup are all valid rule types.

  D. If you need to calculate Gross Margin %, use the Translate rule type.

  E. Calculation rules are run only with FM specific calculation commands in Financial Management; no general VB commands.

  Correct Answer: BC

• Question 35:

  Identify two true statements about the native data load file format. (Choose two.)

  A. The default column order for the native data file is Scenario, Year, Period, View, Entity, Value, Account, ICP, Custom1, Custom2, Custom3, and Custom4.

  B. You cannot change the column order for the data file.

  C. The Group section defines the POV for the data file; you can define only a single member for each POV dimension.

  D. The Line Items detail section contains data values.

  E. The Group section is required.

  Correct Answer: AD

• Question 36:

  Identify the correct sequence for building a Classic FM application:

  1-Create the application shell.

  2-Create an application profile.

  3-Define metadata such as dimensions and application settings.

  4-Load data, data forms, member lists, rules, and journals.

  5-Define security.

  A. 1, 2, 3, 4, 5

  B. 2, 1, 4, 3, 5

  C. 2, 1, 5, 3, 4

  D. 1, 2, 5, 3, 4

  E. 1, 2, 3, 5, 4

  Correct Answer: C

• Question 37:

  In which four ways can a user access FR reports? (Choose four.)

  A. In the Workspace in HTML mode

  B. In the Workspace in PDF mode

  C. Over the Web outside of the Workspace in HTML mode

  D. In Smart View using the BI+ Connection

  E. In PDF format from an email

  Correct Answer: ABDE

• Question 38:

  Before you can define an alias for a dimension or member in EPMA, you must _______.

  A. Do nothing; the Alias property is created by default

  B. Create an Alias dimension and associate it

  C. Create an Alias attribute

  D. Create an Alias Property

  E. Create an Alias Table

  Correct Answer: B

• Question 39:

  A Classic FM application profile contains which three components? (Choose three.)

  A. Frequency

  B. Calendar

  C. Dimension Associations

  D. Language(s)

  E. Scenario

  Correct Answer: ABD

• Question 40:

  Identify the three true statements about Financial Reporting. (Choose three.)

  A. Financial Reporting provides highly formatted, printable reports for FM applications.

  B. Financial Reporting provides ad hoc reporting capabilities for FM applications.

  C. Financial Reporting document types include reports, books, snapshots, and snapshot books.

  D. You can create a single PandL report and run that report for any member in the Entity dimension

  Correct Answer: ACD