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

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.

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.

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.