Saturday, November 10, 2018

1Z0-954 Oracle Communications Session Border Controller Troubleshooting 2017 Implementation Essentials

Exam Title: Oracle Communications Session Border Controller Troubleshooting 2017 Implementation Essentials
Exam Number: 1Z0-954
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 Minutes
Number of Questions: 80
Passing Score: 75%
Validated Against: This exam has been validated against Oracle Communications Session Border Controller 7.3

Troubleshooting Hardware and the Network
Boot the Session Border Controller (SBC) and monitor the boot process
Identify and resolve boot issues
Identify and resolve hardware issues
Identify and troubleshoot network issues
Identify and troubleshoot system issues

Troubleshooting Tools
Describe troubleshooting methodology
Configure and use SBC monitoring and troubleshooting tools

Troubleshooting Media
Describe media timers
Troubleshoot media issues

SBC Review
Explain basic configuration elements
Configure the SBC

Troubleshooting Signaling
Monitor signaling by using ACLI application statistics
Identify SIP response codes and disposition conditions
Troubleshoot Registration issues
Troubleshoot Session agent issues
Troubleshoot policy-based routing issues

Troubleshooting High Availability (HA)
Explain HA state-checkpointing between active and standby peers
Describe HA switchover and associated node state transition events
Define the process watchdog timer
Identify and resolve controlled HA problems

Thursday, November 8, 2018

1Z0-493 Oracle Communications Order and Service Management Server 7 Implementation Essentials

Exam Title: Oracle Communications Order and Service Management Server 7 Implementation Essentials
Exam Number: 1Z0-493
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 minutes
Number of Questions: 89
Passing Score: 70%
Validated Against: This exam has been validated against version 7.

Order and Service Management (OSM) Overview
Describe the requirements of an Order Management system for a Communications Service Provider
Describe the major features of Oracle Order and Service Management
Describe common use cases for Order Management

Using the Design Studio
Use the Design Studio for OSM cartdige implementation
Deploy a cartridge and submit sample orders from the Design Studio

Administration
Configure permissions, notifications and check alerts in the Administrator application
Configure security using WebLogic users and groups, security callback, security credentials and entities
Configure resources using the WebLogic console

Cartridge Configuration
Describe the project and cartridge concepts
Version and maintain multiple versions of cartridges
Use the cartridge management tool and the XML Import/Export tool functionalities
Configure composite cartridges
Extend existing sealed and non sealed cartridges with new features

Configuring Manual Tasks
Configure data used by a task during its execution
Configure permissions to execute and interact with a task
Configure behaviors to enhance the manual task in the Task Web client
Configure data instances to support manual tasks' behaviors

Automation Framework Configuration
Associate automation plug-ins with an automated task
Use the automation framework variables and methods to interact with OSM orders and tasks from XQueries
Configure and develop a custom automation plugin

Order Recognition
Configure the values and XQuery for order recognition rules
Configure the XQuery in order validation rules
Configure the XQuery in data transformation rules

Order Orchestration
Model an orchestration order and a process
Model an orchestration sequence with orchestration stages
Create fulfillment modes, create fulfillment patterns and associate them through product specification
Configure orchestration dependencies
Describe an orchestration plan as viewed in the Order Management Web client

Handling Future Dated Orders
Configure future dated orders
Calculate the order start date for future dated orders

Fallout Management
Describe the typical fallout scenarios in Order Management
Describe the typical fallout notification and recovery functionalities in OSM

Delivering a Solution With OSM
Planify test strategies for an OSM project
Treat known and unknown issues using Oracle Support and Oracle forums
Use configuration management to support an OSM project

Architecture and Installation
Identify the components of the OSM architecture
Install and configure an OSM Server
Configure a high-availability architecture for OSM

OSM Web Clients
Use the Task Web client functionalities to interact with an order
Use the Order Management Web client functionalities to interact with an order
Enhance web clients with flexible headers, filters and custom menu options

Logging and Troubleshooting
View OSM logs and configure log level
Identify and correct common issues
Use OSM interfaces available for basic troubleshooting

Modeling Basic OSM Entities
Define data elements using data schemas and data dictionary
Describe orders data, permissions and lifecycle
Describe tasks permissions, states and statuses

Configuring Processes
Model process flows using tasks and subprocess
Model process flows using multi instance tasks and multi instance subprocesses
Use rules, joins and delay tasks in a process flow

Configuring Notifications
Model data change notifications in orders
Model event notifications in orders and tasks
Model jeopardy notifications in orders and tasks

Order Decomposition
Model order item specification properties and hierarchies
Use product classes and productClassMapping.xml to model products
Decompose order items using decomposition rules
Configure order components to define functions, system topology and granularity
Configure associated order items
Describe the ControlData structure created in the order data for orchestration

