Oracle Oracle Certifications 1Z0-508 Questions & Answers

• Question 21:

  Identify the SmartView Ribbon command that is used to display levels in the Member hierarchy.

  A. Drill Through

  B. Cascade

  C. Zoom in and Zoom out

  D. Query

  Correct Answer: C

  When you zoom in on a member, it is expanded according to the options specified in the Options dialog box. If you select the option to zoom in on all levels, the grid displays all descendants of the selected member.

  The default zoom option is to zoom in to the next level to retrieve data for the children of the selected member or members. For example, if you double-click the [Year] member, the system displays Quarter1, Quarter2, Quarter3, and Quarter4.

  You can zoom in on the bottom level to retrieve data for the lowest level of members in a dimension. You can select retrieving data for the sibling level, the same level, or the same generation as the selected member.

  Reference: Oracle Hyperion Smart View for Office, User's Guide, Zooming In on Dimension Members

• Question 22:

  In Member Selection, which three operators and symbols enable you to display members based specified criteria?

  A. Left parenthesis

  B. Right parenthesis

  C. AND operator

  D. Union operator

  E. Double parentheses

  Correct Answer: CDE

  Boolean operators enable you to specify member combinations in your report. You use the AND, OR, UNION, and NOT Boolean operators, combined with member expressions, to refine your member selections. Example:(Children of East OR Children of West) AND Members where UDA=Major Market Reference: Selecting Members with Advanced Expressions

• Question 23:

  Select the appropriate financial Reporting Center functionality that helps users to view, input, manipulate, distribute and share data from the General Ledger balances to Microsoft Excel.

  A. Account Monitor and Account Inspector

  B. Smart View

  C. Financial Reporting Workspace

  D. Financial Reporting Studio

  Correct Answer: B

  Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.

• Question 24:

  Oracle Business Intelligence Enterprise Edition is available through the iPhone and iPad devices. Which BI object content is NOT visible through a mobile device?

  A. Analysis, including analytic actions

  B. Dashboard Page, including analytic actions

  C. Action

  D. Scorecard, including analytic actions

  E. Briefing Book, limited to alert visible in the Alerts list

  Correct Answer: E

  Oracle Business Intelligence Mobile, part of Oracle Business Intelligence

  Foundation Suite, provides the ability to deliver analyses, dashboards, alerts, and other BI content directly to mobile devices, enabling users to view and then take action on BI insights wherever they are.

  Intelligence Mobile gives you the full spectrum of BI functionality on hoc query, OLAP analysis, dashboards and scorecards. You even have the ability to turn insight into action directly from your mobile reports and dashboards.

  Reference: Oracle Business Intelligence Mobile, Data Sheet

• Question 25:

  Identify two valid points to be considered when configuring the workspace database connection.

  A. Ledgersetup has to be completed after the database connection is created.

  B. Cubes are created as part of ledger setup.

  C. Multiple cubes can be defined for each combination of the chart of accounts and the accounting calendar.

  D. A database connection is needed for each cube.

  E. An ODBC connection is always required.

  Correct Answer: BD

  B: Cubes are created as part of ledger setup.

  D:A database connection is needed for each cube.

  Reference: Oracle Fusion Applications Post-Installation Guide, Configuring Workspace Database Connection

• Question 26:

  Which statement about intercompany balancing is INCORRECT?

  A. Intercompany balancing is used to balance transactions by an additional dimension beyond the primary segment.

  B. Intercompany balancingisused to track intercompany duo to/due from balances by identifying the specific trading company.

  C. The intercompany qualified segment can NOT be set with any of the three balancing segment qualifiers.

  D. Segment values can be assigned more than once within your chart of account.

  E. Segment values can be assigned only once within your chart of account.

  Correct Answer: D

• Question 27:

  What is the best view or tool to use it you need to quickly perform an ad hoc ledger query that drill down to in a web view?

  A. Account Monitoring

  B. Oracle Hyperion Smart View

  C. Oracle Hyperion Financial Reporting Studio

  D. Account Inspector

  Correct Answer: D

  Account Inspector allows financial analysts and accountants to quickly perform ad hoc ledger queries, multi-dimensional analysis, pivoting, and drill down--all within a web page. Because it works off the same multi-dimensional balances that stores pre-aggregated balances at all levels, slicing and dicing data is extremely fast. Any changes you make to your query criteria are instantaneously refreshed to ensure you are working with the most up-to-date information to make the most informed decisions.

• Question 28:

  Which three ledgers can be viewed from the Close Status work region of the General Accounting Dashboard?

  A. Single Ledger

  B. Ledger Set

  C. Related ledgers

  D. Currency Ledgers

  E. Debit ledgers

  F. Level ledger update

  Correct Answer: ABD

  B: Actions that can be performed across a Ledger Set

  Open/Close Periods

  Create Journals

  Translate Balances

  Reporting

  View Information

  Note:

  *Using the Close Status region of the General Accounting Manager dashboard within Fusion General Ledger, you can immediately identify which subledgers have not closed yet.

  *

  Close Status region in the General Accounting Dashboard. The Close Status region provides real time visibility into the period close process from your subledgers to your General Ledger across the entire enterprise.

  *

  General Accounting Dashboard: / Have a comprehensive view of journals requiring attention, intercompany transactions that are incomplete, account balances that have exceeded their thresholds, and the close status of subledgers and ledgers from a central place / Increase user productivity by reducing multiple searches and the number of pages he needs to access by pushing information across areas in one place

• Question 29:

  Transaction objects in Fusion Accounting Hub are associated to .

  A. Event Types

  B. Event Entities

  C. Journal Line Types

  D. Event Classes

  Correct Answer: D

  For each event class, register the transaction objects that will hold source data for the event types in that class.

  Note: Transaction objects are the views and tables that store transaction data in the standardized form required by the Create Accounting program.

  Reference: Oracle Fusion Accounting Hub Implementation Guide, Register the Source System and Define Events Information

• Question 30:

  The tables, of views, from which Create Accounting takes source data to use in rules and create entries are referred to as .

  A. Transaction Objects

  B. Event Entities

  C. Mapping Sets

  D. Accounting attributes

  E. Event Classes

  Correct Answer: B

  The Create Accounting program processes eligible accounting events to create subledger journal entries. To create the subledger journal entries, the Create Accounting program applies application accounting definitions that are created in the Accounting Methods Builder (AMB).

  The Create Accounting program:

  *

  Validates and creates subledger journal entries *Transfers the final journal entries in the current batch run to General Ledger and starts the General Ledger posting process *Generates the Subledger Accounting Program Report, which documents the results of the Create Accounting program

  Note: Create Accounting Program parameters include:

  *

  Ledger: limits accounting events selected for processing to those of a particular ledger

  *

  Process Category: restricts the events selected for accounting to a particular process category

  Reference: Oracle Subledger Accounting Implementation Guide