SAP C_SAC_2501 Practice Exams
Last updated on Nov 16,2026- Exam Code: C_SAC_2501
- Exam Name: SAP Certified Associate - Data Analyst - SAP Analytics Cloud
- Certification Provider: SAP
- Latest update: Nov 16,2026
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
Explanation:
Collapsing the hierarchy in a story can help limit the refresh time, as it reduces the amount of data that needs to be processed and displayed at any given time. By presenting data at a higher aggregation level initially, you can improve performance and allow users to expand specific sections of the hierarchy as needed for more detailed analysis.
Reference: SAP Analytics Cloud Help Documentation: Improving Story Performance
SAP Analytics Cloud User Guide: Managing Data Hierarchy for Performance
What must you use to transform data in a dataset using if/then/else logic?
- A . Calculations editor
- B . Custom expression editor
- C . Formula bar
- D . Transform bar
B
To transform data in a dataset using if/then/else logic in SAP Analytics Cloud, you must use the Custom expression editor. This tool allows you to write complex logical conditions and perform conditional data transformations. The steps involved are: Open the dataset you want to transform.
Navigate to the "Custom expression editor".
Write your if/then/else logic using the syntax supported by SAP Analytics Cloud. For example:
IF([Sales] > 1000, "High", "Low")
Apply the expression to the relevant column.
Validate and save your changes.
This approach allows for flexibility and precision in transforming your data based on specific
conditions.
Reference: =
SAP Help Portal: SAP Analytics Cloud
Official SAP Analytics Cloud Documentation
Which automatically created dimension type can you delete from an analytic data model?
- A . Version
- B . Date
- C . Organization
- D . Generic
D
Explanation:
In an analytic data model within SAP Analytics Cloud, the automatically created dimension type that you can delete is the Generic dimension. This type of dimension is typically used for custom or ad-hoc categorizations and, unlike system-generated dimensions like Date or Version, can be modified or removed as per the specific needs of your data model and analysis requirements.
Reference: SAP Analytics Cloud Help Documentation: Data Model Dimensions
SAP Analytics Cloud User Guide: Managing Dimensions in Analytic Models
What features are supported by data analyzer? Note: There are 3 correct answers to this question.
- A . Linked dimensions
- B . Charts
- C . Conditional formatting
- D . Input controls
- E . Calculated measures
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
Explanation:
When the SAP Analytics Cloud (SAC) modeler removes the first three characters from a public dimension imported from a source system, this change impacts Stories that use this dimension. Specifically, any visualizations, calculations, or filters within those stories that rely on the original dimension values may need to be adjusted to account for the change. This modification does not affect the source system or public datasets directly, but it can impact how the data appears and behaves in stories that use the modified dimension.
Reference: SAP Analytics Cloud Help Documentation: Modifying Dimensions
SAP Analytics Cloud User Guide: Impact of Dimension Changes on Stories
You want to total several income and expense accounts using the account type property.
What configuration option in the advanced formula must you use?
- A . Unbooked
- B . Append
- C . Signflip
- D . Aggregate To
What account types use the average rate type? Note: There are 2 correct answers to this question.
- A . INC
- B . AST
- C . EXP
- D . LEQ
Which of the following data sources can you use in SAP Analytics Cloud data analyzer? Note: There are 3 correct answers to this question.
- A . SAP Analytics Cloud public dataset
- B . SAP HANA view
- C . SAP Datasphere model
- D . SAP Analytics Cloud analytic model
- E . SAP BusinessObjects Universe
How can you determine node relationships in a value driver tree? Note: There are 2 correct answers to this question.
- A . Use a dimension hierarchy
- B . Use a calculated member
- C . Use a story calculated measure
- D . Use a model converted measure
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
Explanation:
A blank planning version in SAP Analytics Cloud can be created within the Version Management feature. This area of the platform allows users to manage different versions of their data, such as budgets, forecasts, and what-if scenarios. Creating a blank version provides a clean slate for planning activities, without pre-existing data, enabling users to start fresh with their assumptions and inputs.
Reference: SAP Analytics Cloud Help Documentation: Version Management in Planning
SAP Analytics Cloud User Guide: Creating New Versions for Planning