Configuring Fulfillment States and the Point of No Return (PONR)
Enforce the end-to-end visibility of Point of No Return (PONR)
Configure follow on orders
Compare Order Lifecycle Policy with product specification's Fulfillment States
Configure state mapping with Fulfillment State Map
Describe fulfillment state composition with Order and Order Item Fulfillment State Composition Rule Set

Order Change Management
Submit revision orders from an upstream system and detect revision orders in OSM
Configure OSM for order change management
Predict a compensation plan based on in-fligh order information and revision order data
Predict possible scenarios while executing the compensation plan for a process

Using the Interfaces
Use the webservice interfaces to interact with OSM from an external system
Use the XML API interfaces to interact with OSM from an automated task

Oracle Reference Architectures for OSM
Describe OSM COM and SOM roles in the Rapid Offer Design and Order Delivery (RODOD) solution
Describe OSM SOM and TOM roles in the Rapid Service Design and Order Delivery (RSDOD) solution

QUESTION 2
A communications service provider has a solution modeled inside OSM sealed cartridges, which are part of a composite
solution. What three enhancements can be implemented
without unsealing the existing cartridges?
A. defining new fulfillment providers for new provisioning systems to decompose order items by target system
B. configuring new fulfillment dependency between two existing products
C. adding a new orchestration stage to the existing orchestration sequence to decompose order items by region
D. including new properties to the order item specification, so that the new property can be used during orchestration plan definition
E. using the existing granularity orchestration stage and changing the granularity for a billing function, so that products are billed as soon as they are provisioned.

Answer: C,D,E

QUESTION 3
A customer purchases ABC service for which a new order is submitted to Order Service Management (OSM). Activation
for this service is under execution, indicating that the point-of-no-return has not yet been reached, when the customer
decides to change the ABC service to XYZ service.
Which two OSM features can you use to handle the customer’s request?

A. Order Change Management
B. Order Fallout Management
C. Future-dated orders
D. Follow-on orders
E. Creation of new orders

Answer: A,D

QUESTION 4
Due to internal errors in a downstream system, one of the automated tasks is receiving an error response to a request sent from OSM. Considering that the error is an issue that could be resolved by simply retrying the request, identify the
functionality you would use to recover from this fallout scenario.

A. Order Change Management
B. Notifications
C. Jeopardy
D. automation framework transaction rollback
E. follow-on order

Answer: D

QUESTION 5
Why would you use the Security Callback feature?

A. to intercept user interaction with orders before they gain access to sensitive order data
B. to block users from accessing any OSM applications and interfaces
C. to intercept critical security alerts for OSM applications before they cause runtime exceptions
D. to allow administrative users to enable security alerts for OSM applications
E. to prevent users without administrative roles to access the WebLogic administration console

Answer: A

Explanation:
Referencehttps://docs.oracle.com/cd/E35413_01/doc.722/e35415/cpt_glossary.htm

QUESTION 6
You must implement a dependency between two order components within a product specification, where the dependent
order component will wait the amount of time defined in an order item property after the blocking order component
finishes its execution and before starting its own execution.
What are the two tasks required to configure this behavior?

A. defining a Wait Condition in the dependency, which is configured with the task state “Received”
B. defining a Wait For Condition in the dependency, which is configured with the task state “Completed”
C. defining a Wait For Condition in the dependency, which is configured with a data change notification
D. defining a Wait Delay in the dependency, which is configured with a fixed time duration
E. defining a Wait Delay in the dependency, which is configured with a duration expression
F. defining a Wait Condition in the dependency, which is configured with no delay duration

Answer: A,E

Wednesday, November 7, 2018

1Z0-458 Oracle Utilities Mobile Workforce Management 2 Implementation Essentials

Exam Title: Oracle Utilities Mobile Workforce Management 2 Implementation Essentials
Exam Number: 1Z0-458
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 minutes
Number of Questions: 75
Passing Score: 70%
Validated Against:

This exam has been validated against version 2.

Take Recommended Training Courses

Complete one of the courses below to prepare for your exam (optional):

Boot Camp: Oracle Utilities Mobile Workforce Management v2 Implementers

Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Guided Learning Path: Oracle Utilities Mobile Workforce Management 2 Implementation Specialist

Mobile Resources
Describe the concepts of mobile resources and the structures used to represent them (mobile workers, vehicles, crews, skills)
Describe service areas
Configure a new mobile worker type
Configure a new vehicle type
Configure a new crew type
Create a crew's shift
Create a mobile worker
Create a vehicle
Create a crew
Configure a Shift Weekly Template for multiple crew types, device types, and measuring component types
Create and configure a new business object for a custom resource

