Oracle 1Z0-508 Online Practice Questions and Exam Preparation

Oracle 1Z0-508 Online Questions & Answers

• Question 31:

  Oracle Business Intelligence Enterprise Edition (OBIEE) allows buttons to create, manage, and invoke the task functionality within the application. What framework is used to set them up?

  A. Resource Description Framework (RDF)
  B. Action Framework
  C. Seed Data Framework (SDF)
  D. Security Framework
  E. Application Development Framework (ADF)
  B. Action Framework

  ---

  The Oracle Business Intelligence 11g Action Framework makes it possible to set up navigation paths to critical information that can be displayed on analyses right next to users' data.

  These paths--or "action links"--can bring up related reports or Websites, or they can enable users to complete business processes by performing actions that access separate applications. Action links are displayed as contextual menus and

  can contain either mandatory or optional items,

  depending on conditions you have defined.

• Question 32:

  Which task is NOT allowed when spreading data for time periods in Microsoft Excel?

  A. spreading data in a summary time period that includes members and mixed currency types
  B. spreading the value of a summary time period to its base time periods or to the first parent or first child of the parent time period
  C. spreading values among children and parents proportionally, based on existing distribution
  D. spreading values based on weekly distribution of a quarter, which could be 4-4-5, 5-4-4, or none
  E. temporarily locking the values of certain cells while spreading data over time periods
  A. spreading data in a summary time period that includes members and mixed currency types

  ---

  Working with a data form page in Excel, you can spread, or distribute, values in several ways:

  *

  Spread the value of a summary time period to its base time periods or to the first parent orfirst child of the parent time period

  *

  Spread values among children and parents proportionally, based on existing distribution

  *

  Spread values based on the weekly distribution of a quarter, which could be 4-4-5, 5-4-4, 4-5-4, or None (as set up by the budget administrator)

  *

  Temporarily lock the values of certain cells while spreading data over time periods Reference: Oracle Hyperion Smart View for Office, User's Guide, Spreading Data for Time Periods

• Question 33:

  Which three tasks that can be performed by using Account inspector in the Account Monitor choice list?

  A. Interactively perform ad hoc inquiries on the financial balances.
  B. Export a custom pivot table to Microsoft Excel.
  C. Drill down to the detailed balances within a custom pivot table.
  D. Close selected accounts and periods that appear in the pivot table.
  E. Do not use a pivot table.
  A. Interactively perform ad hoc inquiries on the financial balances.
  B. Export a custom pivot table to Microsoft Excel.
  C. Drill down to the detailed balances within a custom pivot table.

  ---

  Account Monitor is fully integrated with the online multidimensional analysis tool called the Account Inspector. With the Account Inspector, the user can:

  *

  (A) Perform ad hoc multidimensional pivot table analysis

  *

  Review charts based on the Account Monitor data

  *

  (C) Use drill down from the Account Monitor from any parent to the next parent or child level

  *

  Perform drill down from any child level to detail balances, journal lines, and subledger transactions

  Note on B:

  You can choose to review reports in your preferred format such as, HTML, PDF, or Microsoft Excel.

  Note:

  A:Account Inspectoris useful for ad-hoc inquiries against an account.

  C: Account Monitor and Account Inspector: Financial analysts monitor and track key account balances in real time at every level of your dimensions and hierarchies. These tools provide multidimensional account analysis and drill down

  capability.

  Reference: Fusion Applications Help, Financial Reporting Center: Explained

• Question 34:

  In Oracle Fusion, you can define more complex structure and multiple rules between pairs of .

  A. Ledgers only
  B. Legal Entities only
  C. Ledger, Legal Entities, or Primary Segments
  D. Primary Segments only
  B. Legal Entities only

• Question 35:

  What are two reasons for using scorecards?

  A. KPIs are represented hierarchically
  B. an objective and its supporting child objectives
  C. Dimension Pinnings
  D. Assessment Mappings
  E. Gauges
  A. KPIs are represented hierarchically
  B. an objective and its supporting child objectives

  ---

  Use Oracle Scorecard and Strategy Management to:

  *

  Simultaneously define the objectives (that is, goals such as Decreased Operational Costs) and initiatives (that is, processes or tasks such as Form Cost Minimization Team) that form your strategy to which you assign KPIs to measure

  progress and performance.

  *

  Align objectives and initiatives with customized or traditional perspectives (fundamental business competencies and areas such as finance or customer relations). This later enables you to depict the extent to which corporate strategy

  supports these perspectives.

  *Define target numeric ranges to evaluate the values of KPIs within corporate or department-level objectives and initiatives.

  *

  Graphically communicate strategy and strategic dynamics using strategy maps, cause and effect maps, custom views, and strategy trees.

  *

  Discuss the implementation and status of objectives and initiatives by adding, reading, and replying to comments.

  Note: Oracle Scorecard and Strategy Management is a performance management tool that lets you describe and communicate your business strategy. You can drive and assess your corporate strategy and performance from the top of your organization down, or from the bottom up.

  Oracle Scorecard and Strategy Management also enables you to either align your objectives and initiatives with traditional balanced scorecard perspectives, or to create your own to reflect your fundamental business competencies.

  Reference: Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition , What is Oracle Scorecard and Strategy Management?

