Andrey Tamashenko
Quiz von , erstellt am more than 1 year ago

SAP BPC 10.0 Certification

632
4
0
Andrey Tamashenko
Erstellt von Andrey Tamashenko vor mehr als 8 Jahre
Schließen

Ц_ЕПМБПС_10 часть 1

Frage 1 von 60

1

Which of the following conventions apply to dimension property IDs? (2 correct answers)

Wähle eine oder mehr der folgenden:

  • They must begin with a character

  • They must contain less than 21 characters

  • They must begin with a number

  • They must contain less than 33 characters

Erklärung

Frage 2 von 60

1

Which business rule requires global definitions business rules?

Wähle eine der folgenden:

  • Eliminations and adjustments

  • US eliminations

  • Currency translation

  • Account-based calculation

Erklärung

Frage 3 von 60

1

Which of the following methods does the Shared Query Engine (SQE) use to retrieve data from the database? (2 correct answers)

Wähle eine oder mehr der folgenden:

  • MDX query

  • Axis query

  • RSDRI query

  • Cell query

Erklärung

Frage 4 von 60

1

You enter data using the EPM Office Add-In Excel. When you attempt to save the data, you receive an error message saying that the member you want to… What could help you to resolve this issue? (2 correct answers)

Wähle eine oder mehr der folgenden:

  • Restrict rows and columns to base members

  • Change the header dimensions to base members

  • Set the Expand option to "Member and Children"

  • Change the calc property of the parent members to N

Erklärung

Frage 5 von 60

1

From which of the following objects can you import data using the "Load Transaction Data from BW InfoProvider" Data Manager package? (3 correct answers)

Wähle eine oder mehr der folgenden:

  • InfoArea

  • DataStore

  • MultiProvider

  • InfoObject

  • InfoCube

Erklärung

Frage 6 von 60

1

You have defined the global definitions in the business rules. Which of the following ownership accounts must contain data if you want to perform the ownership calculation? (2 correct answers)

Wähle eine oder mehr der folgenden:

  • POWN_SYS - Percent Ownership_System Calculation

  • PCON_SYS - Percent Consolidation_System Calculation

  • PCTRL - Percent Control

  • PCON - Percent Consolidation

  • POWN - Percent Ownership

Erklärung

Frage 7 von 60

1

Where do you activate the parameter that is used to automatically refresh the input form when you open it?

Wähle eine der folgenden:

  • EPM - Sheet Options

  • EPM - Context Options

  • EPM - Command Display Options

  • EPM - User Options

Erklärung

Frage 8 von 60

1

You want to specify a model and dimension members that are used every time you create Web reports. Where do you set these values?

Wähle eine der folgenden:

  • Preferences

  • Workspace

  • Context Default

  • EPM Context

Erklärung

Frage 9 von 60

1

How do you model cost center rollups by profit center?

Wähle eine der folgenden:

  • Create a profit center hierarchy by cost center

  • Create a user-defined dimension for the cost center

  • Create a user-defined dimension for the profit center

  • Create a cost center hierarchy by profit center

Erklärung

Frage 10 von 60

1

You want to create a PDF book that contains PDF files by cost center for the current year based on an EPM report, and publish it in the library. Which of the following steps are required when you create the publication template?
(2 correct answers)

Wähle eine oder mehr der folgenden:

  • Include the cost center dimension in the page axis of the publication template

  • Include the cost center dimension in the fixed keys of the publication template

  • Assign the EPM report to the publication template

  • Assign a time variable to the publication template

  • Assign the cost center to the variable members of the publication template

Erklärung

Frage 11 von 60

1

What do you need to consider when using journals? Note: There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Journal authorizations are only governed by the task 'create journals'

  • Journals are copied when you copy one appset to another

  • Journals are supported in the work status configuration

  • Journals can be posted either manually or automatically but not both

Erklärung

Frage 12 von 60

1

Company D owns 91% of A, 51% of B, and 49% of C. Which company can use the equity method?

Wähle eine der folgenden:

  • B

  • C

  • A

  • D

Erklärung

Frage 13 von 60

1

You execute the following Script Logic Logic1.lgf by running a data manager package, without transferring any further parameters and without using default logic.
*WHEN ACCOUNT
*IS ACCOUNT1
*REC (FACTOR=1.5, ACCOUNT=ACCOUNT2)
*ENDWHEN
*COMMIT
What is the scope of the calculation?

Wähle eine der folgenden:

  • Only input schedule

  • ACCOUNT1 and ACCOUNT2

  • Only current view

  • All data within the database

Erklärung

Frage 14 von 60

