XMAS ANALYT 2501

1. Your story takes a long time to open. What could cause this? (3 correct answers). Large calculation scope. Many story filters. Many hyperlinks. Complex formatting. Many data sources.

2. What can you do to reduce the data refresh time when opening a story? (3 correct answers). Use responsive pages. Avoid tables with more than 500 rows and 60 columns. Load widgets in the background. Use conditional formatting. Avoid prompts.

3. You have a column chart in a story. You notice some of the labels are missing until you mouse over the data point. How can you ensure that the labels are always visible?. Increase the overall size of the chart widget on the page. Select the Avoid Data Label Overlap checkbox. Increase the font size of the axis labels.

4. You have a story in My Files. You want your colleague to review and comment on the story. What must you do?. Create a Review task for the story. Add a Comment widget to the story. Share with View access. Include the story in a Discussion.

5. How can you help a user enter data faster in a planning story? (2 correct answers). Select fluid data entry mode in the story. Enable Optimize Recommended Planning Area in the model. Set Size Limits for Planning Performance in the model. Enable unbooked data in the story.

6. How can you limit the refresh time of a story?. Use canvas pages. Collapse the hierarchy. Create calculated measures. Implement a value driver tree.

7. You want to display differences between measures in a chart. What can you use?. Variance. Restricted measure. Threshold. Reference line.

8. What is required to use version management in a story?. Planning model. Classic mode. Analytic model. Optimized mode.

9. Which calculation types include dynamic date options? (2 correct answers). Aggregation. Restricted Measure. Difference From. Date Difference or Dimension to measure.

10. 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?. Self. Self and Descendants. Self and Siblings. Self and Children.

11. What can you use to perform cell-based calculations in a story?. Table formulas. Calculated measures. Dimension formulas. Restricted measures.

12. You are creating a styling rule for a table. What is the context?. The most granular level in the table. The highest level in the table. The table header. The location of the cursor.

13. For which activities must you enable Advanced Mode in story design? (2 correct answers). Add JavaScript to a button. Add a popup or radio button. Add a layer to a geo map. Add a custom widget.

14. Which features are available in the Optimized Design Experience? (3 correct answers). Undo button. Grid pages. Linked widgets diagram. Composites. Explorer.

15. When scrolling down in a long table, how can you retain column headers? (2 correct answers). Enable Keeping member names visible. Enable Auto-Size And Page Table Vertically. Freeze up to row. Freeze up to column.

16. You want to use an input control to filter data appearing in a story. At what level is the filter applied?. Calculation. Page. Component. Story.

17. What can you use input controls for in a story? (2 correct answers). Changing dimensions or measures displayed in a table. Filtering data on a page. Selecting an alternate data source. Implementing row-level and column-level security in a table.

18. To which story elements can you apply conditional formatting? (2 correct answers). Table. Chart. Lane. Composite.

19. You are designing a new story. You want the size and position of widgets to adjust dynamically for viewing on different devices and screen sizes. Which page type must you use?. Grid. Responsive. Composite. Canvas.

20. Which programming language is used for scripting in an SAP Analytics Cloud story?. Python. Wrangling Expression Language. ABAP. JavaScript.