C_SAC_2501 Practice Test Questions

60 Questions


What is required to use version management in a story?


A. Planning model


B. Classic mode


C. Analytic model


D. Optimized mode





A.
  Planning model

Explanation:

Version management is a core feature of the planning and forecasting capabilities within SAP Analytics Cloud. Its primary purpose is to allow users to create, compare, and work with different scenarios (e.g., "Actual," "Budget," "Forecast," "Version 1") for planning data.

Planning Model: This is a specific type of model in SAC that has planning features enabled. Only models created as or converted to a planning model support write-back operations, data locking, and version management. Without a planning model, the story is purely analytical (read-only), and the concept of managing different data versions for planning purposes does not apply.

Classic Mode (B): This refers to the older story interface. Stories can be built in either "Classic" or "Optimized" view mode, but this is a user interface preference and is not a prerequisite for version management. Version management functionality is available in both view modes, provided the underlying data model supports it.

Analytic Model (C): This is a broad term for any model used for analysis. While a planning model is a type of analytic model, not all analytic models are planning models. A standard analytic model (without planning enabled) does not support version management.

Optimized Mode (D): This refers to the newer, more performant story interface. Like classic mode, it is a UI setting and not a data requirement. Version management works in optimized mode, but the model itself must still be a planning model.

In summary: The fundamental requirement to access version management features is that the data source for your story must be a model that has planning enabled.

Reference:
SAP Analytics Cloud Help Documentation: "Creating a Planning Model"
SAP Learning Journey for Data Analysts: Topic covering planning capabilities and model types.
The version management icon (a stack of documents) is only active and available in the story toolbar when the widget is connected to a planning model.

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


A. Create a Review task for the story


B. Add a Comment widget to the story


C. Share with View access


D. Include the story in a Discussion





B.
  Add a Comment widget to the story

Summary:

Stories saved in My Files are private by default. To enable collaboration, you must either share the story or include interactive components. In SAP Analytics Cloud (SAC), if you want colleagues to review and comment directly on the story, you need to provide them a way to leave comments. The most direct way is to add a Comment widget to the story, enabling threaded discussions and feedback in-context.

Correct Option (B – Add a Comment widget to the story): The Comment widget in SAC allows users to post comments directly within the story. This widget enables reviewers to leave feedback, reply, and participate in discussions on specific data points or story sections. Adding this widget creates a dedicated space for collaboration and is specifically designed for reviews and commentary on stories.

Incorrect Option (A – Create a Review task for the story): SAC does not have a built-in “Review Task” function for stories. Tasks and processes exist in the planning area (data actions, calendar tasks), but not for ad-hoc story review. Therefore, you cannot initiate a formal “review task” from a story saved in My Files.

Incorrect Option (C – Share with View access): While sharing with View access lets your colleague see the story, it does not automatically allow them to comment. To actually collect comments, you must either enable story commenting via the Comment widget or Discussion. Sharing alone is insufficient to achieve the stated goal.

Incorrect Option (D – Include the story in a Discussion): Including the story in a Discussion allows for ongoing conversation linked to the story, but it does not directly enable commenting within the story context itself. The question asks specifically about reviewing and commenting on the story, which is best achieved with a Comment widget.

Reference:

Add Comment Widgets to Your Stories – SAP Analytics Cloud (Official SAP Help)

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


A. Live


B. On-premise


C. Cloud


D. Import





A.
  Live

D.
  Import

Summary:

SAP Analytics Cloud (SAC) connects to data through two main connection types: Live connections and Import connections. Live connections query the source system in real time without storing data in SAC, while Import connections replicate and store data within SAC for analysis. Options such as “on-premise” or “cloud” describe data location rather than actual SAC connection types.

Correct Option (A – Live): A Live connection keeps data in the source system and queries it in real time. This approach provides up-to-date insights without replicating data into SAC. Live connections are supported for systems like SAP HANA, SAP BW, and SAP S/4HANA, ensuring security and minimizing data latency.

Correct Option (D – Import): An Import connection copies (imports) data from the source system into SAP Analytics Cloud. Once imported, the data resides in SAC’s in-memory engine, enabling advanced data wrangling, modeling, and offline analysis. This method is especially useful when real-time access is not needed or when planning features are required.

Incorrect Option (B – On-premise): “On-premise” is not a connection type but rather describes where the data system resides. Both Live and Import connections can access on-premise systems via secure agents, but SAC itself does not classify “on-premise” as a connection type.

Incorrect Option (C – Cloud): Similarly, “Cloud” refers to the hosting environment of the data source, not a SAC connection type. SAC supports connecting to cloud-based systems (like SAP Datasphere or cloud databases), but the actual connection types remain Live or Import.