1

What value is assigned to the ACCOUNT3 with the following Script Logic?
*WHEN ACCOUNT
*IS ACCOUNT1, ACCOUNT2
*REC (FACTOR=1, ACCOUNT=ACCOUNT3)
*ENDWHEN
*COMMIT

Wähle eine der folgenden:

  • Sum of ACCOUNT1 and ACCOUNT2

  • Difference of ACCOUNT1 and ACCOUNT2

  • Quotient of ACCOUNT1 and ACCOUNT2

  • Product of ACCOUNT1 and ACCOUNT2

Erklärung

Frage 15 von 60

1

Which EV expansion option is used to return the current member and its dependents?

Wähle eine der folgenden:

  • EVBAS

  • EVDPS

  • EVBSS

  • EVDEP

Erklärung

Frage 16 von 60

1

What value for the property DATASRC_TYPE in the datasource dimension allows you to identify system postings?

Wähle eine der folgenden:

  • I - Input

  • A - Automatic

  • L - Level

  • M - Manual

Erklärung

Frage 17 von 60

1

Which tool can you use in the EPM Office Add-in Excel to email a list of static files? (2 correct answers)

Wähle eine oder mehr der folgenden:

  • Distribution

  • Worksheet generation

  • Book publication

  • Portal publication

Erklärung

Frage 18 von 60

1

What dimension property is required for consolidation of investments?

Wähle eine der folgenden:

  • FIRST_CONS_DATE in the groups dimension

  • ENTITY in the groups dimension

  • INTCO in the entity dimension

  • OWNER in the entity dimension

Erklärung

Frage 19 von 60

1

Which step is mandatory if you want to check the data integrity of the incoming records?

Wähle eine der folgenden:

  • Implement a BAdI

  • Assign a driver dimension to the validation rule

  • Activate the validations for the environment

  • Configure controls

Erklärung

Frage 20 von 60

1

What information is needed when you configure the interface between EPM Office Add-In Excel and Bex Query to… Drill Through (3 correct answers)

Wähle eine oder mehr der folgenden:

  • The URL of the BEx Query

  • The OKCODE parameter

  • The FILTER_IOBJNM and FILTER_VALUE parameters

  • The technical field names of the dimensions

  • The technical names of the InfoObjects

Erklärung

Frage 21 von 60

1

What currency type dimension is required for consolidation of investment?

Wähle eine der folgenden:

  • rptcurrency

  • groups

  • transactioncurrency

  • inputcurrency

Erklärung

Frage 22 von 60

1

Transaction to access the “system_constants.lgf” and “MDXlib.lgf” , FxTrans.lgf ?

Wähle eine der folgenden:

  • UJFS

  • RSA1

  • UJD_ROUTINE

  • UJ_VALIDATION

Erklärung

Frage 23 von 60

1

What dimensions are used in "Carry Forward" (перенос остатков) business rule setting ? (3 correct answers)

Wähle eine oder mehr der folgenden:

  • Account (account - A)

  • Data source (audit - D)

  • Flow (subtables - S)

  • Currency (currency - R)

  • Category (category - C)

  • Entity (entity - E)

Erklärung

Frage 24 von 60

1

What should at least be done to set up the Work Status (3 correct answers)

Wähle eine oder mehr der folgenden:

  • Owner in the key dimension

  • Reviewer in the key dimension

  • At least one hierarchy in the key dimension

  • Enable data locking for a model

  • Enable audit for a model

Erklärung

Frage 25 von 60

1

What is the standard Task Porfile that involves the environment management ? (has the task : administration - manage environments)

Wähle eine der folgenden:

  • PrimaryAdmin

  • SecondaryAdmin

  • SystemAdmin

Erklärung

Frage 26 von 60

1

If you had selected “An Existing Model” while creating a model, you will then be able to copy the following objects (3 correct answers)

Wähle eine oder mehr der folgenden:

  • Data Manager Packages

  • Journal Templates

  • Control definitions

  • Task Profiles

  • Process Templates

  • Work Status

Erklärung

Frage 27 von 60

1

Default Data Manager packages types? (2 correct answers)

Wähle eine oder mehr der folgenden:

  • Data Management

  • Financial Processes

  • Report

  • Other functions

Erklärung

Frage 28 von 60

1

Required Dimensions for Ownership model (6 correct answers)

Wähle eine oder mehr der folgenden:

  • Account (A)

  • Category (C)

  • Entity (E)

  • Time (T)

  • Intercompany (I)

  • Group (G)

  • Currency (R)

  • Audit (D)

  • Subtables (S)