Bound Work
Describe the dependency options of bound work
Describe a job and its relation to a crew shift
Configure a job within an XML document
Describe a chain
Configure chain activities in an XML document

Scheduler
Describe the inputs and outputs of the scheduler, including parameter definitions
Describe the scheduler manager
Configure the scheduler horizon
Configure a scheduler area
Configure a scheduler
Describe the scheduler registry
Describe the appointment booking group/service
Describe the holding scheduler
Configure optimization areas
Configure Dispatch Modes for Breaks POU tasks, and Emergencies

Dispatchers
Describe common activity dispatcher functions and the key areas of the Common Dispatcher Interface (CDI)
Configure a dispatch area
Describe a dispatcher's data scope
Describe Key Performance Indicators (KPIs) and the KPI specific CDI
Configure a KPI
Describe clustered tasks
Configure a dispatcher view
Manually dispatch an activity to a crew
Create multiple crew routes on a map

Mail
Describe mail messaging (within the server and mobile applications)
Create a mailing list
Create an emergency mail message
Create and configure a new business object for a custom mail message

Activities
Describe a task, activity, and assignment
Describe the types of available time windows
Describe priority profiles and how they are used
Describe how activities, Periods of Unavailability) POUs, and Breaks are scheduled
Configure a new task type
Configure a priority profile for an activity
Configure new completion details for an assignment
Describe a collision of activities
Create and configure a new business object for a custom task/activity

POUs
Describe a POU, and distinctions between POUs for mobile workers and vehicles (including how POUs are considered by the scheduler)
Describe how POUs are generated by POU templates and batch processes
Configure a POU Task
Configure a POU Event
Configure a Break
Configure a Non-Productive Task
Create and configure a new business object for a custom break or non-productive task

Mobile Application
Describe the architecture of the mobile application
Configure a Mobile Data Terminal (MDT)
Describe how Remote Script Invocation (RSI) is used with the mobile application
Deploy a mobile application
Describe the functions of the mobile device and the Field Reference Activity
Configure mobile display settings on the device
Complete an assignment on the mobile device
Execute / Cancel an assignment on the mobile device
Manage a POU on the mobile device

Alerts
Configure an alert
Describe the backup alert queue
Configure an alert based KPI
Complete an alert
Create and configure a new business object for a custom alert

Transfer of Goods
Describe the concept of goods and capacity
Describe a depot and depot run
Configure a Depot
Describe the depots business hours and depot cutoff
Describe depot activities vs depot tasks
Describe crews in relation to depots
Configure a Depot Run
Create and configure a new business object for a custom depot

Tuesday, November 6, 2018

1Z0-492 Oracle Utilities Smart Grid Gateway 2 for Advanced Metering Infrastructure Implementation Essentials

Exam Title: Oracle Utilities Smart Grid Gateway 2 for Advanced Metering Infrastructure Implementation Essentials
Exam Number: 1Z0-492
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 minutes
Number of Questions: 80
Passing Score: 80%
Validated Against: This exam has been validated against Oracle Utilities Smart Grid Gateway 2.

Devices and Measuring Components
Describe a device and the data structures used to represent them
Describe a measuring component and the structures used to represent them
Explain the relationship between devices and measuring components
Explain scalar and interval measuring components
Configure a new device type
Configure a new measuring component type
Configure a new device config type and associate a measuring component to a device
Use the Duplicate feature to copy a device type or a measuring component type
Use the Device Replicator to create copies of a device

Measurements
Explain the differences between initial measurements, final measurements, and usage
Explain the high level process of loading measurements through to calculating usage
Explain the difference between raw, pre and post VEE (validate, edit and estimate) initial measurements
Locate and view raw (if captured), pre and post VEE initial measurements
Create a new IMD (initial measurement data) BO to store AMI head-end specific data
Explain how scalar and interval IMDs differ, and how they are the same

Device Events
Explain device events and what they are used to represent
Explain event subscriptions
Describe paired events and what they can be used to represent
Locate and view the list of standard device event names
Locate and view the mapping between the AMI specific head-end device event names and standard (product) event names for a given SGG adapter
Set up a new external system to receive device events via an event subscription
Configure a new, custom device event

Commands
Explain the command processing architecture, identify the common product design patterns, and identify which parts of the process are implemented in the OUAF vs. those that are implemented in BPEL
Describe each of the commands generally supported by SGG adapters
Configure the OUAF administration data and BPEL required for a new command based on the Adapter Development Kit.
Add a new element to a command's BO schema
Describe the lifecycles of commands provided with the productized adapters (or the Adapter Development Kit)
Configure the OUAF administration data required to allow an external system to call SGG commands

