Oracle Oracle Certifications 1Z0-960 Questions & Answers

• Question 41:

  You are implementing Financials Cloud and are using spreadsheets to load Legal Entities, Business Units, and Account Hierarchies.

  Which three setup objects can be loaded via a spreadsheet from Functional Setup Manager?

  A. complete Accounting Configuration

  B. Suppliers and Customers

  C. Banks, Bank Accounts, and Branches

  D. chart of account values, accounting calendar, and ledger

  E. setup data for Receivables and Payables product.

  Correct Answer: BCD

• Question 42:

  Which two methods can your General Ledger accountants use to more easily view large amounts of contained in the tables in their work areas?

  A. Detach the table to resize it to the maximum size of the monitor

  B. Export the table to Excel.

  C. Run a Business Intelligence Publisher report with Excel as the output format.

  D. Use the Freeze feature on the tables to scroll through large amounts of data.

  Correct Answer: AB

• Question 43:

  Identify three differences between Oracle Transactional Business Intelligence (OTBI) and Oracle Business Intelligence Applications (OBIA).

  A. OBIA is based on the universal data warehouse design with different prebuilt adapters that canconnect to various source application

  B. Both OBIA and OTBI provide a set of predefined reports and dashboards and a library of metrics that help to measure business performance

  C. OBIA works for multiple sources including E-Business Suite, PeopleSoft, JD Edwards, SAP, andFusion Applications.

  D. OTBI allows you to create custom reports from real-time transactional data against thedatabase directly

  E. Cloud customers can use both OTBI and OBIA.

  Correct Answer: BCD

• Question 44:

  You are required to change today's daily rates for converting GBP to USD. What are three ways in which you can update existing daily rates?

  A. Use the spreadsheet loader from the Currency Rates Manager.

  B. Import daily rates through the Daily Rates open interface table.

  C. Update rates manually using the Currency Rates Manager, which can be accessed only from the Functional Setup Manager

  D. Update rates manually using the Currency Rates Manager, which can be accessed from the Functional Setup Manager or the General Ledger's Period Close work area.

  E. Edit existing transactions and update the rates manually.

  Correct Answer: BCD

• Question 45:

  Before implementing Fusion Financials, your customer used to manually reconcile their intercompany payables and receivables accounts.

  What is a more automated approach to do this?

  A. Run the BI Publisher reports called Intercompany Transaction Summary and Account Details to automatically reconcile intercompany balances.

  B. Create a query using Oracle Transactional Business Intelligence (OTBI) that will match the intercompany payables and receivables balances.

  C. Run the Intercompany Reconciliation report, which shows pairs of intercompany receivables and payables accounts that are out of balance.

  D. In Fusion Financials, you must manually reconcile your intercompany account balances.

  E. Use Oracle Hyperion Close Manager to automatically reconcile intercompany account balances.

  Correct Answer: B

• Question 46:

  Which three objectives must be considered when designing the chart of accounts?

  A. Effectively manage an organization's financial business.

  B. Consider implementing a single, global chart of accounts

  C. Anticipate growth and maintenance needs as organizational changes occur.

  D. Limit the number of segments to those you need today to reduce data entry.

  E. Try to use all 30 segments and 25 characters per segment because you cannot change It later.

  Correct Answer: ABC

• Question 47:

  Your customer wants to create fully balanced balance sheets for the Company, Line of Business, and product segments for both financial and management reporting.

  What is Oracle's suggested best practice for doing this?

  A. Create a segment that acts as the primary balancing segment and create values that represent a concatenation of all three business dimensions.

  B. Use account hierarchies to create different hierarchies for different purposes and use those hierarchies for reporting.

  C. Create three segments and qualify them as the primary balancing segment, second, and third balancing segments, respectively.

  D. Create two segments where the first segment represents the concatenation of Company and Line of Business, and then enable secondary tracking for the Product Segment.

  Correct Answer: C

• Question 48:

  In which two ways can your users customize the Dashboards and Work Areas to suit their individual working styles?

  A. They can format each table by hiding and showing columns, moving columns, and resizing columns.

  B. They can use Personalization to move and remove regions from those pages.

  C. Users have very little control customizing their Dashboards and Work Areas; they can only resize columns.

  D. They can have the System Administration customize pages for them using Page Composer.

  Correct Answer: C

• Question 49:

  Your Financial Analyst needs to interactively analyze General Ledger balances with the ability down to originating transactions.

  Which three features facilitate this?

  A. Account Inspector

  B. Smart View

  C. Account Monitor

  D. Online Transactional Business Intelligence

  E. Financial Reports published to Excel

  Correct Answer: E

• Question 50:

  You want to monitor the dose process of all your financial subledgers and ledgers. How can you quickly obtain this information?

  A. Access each subledgers' calendar and General Ledger's Manage Accounting Periods page to view the status of each period.

  B. Use the Manage Accounting Periods page to view the status of all subledgers and ledgers.

  C. Use Close Monitor in General Accounting Dashboard.

  D. Run Closing Status reports.

  Correct Answer: D