Erklärung

Frage 29 von 60

1

What settings need to be done to allow enter and save data in the EPM workbook?

Wähle eine der folgenden:

  • Sheet Option - Expand Options

  • Sheet Option - Data Input

  • Sheet Option - Member Recognition

  • User Option - Activate Metadata cache

Erklärung

Frage 30 von 60

1

What settings need to be done to use Comments (2 correct answers)

Wähle eine oder mehr der folgenden:

  • Enable Comments for Model

  • EPM Sheet options - Show as Excel comments

  • Create Direct update DSO for Comments

  • Activate Comments for Environment

Erklärung

Frage 31 von 60

1

What business rules are available for Financial model (6 correct answers)

Wähle eine oder mehr der folgenden:

  • Currency conversion

  • Account transformation

  • Intercompany bookings

  • US eliminations

  • Carry-forward rules

  • Validations

  • Automatic adjustments

Erklärung

Frage 32 von 60

1

What hierarchy does the Consolidation Monitor display ?

Wähle eine der folgenden:

  • Interco

  • Entity

  • Group

  • Ownership manager

Erklärung

Frage 33 von 60

1

Budget process extrapolate base amount across 12 month with a growth factor of 3% .
What EPM add-in manual Planning Function used?

Wähle eine der folgenden:

  • Weight

  • Spread

  • Forecast

  • Trend

Erklärung

Frage 34 von 60

1

If reopen a step (activity) in BPF, what status the next step would have?

Wähle eine der folgenden:

  • Reopen

  • Rejected

  • Delayed

  • Open

Erklärung

Frage 35 von 60

1

Context of Control Monitor for Financial Model
same question as
Which dimension types can you use for the context when you use the Controls Monitor in a financial model?
(3 correct answers)

Wähle eine oder mehr der folgenden:

  • Entity

  • Time

  • Category

  • Group

  • Account

  • Currency

Erklärung

Frage 36 von 60

1

EPM function to calculate variances (дисперсия) ?

Wähle eine der folgenden:

  • EPMComparison

  • EPMMemberProp

  • EPMExpendApl

  • EPMMemberOffset

Erklärung

Frage 37 von 60

1

What is entered in the destination group account when you configure AR/AP Intercompany Elimination using the Eliminations and Adjustments business rules?

Wähle eine der folgenden:

  • The intercompany AP account

  • The intercompany AR account

  • The offset account (PLUG account)

  • The same value as in the destination minority account

Erklärung

Frage 38 von 60

1

Who is notified when an activity is submitted in the Business Process Flow? Please choose the correct answer.

Wähle eine der folgenden:

  • Reviewer

  • Manager

  • Performer

  • Owner

Erklärung

Frage 39 von 60

1

Which of the following dimension types are mandatory for the Financial model type?
Note: There are 2 correct answers to this question?

Wähle eine oder mehr der folgenden:

  • I – Intercompany

  • T – Time

  • S – Subtable

  • D – Audit

  • C – Category

Erklärung

Frage 40 von 60

1

Which function do you use to display a dimension name?
Please choose the correct answer.

Wähle eine der folgenden:

  • EPMDimensionOverride

  • EPMDimensionProperty

  • EPMDimensionList

  • EPMDimensionType

Erklärung

Frage 41 von 60

1

Which business rules are used in the consolidation monitor?
Note: There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Account-based calculations

  • US eliminations

  • Eliminations and adjustments

  • Currency translation

  • Global definitions

Erklärung

Frage 42 von 60

1

Which of the following options can you use for drill through? Please choose the correct answer

Wähle eine der folgenden:

  • URL based on the current view

  • RFC connection based on the selected cell

  • URL based on the selected cell

  • RFC connection based on the current view

Erklärung

Frage 43 von 60

1

Which dimension type is optional for consolidation of investment?

Wähle eine der folgenden:

  • TIME

  • CURRENCY

  • GROUPS

  • CATEGORY

Erklärung

Frage 44 von 60

1

What benefits does BusinessObjects Planning and Consolidation offer to a corporation?
There are 3 correct answers to this question

Wähle eine oder mehr der folgenden:

  • It gives the IT department control over budgeting and planning functions

  • It integrates with the Microsoft Office Suite including Word, Excel, and PowerPoint

  • It enables compliance with IFRS and SOX

  • It enables you to drill through to the SAP-ECC system for reporting

  • It provides valid results when running SAP BW BEx queries on the BPC InfoCube

Erklärung

Frage 45 von 60

1

Which account is entered in the destination group account when you replace the US elimination business rule with the automatic adjustment business rule?