SGG Installation and Setup
Describe where all SGG components are installed, including OUAF components, OSB and BPEL composites, directories and files on the various server file systems
Install the OUAF components of SGG base, as well as the OUAF, OSB and BPEL components of the Adapter Development Kit
Configure all endpoints (JMS Queues, MDB, BPEL call-outs, XAI, AMI head-end web services, file system directories, etc) in the OUAF, OSB and BPEL for the Adapter Development Kit
Set up a development environment for the ADK, including setting up a Java project, OSB project and BPEL project, and importing all code and composites provided as part of the ADK

Service Points and Install Events
Describe a service point and the data structures used to represent them
Describe an install event and the relationship between devices and service points
Configure a new service point type
Configure the set of valid device types for a given service point type
Configure a new Install Event BO (business object)
Explain how an Install Event is transitioned by the execution of a command

Activities
Explain activities and define what they can be used to represent
Configure Activity Relationship Types to form parent/child relationships between activities
Configure a new activity identifier type to enable a new activity identifier
Configure relationships between activities and BOs
Via the UI, identify the full list of Business Objects that are based on the Activity MO (maintenance object)

Usage and Event Upload
Explain the usage and device event load architecture at a high level and identify which parts of the initial load process MDM and SGG are responsible for, and which parts are handled by which technologies (Oracle Service Bus vs. Oracle Utilities Application Framework)
Explain the IMD and Device Event Seeder concepts and BOs, including lifecycle and rules, how they derive head-end, device and measuring component information and how the "real" IMD or Device Event BO is determined during load processing.
Identify where usage loading and device event loading configuration is defined in OSB (Oracle Service Bus), including how they are differentiated
Explain the differences between the BASE and CM (customer modification) OSB projects and the reasons for segregating the configuration in this manner
Examine and change CM OSB configuration examples provided as part of the Adapter Development Kit (e.g. the JCA Adapter configuration, Inbound Proxy Service, plain XML and CSV to IMD XML transformation Xqueries, etc)
Deploy custom XML and CSV file parsers to replace the examples provided as part of the ADK (Adapter Development Kit)
Systematically examine all locations where IMD and Device Event load errors can be reported to isolate where in the process errors are occurring
Explain how (and during which part of the process) device events are created for MV90 data when processed by the productized MV90 SGG adapter
Configure service providers and processing methods, provided by productized adapters, for usage and device event uploads
Describe the configuration for mapping vendor specific units of measure, status codes, device event names, etc, to their standard product counterparts.
Describe the information on the payload stats totals and trends view
Describe the XML schemas that define the Payload Statistics XML schemas
Navigate to, view and describe the admin data related to Payload Statistics
Load usage and manually accumulate stats for the payload that was processed
Aggregate stats for the head end tied to the payload that was processed
Configure the system to capture new, custom payload statistics

Adapter Development Kit (ADK)
Describe the purpose of the ADK and what it contains
Add a meter to the test harness
Review (Get) and set meter attributes in the test harness using Oracle Enterprise Manager and the test harness web services
Change the state attributes (connected, commissioned, etc) of the meter by executing a command from SGG against the meter.


Monday, November 5, 2018

1Z0-582 Primavera Contract Management Essentials

Exam Title: Primavera Contract Management Essentials (Retiring on Dec 31, 2018)
Exam Number: 1Z0-582
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 150 minutes
Number of Questions: 87
Passing Score: 68%
Validated Against: This exam has been validated against version 14

Take Recommended Training Courses
Complete one of the courses below to prepare for your exam (optional):

Primavera Contract Management R14

Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Primavera Contract Management 14 Implementation Specialist
Primavera Contract Management Implementation Boot Camp
Primavera Contract Management Essentials Exam Study Guide

Introduction to Contract Management
Describe the advantages of using contract Management
Log in to Contract Management
Navigate Contract Management
Customize the Project View in the main window

Contract Management Administration
Define access templates
Grant user access
Set up user accounts
Explain the purpose of content management
Manage user password settings
Importing Reports & Forms from a folder location

Modify the Control Center
Customize the control center in the main window
Manage control center objects
Configure a workspace

Communicate Project Information
Document a telephone record
Enter a request for information
Record an answer to a request for information

Contract and Trends
Add a contract
Distribute document values to the cost worksheet
Use trends to account for anticipated costs
Use Line Items, Lump Sum and Unit Price
Generate Material records
Set Cost options and Markup for Changes
Differentiate between Budget and Committed

Award Procurement Items
Document bids
Compare bids
Award procurement items

Log and Track Submittals
Document submittal items and packages
Assign status submittals
Identify the responsible part (Ball in Court)
Incorporate multiple reviewers
Create transmittals from submittals
Set up an approval process
Configure the approval process for a document
Use an approval process
Use Dunning letters to notify participants

