SAP Certified Application Associate - SAP Analytics Cloud: Planning

Question 1

Which of the following are prerequisites to export transaction data to a DataStore object (advanced) in SAP Business Warehouse? Note: There are 2 correct Answers to this question.

A. SAP Business Warehouse connection

B. Maintenance view RSBPC_ODATA_V_EX

C. Enhancement spot RSBPC_ODATA

D. OData connection

Correct Answer: B,D

Question 2

Your account dimension has an account for Profit that is calculated as [Revenue] - [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?

A. [Revenue] - [Cost] := INVERSE ([Cost] = [Revenue] - [Profit])

B. [Revenue] - [Cost] | INVERSE ([Cost] := [Revenue] - [Profit])

C. [Revenue] - [Cost] | INVERSE ([Cost] = [Revenue] - [Profit])

D. [Revenue] - [Cost] := (INVERSE [Cost] := [Revenue] - [Profit])

Correct Answer: B

Question 3

What data sources are available for SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct Answers to this question.

A. SAP Analytics Cloud

B. SAP S/4HANA Cloud for group reporting

C. SAP BusinessObjects Universe

D. SAP HANA

Correct Answer: A,D

Question 4

Which of the following actions would allow you to use data point comments? Note: There are 2 correct Answers to this question.

A. Activate comments by model.

B. Insert a calculated column to a table.

C. Activate comments by dimension.

D. Add a comment widget to the story.

Correct Answer: B,D

Question 5

Which work files can you access when you run a planning process? Note: There are 2 correct Answers to this question.

A. Dashboard

B. Workbook

C. Analytic application

D. URL link

Correct Answer: C,D

Question 6

What SAP Business Warehouse data can you import into SAP Analytics Cloud? Note: There are 2 correct Answers to this question.

A. SAP BW query text elements

B. Calculated key figures

C. Hierarchical characteristic structures

D. Characteristic structures

Correct Answer: B,D

Question 7

Which account types allow you to display database values with the opposite sign in stories? Note: There are 2 correct Answers to this question.

A. EXP

B. LEQ

C. AST

D. INC

Correct Answer: B,D

Question 8

How can you use a data action to copy data from one version to another while keeping the account number the same? Note: There are 2 correct Answers to this question.

A. Include a parameter for version and account in the filter section of the data action.

B. Include 'to' & 'from' parameters for version and account in the copy rules.

C. Include a parameter for version in the filter and 'to' & 'from' parameters for the account dimension in the copy rules.

D. Include a parameter for account in the filter and 'to' & 'from' parameters for version in the copy rules.

Correct Answer: A,C

Question 9

You imported a transaction data file into an empty model with the results as shown in Figure A.
Later, a member of the finance team wants you to import a new data file. In the new data file, you find the following differences: The value of the Labor account has increased to 1600. There is a new record for the Services account, with a value of 250. The record for the Travel account has been deleted. To achieve the result shown in Figure B, which option must you use to update the data?

A. Clean and replace subset of data with Scope = Version and Account

B. Append: Reject duplicated rows in model

C. Update

D. Clean and replace selected version data

Correct Answer: C

SAP Certified Application Associate - SAP Analytics Cloud: Planning - C-SACP-2107 Exam Practice Test

Latest Update

Useful Links

Contact Us