EMT Practice Test

1. Question Content...


Question List

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

Question2: You have a planning model with the following dimensions: account, product, profit center, date, and version. In a story, which new master data can you add on the fly? Note: There are 2 correct Answers to this question.

Question3: 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?

Question4: Where can you enter data into an SAP Analytics Cloud model? Note: There are 2 correct Answers to this question.

Question5: In SAP Analytics Cloud, where can you apply data security ? Note: There are 2 correct answers to this question.

Question6: You are working on a flat file-based planning model. You want to prevent manual data entry for certain data intersections. What options do you have? Note: There are 2 correct Answers to this question.

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

Question8: 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?

Question9: When you run a data action with the "publish target version automatically" setting enabled, what changes to your data are published? Note: There are 2 correct Answers to this question.

Question10: In a rolling forecast table, what can be used to determine the date to cut over to plan data?

Question11: Which of the following actions on the date dimension are available in Value Driver Trees? Note: There are 2 correct answers to this question.

Question12: 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.

Question13: What are the pillars of SAP Analytics Cloud? Note: There are 3 correct answers to this question.

Question14: 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?

Question15: What can you do with live connections in SAP Analytics Cloud? Note: There are 2 correct answers to this question.

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

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

Question18: 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? Choose the correct answer.

Question19: Which of the following SAP Business Warehouse variable types can be used when importing data to SAP Analytics Cloud? Note: There are 2 correct Answers to this question.

Question20: 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?

Question21: What dimension types can be used to determine currencies? Note: There are 2 correct answers to this question.

Question22: Which scenarios can you implement using SAP Analytics Cloud advanced formulas? Note: There are 2 correct Answers to this question.

Question23: In a story, you are using a planning model with currency translation enabled. Which properties in the cross calculation editor do you have when configuring currency conversion? Note: There are 2 correct answers to this question.

Question24: You need to copy data from one version to another for a group of customers. For privacy reasons, you want the results to be copied to an unassigned customer. Where do you specify this in your data action?

Question25: You are planning with two hierarchies that have different granularity. Your model contains no data. The story has two pages: a parent planning page and a member planning page (see screenshot). In the Member Planning page you enter the following data: Brazil 100, Chile 100, Peru 100 In the Parent Planning page you enter the following data: North America 10000, South America 30000 When you go back to the Member Planning page, what will you see? Note: There are 2 correct Answers to this question.

Question26: You enter the following code into the formula script editor: MEMBERSET[d/Account]= What does the auto-complete feature return? Note: There are 2 correct Answers to this question.

Question27: When you delete a planning model, what dimension types are always deleted? Note: There are 2 correct Answers to this question.