Record Project Communications
Create daily reports
Document daily progress
Generate daily reports and meeting minutes
Record and print meeting minutes

Customize the View in the Log Window
Create a layout
Filter a layout
Sort a layout
Group a layout
Export logs to excel
Customize project and document view
Create custom fields
Use custom fields

Setting up and Working with Company Directory
Add a new company
Create contacts
Edit contact information
Distinguish between group and project contacts
Copy contacts from another project
Create distribution lists from contacts in a project
Designate companies or contacts as inactive

Creating a project
Create a new project using the add project wizard

Track Document
Explain the distribution process
Create transmittals from distribution lists
Use the transmittal queue
Package a group of drawings as a set
Distribute drawings to project participants

Document Project Issues
Define an issue
Create an issue
Link documents and attachments to an issue
Document an issue by searching through project documents and attachments

Manage Project Costs
Define the cost process in a project
View a cost coding structure
Define the cost worksheet
Explain how document values are distributed
View the source documents from a cost code

Payment Requisitions and Invoices
Determine requisition options
Generate a requisition from a contract
Create a schedule of values
Balance the requisition
Retrieve approved change orders
Record status for requisitions
Distribute actual cost to the worksheet
Add invoices to a contract or purchase order

Track Drawings
Record and view drawing logs
Create transmittals from distribution lists
Use transmittal queue
Package a group of drawings to the drawing set
Add multiple drawings to the drawing set
Distribute drawings to project participants

Change Management
Describe the change management workflow process
Define change management phases
Define project settings for document flow
Save versions of documents
Create, link and reference change documents
Trace estimated, quoted, negotiated and final change values



Sunday, November 4, 2018

1Z0-562 Oracle Utilities Customer Care and Billing 2 Essentials

Exam Title: Oracle Utilities Customer Care and Billing 2 Essentials
Exam Number: 1Z0-562
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 minutes
Number of Questions: 70
Passing Score: 60%
Validated Against: This exam has been validated against 2.3.1.

Take Recommended Training Courses
Complete one of the courses below to prepare for your exam (optional):

Oracle Utilities Customer Care and Billing Functionality for Implementers Bootcamp (available to partners only)
Oracle Utilities Customer Care and Billing Fundamentals Bootcamp (available to partners only)

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Training Opportunities for Oracle Partner Network Members (available to partners only)

Control Central & User Interface Standards
Navigate the Oracle Utilities Customer Care and Billing User Interface
Use and Maintain Control Central
Locate Help Documentation and Text

Customer Information
Maintain and Manage Customer Information
Determine Customer Account Structure
Manage Customer Contacts

Sales and Marketing
Configure and Manage Campaigns, Packages and Orders

Field Work
Manage Field Activities and Field Orders

Route Management and Field Activity Upload
Maintain Service Cycles, Routes and Field Activity Upload

Billing
Manage Bills
Maintain Bill Segments
Complete Bills

Payments
Manage Payments
Manage Overpayment and Payment Distribution

Monitor Overdue Debt
Configure and Manage Credit & Collections and Overdue Processes
Manage Payment Arrangements and Pay Plans

Business Object Elements
Configure using Business Object Elements

Business Object Inheritance
Share Business Object Properties

Business Object Options
Use Business Object Options

Service Scripts
Configure Service Scripts

Advanced BPA Script Features
Configure and Manage Business Process Assistant (BPA) scripts

Bundling
Configure using Bundling Capabilities

Framework Overview
Use the Oracle Utilities Application Framework
Understand Maintenance Objects
Create Plug-In Logic
Extend the Database
Enforce Security Rules

To Do
Configure and Manage To Do Functionality

Device (Meter and Item) Management
Configure and Manage Meters and Items

Meter Reading
Maintain Meter Reads

Financial Transactions
Manage Financial Transactions

Rates
Manage and Apply Rates
Apply Proration
Apply Bill Factors

Adjustments
Configure and Manage Adjustments

Case Management
Configure the Case Management Functionality

Business Object Business Rules
Use Business Object Rules

Business Object Lifecycle
Apply Business Object Life Cycle

Business Object Access Rights
Configure Access Rights

Business Services
Configure Business Services

Revision Control
Use Revision Control



QUESTION 1
What controls the types of service agreements and service points to be created? (Choose the best answer.)

A. Campaign
B. Package
C. Campaign and Package
D. Service Agreement Type/Service Point Type Relationship
E. Order

Answer: C


QUESTION 2
Which two Payment statuses will create Financial Transactions for a payment? (Choose two.)

A. Incomplete
B. Freezable
C. Complete
D. Frozen
E. Canceled

Answer: D
Reference:
https://docs.oracle.com/cd/E28945_01/4.3%20Collect%20Revenue/CC&B%20URM%204. 3.1.1.pdf


