Special Summer Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

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

Page: 1 / 6
Total 60 questions

SAP Certified Associate - Data Analyst - SAP Analytics Cloud Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Question 1

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

correct answers to this question.

Options:

A.

Enable Keeping member names visible

B.

Enable Auto-Size And Page Table Vertically

C.

Freeze Up to row

D.

Freeze Up to column

Question 2

You are entering values for several expense accounts in a data table. Which data entry mode must

you use to process the data with a delay defined in System Administration?

Options:

A.

Fluid

B.

Single

C.

Mass

Question 3

You have a story based on an import model. The transaction data in the model's data source

changes. How can you update the data in the model? Note: There are 2 correct answers to this

question.

Options:

A.

Allow model import

B.

Refresh the story

C.

Refresh the import job

D.

Schedule the import

Question 4

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

Options:

A.

Calculations editor

B.

Custom expression editor

C.

Formula bar

D.

Transform bar

Question 5

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?

Options:

A.

Create a group that includes the dimensions.

B.

Create a level-based hierarchy in the dataset.

C.

Create a parent-child hierarchy in the dataset.

D.

Convert the embedded dataset to a model.

Question 6

In a planning data model, what dimensions are included by default? Note: There are 2 correct

Answers to this question.

Options:

A.

Date

B.

Version

C.

Entity

D.

Organization

Question 7

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

answers to this question.

Options:

A.

Use responsive pages

B.

Avaid tables with more than 500 rows and 60 columns

C.

Load widgets in the background

D.

Use conditional formatting

E.

Avaid prompts

Question 8

What account types use the average rate type? Note: There are 2 correct answers to this question.

Options:

A.

INC

B.

AST

C.

EXP

D.

LEQ

Question 9

In which types of data source can you concatenate data? Note: There are 3 correct answers to

this question.

Options:

A.

Embedded data set

B.

Live data model

C.

Data analyzer insight

D.

Standalone dataset

E.

Imported data model

Question 10

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?

Options:

A.

Use two properties

B.

Dis-able allocations

C.

Use two hierarchies

D.

Dis-able distribution

Question 11

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

Options:

A.

Calculated measures

B.

Dimension formulas

C.

Restricted measures

D.

Table formulas

Question 12

For which activities must you enable Advanced Mode in story design? Note: There are 2 correct

answers to this question.

Options:

A.

Add JavaScript to a button

B.

Add a popup

C.

Add a layer to a geo map

D.

Add a custom widget

Question 13

You are using a live connection for a model. Where can you define data security?

Options:

A.

Source system

B.

Data access control

C.

SAP Analytics Cloud model

D.

SAP Analytics Cloud role

Question 14

Which calculation types include dynamic date options? Note: There are 2 correct answers to this

Question.

Options:

A.

Aggregation

B.

Date Difference

C.

Restricted Measure

D.

Difference From

Question 15

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?

Options:

A.

Level

B.

Hierarchy

C.

Cardinality

D.

Granularity

Question 16

Which SAP Analytics Cloud feature uses natural language processing?

Options:

A.

Digital boardroom

B.

Data analyzer

C.

Smart insight

D.

Just Ask feature

Question 17

You need to delete characters from a column in a dataset. What can you use? Note: There are 2

correct answers to this question.

Options:

A.

Custom expression editor

B.

Formula bar

C.

Calculation editor

D.

Transform bar

Question 18

In a data model, what can you use to further describe a dimension?

Options:

A.

Data action

B.

Measure

C.

Property

D.

Variable

Page: 1 / 6
Total 60 questions