What source system can you connect to with a live connection?
- A . SAP ERP Central Component
- B . SAP SuccessFactors
- C . SAP Business ByDesign Analytics
- D . SAP Datasphere
You are using a live connection for a model. Where is the data stored?
- A . Public dataset
- B . SAP Analytics Cloud model
- C . Source system
- D . Embedded data set
You are using a live connection for a model. Where can you define data security?
- A . Source system
- B . Data access control
- C . SAP Analytics Cloud model
- D . SAP Analytics Cloud role
What must you use to transform data in a dataset using if/then/else logic?
- A . Calculations editor
- B . Custom expression editor
- C . Formula bar
- D . Transform bar
You import data into a dataset. One of the columns imported is Year, and SAP Analytics Cloud interprets it as a measure.
How can you ensure that it is treated as a calendar year?
- A . Change the Year measure to a dimension in the dataset.
- B . Includes the Year measure in a level-based time hierarchy in the dataset.
- C . Insert a character into the Year measure using the transform bar.
- D . Add the month as a suffix to the Year measure.
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.
- A . Allow model import
- B . Refresh the story
- C . Refresh the import job
- D . Schedule the import
You need to delete characters from a column in a dataset.
What can you use? Note: There are 2 correct answers to this question.
- A . Custom expression editor
- B . Formula bar
- C . Calculation editor
- D . Transform bar
What can you use to organize dimensions into logical categories in a live model?
- A . Level-based hierarchy
- B . Groups
- C . Value driver tree
- D . Parent-child hierarchy
What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
- A . Live
- B . On-premise
- C . Cloud
- D . Import
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?
- 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.
You are creating a script for an advanced data action.
Which character designates a virtual variable member?
- A . %
- B . /
- C . *
- D . #
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?
- A . Level
- B . Hierarchy
- C . Cardinality
- D . Granularity
You want to total several income and expense accounts using the account type property.
What configuration option in the advanced formula must you use?
- A . Unbooked
- B . Append
- C . Signflip
- D . Aggregate To
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?
- A . Use two properties
- B . Dis-able allocations
- C . Use two hierarchies
- D . Dis-able distribution
What can you do with a multi action? Note: There are 2 correct answers to this question.
- A . Run allocation data actions
- B . Import transaction data
- C . Approve data
- D . Run allocation processes
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?
- A . Reference
- B . Driver
- C . Distribute
- D . Redistribute
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?
- A . Fluid
- B . Single
- C . Mass
Where can you change a data lock status? Note: There are 2 correct answers to this question.
- A . Data action
- B . Value lock management
- C . Multi action
- D . Calendar task
How can you improve the performance of advanced data actions? Note: There are 3 correct answers to this question.
- A . Use fewer MEMBERSET statements
- B . Use fewer FOREACH functions
- C . Use fewer IF statements
- D . Use fewer data functions
- E . Use fewer aggregation dimension functions
What type of predictive scenario can write back to a planning model?
- A . Regression
- B . Value driver tree
- C . Classification
- D . Time series forecast