Reference:

Connections in SAP Analytics Cloud – Official SAP Help

What must a data model contain in SAP Analytics Cloud? Note: There are 2 correct answers to this question.


A. Calculations


B. Dimensions


C. Measures


D. Hierarchies





B.
  Dimensions

C.
  Measures

Summary:

A data model in SAP Analytics Cloud (SAC) is the foundation for stories and analytics. It structures the imported or live-connected data. At minimum, every SAC model must contain dimensions (which provide context such as time, product, region) and measures (quantitative values for analysis). While calculations and hierarchies can enrich the model, they are optional and not mandatory.

Correct Option (B – Dimensions): Dimensions describe the attributes or categories of your data, such as Date, Customer, Product, or Region. They provide context to your measures, allowing you to slice, filter, and drill down on data. Every SAC model requires at least one dimension (commonly a Time dimension) to properly organize and analyze data.

Correct Option (C – Measures): Measures are the numeric values used for analysis (e.g., Revenue, Quantity, Cost). They form the quantitative side of your model, enabling aggregations and calculations. Without measures, SAC cannot perform meaningful numerical analysis. Measures combined with dimensions create the backbone of any SAC model.

Incorrect Option (A – Calculations): Calculations (or calculated measures/dimensions) are optional enhancements within a model. They allow you to derive new metrics or logic from existing data but are not required. A SAC model can function without any custom calculations, relying solely on its base measures and dimensions.

Incorrect Option (D – Hierarchies): Hierarchies organize data within dimensions (for example, Country → Region → City). While useful for drill-down and visualization, hierarchies are optional. A model does not have to include them to function correctly; it only needs dimensions and measures.

Reference:

Create Models in SAP Analytics Cloud – Official SAP Help

Which features are available in the Optimized Design Experience? Note: There are 3 correct answers to this question.


A. Undo button


B. Grid pages


C. Linked widgets diagram


D. Composites


E. Explorer





A.
  Undo button

C.
  Linked widgets diagram

D.
  Composites

Summary:

The Optimized Design Experience (ODE) in SAP Analytics Cloud brings many improvements in usability and performance versus the Classic mode. It adds features like undo/redo, a redesigned chart builder, composites widgets, and better widget linking visualizations. It also deprecates or replaces some older features (e.g. Explorer, Grid Pages). Not all classic features are supported; some must be replaced or refactored.

Correct Options:

B – Undo button:
ODE provides a design‐time undo/redo feature, allowing users to reverse or correct design changes (like accidentally deleting a widget). This is a newer usability enhancement available in the optimized design mode.
C – Linked widgets diagram:
ODE includes a visual diagram to manage relationships between widgets, e.g. linked analyses among charts/tables etc. This enables designers to see which widgets are linked and adjust relationships graphically
D – Composites:
Composites are supported in optimized design mode. You can import composites and use them as reusable widgets. They behave like built‐in widgets, with styling, scripting, variables etc. Composites are supported (on canvas pages) in ODE.

Incorrect Options:


A – Explorer:
Explorer is deprecated in the Optimized Design Experience. ODE replaces Explorer with Data Analyzer as the exploration tool. Thus, Explorer is not available.
B – Grid pages:
Grid pages are not supported in the Optimized Design Experience. If a story contains grid pages, it must be redesigned (e.g. convert grid pages to responsive or canvas layouts) before converting to ODE. So this is incorrect.

Reference:
Choosing Between Optimized and Classic Design Modes – SAP Help Portal
Use Composites in Your Story Design (Optimized Story Experience) – SAP Help Portal

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


A. Embedded data set


B. Live data model


C. Data analyzer insight


D. Standalone dataset


E. Imported data model





A.
  Embedded data set

D.
  Standalone dataset

E.
  Imported data model

Summary:
Concatenation is a data preparation operation that appends rows from one dataset to another, requiring both datasets to have compatible structures. This process is typically performed during the data acquisition or modeling phase and is a feature of tools designed for data transformation and blending, not for live analysis or specific analytical views.

Correct Option:
A. Embedded data set: An embedded dataset is created or uploaded directly within a story. The data preparation panel for these datasets includes transformation features like the "Combine Data" option, which allows for concatenating (appending) multiple embedded datasets together.

Correct Option:
D. Standalone dataset: A standalone dataset is a central object in the "Datasets" menu, separate from any story. It is specifically designed for data preparation. The data blending interface for standalone datasets supports operations to append data from another dataset, making concatenation a core function.

Correct Option:
E. Imported data model: An imported data model is built from a dataset and allows for more complex data preparation than a live connection. Within the modeler, you can use features like "Union" to concatenate (append) data from multiple tables or queries that share a common structure.

