March Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

SAP C_EPMBPC_11 SAP Certified Application Associate - SAP Business Planning and Consolidation 10.1 and 11.0 Exam Practice Test

Demo: 34 questions
Total 233 questions

SAP Certified Application Associate - SAP Business Planning and Consolidation 10.1 and 11.0 Questions and Answers

Question 1

Identify three function category from the following (3)

Options:

A.

EPM functions

B.

PCL function

C.

FPMXL client. Technical Category

D.

EV Functions

E.

BSNL

Question 2

You are configuring comments in BPC Embedded. Which objects are required? Note:There are 2 correct answers to this question.

Options:

A.

An AdavancedDataStore Object

B.

A Characteristics as key figure

C.

A system-generated data table

D.

A CompositeProvider

Question 3

You are formatting an EPM Report.Which of the following features are configured in the EPM formatting sheet? (2)

Options:

A.

Indent children

B.

Hierarchy levels

C.

Data validation

D.

Repeat row headers

Question 4

What step is required when setting up Finance or Consolidation Application compared to other Applications?

Options:

A.

Select Application options

B.

Select copy options

C.

Select source Application

D.

Modify Application

Question 5

Which of the following options can you use for drill through? (1)

Options:

A.

RFC connection based on the current view

B.

URL based on the current view

C.

URL based on the selected cell

D.

RFC connection based on the selected cell

Question 6

You use the INC account type for revenue accounts and the EXP account type for expense accounts. What is displayed in a planning and consolidation report when incomes are stored as negative values and expenses are stored as a positive values (dimensions)? 2 BPC440

Options:

A.

Positive revenue values

B.

Positive expense values

C.

Negative revenue values

D.

Negative expense values

Question 7

The Consolidation Monitor displays a blank screen for the current period although the previous period has been displayed properly. What is missing? (1)

Options:

A.

Ownership data

B.

Master data

C.

Exchange rate data

D.

Trial balance date

Question 8

What is entered in the group account when you configure AR/AP intercompany eliminations and adjustment business rule?

Please choose the correct answer.

Options:

A.

the intercompany AP account

B.

the intercompany AR account

C.

the same value as in the destination minority account

D.

the offset account

Question 9

Which of the following dimension types are mandatory for the Financial model type? (3)

Options:

A.

Audit

B.

Category

C.

Time

D.

Intercompany

E.

Currency

Question 10

22. You are working in a BPC Embedded System.

What options do you have when maintaining members and properties of local dimensions?

Note: There are 2 correct answers to this question.

Options:

A.

Enable time dependent properties.

B.

Update property values for global members.

C.

Add a member that does NOT exist in a global dimension.

D.

Delete global members

Question 11

Which fields are required to eliminate the investment when using the All Formula? (2)

Options:

A.

Destination All

B.

Destination Group Account

C.

Source Account

D.

Destination Equity Account

E.

Account

F.

Destination Minority Interest

Question 12

Which of the following delivered task profiles allows you to maintain environment? (1)

Options:

A.

secondary admin

B.

System Admin

C.

primary Admin

D.

system security

Question 13

What tasks can be done using the Web Administration? (2)

Options:

A.

Activating but not deactivating auditing

B.

Adjusting the version number of a report template

C.

Changing documents type but not document subtype

D.

Setting up file types

Question 14

The access rights you can assign to the sets of members are (3)

Options:

A.

Write

B.

Denied

C.

Read only

D.

Accept

E.

Follow

Question 15

When validating the 'FXTrans.LGF' file, you get a validation error stating that the currency dimension is missing a property. What property is missing? 1

Options:

A.

GROUP_CURRENCY

B.

STORE_GROUP_CURR

C.

CURRENCY_TYPE

D.

PARENT_GROUP

Question 16

In SAP BusinessObjects Planning and Consolidation for NetWeaver, the language texts are missing. How do you fix this issue? (1)

Options:

A.

Refresh dimension members.

B.

Load data from the InfoProvider.

C.

Import transaction data.

D.

Import master data descriptions.

Question 17

Your customer wants to load certain accounts with both local and reporting currencies without doing a currency translation. Which expression in the formula of the business rule for currency conversion can you use to achieve this? 1 BPC440

Options:

A.

[COPYLC]

B.

[END]

C.

[NOTRANS]

D.

[ASJS]

Question 18

SAP BPC 11.0 is based on SAP BW/4HANA.

Which traditional BW InfoProviders were replaced with Advanced DataStore Object?

Note: There are 2 correct answers to this question

Options:

A.

