問題一覧
1
In which types of data source can you concatenate data? Note: There are 3 correct answers to this question
Embedded data set, Standalone dataset, Imported data model
2
Your story takes a long time to open. What could cause this? Note: There are 3 correct answers to this question.
Many story filters, Complex formatting, Many data sources
3
Which automatically created dimension type can you delete from an analytic data model?
Generic
4
What features are supported by data analyzer? Note: There are 3 correct answers to this question.
Charts, Conditional formatting , Calculated measures
5
Which calculation types include dynamic date options? Note: There are 2 correct answers to this question.
Restricted Measure, Difference From
6
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?
Create a level-based hierarchy in the dataset.
7
You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question.
Custom expression editor, Transform bar
8
Which SAP Analytics Cloud feature uses natural language processing?
Smart insight
9
Your 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.
Planning, Analytic
10
You want to display differences between measures in a chart. What can you use?
Variance
11
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.
Refresh the story, Schedule the import
12
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?
Responsive
13
In a planning data model, what dimensions are included by default? Note: There are 2 correct answers to this question.
Date, Version
14
What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct answers to this question.
Avaid tables with more than 500 rows and 60 columns, Load widgets in the background, Use conditional formatting
15
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
16
What source system can you connect to with a live connection?
SAP Datasphere
17
How can you limit the refresh time of a story?
Collapse the hierarchy
18
What type of predictive scenario can write back to a planning model?
Time series forecast
19
What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
Live, Import
20
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 you use?
Self
21
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?
Change the Year measure to a dimension in the dataset.
22
You are using a live connection for a model. Where can you define data security?
Source system
23
You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question.
Budget, Actual
24
In a data model, what can you use to further describe a dimension?
Property
25
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 row, Freeze Up to column
26
You are creating a styling rule for a table. What is the context?
The location of the cursor
27
For which activities must you enable Advanced Mode in ? Note: There are 2 correct answers to this question.
Add JavaScript to a button, Add a popup
28
You want to use an input control to filter data appearing in a story. At what level is the filter applied?
Page
29
You have a story in My Files. You want your colleague to review and comment on the story. What must you do?
Add a Comment widget to the story
30
What is required to use version management in a story?
Planning model
31
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 hierarchies
32
To which story elements can you apply conditional formatting? Note: There are 2 correct answers to this question.
Table, Chart
33
How can you help a user enter data faster in a planning story? Note: There are 2 correct answers to this question.
Select fluid data entry mode in the story., Enable Optimize Recommended Planning Area in the model.
34
How can you determine node relationships in a value driver tree? Note: There are 2 correct answers to this question.
Use a dimension hierarchy, Use a calculated member
35
What must you use to transform data in a dataset using if/then/else logic?
Custom expression editor
36
You have a live data model with two dimensions: Firstname and Lastname. Users want a single dimension in the data model that displays the dimensions as Lastname, Firstname. What must you do?
Create a calculated dimension in the data model.
37
What can you use to perform cell-based calculations in a story?
Table formulas
38
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?
Publish
39
You are creating a script for an advanced data action. Which character designates a virtual variable member?
/
40
Where can you change a data lock status? Note: There are 2 correct answers to this question.
Multi action, Calendar task
41
What account types use the average rate type? Note: There are 2 correct answers to this question.
INC, EXP
42
What can you use to organize dimensions into logical categories in a live model?
Parent-child hierarchy
43
You are using a live connection for a model. Where is the data stored?
Source system
44
What must a data model contain in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
Dimensions, Measures
45
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
46
How can you improve the performance of advanced data actions? Note: There are 3 correct answers to this question.
Use fewer FOREACH functions, Use fewer IF statements, Use fewer data functions
47
What can you do with a multi action? Note: There are 2 correct answers to this question.
Run allocation data actions, Import transaction data
48
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 HANA view, SAP Datasphere model, SAP Analytics Cloud analytic model
49
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?
Select the Avoid Data Label Overlap checkbox
50
You want to total several income and expense accounts using the account type property. What configuration option in the advanced formula must you use?
Signflip
51
Which tasks can you perform in data analyzer? Note: There are 2 correct answers to this question.
Filter data, Drill down on data
52
Which features are available in the Optimized Design Experience? Note: There are 3 correct answers to this question.
Undo button, Linked widgets diagram, Composites
53
You want to save your data analyzer result. What is it saved as?
Insight
54
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?
Cardinality
55
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.
56
Where can you create a blank planning version?
In version management
57
Which dimension type can you use like a measure?
Account
58
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?
Driver
59
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?
Stories
60
Which programming language is used for scripting in an SAP Analytics Cloud story?
JavaScript