SAP C_SAC_2415 Practice Test - Questions Answers, Page 2
List of questions
Question 11

You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question.
Custom expression editor
Formula bar
Calculation editor
Transform bar
Question 12

What can you use to organize dimensions into logical categories in a live model?
Level-based hierarchy
Groups
Value driver tree
Parent-child hierarchy
Explanation:
In a live model within SAP Analytics Cloud, dimensions can be organized into logical categories using either level-based hierarchies or parent-child hierarchies. Level-based hierarchies are used when the relationships between items are defined by distinct levels, such as Geography might be divided into Country, State, and City levels. Parent-child hierarchies, on the other hand, are useful when the data's hierarchy is not strictly defined by levels but by a parent relationship where a child member is associated with a parent member, which is common in organizational structures or product categories.
SAP Analytics Cloud Help Documentation: Creating and Managing Hierarchies
SAP Analytics Cloud User Guide: Working with Models
Question 13

What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
Live
On-premise
Cloud
Import
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.
SAP Analytics Cloud Help Documentation: Data Connections Overview
SAP Analytics Cloud User Guide: Live Data vs. Import Data Scenarios
Question 14

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.
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).
SAP Analytics Cloud Help Documentation: Creating Hierarchies in Models
SAP Analytics Cloud User Guide: Data Modeling and Hierarchies
Question 15

You are creating a script for an advanced data action. Which character designates a virtual variable member?
%
/
*
#
Question 16

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
Question 17

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
Question 18

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
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.
SAP Analytics Cloud Help Documentation: Hierarchies in Planning
SAP Analytics Cloud User Guide: Managing Hierarchies for Planning
Question 19

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
Question 20

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
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.
SAP Analytics Cloud Help Documentation: Allocation Steps in Planning
SAP Analytics Cloud User Guide: Using Drivers for Allocation
Question