Font size
S
M
L
XL
WorksheetsC_SACP_2202 - SAP Certified Application Associate - SAP Analytic
Total questions: 80
Worksheet time: 40mins
Name
Class
Date
1.
What data can be exported from SAP Analytics Cloud to SAP S/4HANA? Note: There are 2 correct answers to this question.
a)
Statistical key figures
b)
Activity prices
c)
Master data attributes
d)
Hierarchies
2.
Which of the following actions would allow you to use data point comments? Note: There are 2 correct answers to this question.
a)
Insert a calculated column to a table.
b)
Add a comment widget to the story.
c)
Activate comments by model.
d)
Activate comments by dimension.
3.
Which data locking status can you use to prevent manual data entry?
a)
Released
b)
Closed
c)
Submitted
d)
Restricted
4.
You are planning with two hierarchies that have different granularity. Your model contains no data. The story has two pages: a parent planning page and a member planning page (see screenshot). In the Member Planning page you enter the following data: Brazil 100, Chile 100, Peru 100<br />In the Parent Planning page you enter the following data: North America 10000, South America 30000<br />When you go back to the Member Planning page, what will you see? Note: There are 2 correct answers to this question.
a)
North America 10000, US 5000, Canada 5000
b)
South America 30300, Brazil 10100, Chile 10100, Peru 10100
c)
South America 30300, Brazil 100, Chile 100, Peru 100
d)
North America 10000, US 0, Canada 0
5.
What node types can be imported from S/4HANA? Note: There are 3 correct answers to this question.
a)
T
b)
L
c)
N
d)
H
e)
R
6.
You want to create a copy data action that allows you select the source values and target values for the following dimensions at run time: Version, Account, Time. What do you specify for each of these dimensions? Choose the correct answer.
a)
Source version parameter in the filter. Source and target parameters for account and time in the copy rules
b)
Source and target parameters for version in the filter. Source and target parameters for version and time in the copy rules
c)
No Filter. Source and target parameters for version, account, and time in the copy rules
d)
Source and target parameters for version in the filter. Source and target parameters for version and time in the copy rules.
7.
What can you do in an analytic application?
a)
Enter form-based comments.
b)
Trigger input tasks.
c)
Read data from write-back models.
8.
Which DataStore object (advanced) properties must be selected to export data to SAP Business Warehouse? Note: There are 2 correct answers to this question.
a)
Write interface enabled
b)
Write change log
c)
Direct update datastore object
d)
Standard datastore object
9.
Which SAP Analytics Cloud Machine Learning function provides performance indicators that can be used to evaluate the accuracy of a statistical model?
a)
Smart Predict
b)
Smart Insights
c)
Smart Grouping
d)
Smart Discovery
10.
You imported a transaction data file into an empty model with the results as shown in Figure A. Later, a member of the finance team wants you to import a new data file. In the new data file, you find the following differences: The value of the Labor account has increased to 1600. There is a new record for the Services account, with a value of 250.<br />The record for the Travel account has been deleted. To achieve the result shown in Figure B, which option must you use to update the data?
a)
Update
b)
Clean and replace subset of data with Scope = Version and Account
c)
Append: Reject duplicated rows in model
d)
Clean and replace selected version data
11.
You are working on a flat file-based planning model. You want to prevent manual data entry for certain data intersections.<br />What options do you have? Note: There are 2 correct answers to this question.
a)
Work status locks
b)
Data locks
c)
Cell locks
d)
Data slice locks
12.
What can you use to restrict input in a story based on nested conditions?
a)
Validation rules
b)
Data locking
c)
Advanced filtering
13.
Which of the following SAP Business Warehouse variable types can be used when importing data to SAP Analytics Cloud?<br />Note: There are 2 correct answers to this question.
a)
Single values
b)
Hierarchy nodes
c)
SAP exits
d)
Customer exits
14.
You are running a predictive forecast. What could the data lines represent in the preview? Note: There are 2 correct answers to this question.
a)
Line 1 is forecast data
b)
Line 1 is input data
c)
Line 2 is forecast data
d)
Line 2 is input data
15.
You have created a new SAP Analytics Cloud dimension to be used for SAP S/4HANA master data. To import the members, text, and hierarchy data, how many data sources do you need?
a)
6
b)
3
c)
5
d)
4
16.
Which of the following can you use to create an SAP Analytics Cloud planning model? Note: There are 3 correct answers to this question.
a)
Story
b)
Model
c)
File
d)
Data source
e)
Analytic application
17.
Which dimension types support the system-generated Person Responsible property? Note: There are 2 correct answers to this question.
a)
Account
b)
Generic
c)
Organization
d)
Version
18.
In an analytic application, which element can you enter comments for?
a)
Data points in a chart
b)
Data cells in a table
c)
Dimension members in a table
19.
In SAP Analytics Cloud Smart Predict, how can you use versions with a planning model? Note: There are 2 correct answers to this question.
a)
Train the model with completed public data.
b)
Train the model with in-process public data.
c)
Save the forecast to public version.
d)
Save the forecast to a private version.
20.
You enter plan values by year and product group. You want to allocate these values to months and products in proportion to last yearIs actual data. What setting in the allocation process is required to achieve this?
a)
Add product as a reference dimension
b)
Add date as a reference dimension
c)
Add date as a source dimension
d)
Add product as a source dimension
21.
You have labor hours in an expense model and labor rates in the HR model. To calculate and store labor values (labor hours x labor rates) in the expense model, what must you do? Note: There are 2 correct answers to this question.
a)
Include the labor hours and labor rates in a dimension formula.
b)
Blend labor hours and labor rates in the story.
c)
Copy the labor rates into the expense model.
d)
Look up the labor rates in an advanced data action.
22.
You are creating a planning model that is based on SAP BPC, version for SAP BW/4HANA Embedded option. What sources<br />are supported for the SAP Analytics Cloud model?
a)
BW query
b)
Aggregation level
c)
CDS view
d)
CompositeProvider
23.
You are importing from SAP S/4HANA into a planning model with pre-converted actuals turned on. What mappings are required to import both local and default currency?
a)
Two accounts
b)
Two currencies
c)
Two measures
d)
Two currency types
24.
You have a planning model with the following dimensions: account, product, profit center, date, and version. In a story, which new master data can you add on the fly? Note: There are 2 correct answers to this question.
a)
Hierarchy node
b)
Account member
c)
Profit center property value
d)
Product member
25.
Which scenarios can you implement using SAP Analytics Cloud advanced formulas? Note: There are 2 correct answers to this question.
a)
Aggregate dimension members.
b)
Eliminate intercompany transactions in real-time.
c)
Forecast HR turnover rates using machine learning.
d)
Calculate depreciation.
26.
When you import group reporting data from SAP S/4HANA to an SAP Analytics Cloud planning model, which mappings are required? Note: There are 2 correct answers to this question.
a)
Company to an SAP Analytics Cloud entity
b)
Consolidation unit to an SAP Analytics Cloud entity
c)
Financial statement item to an SAP Analytics Cloud account
d)
General ledger account to an SAP Analytics Cloud account
27.
Which of the following are prerequisites to export transaction data to a DataStore object (advanced) in SAP Business Warehouse? Note: There are 2 correct answers to this question.
a)
OData connection
b)
Enhancement spot RSBPC_ODATA
c)
Maintenance view RSBPC_ODATA_V_EX
d)
SAP Business Warehouse connection
28.
In a story, you are using a planning model with currency translation enabled. Which properties in the cross calculation editor do you have when configuring currency conversion? Note: There are 2 correct answers to this question.
a)
Category
b)
Rate version
c)
Rate type
d)
Exchange rate
29.
What are prerequisites for importing master data from an SAP S/4HANA system into SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
A data service must be active in the S/4HANA service catalog.
b)
A CDS view must exist for the source data.
c)
The target dimension must be a private dimension.
d)
The target dimension must be input enabled.
30.
When you delete a planning model, what dimension types are always deleted? Note: There are 2 correct answers to this question.
a)
Account
b)
Organization
c)
Time
d)
Version
31.
You have a planning model with the following dimensions: Cost Center, Account,Date, Entity, Version<br />When you add new transactional data to your model, you want to overwrite any records with cost center A and add new data for<br />cost center B. Which import method do you use?
a)
Clean and replace selected version data
b)
Update
c)
Append
d)
Clean and replace subset of data
32.
Your account dimension has an account for Profit that is calculated as [Revenue] – [Cost]. Which formula can you use to enter a value for Profit and have the system re-calculate Cost while Revenue remains constant?
a)
[Revenue] – [Cost] | INVERSE ([Cost] = [Revenue] – [Profit])
b)
[Revenue] – [Cost] := INVERSE ([Cost] = [Revenue] – [Profit])
c)
[Revenue] – [Cost] := (INVERSE [Cost] := [Revenue] – [Profit])
d)
[Revenue] – [Cost] | INVERSE ([Cost] := [Revenue] – [Profit])
33.
How can you change plan data via the Planning Panel in a story? Note: There are 2 correct answers to this question.
a)
Repost the values to a higher level of the hierarchy.
b)
Redistribute values to a lower level of the hierarchy.
c)
Distribute values based on recommendations.
d)
Realign values based on properties.
34.
When exporting from SAP Analytics Cloud to SAP Business Warehouse, which of the following are active by default? Note: There are 2 correct answers to this question.
a)
Update fiscal period
b)
Overwrite mode
c)
Update calendar month
d)
Delta mode
35.
You saved data for a certain cost center and profit center combination. Later, an administrator created a validation rule that prevents saving data against that combination. What happens when you display the data in a story?
a)
An error message is displayed.
b)
The data is deleted.
c)
A warning message is displayed.
d)
The data is realigned.
36.
In an existing planning model, what currency-related setting CANNOT be changed?
a)
Currency dimension
b)
Date dimension
c)
Currency table
d)
Default currency
37.
What does SAP recommend you do before you import data from SAP Business Warehouse to SAP Analytics Cloud?
a)
Set up a file server
b)
Install SAP Analytics Cloud agent
c)
Configure an OData connection
38.
You have an allocation process with 3 steps. Which of the following can be used to run only allocation step #2?
a)
Allocation button
b)
Story task bar
c)
Data Action
39.
You create a dimension in SAP Analytics Cloud with a hierarchy. You want to update the new dimension with data from a characteristic in SAP Business Warehouse using SAP recommended practices. To populate the members and the hierarchy, what steps must you take? Note: There are 3 correct answers to this question
a)
Load the members and hierarchy in the same import.
b)
Create an SAP Analytics Cloud query.
c)
Create an SAP Business Warehouse query.
d)
Include the hierarchy in the SAP Business Warehouse query.
e)
Load the members in a separate import.
40.
You have a model in SAP BPC, version for SAP BW/4HANA Standard option that contains data records in both local currency and group currency. When you create the corresponding planning model in SAP Analytics Cloud, you set the Currency Conversion setting to On. How does this<br />impact the planning model? Note: There are 2 correct answers to this question.
a)
Local currency and group currency are imported.
b)
Currencies are determined from the currency dimension.
c)
Local currency is imported.
d)
Currencies are determined from the entity dimension.
41.
From which S/4HANA source table can you import actual data for cost centers?
a)
COSP
b)
COSS
c)
ACDOCA
d)
ACDOCP
42.
What SAP Business Warehouse data can you import into SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
SAP BW query text elements
b)
Characteristic structures
c)
Hierarchical characteristic structures
d)
Calculated key figures
43.
When you run a data action with the "publish target version automatically" setting enabled, what changes to your data are published? Note: There are 2 correct answers to this question.
a)
Manual changes to the private and public versions
b)
Data action-specific changes to the target public version
c)
Data action-specific changes to the private and public versions
d)
Manual changes to the target version
44.
You want to import group reporting data to an SAP Analytics cloud planning model. What source table must you use?
a)
ACDOCU
b)
ACDOCA
c)
ACDOCP
d)
ACDOCC
45.
You are mapping an SAP Business Warehouse data source with 4 key figures and 10 lines of data to a planning model. You have mapped all key figures to your model. How many lines of data are imported into your model?
a)
10
b)
40
c)
14
d)
4
46.
What are the pillars of SAP Analytics Cloud? Note: There are 3 correct answers to this question.
a)
Planning
b)
Business Intelligence
c)
Data Warehousing
d)
Blockchain management
e)
Predictive
47.
You need to plan with finance data from SAP S/4HANA in SAP Analytics Cloud. To get started, you need to import master data from SAP S/4HANA. You are following the steps recommended by SAP. From which source can you import master data from SAP S/4HANA?
a)
CDS view
b)
Calculation view
c)
InfoObject
d)
Dataset
48.
In the visual editor for advanced formulas, which of the following formula options can you select? Note: There are 2 correct answers to this question.
a)
Repeat
b)
Lookup
c)
Comment
d)
Round
49.
You need to copy data from one version to another for a group of customers. For privacy reasons, you want the results to be copied to an unassigned customer. Where do you specify this in your data action?
a)
Copy rules
b)
Aggregate to
c)
Options
d)
Filters
50.
What dimension types can be used to determine currencies? Note: There are 2 correct answers to this question.
a)
Organization
b)
Account
c)
Date
d)
Generic
51.
You have an SAP Business Warehouse data source with 25 key figures and no account characteristic.What must you do to import this data into an existing planning model? Note: There<br />are 2 correct answers to this question.
a)
Map the key figures to the account card during the import.
b)
Include 25 accounts in the planning model.
c)
Map the key figures to the measures card during the import.
d)
Include 25 value columns in the planning model.
52.
In SAP Analytics Cloud, where can you apply data security ? Note: There are 2 correct answers to this question.
a)
Model
b)
Property
c)
Analysis authorizations
d)
SAP Identity Management
53.
What master data can you update during the import of transaction data into an SAP Analytics Cloud planning model with private and public dimensions?
a)
Hierarchies for public dimensions
b)
Property values for public dimensions
c)
Property values for private dimensions
54.
Which planning version type can you share with a co-worker from within a story?
a)
Plan
b)
Private
c)
Public
55.
Which work files can you access when you run a planning process? Note: There are 2 correct answers to this question.
a)
URL link
b)
Dashboard
c)
Workbook
d)
Analytic application
56.
You enter the following code into the formula script editor: MEMBERSET[d/Account]= What does the auto-complete feature return? Note: There are 2 correct answers to this question.
a)
Parameters
b)
Properties
c)
Hierarchies
d)
Members
57.
When you import account hierarchy data from SAP S/4HANA, which of the following account types are determined by<br />semantic tags exclusively? Note: There are 2 correct answers to this question.
a)
LEQ
b)
INC
c)
AST
d)
EXP
58.
You are using the SAP BPC, version for SAP BW/4HANA Standard option. When importing data from a YTD model to SAP Analytics Cloud, what can you do? Note: There are 2 correct answers to this question.
a)
Store periodic data for income statement accounts.
b)
Select the basic model type.
c)
Select the write-back model type.
d)
Store YTD data for income statement accounts.
59.
When you import data into a planning model, what can you do with category and version in data management? Note: There are 3 correct answers to this question.
a)
Use an existing version.
b)
Use an existing category.
c)
Create a new public version.
d)
Create a new private version.
e)
Create a new category.
60.
You want to rebuild an SAP Analytics Cloud planning model but the Rebuild Model button is inactive. Why might this happen? Note: There are 2 correct answers to this question.
a)
A public version is used in the model.
b)
Data exists in the model.
c)
Currency conversion is enabled.
d)
A private version is used in the model.
61.
Which hierarchy types are supported in an SAP Analytics Cloud dimension?
a)
Time-dependent
b)
Version-dependent
c)
Story-specific
d)
Level-based
62.
You are using mass data entry mode. After you enter new transaction data, what can you do with the data?
a)
Lock
b)
Publish
c)
Process
d)
Revert
63.
Where can you enter data into an SAP Analytics Cloud model? Note: There are 2 correct answers to this question.
a)
In the SAP Analytics Cloud mobile app
b)
In an analytic application
c)
In the SAP HANA studio
d)
In a story
64.
You want to import data from SAP BPC Standard. Which SAP Analytics Cloud planning model types can you use? Note: There are 2 correct answers to this question.
a)
Basic
b)
Generic
c)
Write-back
d)
Financial
65.
In a rolling forecast table, what can be used to determine the date to cut over to plan data?
a)
Last actual value
b)
Current date with an offset
c)
Look back x number of months
d)
Look ahead x number of months
66.
Which of the following actions on the date dimension are available in Value Driver Trees? Note: There are 2 correct answers to this question.
a)
Change the date filter for an individual node within the Value Driver Tree.
b)
Specify a presentation date range.
c)
Select the Day granularity.
d)
Change the date filter for the entire Value Driver Tree.
67.
You are using the planning panel to distribute values. Which of the following driver options can you select? Note: There are 3 correct answers to this question.
a)
Append
b)
Overwrite
c)
Equal
d)
Proportionate
e)
User-defined
68.
In SAP Analytics Cloud, what must you do when you use a planning model with group reporting data for legal elimination reports? Note: There are 2 correct answers to this question.
a)
Select a consolidation unit hierarchy.
b)
Store elimination entities persistently.
c)
Select a consolidation profit center hierarchy.
d)
Determine elimination entities dynamically.
69.
You are using SAP BPC, version for SAP BW/4HANA Standard option. When you create a planning model based on an SAP BPC model, what can you do in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Create planning sequences.
b)
Create data manager packages.
c)
Create data actions.
d)
Create public dimensions.
70.
What does SAP recommend you do to improve the performance of advanced formulas?
a)
Minimize the number of MEMBERSET statements.
b)
Maximize the number of DATA functions.
c)
Maximize the number of RESULTLOOKUPs.
d)
Minimize the use of LOOP instructions.
71.
In a story, how can you create a chart to compare versions? Note: There are 2 correct answers to this question.
a)
Add a new member with a formula.
b)
Add a chart component.
c)
Add a recommended comparison.
d)
Add a Idifference fromI measure.
72.
You have compared the data version options in stories vs. SAP Analysis, Edition for Microsoft Office. What did you discover?
a)
Private versions are available in stories only.
b)
The data version options are the same.
c)
Sharing private versions is available only in stories.
73.
In SAP Analytics Cloud, where can users access data locking tasks?
a)
Input controls
b)
Planning stories
c)
Security
d)
Calenda
74.
What data sources are available for SAP Analysis, Edition for Microsoft Office? Note: There are 2 correct answers to this question.
a)
SAP BusinessObjects Universe
b)
SAP S/4HANA Cloud for group reporting
c)
SAP Analytics Cloud
d)
SAP HANA
75.
When you set up a copy data action, what must you do to allow the user to select the source version?
a)
Add a parameter to the filter.
b)
Add an aggregate for the version.
c)
Add a copy rule for the version.
76.
In the pre-delivered planning content, which financial statement version is used to integrate S/4HANA account hierarchies and SAP Analytics Cloud account hierarchies?
a)
S4H1
b)
YCOA
c)
RTC1
d)
FPA1
77.
You are using SAP Analytics Cloud and SAP BPC, version for SAP BW/4HANA Embedded option. Which of the following planning features are available for hybrid planning?<br />Note: There are 2 correct answers to this question.
a)
Analysis authorizations
b)
Data actions
c)
Planning sequences
d)
Data access controls
78.
Which account types allow you to display database values with the opposite sign in stories? Note: There are 2 correct answers to this question.
a)
EXP
b)
AST
c)
LEQ
d)
INC
79.
How can you use a data action to copy data from one version to another while keeping the account number the same? Note: There are 2 correct answers to this question.
a)
Include a parameter for version in the filter and ItoI & IfromI parameters for the account dimension in the copy rules.
b)
Include a parameter for version and account in the filter section of the data action.
c)
Include a parameter for account in the filter and ItoI & IfromI parameters for version in the copy rules.
d)
Include ItoI & IfromI parameters for version and account in the copy rules.
80.
What can you do with live connections in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Secure data with on-premise system security.
b)
Reduce data redundancy.
c)
Export data.
d)
Secure data with SAP Analytics Cloud security
Reset
