Oracle 1Z0-1080-23 Exam - Free questions
Oracle Planning 2023 Implementation Professional
1Z0-1080-23 Free questions
Here you can find Oracle Planning 2023 Implementation Professional exam free sample questions which will help you to prepare for your upcoming certification test. These questions will give you an idea of what to expect on the exam and help you review the 1Z0-1080-23 study material.
These 1Z0-1080-23 questions are updated regularly, so you can be confident that you're studying with the most up-to-date information available. We also provide answer keys so that students can check their work.
Additionally, going through Oracle Planning 2023 Implementation Professional practice questions can help you identify any areas where you need more review. Taking advantage of our 1Z0-1080-23 demo questions is a great way to set yourself up for success on the real thing.
Question No. 1) You want to move financial information from Projects to Financials for account level data. Which describes the action you can take to accomplish this? (Choose the best answer.)
A) In data maps, push data for the predefined Financial Statement Integration.
B) Rollup project data which pushes data to Financials based on account mappings.
C) On the Financials Integration Summary form, from the Actions menu, select PFP Detail to calculate project data.
D) In Financials, run the Financials Integration business rule to update data from Projects.
Question No. 2) Which two statements are true regarding the creation and management of business rules in module-based Planning? (Choose two.)
A) Pre-defined business rules for modules may be modified, but may be ignored after an application upgrade.
B) Custom business rules for modules can only be created using the graphical designer.
C) Custom business rules can be created for each module.
D) Modules cannot use regular business rules. Instead, they must be scripted using Groovy.
Question No. 3) What three actions can you perform on the data displayed in the Data Integration Workbench? (Choose three.)
A) Re-register or modify the data source system
B) Open loaded data in Microsoft Excel
C) Apply a filter using Equal and a specific value
D) Apply a filter using Contains and a specific value
E) Drill-through to source from specified data cells
Question No. 4) Which two client requirements align with using an ASO plan type alongside the module-based plan types? (Choose two.)
A) The client would like to plan revenue by Product and Services dimensions.
B) The client would like to report the results of the allocation process by Entity.
C) The client would like to store 10 years of actuals history for reporting purposes but only requires prior year history for planning purposes.
D) Due to sparse dimensionality, aggregation times are slow in the application.
E) The client has 10 dimensions in the application and needs to report at each intersection.
Question No. 5) What three time period management tasks can you perform in Strategic Modeling? (Choose three.)
A) Combine periods of years, halves, quarters, months, and weeks for historical forecast data.
B) Configure time periods to reflect the detail required by financial models, such as different levels of granularity for different years.
C) Enable the input option for upper level time periods when you add time detail.
D) Create period-to-date, trailing periods, deal periods, and sub periods to record transactions.
E) Select and combine periods of years, halves, quarters, months, and weeks for the beginning balance year.
Question No. 6) In order to set up weekly planning for a continuous 18 months, which three options would need to be selected when initially configuring Financials? (Choose three.)
A) Rolling Forecast
B) Custom Periods
C) Weeks to months mapping
D) Plan Element dimension
E) Weekly Planning
Question No. 7) In order to be able to configure Additional Earnings in the Benefits and Taxes wizard, into which dimension do you have to import members? Choose the best answer.
A) Pay Type
Question No. 8) When setting up a data map, which two options are available for handling unmapped dimensions? (Choose two.)
A) Selecting a single unmapped dimension member on the source to map to multiple unmapped dimension members on the target
B) Selecting multiple unmapped dimension members on the source to map to multiple unmapped dimension members on the target
C) Selecting multiple unmapped dimension members on the source to map to a single unmapped dimension member on the target
D) Selecting a single unmapped dimension member on the source to map to a single unmapped dimension member on the target
Question No. 9) After enabling Financials, which three are recommended configuration tasks? (Choose three.)
A) Setting up exchange rates (for multicurrency applications)
B) Removing custom dimensions
C) Adding custom expense driver categories
D) Adding custom dimensions
E) Completing Planning and Forecast Preparation
Question No. 10) Which two clients or command line tools can you download from Planning? (Choose two.)
A) Data Management
C) Strategic Modeling Smart View add-on
D) Calculation Manager
Question No. 11) Which three are benefits of using EPMEnterprise Cloud Service over EPM Standard Cloud Service? (Choose three.)
A) enable presided configurable content including dimensions, models, forms, rules, dashboards, infolets, and reports for Strategic Modeling
B) with Free Form Planning, deploy Planning business processes with no dimension requirements and create business processes using Essbase outline files
C) Custom Planning, which allows a high degree of business process customization to support business requirements
D) use of the Groovy scripting language to create or customize business rules
E) deploy more than one supported business process in the same instance
Question No. 12) What is the correct sequence of steps for enabling each Planning module? Choose the best answer.
A) Enable the module, refresh the database
B) Run pre-configuration tasks, enable the module, configure the module
C) Configure the module, refresh the database
D) Enable the module, configure the module, run post configuration tasks
Question No. 13) Which card allows you to enable modules? (Choose the best answer.)
A) Valid Intersections
B) Data Maps
Question No. 14) Revenue planned in Projects is rolled up into Financials for contract projects. How must you set up the modules to share the data? Choose the best answer.
A) To capture Project revenue, enable Standard Rates from Projects.
B) When enabling Financials, create a custom Project dimension to map the data to.
C) In Projects, select an entity and map revenue accounts to Financials accounts for that entity.
D) Set up the Contract Revenue Reporting data map to map contract-related revenue to Financials.
Question No. 15) Which statement is true when executing a lifecycle management migration? Choose the best answer.
A) Restoring Essbase data from a snapshot will remove any data that doesn’t exist in the backup.
B) Importing Dimensions will remove members that do not exist in the snapshot.
C) Selected slices of data can be imported into Essbase.
D) All forms that do not exist in the snapshot will be deleted.
Question No. 16) Which statement describes infolets? Choose the best answer.
A) Infolets help you personalize focused data slices that you frequently use for analysis.
B) Infolets help you quickly analyze data and understand key business questions by presenting a visual overview of high-level, aggregated information.
C) Infolets are predefined dashboards that give you insight into overall project financials and expense and revenue metrics.
D) Infolets help you organize, track, and prioritize your workload.
Question No. 17) Which three do you need to enable in order to perform indirect cash flow statement planning? (Choose three.)
B) Cash Flow Statement
C) Income Statement
D) Balance Sheet
Question No. 18) Which two are benefits of enabling Use Database Suppression in Smart Push? (Choose two.)
A) It automatically merges comments, attachments, and supporting detail when mapping a cube for reporting.
B) It helps eliminate the impact on query thresholds and improving wait times.
C) It allows you to continue using the application while Smart Push runs in the background.
D) It enables you to apply row suppression at the database level instead of the application level.
Question No. 19) What would be the recommended module-based cube architecture for a company wanting to enable Financials and Capital, as well as create a Detailed Sales Forecasting cube with complex allocations and calculations, corresponding sales reporting cube, and consolidated reporting cube? (Choose the best answer.)
A) 3 BSO cubes (1 required for the modules +2 custom BSO cubes), 2 ASO cubes
B) 2 BSO cubes (1 required for the modules +1 custom BSO cubes), 2 ASO cubes
C) 3 custom BSO cubes, 2 ASO cubes
D) 3 BSO cubes (2 required for the modules +1 custom BSO cube),2 ASO cubes
Question No. 20) Which three are predefined Workforce business rules? (Choose three.)
B) Plan Departure
C) Promote Employee
D) Change Job
E) Remove Existing Employee
Question No. 21) A company would like to configure Financials, Workforce, and Projects. They would like to plan and forecast the Project dimension in Financials, as well as track employee utilization in Projects. Which two actions must they take to ensure that the Project dimension is shared and the data integrated correctly across all three modules? (Choose two.)
A) In Workforce, ensure that the granularity is at Employee or Employee and Job
B) In Financials, rename one of the custom dimensions to “Project” and enable it
C) In Projects, ensure that the Employee driver-based expense is enabled
D) In Workforce, rename one of the custom dimensions to “Project” and enable it
Question No. 22) Which three are use cases for data maps? (Choose three.)
A) To allow users to drill back to the data in a different cube.
B) To integrate data between custom plan types and Planning modules
C) To integrate data between Planning modules
D) To push data from a planning cube to a reporting cube
E) To create a replicated partition between cubes
Question No. 23) Which two are supported funding methods in Strategic Modeling? (Choose two.)
A) Target Capital Structure funding method
B) Standard funding method
C) Proposed Projects funding method
D) Employee-based funding method
Question No. 24) What does a navigation flow allow you to do? Choose the best answer.
A) Promote a plan to your supervisor
B) Display report variances by geography
C) Run multiple business rules in a predetermined sequence
D) Customize the clusters and cards that a user can access
Question No. 25) Which three security design principles can help reduce overall security maintenance and troubleshooting, while still balancing security control? (Choose three.)
A) Creating groups over assigning individual access permissions to users
B) Configuring single sign-on (SSO)
C) Assigning a higher level role than necessary, then scaling back access permissions
D) Using inherited permissions
E) Assigning global read access to each cube, then fine-tuning none and write access within dimensional security