QUESTION 3
What correctly describes the possible causes of price proration? (Choose the best answer.)

A. change in Rate Schedule only
B. change in Rate Version only
C. change in Bill Factor only
D. changes in Rate Schedule and Bill Factor
E. changes in Rate Version and Bill Factor

Answer: C
Reference:
https://docs.oracle.com/cd/E18733_01/pdf/E18367_V3_01.pdf


QUESTION 4
Which three areas can be specified to invoke a User Interface (UI) map from a Business Process Assistant (BPA) script? (Choose three.)

A. Business Process Assistant (BPA) Script Area
B. Page
C. Pop-Up
D. Portal
E. Zone

Answer: B,C,D


QUESTION 5
Which entity defines the type of collection process to start based on age of debt, amount of debt, and type of customer? (Choose the best answer.)

A. Customer Class
B. Debt Class
C. Collection Class
D. Collection Class Control
E. Collection Process Template

Answer: B

Saturday, November 3, 2018

1Z0-531 Oracle Essbase 11 Essentials

Exam Title: Oracle Essbase 11 Essentials
Exam Number: 1Z0-531
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 105 minutes
Number of Questions: 69
Passing Score: 62%
Validated Against: This exam has been validated against Oracle Essbase 11.1.2.1.

Take Recommended Training Courses

Complete one of the courses below to prepare for your exam (optional):

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3)

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Resources available to partners only
Training Opportunities for Oracle Partner Network Members
Oracle Essbase 11.1.1: Bootcamp
OPN Guided Learning Path: Oracle Essbase Implementation Specialist
Training Resources by Exam Topics

Overview of Oracle Essbase
Describe multidimensional analysis
Describe Oracle Essbase

Essbase Application Creation Fundamentals
Perform manual outline creation
Build dimensions from sources
Perform initial data loads
Use calculations and aggregations
Assign security

Block Storage Databases
Describe block storage calculations
Describe the default database calculation order
Describe data blocks
Describe how data blocks are indexed
Interpret database statistics
Describe when data blocks are created
Describe the block storage database calculation process
Tune and optimaize block storage databases
Describe and implement block storage design best practices
Describe BSO load techniques

Essbase Administration
Describe the file Essbase.cfg and its settings.
Describe the file Essbase.sec and its settings.
Identify and interpret Essbase log files
Manage Essbase security via Administration Services
Manage Essbase security via Shared Services
Back up and recover Block Storage Databases
Automate database processes with MaxL
Describe and use substitution variables and location aliases

Smart View
Describe Smart View
Retrieve Data using Smart View

Aggregate Storage Databases
Describe when to deploy aggregate storage, block storage, or a combined solution
Convert block storage to aggregate storage
Create, load, and pre-aggregate aggregate storage databases
Employ database partitioning in combined block/aggregate storage solutions
Write member formulas using MDX
Perform management tasks for aggregate storage databases
Partition block and aggregate storage databases
Describe and implement aggregate storage design best practices
Describe multiple hierarchies and the use of Shared Members

Working with Caluculation Scripts
Identify correct and incorrect calculation script syntax
Describe calculation script behavior for various ASO data structures
Describe calculation script behavior for various BSO data structures
Design calculation scripts to meet specified requirements

Essbase Studio
Describe functionality of Essbase studio
Add and delete joins between tables
Create drill through reports



QUESTION 1
Which six files are involved in database recovery for block storage option after a database crash?

A. Essn.pag – data
B. Essn.ind – index
C. Essn.dat
D. Temp.dat
E. Dbname.esm - kernel file that contains control information for db recovery
F. Dbname.tct - transaction control table
G. Dbname.ind - free fragment file for data and index free fragments
H. DBname.otl
I. Metadata folder

Answer: A,B,E,F,G,H

Explanation:
Reference:http://docs.google.com/viewer?a=v&q=cache:gg97eNiYC5EJ:download.oracle.com/doc
s/cd/E10530_01/doc/epm.931/hfm_backup.pdf+Oracle+Essbase+11+files+are+involved+in+datab
ase+recovery+for+block+storage+option+after+a+database+crash&hl=en&gl=in&pid=bl&srcid=AD
GEESiaLpMxmtXkShigMfg6Tq-lHEYjDlA9lQA4RvDDk8GPha1uxkgzqmyFMiuYr-
9RyGrSKqS3S3O4snNtDoRtlrL3jkCO6qyrO54cT_eO_lkUDC6xjXRJ8wsstbXZvA6VnccpT9B1&sig
=AHIEtbS8j8hlh9hKrEm0ipmWV1sjMdj4cA


QUESTION 2
Which two options would provide a better design for the following accounts and metrics?



