問題一覧
1
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
2
Which tasks can you perform in data analyzer? Note: There are 2 correct answers to this question.
Filter data, Drill down on data
3
Which calculation types include dynamic date options? Note: There are 2 correct answers to this question.
Restricted Measure, Difference From
4
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
5
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
6
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
7
You want to use an input control to filter data appearing in a story. At what level is the filter applied?
Page
8
Which SAP Analytics Cloud feature uses natural language processing?
Smart insight
9
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
10
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
11
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
12
To which story elements can you apply conditional formatting? Note: There are 2 correct answers to this question.
Table, Chart
13
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.
14
What can you use to perform cell-based calculations in a story?
Table formulas
15
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
16
Which programming language is used for scripting in an SAP Analytics Cloud story?
JavaScript
17
Where can you create a blank planning version?
In version management
18
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
19
What source system can you connect to with a live connection?
SAP Datasphere
20
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
21
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
22
You are using a live connection for a model. Where is the data stored?
Source system
23
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.
24
What must a data model contain in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
Dimensions, Measures
25
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
26
What features are supported by data analyzer? Note: There are 3 correct answers to this question.
Charts, Conditional formatting , Calculated measures
27
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
28
What account types use the average rate type? Note: There are 2 correct answers to this question.
INC, EXP
29
What type of predictive scenario can write back to a planning model?
Time series forecast
30
Which automatically created dimension type can you delete from an analytic data model?
Generic
31
Which features are available in the Optimized Design Experience? Note: There are 3 correct answers to this question.
Undo button, Linked widgets diagram, Composites
32
In a planning data model, what dimensions are included by default? Note: There are 2 correct answers to this question.
Date, Version
33
What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
Live, Import
34
What can you use to organize dimensions into logical categories in a live model?
Parent-child hierarchy
35
You are creating a styling rule for a table. What is the context?
The location of the cursor
36
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
37
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
38
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.
39
What can you do with a multi action? Note: There are 2 correct answers to this question.
Run allocation data actions, Import transaction data
40
You are creating a script for an advanced data action. Which character designates a virtual variable member?
/
41
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.
42
Which dimension type can you use like a measure?
Account
43
What is required to use version management in a story?
Planning model
44
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
45
What must you use to transform data in a dataset using if/then/else logic?
Custom expression editor
46
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.
47
Where can you change a data lock status? Note: There are 2 correct answers to this question.
Multi action, Calendar task
48
In a data model, what can you use to further describe a dimension?
Property
49
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
50
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
51
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
52
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
53
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
54
You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question.
Budget, Actual
55
How can you limit the refresh time of a story?
Collapse the hierarchy
56
You want to display differences between measures in a chart. What can you use?
Variance
57
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
58
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
59
You are using a live connection for a model. Where can you define data security?
Source system
60
You want to save your data analyzer result. What is it saved as?
Insight