C_SAC_2421 Exam Questions and Answers

QUESTION: 9

What are the available connection types in SAP Analytics Cloud?
Note: There are 2 correct answers to this question.

Live
On-premise
Cloud
Import

Answer(s): A,D

Explanation:

SAP Analytics Cloud supports two primary types of data connections: Live Data Connection and Import Data Connection. Live Data Connection establishes a direct link to the data source, allowing real-time data access without replicating the data into SAP Analytics Cloud. This is ideal for scenarios where up-to-the-minute data is crucial, and data volume is large. On the other hand, Import Data Connection involves copying data from the source into SAP Analytics Cloud, which is suitable for scenarios where data doesn't change frequently, or there's a need for data transformation and enrichment within SAP Analytics Cloud.

Reference:

SAP Analytics Cloud Help Documentation: Data Connections Overview SAP Analytics Cloud User Guide: Live Data vs. Import Data Scenarios

Reveal Solution Next Question

QUESTION: 10

Your embedded dataset in SAP Analytics Cloud has columns for Country, Region, City, and Customer Name. You want to aggregate measures for these columns as a single column.
What can you do?

Create a group that includes the dimensions.
Create a level-based hierarchy in the dataset.
Create a parent-child hierarchy in the dataset.
Convert the embedded dataset to a model.

Answer(s): B

Explanation:

To aggregate measures for columns such as Country, Region, City, and Customer Name as a single column in an embedded dataset, creating a level-based hierarchy is the most effective approach. This type of hierarchy allows you to define a multi-level structure that represents the logical relationship between different geographical entities and customer names. By doing so, you can easily perform aggregations and analyze data at various levels of detail, from the broadest level (e.g., Country) down to the most specific one (e.g., Customer Name).

Reference:

SAP Analytics Cloud Help Documentation: Creating Hierarchies in Models SAP Analytics Cloud User Guide: Data Modeling and Hierarchies

Reveal Solution Next Question

QUESTION: 11

You are creating a script for an advanced data action.
Which character designates a virtual variable member?

%
/
*
#

Answer(s): A

Reveal Solution Next Question

QUESTION: 12

You are creating a data action to copy data from one year to the next.In the parameter for the source year, which default setting must you change?

Level
Hierarchy
Cardinality
Granularity

Answer(s): C

Reveal Solution Next Question

QUESTION: 13

You want to total several income and expense accounts using the account type property.
What configuration option in the advanced formula must you use?

Unbooked
Append
Signflip
Aggregate To

Answer(s): C

Reveal Solution Next Question

QUESTION: 14

You have a dimension with members for product groups and products. Each product group has associated products. You want to plan by product group without disaggregating into the products. How can you do this?

Use two properties
Dis-able allocations
Use two hierarchies
Dis-able distribution

Answer(s): C

Explanation:

When you have a dimension with members for product groups and associated products and want to plan by product group without disaggregating into the individual products, using two hierarchies is the best approach. One hierarchy can represent the product groups at a higher level, allowing for planning and analysis at the group level. The second hierarchy can include both the product groups and their associated individual products for more detailed analysis when needed. This approach provides flexibility in planning and analyzing data at different levels of detail without the necessity of disaggregating data at the product group level.

Reference:

SAP Analytics Cloud Help Documentation: Hierarchies in Planning SAP Analytics Cloud User Guide: Managing Hierarchies for Planning

Reveal Solution Next Question

QUESTION: 15

What can you do with a multi action?
Note: There are 2 correct answers to this question.

Run allocation data actions
Import transaction data
Approve data
Run allocation processes

Answer(s): A,B

Reveal Solution Next Question

QUESTION: 16

You are creating an allocation step to distribute expenses from the HR cost center to your operating cost centers.
Which dimension setting controls how much is distributed to each operating cost center?

Reference
Driver
Distribute
Redistribute

Answer(s): B

Explanation:

In the context of creating an allocation step to distribute expenses from the HR cost center to operating cost centers in SAP Analytics Cloud, the "Driver" dimension setting is crucial. This setting determines the basis or criteria on which the distribution is calculated and applied to each operating cost center. For instance, the driver could be the number of employees, square footage, or any other relevant metric that justifies the distribution of costs. By defining a driver, you ensure that the allocation of expenses is proportional and fair based on the selected criteria.

Reference:

SAP Analytics Cloud Help Documentation: Allocation Steps in Planning SAP Analytics Cloud User Guide: Using Drivers for Allocation

Reveal Solution Next Question

SAP C_SAC_2421 Exam (page: 2) SAP Certified Associate - Data Analyst - Analytics Cloud Updated on: 12-Feb-2026

QUESTION: 9

Explanation:

Reference:

QUESTION: 10

Explanation:

Reference:

QUESTION: 11

QUESTION: 12

QUESTION: 13

QUESTION: 14

Explanation:

Reference:

QUESTION: 15

QUESTION: 16

Explanation:

Reference:

SAP C_SAC_2421 Exam (page: 2)
SAP Certified Associate - Data Analyst - Analytics Cloud
Updated on: 12-Feb-2026