Incorrect Option:
B. Live data model: A live data model connects directly to a source like SAP HANA or SAP BW. It does not store data locally and performs no data transformation within SAC. All data shaping and union operations must be defined in the underlying source system; concatenation cannot be performed within SAC on a live model.

Incorrect Option:
C. Data analyzer insight: Data Analyzer is a separate, simplified application for quick analysis. An "insight" is the output of this analysis. It is a consumption and visualization tool, not a data preparation or modeling tool. It does not provide functionality to concatenate or blend data sources.

Reference:
Official SAP Help Portal: Combining Data

What can you use input controls for in a story? Note: There are 2 correct answers to this question.


A. Changing dimensions or measures displayed in a table


B. Filtering data on a page


C. Selecting an alternate data source


D. Implementing row-level and column-level security in a table





A.
  Changing dimensions or measures displayed in a table

B.
  Filtering data on a page

Summary:

Input Controls in SAP Analytics Cloud (SAC) are interactive filters or selectors placed on a story page. They allow end users to dynamically change views, filter data, or switch between different measures or dimensions. Input controls do not change data sources or enforce security directly; instead, they give viewers the ability to adjust what they see in tables and charts in real time.

Correct Options:

A – Changing dimensions or measures displayed in a table: Input controls let you switch dimensions or measures displayed in tables or charts. For example, you can provide a drop-down to choose between displaying Revenue, Profit, or Quantity in a chart. This interactivity helps make one visualization support multiple perspectives without recreating it.

B – Filtering data on a page: Input controls can also act as filters for story pages. By selecting a dimension value (e.g., Region or Year), you filter the data shown across all widgets on the page or specific widgets depending on your configuration. This allows interactive and user-driven exploration of data.

Incorrect Options:

C – Selecting an alternate data source: Input controls cannot switch the underlying data source of a chart or table. They only filter or toggle dimensions/measures from the data already bound to that widget. To change the data source, you must manually edit the story or use data blending techniques, not input controls.

D – Implementing row-level and column-level security in a table: Row- or column-level security is set up at the model level through data access controls, not via input controls. Input controls merely filter visible data, but they do not enforce true security or prevent access at the model backend.

Reference:
Add Input Controls to Stories – SAP Analytics Cloud (Official SAP Help)

How can you limit the refresh time of a story?


A. Use canvas pages


B. Collapse the hierarchy


C. Create calculated measures


D. Implement a value driver tree





B.
  Collapse the hierarchy

Summary:

Large datasets, complex hierarchies, and multiple widgets can increase story refresh times in SAP Analytics Cloud (SAC). One effective way to improve performance is to reduce the number of members being displayed at once, especially in hierarchical dimensions. Collapsing hierarchies limits the visible data and therefore reduces the refresh time of a story. Other options like page type or calculated measures don’t directly control refresh speed in the same way.

Correct Option (B – Collapse the hierarchy): Collapsing a hierarchy reduces the number of displayed nodes at any one time. By showing only top-level nodes, SAC needs to load and render fewer data points. This improves query execution and visual rendering, leading to faster refresh times. Users can expand the hierarchy when needed, but starting collapsed minimizes the initial data load.

Incorrect Options:

A – Use canvas pages: Choosing canvas pages over responsive pages does not directly limit refresh time. Canvas pages give more layout flexibility but have no built-in performance optimization feature for data loading. Refresh speed depends mainly on data volume and query complexity, not page type.

C – Create calculated measures: Creating calculated measures often increases processing requirements rather than reducing them. While calculated measures may consolidate logic, they don’t inherently limit data load or speed up refresh times.

D – Implement a value driver tree: A value driver tree is a planning feature used for driver-based forecasting and analysis. It does not influence story refresh times. Adding a value driver tree won’t reduce or limit the data loaded in your story.

Reference:
Best Practices for Optimizing Story Performance – SAP Help Portal

Where can you create a blank planning version?


A. In a data cell


B. In version management


C. In the version dimension


D. In the planning model





B.
  In version management

The SAP Analytics Cloud (SAC) modeler has removed the first three characters from an SAP Analytics Cloud public dimension imported from a source system. What is impacted by this change?


A. Public datasets


B. Source system


C. Stories


D. Embedded data sets





C.
  Stories

Which calculation types include dynamic date options? Note: There are 2 correct answers to this Question.


A. Aggregation


B. Date Difference


C. Restricted Measure


D. Difference From





C.
  Restricted Measure

D.
  Difference From

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


A. Story


B. Insight


C. Dataset


D. Model





B.
  Insight


Page 1 out of 5 Pages