What source system can you connect to with a live connection?

SAP Business ByDesign Analytics

You are using a live connection for a model. Where is the data stored?

Embedded data set Connections and data preparation

What must you use to transform data in a dataset using if/then/else logic?

Transform bar changes. This approach allows for flexibility and precision in transforming your data based on specific conditions.

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 level-based hierarchy in the dataset.

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.

How can you improve the performance of advanced data actions? Note: There are 3 correct answers to this question.

Use fewer aggregation dimension functions

Which of the following data sources can you use in SAP Analytics Cloud data analyzer? Note: There are 3 correct answers to this question.

SAP Analytics Cloud analytic model

SAP Analytics Cloud public dataset

SAP Analytics Cloud analytic model

You have a live data model with two dimensions: Firstname and Lastname. Users want a single dimension in the data model that displays the dimensions as Lastname, Firstname. What must you do?

Create a calculated dimension in the data model.

Create the combined data in the source system.

Create a calculated dimension in the data model.

Create a calculated dimension in the story.

Group the Firstname and Lastname in the data model.

You have a dataset that extracts data from an SAP Business Warehouse (SAP BW) system. The data in the SAP BW system changes. How can you update the dataset?

You can schedule the dataset to update on a regular basis.

You must manually reimport the data.

You must refresh the story that uses the dataset.

You can schedule the dataset to update on a regular basis.

What can you use input controls for in a story? Note: There are 2 correct answers to this question.

Changing dimensions or measures displayed in a table

Selecting an alternate data source

Implementing row-level and column-level security in a table

SAP C_SAC_2421 Practice Test 1 - Free Online Exam Prep & Questions

Question 1 / 40

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

Comment (0)

Suggested answer: C

Explanation:

SAP Analytics Cloud Help Documentation: Hierarchies in Planning

SAP Analytics Cloud User Guide: Managing Hierarchies for Planning

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.

asked 23/12/2024

Dario ZUGCIC

46 questions

1 2 3 4 5 6 7 8 9 10 11

SAP C_SAC_2421 Practice Test 1

Question

SAP C_SAC_2421 Practice Tests

Practice Tests