C-SAC-2501 SAP Certified Associate Analytics Cloud Practice Questions

A Page Filter or a page-level Input Control applies its filter context to all widgets on that page by default. This is the most efficient method for ensuring multiple visualizations are filtered by the same dimension member simultaneously, providing a consistent view of the data for the user.

The core function of a VDT is to model relationships between business drivers. When a user changes a value in a driver node (e.g., sales volume), the VDT automatically recalculates all dependent nodes up to the final KPI (e.g., Net Profit).

After performing a what-if analysis, the resulting data from the simulation can be explicitly saved as a new version. This allows planners to compare different scenarios or use the simulation result as a basis for a new budget or forecast.

The Data Management screen for the specific model contains the schedule settings and a history of all import jobs. This is the primary location to check the status of past jobs, see if they succeeded or failed, and view any associated error messages. This will quickly reveal if the job ran as expected.

For live connections to certain on-premise data sources like SAP HANA, the SAP Analytics Cloud Agent acts as a reverse proxy to securely transfer data between the on-premise system and the cloud tenant. The SAP Cloud Connector is also required to establish the secure tunnel between the on-premise network and SAP Business Technology Platform, which hosts SAC.

This is the best practice architecture. A live connection to SAP BW is recommended to leverage its powerful OLAP engine for financial data and avoid data replication. For cloud sources like Salesforce, which do not typically support live connections in the same way, an import connection is used. This allows data to be acquired into SAC for modeling and analysis, and it can be refreshed on a schedule.

A Variance Chart is specifically designed to show the difference between two measures, such as actual versus target, making it the ideal choice for this scenario. It clearly visualizes both the size and the direction (positive or negative) of the deviation. A Waterfall Chart shows the cumulative effect of sequentially introduced values. A Stacked Bar Chart is for showing parts of a whole. A Scatter Plot is for showing the relationship between two numerical variables.

The Currency Conversion feature, enabled in the model's preferences, is essential for translating data from different local currencies into a single reporting currency. This requires setting up a currency dimension, a currency rates table, and defining the conversion logic. Data locking prevents changes, Value Driver Trees are for simulations, and Validation Rules check data integrity but do not perform currency translations.

Data Blending is the mechanism used within a story to combine data from different models (e.g., one import, one live). This is done by defining links between common dimensions.

For the blend to be successful, there must be at least one common dimension (the linking dimension), such as 'Product ID' or 'Region', with identical member IDs across both datasets.

Within the Data Preparation (Wrangling) screen, the most direct and correct method is to change the column's data type from 'String' to 'Date'. SAP Analytics Cloud will then attempt to parse the text strings and convert them into a proper date format, which is essential for creating time hierarchies and performing time-series analysis.

A Responsive page is essential for the layout to adapt automatically between large screens and mobile devices. A Geo Map with enabled hierarchy levels (Country > Region > Store) directly supports the drill-down requirement. Linked analysis is the best practice for making the dashboard interactive, where selecting a country on the map automatically filters the time-series chart and other widgets. This approach is the most efficient and user-friendly way to meet all stated requirements.