SAC Simulado

Prévia do material em texto

Pergunta 1
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
Dis-able distribution
Use two properties
Dis-able allocations
Pergunta 2 
Where can you change a data lock status? Note: There are 2 correct answers to this question.
Data action
Multi action
Calendar task
Value lock management
Pergunta 3 
What source system can you connect to with a live connection?
SAP Business ByDesign Analytics
SAP Datasphere
SAP ERP Central Component
SAP SuccessFactors
Pergunta 4 
What type of predictive scenario can write back to a planning model?
Regression
Value driver tree
Classification
Time series forecast
Pergunta 5 
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 Analytics Cloud public dataset
SAP BusinessObjects Universe
SAP Datasphere model
SAP Analytics Cloud analytic model
SAP HANA view
Pergunta 6 
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
Hierarchy
Granularity
Level
Pergunta 7 
You are using a live connection for a model. Where is the data stored?
SAP Analytics Cloud model
Public dataset
Source system
Embedded data set
Pergunta 8 
What can you use to organize dimensions into logical categories in a live model?
Parent-child hierarchy
Value driver tree
Level-based hierarchy
Groups
Pergunta 9 
You need to delete characters from a column in a dataset. What can you use? Note: There are 2 correct answers to this question.
Calculation editor
Transform bar
Custom expression editor
Formula bar
Pergunta 10 
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.
Allow model import
Refresh the import job
Refresh the story
Schedule the import
Pergunta 11 
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 story calculated measure
Use a calculated member
Use a model converted measure
Pergunta 12 
You are creating a new public version. Which categories can you use? Note: There are 2 correct answers to this question.
Forecast
 
Budget
Actual
Predictive
Pergunta 13 
What must you use to transform data in a dataset using if/then/else logic?
Transform bar
Formula bar
Calculations editor
Custom expression editor
Pergunta 14 
You want to total several income and expense accounts using the account type property. What configuration option in the advanced formula must you use?
Aggregate to
Unbooked
Append
Signflip
Pergunta 15 
Where can you create a blank planning version?
 
In version management
In a data cell
In the version dimension
In the planning model
Pergunta 16 
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?
Nothing
Send
 
Publish
Save
Pergunta 17 
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 aggregation dimension functions
Use fewer MEMBERSET statements
Use fewer IF statements
Use fewer data functions
Pergunta 18 
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
Pergunta 19 
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
Single
Mass
Pergunta 20 
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 story.
Create a calculated dimension in the data model.
Group the Firstname and Lastname in the data model.
Create the combined data in the source system.
Pergunta 21 
What are the available connection types in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
Live
On-premise
Import
Cloud
Pergunta 22 
What account types use the average rate type? Note: There are 2 correct answers to this question.
INC
AST
EXP
LEQ
Pergunta 23 
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.
Standalone
Embedded
Planning
 
Analytic
Pergunta 24 
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.
Create a group that includes the dimensions.
Convert the embedded dataset to a model.
Create a parent-child hierarchy in the dataset.
Pergunta 25 
You are using a live connection for a model. Where can you define data security?
SAP Analytics Cloud model
Data access control
Source system
SAP Analytics Cloud role
Pergunta 26 
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
Distribute
Reference
Redistribute
Pergunta 27 
What must a data model contain in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
Measures
Calculations
Dimensions
Hierarchies
Pergunta 28 
Which SAP Analytics Cloud feature uses natural language processing?
Smart insight
Digital boardroom
Data analyzer
Just Ask feature
Pergunta 
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.
Insert a character into the Year measure using the transform bar.
Includes the Year measure in a level-based time hierarchy in the dataset.
Add the month as a suffix to the Year measure.
Pergunta 30
You are creating a script for an advanced data action. Which character designates a virtual variable member?
#
*
%
/
Pergunta 31
How can you help a user enter data faster in a planning story? Note: There are 2 correct answers to this question.
Enable unbooked data in the story.
Set Size Limits for Planning Performance in the model.
Select fluid data entry mode in the story.
Enable Optimize Recommended Planning Area in the model.
Pergunta 32
Which calculation types include dynamic date options? Note: There are 2 correct answers to this question.
Difference From
Aggregation
Date Difference
Restricted Measure
Pergunta 33
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?
Source system
Embedded data sets
Public datasets
Stories
Pergunta 34
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
Composite
Responsive
Canvas
Pergunta 35
When scrolling down in a long table, how can you retain column headers?
Freeze Up to column
Enable Keeping member names visible
Freeze Up to row
Enable Auto-Size And Page Table Vertically
Pergunta 36
 You want to use an input control to filter data appearing in a story. At what level is the filter applied?
