SAC Data Analyst

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

• %

• /

• #

• *

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

• Append

• Signflip

• Unbooked

• Aggregate To

What type of predictive scenario can write back to a planning model?

• Classification

• Value Creation

• Regression

• Time Series Forecast

Which programming language is used for scripting in an SAP Analytics Cloud story?

• Java Script

• Ahad

• Python

• Wrangling Expression Language

Which calculation types include dynamic date options?

Note: There are 2 correct answers to this

• Aggregation

• Date Difference

• Difference From

• Restricted Measure

You want to use an input control to filter data appearing in a story. At what level is the filter applied?

• Component

• Page

• Calculation

• Story

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

• Use responsive Pages

• Load Widgets in the background

• Avoid Prompts

• Use Conditional formatting

• Avoid tables with more than 500 rows and 60 columns

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

• Use fewer MEMBERSET statements

• Use fewer aggregation dimension functions

• Use fewer IF statements

• Use fewer FOREACH functions

• Use fewer data functions

What must a data model contain in SAP Analytics Cloud? Note: There are 2 correct answers to this question.

• Measures

• Hierarchies

• Calculations

• Dimensions

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?

• Fluid

• Mass

• Single