TEST_SAC

1. Which formats are supported for scheduling a publication? Note: There are 2 correct answers to this question. Microsoft PowerPoint. Adobe PDF. Microsoft Excel. Microsoft Word.

2. What can you do with Smart Discovery? Note: There are 2 correct answers to this question. Simulate Forecast. Identify data relationship. Simulate Numeric Targets. Identify data model relationships.

3. You have two tables in your story page. Table 1 displays revenue by location from the finance model. Table 2 displays quantity shipped by location from the shipping model To pass a filter value from table 1 to table 2, what must you do? Note: There are 2 correct answers to this question. Enable linked analysis. Add a link formula. Add a linked dimension. Add a linked model.

4. You need to create a calculated measure for “Current Month Forecast” using a cross calculation. What type of calculation must you use?. Forecast. Rolling Forecast. Resctricted Measure. Calculated Measure.

5. Which feature generates story pages?. Search to Insight. Smart Discovery. Smart Insights. Smart Predict.

6. What are data sources for the analytics designer? Note: There are 2 correct answers to this question. Microsoft Excel spreadsheets. SAP Analytics Cloud models. SAP Data Warehouse Cloud tables. OData services.

7. When you bookmark a story, what user changes are included?. Formatting. Formulas. Filters.

8. Which transformation functions can you use when wrangling data? Note: There are 3 correct answers to this question. Concatenate. Replace. Substring. Split. Look up.

9. What objects can you use to define a measure range in a report? Note: There are 2 correct answers to this question. Calculation input control. Page input control. Table filter. Story filter.

10. Which of the following structures can an SAP Analytics Cloud story be based on? Note: There are 2 correct answers to this question. Models. Persistent tables. Datasets. Virtual Tables.

11. What formats can you change with story preferences? Note: There are 2 correct answers to this question. Time. Lane. Date. Text.

12. Why would you choose a Classic model over a New model?. Wrangling is faster. Dimension members can be created during the model import. Multiple measures are possible.

13. Which of the following are exception aggregation types in SAP Analytics Cloud? Note: There are 3 correct answers to this question. Average. YTD. Last. Abs. None.

14. What can you use to group by region in a story?. A measure-based dimension. A page break. The auto size and page table vertical setting. A section widget.

15. Which of the following options are included with the SAP Analytics Cloud, embedded edition? Note: There are 2 correct answers to this question. Planning professional license. Import connections. Live connections. Business intelligence license.

16. From which of the following locations can you export a model?. My files folder. Content network. Public files folder.

17. In basic story design, which advanced mathematical predictions can you choose to create a forecast? Note: There are 2 correct answers to this question. Linear regression. Moving average. Extrapolation. Exponential smoothing.

18. How can you create a threshold for a cost as a percentage of revenue?. Add a threshold that compares account values. Add a threshold based on a numeric range. Add a threshold that compares measures values.

19. If you share a story with Access mode Edit, what can recipients do to the story? Note: There are 2 correct answers to this question. Delete comments. Copy the story. Add comments. Share the story.

20. Which of the following features are fully supported in the iOs app of SAP Analytics Cloud? Note: There are 2 correct answers to this question. RSS reader. Single sign-on. SAP BW variables. OS notifications.

21. In the Analytics Designer, what are advanced scripting capabilities? Note: There are 3 correct answers to this question. Graphical scripting interface. JavaScript. Auto Scripting. Content assistance. Auto Complete.

22. What can you do after you add a linked model to a table widget?. Use hyperlinks. Create formulas based on multiple models. Combine data in a database table.

23. You are in the builder pane of a story and you cannot edit a calculated measure. What could be the reason? Note: There are 2 correct answers to this question. The calculated measure is used in several pages. The calculated measure is a model formula. The calculated measure is a cross calculation. The calculated measure is a table formula.

24. You need to create a dimension in your story to define high and low profit levels as “High” and “Low”. What type of calculation must you use?. Cross calculation. Calculated dimension. Measure-based dimension. Dimension as a measure.

25. Which feature does Smart Predict support?. Smart transformations. Data Discovery. Business Intelligence. Enterprise Planning.

26. In which SAP Analytics Cloud function are linear regression and exponential smoothing available?. Predictive Forecast. Smart Predict. Smart Discovery. Search to Insight.