Component
Page
Story
Calculation
Pergunta 37
Which features are available in the Optimized Design Experience? Note: There are 3 correct answers to this question.
Grid pages
Composites
Explorer
Linked widgets diagram
Undo button
Pergunta 38
Which automatically created dimension type can you delete from an analytic data model?
Generic
Date
Organization
Version
Pergunta39
In a planning data model, what dimensions are included by default? Note: There are 2 correct answers to this question.
Version
Organization
Date
Entity
Pergunta 40
What features are supported by data analyzer? Note: There are 3 correct answers to this question.
Linked dimensions
Input controls
Calculated measures
Conditional formatting
Charts
Pergunta 41
To which story elements can you apply conditional formatting? Note: There are 2 correct answers to this question.
Chart
Table
Lane
Composite
Pergunta 42
Which dimension type can you use like a measure?
Entity
Organization
Account
Date
Pergunta 43
How can you limit the refresh time of a story?
Implement a value driver tree
Create calculated measures
Collapse the hierarchy
Use canvas pages
Pergunta 44
What is required to use version management in a story?
Analytic model
Classic mode
Planning model
Optimized mode
Pergunta 45
You want to display differences between measures in a chart. What can you use?
Variance
Threshold
Restricted measure
Reference line
Pergunta 46
In a data model, what can you use to further describe a dimension?
Property
Variable
Measure
Data action
Pergunta 47
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 must create a new dataset.
You must manually reimport the data.
You can schedule the dataset to update on a regular basis.
You must refresh the story that uses the dataset.
Pergunta 48
You want to save your data analyzer result. What is it saved as?
Insight
Dataset
Story
Model
Pergunta 49
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
Self and Children
Self and Siblings
Self and Descendants
Pergunta 50
You have a story in My Files. You want your colleague to review and comment on the story. What must you do?
Include the story in a Discussion
Share with View access
Add a Comment widget to the story
Create a Review task for the story
Pergunta 51
What can you do to reduce the data refresh time when opening a story? Note: There are 3 correct answers to this question.
Avoid tables with more than 500 rows and 60 columns
Avoid prompts
Use conditional formatting
Load widgets in the background
Pergunta 52
You are creating a styling rule for a table. What is the context?
The most granular level in the table
The highest level in the table
The location of the cursor
The table header
Pergunta 53
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
Increase the font size of the axis labels
Increase the overall size of the chart widget on the page
Pergunta 54
Which tasks can you perform in data analyzer? Note: There are 2 correct answers to this question.
Filter data
Create cross-calculation
Input data
Drill down on data
Pergunta 55
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 hyperlinks
Many data sources
Large calculation scope
Pergunta 56
What can you use input controls for in a story? Note: There are 2 correct answers to this question.
Selecting an alternate data source
Implementing row-level and column-level security in a table
Changing dimensions or measures displayed in a table
Filtering data on a page
Pergunta 57
In which types of data source can you concatenate data? Note: There are 3 correct answers to this question.
Standalone dataset
Embedded data set
Data analyzer insight
Live data model
Imported data model
Pergunta 58
For which activities must you enable Advanced Mode in ? Note: There are 2 correct answers to this question.
Add a custom widget
Add JavaScript to a button
Add a layer to a geo map
Add a popup
Pergunta 59
What can you use to perform cell-based calculations in a story?
Dimension formulas
Table formulas
Calculated measures
Restricted measures
Pergunta 60
Which programming language is used for scripting in an SAP Analytics Cloud story?
Wrangling Expression Language
ABAP
JavaScript
Python