C-SAC-2501 Sample Questions & Answers
Three areas tie for top weight: visualizing data through stories, planning both by hand and with advanced tools, and building and analyzing data models, alongside connecting to and preparing data, plus tuning performance, troubleshooting and security.
Launch the full C-SAC-2501 simulator →Showing 10 of 20 free samples.
- Question 1Beginner
Planning · Data Entry and Manipulation
True or False: In an SAP Analytics Cloud planning model, data locking can be applied at the cell level to prevent specific data points from being changed, even if other cells in the same row or column are editable.
Show answer & explanation
Correct answer: A
Data locking in SAP Analytics Cloud planning is granular. It can be set on specific data cells, entire rows, or based on dimension member combinations. This allows planners to finalize certain values while leaving others open for input or adjustment, providing precise control over the planning process.
- Question 2Intermediate
Data modeling, analysis, and integration · Model Types and Structure
A consultant is designing an analytic model that contains sensitive salary data. The requirement is to prevent most business users from seeing the 'Salary' measure, while allowing only users with the 'HR_Manager' role to view it. All users will use the same set of stories built on this model. What is the most effective and secure way to implement this requirement at the model level?
Show answer & explanation
Correct answer: C
Data Access Control on measures is the correct, model-level security feature for this scenario. It allows an administrator to define which roles can read or write to specific measures, ensuring the security is enforced consistently across all stories that use the model. This is more secure and scalable than managing access through multiple story versions or story-level filters, which can be bypassed.
- Question 3Intermediate
Story Design · Filters and Prompts
A designer is creating a dashboard page with multiple charts. When a user selects a data point in one chart (e.g., a specific product category in a bar chart), all other charts on the page should automatically filter to show data only for that selected category.
Show answer & explanation
Correct answer: C
Linked Analysis is specifically designed for creating interactions between widgets on a story page. By setting up linked analysis, selections made in one widget can act as filters for other selected widgets, creating a dynamic and interactive dashboard experience. Page filters are static, input controls require manual selection, and bookmarks save states but don't create this dynamic interaction.
- Question 4Advanced
Planning · Allocations and Distributions
'Global Logistics Corp' is implementing a top-down budgeting process using SAP Analytics Cloud Planning. The CFO sets a total corporate budget for 'Operating Expenses'. This total amount needs to be distributed to different departments (Sales, Marketing, IT, HR) based on their employee headcount.
The planning model has an 'Amount' measure, a 'Department' dimension, and an 'Account' dimension which includes 'Operating Expenses' and 'Headcount'. The 'Headcount' data is already loaded into the model for the previous fiscal year and will be used as the driver for the allocation. The CFO will enter the single total budget amount at the top level of the 'Department' hierarchy.
The requirement is to automatically push down the total 'Operating Expenses' budget to the individual departments. The distribution must be proportional to each department's headcount. For instance, if the IT department has 20% of the total headcount, it should receive 20% of the total operating expense budget.
The planning team needs to configure this logic within the SAC planning model so that when the CFO saves the top-level budget number, the allocation happens automatically without manual intervention.
Show answer & explanation
Correct answer: A
A Data Action with an ALLOCATION step is the standard and most robust method for this scenario. It allows the definition of a structured, repeatable process where a source amount ('Operating Expenses') is distributed to target members ('Departments') based on the values of a driver measure ('Headcount'). This can be triggered by a button in a story, ensuring consistency and accuracy. Spreading is a manual, ad-hoc user action. A cross-model copy is for moving data, not allocating. A VDT is for simulation, not for persisting allocated budget values.
- Question 5IntermediateSelect 2
Connections and data preparation · Connection Types
A data architect is setting up connections in SAP Analytics Cloud. The business has two primary use cases: 1) A real-time sales dashboard that must reflect transactions in the source SAP S/4HANA system within seconds. 2) A monthly financial consolidation report that combines data from multiple flat files and requires significant data cleansing and transformation before being used in stories. Which connection types should the architect choose for these two use cases, respectively? (Select TWO)
Show answer & explanation
Correct answers: A, D
A Live Connection is the correct choice for the real-time dashboard because it queries the source system (SAP S/4HANA) directly without storing data in SAC, ensuring the data is always current.
An Import Connection is the appropriate choice for the financial report because the data needs to be brought into SAC's in-memory engine to perform the required cleansing and transformations (wrangling).
- Question 6Intermediate
Data modeling, analysis, and integration · Smart Discovery and Insights
A business analyst is using Smart Discovery on a dataset containing customer churn information. The goal is to understand the main factors that contribute to customers discontinuing their service. After running the Smart Discovery, the analyst is presented with a Key Influencers analysis. What does this analysis show?
Show answer & explanation
Correct answer: B
The Key Influencers section within a Smart Discovery insight is generated by running automated classification or regression algorithms. It identifies and ranks the variables (dimensions) that most strongly correlate with and influence the outcome of the target measure, providing valuable insights into the main drivers of a business outcome.
- Question 7Advanced
Story Design · Calculations and Measures
When creating a calculated measure within a story, you want to compute the 'Average Selling Price' by dividing 'Total Revenue' by 'Units Sold'. However, for some data points, 'Units Sold' might be zero, which would cause a division-by-zero error. Which formula should be used to handle this potential error gracefully?
Show answer & explanation
Correct answer: B
The IF function is the standard way to implement conditional logic in SAP Analytics Cloud formulas. This expression checks if 'Units Sold' is not equal to zero. If true, it performs the division; if false (i.e., 'Units Sold' is zero), it returns 0, thus preventing a division-by-zero error and ensuring the calculation is robust.
- Question 8Intermediate
Planning · Data Entry and Manipulation
A financial planner needs to create a forecast for the next 12 months. They start by creating a new public version called 'Forecast_2026' by copying the 'Actuals_2025' version. The planner now needs to increase all values in the new 'Forecast_2026' version by 5% across all product categories and regions. What is the most efficient way to apply this uplift to the entire version?
Show answer & explanation
Correct answer: B
A Data Action is the correct tool for performing mass data changes in a structured and repeatable way. An advanced formula step can be configured to read the data from the 'Forecast_2026' version, multiply it by 1.05, and write the result back. This is efficient, accurate, and can be easily re-run if needed.
- Question 9Beginner
Connections and data preparation · Data Quality
An analyst is preparing data from a CSV file. The file contains a 'Region' column with inconsistent values such as 'N. America', 'North America', and 'NA'. To ensure data quality and proper aggregation, these values must be consolidated into a single standard value, 'North America'. Which data wrangling transformation is best suited for this task?
Show answer & explanation
Correct answer: B
The 'Replace' transformation in the data preparation screen is designed for finding and replacing specific text values. The analyst can set up rules to find 'N. America' and 'NA' and replace them with 'North America', effectively standardizing the data in the column.
- Question 10Intermediate
Data modeling, analysis, and integration · Dimension Management
A data modeler is building a model with a 'Product' dimension. This dimension needs to represent a natural drill-down path for users: Category -> Sub-Category -> Product SKU. For example, Electronics -> Televisions -> TV-SKU-123. Which type of hierarchy should the modeler create for the 'Product' dimension to represent this structure?
Show answer & explanation
Correct answer: B
A Level-Based Hierarchy is the correct choice when the drill-down path consists of distinct, named levels, and every member at a lower level belongs to a member at the level above it. The structure Category -> Sub-Category -> Product SKU is a classic example of a level-based hierarchy. A parent-child hierarchy is used for unbalanced or ragged structures, like an employee reporting chart.
Ready for the real thing?
The full C-SAC-2501 simulator has every exam-style question, timed mode, and instant scoring.