27. In geo map, how does a choropleth layer present data?. It shows connections between two locations. It applies blocks of shading to locations. It uses color to visualize data density. It shows data as points on the map.

28. Which collaboration type is supported by SAP Analytics Cloud? Note: There are 3 correct answers to this question. Projects groups. Comment. Discussion. Chat. Calendar task.

29. Which analytical processes does SAP Analytics Cloud offer? Note: There are 3 correct answers to this question. Data Integration. Business Intelligence. Augmented Analytics. Enterprise Planning. Data orchestration.

30. Which of the following SAP BW/4HANA query features are supported in a live connection? Note: There are 3 correct answers to this question. Display attributes. Conditions. Navigation attributes. Structures. Times depends of hierarchy.

31. What can you do with the Geo map widget of SAP Analytics Cloud? Note: There are 2 correct answers to this question. Select the map provider. Select different data sources for each layer. Define custom regions with JSON files. Select the basemap template..

32. In the new model, which of the following patterns you can use for week granularity . Note: There are 2 correct answers to this question. 4-4-4. 12x4. 13x4. 4-4-5.

33. Which of the following tools can you use to present your SAP Analytics Cloud stories? Note: There are 2 correct answers to this question. Content network. SAP Analytics Catalog. Analytics applications. SAP Digital Boardroom.

34. Which filter operations can be used in SAP Analytics Cloud, add-in for Microsoft Office? Note: There are 2 correct answers to this question. Filter by hierarchy node. Filter by property. Filter by measure value. Filter date by current and prior period.

35. SAP Analytics Cloud is part from which platform?. SAP business intelligence platform. SAP business technology platform. SAP Hana cloud platform.

36. You are using Microsoft Office 365. Which SAP Analytics Cloud planning features are supported with SAP Analytics Cloud, add-in for Microsoft Office? Note: There are 2 correct answers to this question. Revert. Data action. Cell locking. Publish.

37. When you are connected to SAP Analytics Cloud, which of the following SAP Analysis for Microsoft Office features can you use in a spreadsheet? Note: There are 2 correct answers to this question. Advanced calculations. SAP Analysis Cloud functions. SAP formula functions. Dynamic calculations.

38. In SAP Analytics Cloud, how can you create users? Note: There are 3 correct answers to this question. Create manually. Create via the Simple Cloud Identity Management (SCIM) API. Import from a file. Import from an SAP BW system. Import from an SAP HANA system.

39. You have 2 models, each with the following dates: Model1 Model2 Jun-03 Jun-06 Jun-04 Jun-07 Jun-05 Jun-08 What link type must you choose to return the dates: Jun-03, Jun-04, and Jun-05?. All primary data. Intersecting data only. All data.

40. Which property is generated by the system when you create Organization dimensions?. Reviewer. Owner. Manager. Person responsible.

41. Which feature is available with chart scaling? Note: There are 2 correct answers to this question. Set bar widths by dimension. Set bar widths by measure. Break scale. Number scaling.

42. Which global performance indicators does Smart Predict use Note: There are 2 correct answers to this question. Prediction Confidence. Predictive Statistics. Prediction Classifications. Predictive Power.

43. On what objects can you use linked dimensions? Note: There are 2 correct answers to this question. Tables in analytic applications. Calculations in stories. Tables in data analyzer insights. Filters in stories.

44. What can you add to a Data Analyzer Insight? Note: There are 2 correct answers to this question. Filters. Table calculations. Advanced filters. Restricted measures.

45. What objects can you publish to a catalog? Note: There are 2 correct answers to this question. Stories with grid pages. Stories with responsive pages. Public dimensions. Private dimensions.

46. What can you import into a digital Boardroom?. SAP Analytics Cloud add-in Microsoft Office workbook. Stories. Analytics applications.

47. Why would you use an analytic application instead of a story?. To perform enterprise planning. To blend models. To use quick menus.

48. In the SAP Business Technology Platform, what provides data quality capabilities?. SAP Analytics Cloud. SAP Data Warehouse Cloud. SAP Data Integration Service.

49. From where can you access Explorer? Note: There are 2 correct answers to this question. From an existing dataset. From the SAP Analytics Cloud home page. From the Data view of a story. From the modeler.