Persistent Staging Area

B.

VirtualProvider

C.

InfoCube

D.

MultiProvider

Question 19

What interfaces can you use during the step Define Action when setting up a BPF? (1)

Options:

A.

Data Audit, BPC for Excel, BPC for PowerPoint

B Journal, BPC for Excel, BPC for Word

B.

BPC Administration, BPC for Excel, BPC for Word

C.

Manage Books, BPC Web, BPC for Word

Question 20

How many journal templates are in a model. 1 BPC440

Options:

A.

Based on the no of dimensions

B.

Only one journal template per model.

C.

N no of journal templates.

D.

Journal templates are app set specific.

Question 21

Which dimensions can you use to configure the "carry-forward business rule"? (3)

Options:

A.

Account

B.

Entity

C.

Time

D.

Data Source

E.

Flow

Question 22

Which if the following dimension types are required? (4)

Options:

A.

Account

B.

Entity

C.

Time

D.

Currency

E.

Category

F.

Intercompany

Question 23

Vol are working in a BPC Standard system

Which of the following dimension types can be used as reference dimensions for referential integrity?

Note: There are 2 correct answers to this question.

Options:

A.

Entity

B.

Time

C.

Audit

D.

Subtables

Question 24

How can an Aggregation Level be used? Note: There are 3 correct answers to this question

Options:

A.

As an InfoProvider for consolidation models.

B.

As an InfoProvider for planning queries.

C.

As an InfoProvider for characteristic relationships.

D.

To store summary data.

E.

To determine the level of granularity.

Question 25

47. You have two models: one for Expense, and another for Sales. Both models have the same Profit Center dimension. You would

like users to perform reporting on both models as follows:

In column A: Expense values fn column B: Profit centers in column C Sales values

Which methods can you use to accomplish this requirement?

Note: There are 2 correct answers to this question.

Options:

A.

'Shared axis' reporting.

B.

The 'repeat row headers' property

C.

'EPMRetrieveData' formulas.

D.

The 'outer dimensionl option.

Question 26

For which calculation do you have to use a different implementation method than Business Rules? 1 BPC440

Options:

A.

Automatic adjustment

B.

Account transformation

C.

Allocation

D.

Currency conversion

Question 27

You EPM Report is enabled to send data and comments. You type in a revenue value and a comment in the EPM report and save the data. Where is the data stored? (1)

Options:

A.

The revenue data in a infocube and the comment in a DataStore Object

B.

Both the revenue value and the comment in a Infocube

C.

The revenue data in a infocube and the comment in another database table

D.

Both the revenue value and the comment in a DataStore Object

Question 28

You want to use a data manager package to load data from an InfoProvider in BPC for NetWeaver. What is supported? (2)

Options:

A.

Using JavaScript in the transformation files

B.

Mapping only one key figure to the target data although source data has multiple key figures

C.

Loading data from an InfoCube, but not from a DataStore Object

D.

Selecting data pertaining to specific master data values to load

Question 29

How do you allow data entry and posting in a BPC Excel sheet? (1)

Options:

A.

Use a hierarchical structure for member values.

B.

Set the workbook option to 'Refresh automatically1.

C.

Use base members.

D.

Add a row to show the variance of the plan.

Question 30

You select a parent in the detailed section of the control definition. Which option do you choose to ensure that the control will be executed for each member of the selected parent? (1)

Options:

A.

Threshold Level

B.

Control Status

C.

Control Level

D.

Breakdown Dimension

Question 31

You are working with BPC Embedded in a replicated scenario. You need to create a Local Provider. Aside from the Native SAP HANA table, which other objects are system generated? Note: There are 2 correct answers to this question.

Options:

A.

External calculation view

B.

Workspace

C.

BW Query

D.

Aggregation level

Question 32

You need to run a planning sequence while data is being saved Which object do you attach the planning sequence to?

Options:

A.

Process chain

B.

Planning query

C.

CompositeProvider

D.

Advanced DataStore Object

Question 33

You are using B PC 11.0 for SAP BW/4HANA.

From which objects can you create an aggregation level?

Note: There are 3 correct answers to this question

Options:

A.

MultiProviders

B.

CompositeProviders

C.

Advanced Data Store Objects

D.

infoCubes

E.

LocalProviders

Question 34

You want to calculate revenues as a product of the unit sold and price for unit and save the results in database How can you achieve this? (1)

Options:

A.

Use the logic script

B.

Use the dimension member formulas

C.

Use the worksheet logic

D.

Use business rules

Demo: 34 questions
Total 233 questions