Free C-SAC-2501 sample questions
The free C-SAC-2501 sample questions on this page come with answers and explanations. Stories, planning and data models in SAP Analytics Cloud are the main topics. If you have access to the tool, repeat each step there as you go.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
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?
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?
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?
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?
A story designer has added a bar chart and a table to a story page. The requirement is for both visualizations to always show data for the same fiscal quarter, which the user can select from a dropdown list. How should the designer implement this shared filter?
A planning team is using a Value Driver Tree (VDT) to simulate the impact of changes in raw material costs and sales volume on the company's overall Net Profit. Which two statements accurately describe the functionality of a Value Driver Tree in SAP Analytics Cloud? (Select TWO)
A data analyst has scheduled a daily data import job from a connected SAP BW system into an SAP Analytics Cloud model. On Monday morning, users report that the data in their stories is from Friday, not from the weekend. What is the first place the analyst should check to diagnose why the scheduled job did not update the model?
When connecting to an on-premise SAP HANA Calculation View using a live connection, what component is typically required to be installed and configured in the on-premise landscape to facilitate communication between SAP Analytics Cloud and the HANA database?
A company has two main data sources for analysis in SAP Analytics Cloud: an on-premise SAP BW system for financial actuals and a cloud-based Salesforce system for CRM data. The company wants to minimize data duplication and leverage the processing power of the source systems. Which connection types should be recommended? graph TD subgraph On-Premise BW[SAP BW] end subgraph Cloud SF[Salesforce] end SAC[SAP Analytics Cloud] BW -->> SAC SF -->> SAC
10 more free samples are waiting
Create a free account to unlock the whole C-SAC-2501 sample bank, or get full access to all 240 practice questions in the simulator.