Q24. Where can you change a data lock status? Note: There are 2 correct answers to this question.

Q25. You are creating an allocation step to distribute expenses from the HR cost center to your operating cost centers. Which dimension setting controls how much is distributed to each operating cost center?

Q26. What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question.

Q27. In which types of data source can you concatenate data? Note: There are 3 correct answers to this question.

Q28. You want to save your data analyzer result. What is it saved as?

Q29. To which story elements can you apply conditional formatting? Note: There are 2 correct answers to this question.

Q30. You have a story based on an import model. The transaction data in the model’s data source changes. How can you update the data in the model? Note: There are 2 correct answers to this question.

Q31. You are creating a script for an advanced data action. Which character designates a virtual variable member?

Q32. You have a dimension with members for product groups and products. Each product group has associated products. You want to plan by product group without disaggregating into the products. How can you do this?

Q33. What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct answers to this question.

Q34. You are creating a styling rule for a table with a hierarchy of Country, Region, and City. You want to apply the styling rule only to countries. Which level option must you use?

Q35. You want to display differences between measures in a chart. What can you use?

Q36. What source system can you connect to with a live connection?

Q37. You are creating a data action to copy data from one year to the next.In the parameter for the source year, which default setting must you change?

Q38. When scrolling down in a long table, how can you retain column headers? Note: There are 2 correct answers to this question.

Q39. You want to use an input control to filter data appearing in a story. At what level is the filter applied?

Q40. You import data into a dataset. One of the columns imported is Year, and SAP Analytics Cloud interprets it as a measure. How can you ensure that it is treated as a calendar year?

Q41. You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question.

Q42. You are creating a styling rule for a table. What is the context?

Q43. In a planning data model, what dimensions are included by default? Note: There are 2 correct Answers to this question.

Q44. You have a story in My Files. You want your colleague to review and comment on the story. What must you do?

Q45. Which dimension type can you use like a measure?

Q46. You have a live data model with two dimensions: Firstname and Lastname. Users want a single dimension in the data model that displays the dimensions as Lastname, Firstname. What must you do?

Q47. How can you help a user enter data faster in a planning story? Note: There are 2 correct answers to this question.