WorksheetsSAC Data Analyst
Total questions: 60
Worksheet time: 37mins
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
In which types of data source can you concatenate data? Note There are 3 correct answers to this question.
Imported data model
Live data model
Data analyzer insight
Embedded data set
Standalone Dataset
Tour 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 parent-child hierarchy in the dataset
Convert the embedded dataset to a model
Create a group that includes the dimensions
You need to delete characters from a column in a dataset. What can you use? Note: Tare 2 connect answers to this question
Formula bar
Calculation editor
Transform bar
Custom expression editor
You are creating a styling rule for a table with a hierarchy of Country Region and City: You want to apply the styling rule only to countries. Which level option must γου select?
Self and Descendants
Self and Children
Self and Siblings
Self
You are designing a new story You want the size and position of widgets to adjust dynamically for viewing on different devices and screen sizes. Which page type must you use?
Grid
Canvas
Composite
Responsive
What features are supported by data analyzer? Note: There are 3 correct answers to this question
Input controls
Calculated measures
Charts
Linked dimensions
Conditional Formatting
What account types use the average rate type? Note: There are 2 correct answers to this question
AST
EXP
LEQ
INC
The SAP Analytics Cloud (SAC) modeler has removed the first three characters from an SAP Analytics Cloud public dimension imported from a source system. What is impacted by this change?
Embedded data sets
Source system
Public datasets
Stories
What can you use to organize dimensions into logical categories in a live model?
Value driver tree
Parent-child hierarchy
Groups
Level-based hierarchy
Which SAP Analytics Cloud feature uses natural language processing?
Just Ask feature
Digital Boardroom
Data Analyzer
Smart insight
Which features are available in the Optimized Design Experience? Note: There are 3 correct answers to this question
Grid pages
Linked widgets diagram
Composites
Undo button
Explorer
What is required to use version management in a story?
Planning model
Classic model
Analytic model
Optimized mode
What must you use to transform data in a dataset using if/then/else logic?
Custom expression editor
Formula bar
Calculations editor
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?
Includes the Year measure in a level-based time hierarchy in the dataset
Change the Year measure to a dimension in the dataset
Add the month as a suffix to the Year measure
Insert a character into the Year measure using the transform bar
Four users need to analyze data in a story. What kinds of data models can you create? Note: There are 2 correct answers to this question
Analytic
Embedded
Planning
Standalone
You are creating a styling rule for a table. What is the context?
The table header
The highest level in the table
The location of the cursor
The most granular level in the table
You input new data for a private version in a story. What must you do to ensure the new data is added to the model?
Send
Publish
Nothing
Save
For which activities must you enable Advanced Mode in story design? Note. There are 2 correct answers to this question
Add a custom widget
Add a popup
Add a layer to a geo map
Add JavaScript to a button
You are using a live connection for a model. Where is the data stored?
Embedded data set
Source system
Public dataset
SAP Analytics Cloud Model
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 Business Objects Universe
SAP Analytics Cloud Analytic Model
SAP Analytics Cloud Public Dataset
SAP HANA View
SAP Datasphere Model
You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question
Actual
Forecast
Predictive
Budget
How can you help a user enter data faster in a planning story? Nate There are 2 correct answers to this question
Select fluid data entry mode in the story
Enable Optimize Recommended Planning Area in the model
Set Size Units for Planning Performance in the model
Enable unbooked data in the story
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?
Reference
Distribute
Driver
Redistribute
In a data model, what can you use to further describe a dimension?
Property
Measure
Data action
Variable
In a planning data model, what dimensions are included by default? Note There are 2 correct Answers to this question
Date
Entity
Organization
Version
Where can you create a blank planning version?
In Version management
In the planning model
In the Version dimension
In a data cell
Which tasks can you perform in data analyzer? Note: There are 2 correct answers to this question
Filter data
Input Data
Drill Down on data
Create Cross-Calculation
You are using a live connection for a model. Where can you define data security?
Source System
Data access control
SAP Analytics Cloud Role
SAP Analytics Cloud 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 refresh the story that uses the dataset
You must create a new dataset
You must manually re-import the data
What can you do with a multi action? Note: There are 2 correct answers to this question
Import transaction data
Run allocation data actions
Approve data
Run allocation processes
How can you limit the refresh time of a story?
Implement a value driver tree
Use canvas pages
Collapse the hierarchy
Create calculated measures
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?
Hierarchy
Cardinality
Level
Granularity
How can you determine node relationships in a value driver tree? Note: There are 2 correct answers to this question
Use a model converted measure
Use a story calculated measure
Use a dimension hierarchy
Use a calculated member
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
Filtering data on a page
Selecting an alternate data source
Implementing row-level and column-level security in a table
What source system can you connect to with a live connection?
SAP SuccessFactors
SAP ERP Central Component
SAP Datasphere
SAP Business By Design Analytics
Which dimension type can you use like a measure?
Account
Date
Organization
Entity
What can you use to perform cell-based calculations in a story?
Restricted measures
Calculated measures
Dimension formulas
Table formula
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
Use two hierarchies
Dis-able distribution
Dis-able allocations
Where can you change a data lock status? Note: There are 2 correct answers to this question
Multi action
Data action
Value lock Management
Calendar task
You have a live data model with two dimensions: First name and Last name. Users want a single dimension in the data model that displays the dimensions as Last name, First name. What must you do?
Group the First name and Last name in the data model
Create a calculated dimension in the data model
Create a calculated dimension in the story
Create the combined data in the source system
When scrolling down in a long table, how can you retain column headers? Note There are 2 correct answers to this question
Freeze Up to column
Freeze Up to row
Enable Auto-Size And Page Table Vertically
Enable Keeping member names visible
Which automatically created dimension type can you delete from an analytic data model?
Organization
Date
Generic
Version
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
Schedule the import
Allow model import
Refresh the story
Refresh the import job
To which story elements can you apply conditional formatting? Note There are 2 correct answers to this question
Chart
Composite
Lane
Table
What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question
On-premise
Live
Import
Cloud
You want to display differences between measures in a chart. What can you use?
Restricted measure
Threshold
Variance
Reference Line
You have a story in My Flies. You want your colleague to review and comment on the story What must γου do?
Include the story in a Discussion
Add a Comment widget to the story
Create a Review task for the story
Share with View access
Your story takes a long time to open. What could cause this? Note There are 3 correct answers to this question
Many data source
Complex formatting
Large calculation scape
Many story filters
Many hyperlinks
You want to save your data analyzer result. What is it saved as?
Story
Dataset
Insight
Model
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?
Increase the overall size of the chart widget on the page
Select the Avoid Data Label Overlap checkbox
Increase the font size of the axis labels