• Question 36:

  Journal approval in Oracle Fusion Applications uses Oracle Fusion Approvals Management (AMX) to build approvals. Which AMX builder method is most effective when the General Accountant enters the journals for approval?

  A. Human Resources (HK) Supervisory
  B. Job level
  C. Position
  D. Approval Group
  A. Human Resources (HK) Supervisory

  ---

  Human Resources (HK) Supervisory This method uses the HR Supervisory hierarchy levels and specifies the number of levels available for approval. This method is most effective when the General Accountant enters the journals. For example, if an accountant enters a journal, he needs approval from his manager. If his manager enters a journal he needs approval from his manager and so on up the hierarchy for the specified number of levels. Self approval can be set at any levels in the hierarchy.

  Note: Journal approval in Oracle Fusion applications uses Oracle Fusion Approvals Management (AMX) to merge the functionality of Oracle Approvals Management (AME) and PeopleSoft Approvals (AWE).

  Reference: Oracle Fusion Applications Financials Implementation Guide, AMX List Builder Considerations

• Question 37:

  Identify the step that is NOT correct about implementing Fusion Accounting Hub to integrate with an external system.

  A. Analyze external system transactions.
  B. Capture accounting events.
  C. Determine the accounting impact of transactions.
  D. Enable external system to create Journal entries.
  D. Enable external system to create Journal entries.

  ---

  The Oracle Fusion Accounting Hub allows you to use Subledger Accounting to perform accounting transformations on external, non-Oracle system data. Subledger Accounting is also used to flexibly create accounting for Oracle subledgers such as Oracle Payables and Receivables. Subledger Accounting includes:

  *

  Registration of your external systems, indicating what types of transactions or activities require accounting from those systems.

  *

  Create a library of transaction and reference information that will be used for defining accounting treatments.

  *

  Configurable accounting rules to define accounting treatments for transactions.

  *

  Accounting engine that combines transaction and reference information from source systems with accounting rules to create detailed journals stored in an accounting repository.

  *

  Detailed subledger accounting journal entry repository to audit and reconcile accounting balances.

  *

  Reports and user interface inquiries for analyzing accounting transformations.

  *

  Configurable analytical balances based upon source system or reference attributes.

  Note:

  The Oracle Fusion Accounting Hub process can begin by using financial data from any or all of the following:

  *

  Non-Oracle external applications including transaction and reference information from industry, specific applications

  *

  Oracle Fusion subledgers including subledger journals

  *

  Oracle E-Business Suite, Oracle PeopleSoft, and Oracle JD Edwards General Ledgers including account balances

  The Accounting Hub process ends with complete reporting and analysis solutions.

  Note 2:

  The Accounting Hub contains for example the following component:

  *

  Oracle Fusion Subledger Accounting to perform accounting transformations on external system data

  Reference: Oracle Fusion Accounting Hub Implementation Guide, Oracle Fusion Subledger Accounting for External Systems

• Question 38:

  The Profitability Dashboard providers visibility into a company's performance. Which indicator is via the Profitability Dashboard?

  A. Pipeline
  B. Budget
  C. Return on Equity
  D. Recruitment
  E. Suppliers
  C. Return on Equity

  ---

  Profitability Returns

  

  Return on Equity

  

  Return on Assets

  

  Return on Capital

  Margins

  

  Gross Margin Percent

  

  Operating Margin Percent

  

  EBT Margin Percent

  

  Net Income Margin Percent

  Product Profitability

  

  Revenue

  

  Product Gross Profit

  

  Product Operating Profit

  

  Customer Profitability

  

  Revenue

  

  Customer Gross Margin

  Note:

  *Financial Analytics Profitability Dashboard provides management a picture of key profitability indicators

  *

  Profitability Dashboards Identify most profitable customers, products, and channels, and understand profitability drivers across regions, divisions, and profit centers. Profitability Dashboards provide key datapertaining to profitability, including Profit and Loss Statements, Customer and Product profitability, Margin Analysis, ROA, and ROE

  *

  Profitability Dashboard Pages Overview PandL Margins Revenue Products Customers

• Question 39:

  Identify the business intelligence component that enables you to explore and interact with information by visually presenting data in tables, graphs, and pivot tables.

  A. Oracle Business Intelligence- Enterprise Edition
  B. Analysis Editor
  C. BI Composer
  D. Oracle Transaction Business intelligence
  E. Oracle Business Intelligence Applications
  B. Analysis Editor
  C. BI Composer

  ---

  B: The "Analysis editor" lets you explore and interact with information by visually presenting data in tables, graphs, pivot tables, and so on. You can include the views that you create in an analysis for display in dashboards.

  C: BI Composer is a simple-to-use wizard that allows you to quickly and easily create, edit, or view analyses without the complexities of the "Analysis editor".

  Note (see select views below): What Are the Steps for Creating or Editing an Analysis in BI Composer?

  The steps for creating or editing an analysis in BI Composer are as follows:

  Select Columns -- In this step you select the columns that are to be included in the analysis. You can also:

  Select Views -- In this step you select the views that are to be included in the analysis, such as a title, table, pivot table, bar graph, and so on. (Note that not all views available in Oracle BI Enterprise Edition are supported in BI Composer.)

  You can also preview the results.

  Etc.

  Reference: What Are the Steps for Creating or Editing an Analysis in BI Composer?

• Question 40:

  What can be used to restrict the events selected for accounting when users submit the Accounting Process?

  A. Process Category
  B. EventClasses
  C. Event Types
  D. Journal Line Types
  E. Batch Name
  A. Process Category

  ---

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

  The Create Accounting program selects events with event types falling into the event classes assigned to the process category.

  Only process categories established by development teams as part of the seed data are included in the list of values.

  Reference: Oracle Subledger Accounting Implementation Guide, Create Accounting Program