A. If there are a small number of accounts that require FTE and Expense dollars, split Accounts
and Metrics into 2 dimensions
B. If there are a large number of accounts that require FTE and Expense dollars, split Accounts
and Metrics into 2 dimensions
C. If reporting dictates FTE and dollars in the columns and accounts in the rows, split Accounts
and Metrics into 2 dimensions
D. Ifblock size is large, then keep Accounts and Metrics as one dimension with a dense dimension

Answer: B

Explanation: http://www.scribd.com/doc/40391863/10-Hardcore-Essbase-Tuning-Tips-You-Ve-
Never-Heard-Before


QUESTION 3
Identify the two true statements about incremental loading.

A. Allows for real time data access for end users.
B. Creates*subscribes* along the main slice in the database.
C. Materialization of slices is required to provide users the correct query results.
D. Different materialized views may exist within a slice as compared to the main slice of
thedatabase.

Answer: C,D


QUESTION 4
You should back up the following three for ASO.

A. Hyperion_Home \common
B. Essbaseinstallfolder\bin
C. ARBORPATH\app\appname
D. Essbaseinstallfolder \locale
E. Essbase.sec
F. Essbase.cfg

Answer: C,E,F

Explanation:
http://docs.google.com/viewer?a=v&q=cache:MXHPDeHWl5YJ:download.oracle.com/docs/cd/E12
825_01/epm.111/epm_backup_recovery_11111.pdf+Aggregate+storage+applications+(ASO)+bac
kup+Essbaseinstallfolder+%5Capp%5Cappname&hl=en&gl=in&pid=bl&srcid=ADGEESj8WeUjkx3
1E52J6ZO1oI-z_uLR5yX9WdQ-k2c2YpLrTbVF3OqyXMD5e1hnqcwMngA9wWkPUKRtPNRWB
Qn4EC69Lo2gziBIhL29czy9Oad5PzreJFe7
bBsfjcAfPGKMjfz-gQ1&sig=AHIEtbRXdFBZwAWib5PvJfE1ElMY8oIrzw
http://docs.google.com/viewer?a=v&q=cache:gg97eNiYC5EJ:download.oracle.com/docs/cd/E105
30_01/doc/epm.931/hfm_backup.pdf+Oracle+Essbase+11+files+are+involved+in+database+reco
very+for+block+storage+option+after+a+database+crash&hl=en&gl=in&pid=bl&srcid=ADGEESiaL
pMxmtXkShigMfg6Tq-lHEYjDlA9lQA4RvDDk8GPha1uxkgzqmyFMiuYr-
9RyGrSKqS3S3O4snNtDoRtlrL3jkCO6qyrO54cT_eO_lkUDC6xjXRJ8wsstbXZvA6VnccpT9B1&sig
=AHIEtbS8j8hlh9hKrEm0ipmWV1sjMdj4cA


QUESTION 5
You have the following analysis requirement. Products roll up to Product Family which rolls up to
Product Category. You also need to group Products by Product Manager. Product Managers may
manage one or more Products across product families. You do not need to create reports with
Product Manager by Product Family. You need to secure products by Product Manager for
planning submissions.
You consider Shared members as a solution because of which two options?

A. Shared members provide cross tab reporting (Product Manager in the rows and Product
Familyacross the column)
B. Shared members provide additional categorization but results in a smaller database then if
youwere to add Product Manager as a separate dimension
C. You can assign security to shared members
D. Shared members can be assigned to sparse members only

Answer: B,C

Explanation: http://www.oracledatabase12g.com/wpcontent/
uploads/book/Oracle%20Essbase%20&%20Oracle%20OLAP.pdf
page 95


Friday, November 2, 2018

1Z0-591 Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials

Exam Title: Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials
Exam Number: 1Z0-591
Exam Price: $245.00 More on exam pricing
Format: Multiple Choice
Duration: 120 minutes
Number of Questions: 75
Passing Score: 63%
Validated Against: This exam has been validated 11.1.1.5.

Take Recommended Training Courses

Complete one of the courses below to prepare for your exam (optional):
Oracle Business Intelligence Enterprise Edition Plus Implementation Boot Camp
Oracle Business Intelligence Foundation 11g Implementation Specialist
Oracle BI 11g R1: Build Repositories
Oracle BI 11g R1: Create Analyses and Dashboards

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Oracle BI and EPM System Overview
Describe how OBIEE addresses business intelligence challenges
Describe the Oracle Business Intelligence Enterprise Edition (OBIEE) products

Oracle BI Installation
Describe the Installation Architecture for OBI EE
Explain system requirements, supported platforms and installation pre-requisites
Install OBIEE

