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

Q13. How can you change plan data via the Planning Panel in a story? Note: There are 2 correct answers to this question.

Q14. 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?

Q15. When you import data into a planning model, what can you do with category and version in data management?
Note: There are 3 correct answers to this question.

Q16. What node types can be imported from S/4HANA? Note: There are 3 correct answers to this question.

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

Q18. In SAP Analytics Cloud, what must you do when you use a planning model with group reporting data for legal elimination reports? Note: There are 2 correct answers to this question.

Q19. You saved data for a certain cost center and profit center combination. Later, an administrator created a validation rule that prevents saving data against that combination. What happens when you display the data in a story?

Q20. You are running a predictive forecast.
What could the data lines represent in the preview?
Note: There are 2 correct answers to this question.

Q21. You need to plan with finance data from SAP S/4HANA in SAP Analytics Cloud. To get started, you need to import master data from SAP S/4HANA. You are following the steps recommended by SAP. From which source can you import master data from SAP S/4HANA?

Q22. Which SAP Analytics Cloud Machine Learning function provides performance indicators that can be used to evaluate the accuracy of a statistical model?

Q23. What can you do in an analytic application?

Q24. Which data locking status can you use to prevent manual data entry?

Q25. You have financial data from SAP S/4HANA with local currency, group currency, and quantity values. You need to import the data into SAP Analytics Cloud. Following the SAP best practice guidelines, how would you design a New Model?

Q26. Why would you use the SAP Analytics Cloud add-in for Microsoft Office instead of SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct answers to this question.

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

Q28. You create a dimension in SAP Analytics Cloud with a hierarchy. You want to update the new dimension with data from a characteristic in SAP Business Warehouse using SAP recommended practices. To populate the members and the hierarchy, what steps must you take? Note: There are 3 correct answers to this question

Q29. You have a planning model with the following dimensions; Cost Center, Account, Date, Entity, Version.
When you add new transactional data to your model, you want to overwrite any records with cost center A and add new data for cost center B.
Which import method do you use?

Q30. You want to create a copy data action that allows you select the source values and target values for the following dimensions at run time; Version. Account. Time. What do you specify for each of these dimensions?

Q31. You have an SAP Business Warehouse data source with 25 key figures and no account characteristic. What must you do to import this data into an existing planning model? Note: There are 2 correct answers to this question.

Q32. What can you schedule from the SAP Analytics Cloud calendar? Note: There are 2 correct answers to this question.