Wähle eine der folgenden:

  • Destination minority account

  • Destination equity account

  • Account in the ELIMACC property

  • Account with the STORE_ENTITY property

  • Intercompany accounts payable account

  • Intercompany accounts receivable account

Erklärung

Frage 46 von 60

1

What is the purpose of Appset Business Rules?

Wähle eine der folgenden:

  • Reclassification

  • Translation

  • Elimination

  • Validation

Erklärung

Frage 47 von 60

1

When you reopen a step in a Business Process Flow, what is the status of the successor step?

Wähle eine der folgenden:

  • Open

  • Rejected

  • Reopened

  • Pending

Erklärung

Frage 48 von 60

1

When using US Eliminations, which dimensions must be included in the Application?
The are 3 correct answers to this question:

Wähle eine oder mehr der folgenden:

  • Group

  • Time

  • DataScr

  • Entity

  • Category

Erklärung

Frage 49 von 60

1

Which activities are possible without additional programming while running a data management package in SAP BusinessObjects Planning and Consolidation for NetWeaver?
There are 3 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Load master data and texts from a BW InfoObject

  • Export master data to SAP ECC

  • Export texts for selected language to a flat file

  • Load transaction data from a BW InfoProvider

  • Export transaction data to a flat file

Erklärung

Frage 50 von 60

1

How can you use Xcelsius in an integrated scenario with SAP BusinessObjects Planning and Consolidation?
There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • To read live data by embedding EvDRE templates

  • To view Business Process Flows

  • To Simulate and write back data

  • To view the Dynamic Hierarchy Editor

  • To modify dimension properties

Erklärung

Frage 51 von 60

1

Which transformation file parameter do you use for filtering when you import data from an InfoProvider.

Wähle eine der folgenden:

  • AMPUNTDECIMALPOINT

  • MAXREJECTACCOUNT

  • SKIP

  • SELECTION

Erklärung

Frage 52 von 60

1

You have created the controls and a user has tested them for the current period. However, the user does not see the controls …… the Controls Monitor. How do you resolve this issue?

Wähle eine der folgenden:

  • Change the work status in the Consolidation Monitor for the following period

  • Assign the control set to the following period

  • Grant authorization to the user to view the controls for following period

  • Assign the control level to the following period

Erklärung

Frage 53 von 60

1

What is ALWAYS copy when you create model using existing one?
Когда создается новая модель на основе другой модели, что копируется всегда

Wähle eine der folgenden:

  • transactional data

  • control definition

  • journal templ

  • dm pack

Erklärung

Frage 54 von 60

1

Cons monitor displays blank screen for current period although the previous period has been displayed properly
В чем причина?

Wähle eine der folgenden:

  • no master data exist

  • no exchange rate exist

  • no ownership rec exist

  • no trial balance exist

Erklärung

Frage 55 von 60

1

Which of follow task can you perform from Consolidation monitor (2 correct answers)

Wähle eine oder mehr der folgenden:

  • Ownership calc

  • Controls

  • Consolidation

  • DM package

  • Currency transl

Erklärung

Frage 56 von 60

1

Что должно быть выполнено, чтобы Dashboard использовал данные BPC

Wähle eine der folgenden:

  • BPC data grid must be used in Dashboard

  • EPM report must be created

  • a list of models must be generated in the EPM report

  • run time connection должно быть между BPC и Dashboard

Erklärung

Frage 57 von 60

1

When a user tries to log in to an Application using BPC for Excel, the Application does not appear in the list of available Applications the user just created.
What is the problem?

Wähle eine der folgenden:

  • The user is not created correctly

  • The Application is not created correctly

  • The member access profile is not correct

  • The task profile is not correct

Erklärung

Frage 58 von 60

1

What determines the user access to BPC Applications?
Note: There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Profile SAP_ALL

  • Secured dimensions

  • Member access profile

  • User/team assignment

Erklärung

Frage 59 von 60

1

You want to format your account members dynamically in an EVDRE report.
In which column do you have to enter the value 'NUMBERFORMAT=ACCOUNT.FORMAT'?

Wähle eine der folgenden:

  • PARAMETERS

  • CRITERIA

  • FORMAT

  • USE

Erklärung

Frage 60 von 60

1

For which users does the system prevent saving templates to the company folder?
Note: There are two (2) correct answers to this question.

Wähle eine oder mehr der folgenden:

  • For a non admin user with the Manage Template task

  • For a non admin user without the Manage Template task

  • For a user with the Primary Admin default function task

  • For a team leader with the Manage Template task

  • For a team leader without the Manage Template task

Erklärung