Dimensional Modeling
Describe the differences between Transactional and Analytical Systems
Describe Data Warehousing
Build Dimensions, Facts and Hierarchies
Explain Dimensional Modeling

Build Basic Repository
Define a System Data Source Name (DSN) for a data source
Build the Physical layer of the Repository
Build the Logical layer of the Repository
Build the Presentation layer of the repository

Complex Repository Modeling
Describe Derived Metrics and its use
Configure Derived Metrics based on existing logical columns
Configure Derived Metrics based on physical columns

Building a Repository with Multiple Sources
Add multiple sources to an existing logical table source for a dimension in the business model
Add a second table source to a dimension in the business model

Using Variables
Explain session variables
Describe repository variables
Describe initialization blocks
Implement a dynamic repository variable

Oracle Business Intelligence Enterprise Edition Security
Describe authentication and authorization
Describe the different levels at which security is enforced
Configure security using Security Manager
Configure Query Governing controls

MS Office Integration
Use MS Office Plug-In for OBI EE
Describe the required components to enable office integration
Install and configure MS office server and client for OBI EE

Write Back within OBI EE
Describe Write Back capabilities
Configure Write Back with OBI EE

OBI EE Architecture
Describe major components of the OBIEE architecture
Describe the function of each component

OBI EE User Interface Overview
Describe the components of OBI EE User Interface
Perform Oracle Analysis to construct, modify, and save BI requests
Build Dashboards
Create BI Delivers

Oracle BI Repository Overview
Describe the three layers of the OBI Repository
Use the Administration Tool to view and modify the repository

Repository Testing and Deployment
Describe techniques for testing a repository
Validate and test a repository

Advanced Repository Modeling
Create Data Partitioning
Create Segmentation of Data
Create Time Series Data

Hierarchies and Level Based Measures
Create a dimensional hierarchy
Use level-based measures
Create a rank measure
Describe Aggregate tables and the purpose they serve
Create Aggregate tables in the OBI repository

Implementation Methodology and Best Practices
Describe the implementation phases

Cache Management & Performance Tuning
Explain the purpose of cache in OBI EE
Configure caching and manage cache files
Develop caching strategies
Describe the request and data flow in OBI EE

Spatial Integration
Explain Spatial Intelligence and Integration
Add Map based visualization to OBI EE

Essbase Integration
Implement Essbase as a Data Source
Configure BI Server Metadata for Essbase
Explain Essbase Integration



QUESTION 1
When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if
the data is loaded nightly?

A. The lowest level of aggregation
B. The highest level of aggregation
C. Multiple levels of aggregation
D. Independently from aggregation level

Answer: B

Explanation: Aggegated by days.


QUESTION 2
The highest sales amount for this year is $10,000. If you create a rank measure for sales this year
and display it on a report, the value will be________.

A. $10,000
B. 0
C. 1
D. Year

Answer: C

Explanation: The rank measure is numbered from 1. The highest sales amount will be ranked 1.


QUESTION 3
Which two components are required for all OBIEE installations?

A. Admin Server
B. RCU Schema
C. Managed Server
D. Node Manager
E. Oracle 11g

Answer: B,E

Explanation: B: Before you can run Oracle Business Intelligence 11g Installer, you must first
create
required Oracle Business Intelligence schemas in an unhardened database. You use
a tool called the Repository Creation Utility (RCU) to create these schemas with
the appropriate permissions and data.
E: The database 11gR2 is required if you want to run the Oracle Business Intelligence Enterprise
Edition Plus Samples
One Oracle Database Preinstalled and not hardened to host the schemas.


QUESTION 4
The administration tool is the developer's interface to the repository file. It allows the development
of and changes to the metadata repository file. Which statement is true?

A. Changes to the repository can only be carried out in offline mode.
B. Multiple developers can work on one repository at the same time. Results can be merged later on.
C. All aspects of security are being held in the repository file.
D. Opening the rpd.filein online mode results in performance Issues for the application user.

Answer: B

Explanation: The Oracle BI repository development process adheres to the classic Software
Configuration Management (SCM)process, which utilizes a three-way merge to manage
concurrent development.
The merge process involves three repositories:
In a multiuser environment (MUDE), Developers check out the file and make changes locally.
Then, these changes are automatically reconciled and merged into the master repository.


QUESTION 5
Which installation option is used to install into an existing Fusion Middleware Home?

A. Software Only Install
B. Simple Install
C. EnterpriseInstall
D. Cannot installinto an existing Fusion Middleware Home

Answer: A

Explanation: The Software Only Install type installs the Oracle Business Intelligence software binary
files in an Oracle home for later configuration as part of a Fusion Middleware deployment.

MCITP Training - MCITP Certificaion - MCTS Exams Training - CCNA Exams - and more at CertKingdom.com