50. To create a story by dragging a data file on to the SAP Analytics Cloud home page, what options do you have? Note: There are 2 correct answers to this question. Use Search to Insight. Explore data. Prepare dataset. Combine data.

51. In the analytics designer, what can you do with scripting Note: There are 2 correct answers to this question. Organize widgets on the canvas. Implement cascading filter behavior. Display popup dialogs. Move widgets from canvas to panel.

52. Which hyperlink options does the text widget have? Note: There are 3 correct answers to this question. Page. Catalog. Analytic application. Story. Mobile App URL.

53. Which of the following programming languages can you use to configure widgets in SAP Analytics Cloud? Note: There are 2 correct answers to this question. HTML. Javascript. R. Java.

54. What feature does a live connection for universe data provide?. Read/Write access from SAP Analytic Cloud. Smart Transformations. Automatic time determination in stories. Universe security to control data access.

55. In SAP Analytics Cloud, where can you modify data security settings?. Hierarchies Single sign-on. Model preferences. Story preferences.

56. From where must you import delivered content?. From service.sap.com. From the content network. From a zip file.

57. What objects can be used to control visibility of transaction data stored in an SAP Analytics Cloud model? Note: There are 2 correct answers to this question. Data management. Data locks. Data access controls. Roles.

58. In SAP Analytics Cloud, where can you create an input task? Note: There are 2 correct answers to this question. Story. Model. Worksheet. Calendar.

59. Which object must you configure to use a live connection to an SAP BusinessObjects universe?. SAP Analytics Cloud connector. SAP BussinessObjects Enterprise Live Data Connect. SAP Analytics Cloud agent. SAP Info Access.

60. What data source is typically associated with ad hoc analysis in a story?. Dataset. Data file. Analytic model. SAP HANA analytic view.

61. How do you configure a comment column in a table?. Add a calculation. Add a measure. Add an input control.

62. Which scenario types can you select when you create a new Predictive Scenario in SAP Analytics Cloud? Note: There are 2 correct answers to this question. Classification. Regression. Linear Regression. Exponential Smoothing.

63. Which of the following can SAP Analytics Cloud Explorer suggest?. Visualizations based on story’s data source. Analytic applications based on a story’s data source. Information spaces for SAP BusinessObjects Enterprise. Models based on data in uploaded file.

64. What is unique about responsive pages?. You can add lanes. You can order charts from back to front. You can enable Snap to grid. You can set page size to dynamic.

65. From where can you schedule a story? Note: There are 2 correct answers to this question. Files. Catalog. System. Canvas pages.

66. You need to store story-specific transaction data in SAP Analytics Cloud. Which structure can you use?. Planning model. Analytic model. Dataset.

67. You have an existing bar chart that displays domestic revenue account values by region. You want to display the difference between these domestic values and the foreign revenue account values. What can you do?. Select a recommended comparaison in the builder pane. Use the variance waterfall chart setting. Select Add Variance in the builder panel.

68. Which of the following features are supported by SAP Analytics Cloud, add-in for Microsoft Office? Note: There are 2 correct answers to this question. Member selector. Cell locking. Comments. Error pane.

69. Which widget type would you choose to display a word cloud?. Chart widget. Custom widget. R visualization. Text widget.

70. What are characteristics of SAP Analytics Cloud comments? Note: There are 2 correct answers to this question. They can be selected by a leaf node's parent. The most recent comment is shown. They can only be added to header cells of a table. The maximum length is 1000. They can be copied between categories.

71. You want to create a task with assignees and reviewers. Which task type must you select?. Data Action task. Composite task. Smart Grouping.

72. Which predictive features do all live data models fully support? Note: There are 2 correct answers to this question. Smart Discovery. Time series forecasting. Smart Insights. Smart Grouping.

73. What are special features of planning models? Note: There are 3 correct answers to this question. They require a time dimension. They can define data actions. They support categories. They can create currency conversion tables. They support version management.

74. What must you set up to import data from SAP BW to SAP Analytics Cloud? Note: There are 2 correct answers to this question. Direct connection. SAP BTP Cloud connector. SAP Analytics Cloud agent. Tunnel connection.

75. In SAP Analytics Cloud, you have blended two models in a story. What is the consequence?. The links between the models can be used in that story only. A new model is created. The original models are modified. The links between the models can be used in other stories.