SAP C_SAC_2501 Exam Practice Test Instant Access

Question 1

Where can you create a blank planning version?

AIn a data cell

BIn version management

CIn the version dimension

DIn the planning model
A blank planning version in SAP Analytics Cloud can be created within the Version Management feature. This area of the platform allows users to manage different versions of their data, such as budgets, forecasts, and what-if scenarios. Creating a blank version provides a clean slate for planning activities, without pre-existing data, enabling users to start fresh with their assumptions and inputs.

Answer : B

SAP Analytics Cloud Help Documentation: Version Management in Planning

SAP Analytics Cloud User Guide: Creating New Versions for Planning

Question 2

Which of the following data sources can you use in SAP Analytics Cloud data analyzer? Note: There

are 3 correct answers to this question.

ASAP Analytics Cloud public dataset

BSAP HANA view

CSAP Datasphere model

DSAP Analytics Cloud analytic model

ESAP BusinessObjects Universe

Answer : B, C, D

Question 3

You have a column chart in a story. You notice some of the labels are missing until you mouse over

the data point. How can you ensure that the labels are always visible?

AIncrease the overall size of the chart widget on the page

BSelect the Avoid Data Label Overlap checkbox

CIncrease the font size of the axis labels
To ensure that labels are always visible on a column chart in a story, you should select the 'Avoid Data Label Overlap' checkbox in the chart's settings. This option adjusts the labels' positioning to prevent overlap, making them visible at all times without the need for mouse-over interaction.

Answer : B

SAP Analytics Cloud Help Documentation: Chart Design and Label Management

SAP Analytics Cloud User Guide: Enhancing Data Label Visibility in Charts

Question 4

When scrolling down in a long table, how can you retain column headers? Note: There are 2

correct answers to this question.

AEnable Keeping member names visible

BEnable Auto-Size And Page Table Vertically

CFreeze Up to row

DFreeze Up to column

Answer : C, D

Question 5

What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct

answers to this question.

AUse responsive pages

BAvaid tables with more than 500 rows and 60 columns

CLoad widgets in the background

DUse conditional formatting

EAvaid prompts

Answer : B, C, D

Question 6

What can you use to perform cell-based calculations in a story?

ACalculated measures

BDimension formulas

CRestricted measures

DTable formulas
Table formulas in SAP Analytics Cloud are used to perform cell-based calculations within a story. These formulas can be applied directly to table cells, allowing for customized calculations that are specific to the data presented in the table. This feature is particularly useful for ad-hoc analysis and when specific calculations are needed that are not covered by predefined measures or dimensions.

Answer : D

SAP Analytics Cloud Help Documentation: Using Table Formulas

SAP Analytics Cloud User Guide: Cell-Based Calculations in Stories

Question 7

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

ASAP ERP Central Component

BSAP SuccessFactors

CSAP Business ByDesign Analytics

DSAP Datasphere
SAP Analytics Cloud can establish a live connection with various source systems, including SAP Datasphere. This allows for real-time data access and analysis without the need to replicate data into the cloud, which is beneficial for scenarios where data privacy and security are paramount.

Answer : D

SAP Analytics Cloud Connection Guide1

SAC Live and Import Connection Overview2

SAP Analytics Cloud: Expand Live Data Source Options3

Live connection in SAP Analytics Cloud: advantages and challenges4

Explaining Where the Data Comes From - SAP Learning5

SAP Certified Associate - Data Analyst - SAP Analytics Cloud C_SAC_2501 Exam Practice Test