SAC Planning 2022
1. 01. For which of the following are value driver trees available? There are 2 correct answers
to this question.
a) Live models
b) Datasets
c) Planning models
d) Analytic models: c) Planning models
d) Analytic models
2. 02. Which components will you need before you can import group reporting transaction data from S/4HANA
into SAP Analytics Cloud?
There are 2 correct answers to this question.
a) S/4HANA connection
b) Freehand query
c) GRTransactionData query
d) OData connection: b) Freehand query
d) OData connection
3. 03. You have an SAP Analytics Cloud BI license. What can you do with a value driver tree (VDT)?
There are 2 correct answers to this question.
a) Create a VDT directly within a story.
b) Change data on a VDT.
c) Create a VDT from a planning process.
d) Publish data with a VDT.: a) Create a VDT directly within a story.
b) Change data on a VDT.
4. 04. How can you change plan data via the Planning Panel in a story? There are 2 correct answers to
this question.
a) Repost the values to a higher level of the hierarchy.
b) Realign values based on properties.
c) Distribute values based on recommendations.
d) Redistribute values among date members.: c) Distribute values based on recommendations.
d) Redistribute values among date members.
5. 05. In a story table cell, you want to change the value from 500 to 450. What can you enter to achieve this?
There are 2 correct answers to this question.
a) -50
b) -10%
c) 90%
d) +-50: b) -10%
d) +-50
, SAC Planning 2022
6. 06. What dimension types are required in a planning model? There are 3 correct answers
to this question.
a) Date
b) Version
c) Generic
d) Account
e) Organization: a) Date
b) Version
d) Account
7. 07. Where can you run data actions? There are 2 correct
answers to this question.
a) SAP Analytics Cloud calendar
b) Planning process
c) Planning sequence
d) Analytical application: a) SAP Analytics Cloud calendar
d) Analytical application
8. 08. What can you use to publish the result of a predictive forecast in a planning model?
There are 2 correct answers to this question.
a) Time series chart
b) Smart Predict model
c) Line chart
d) Table: b) Smart Predict model
d) Table
9. 09. When setting up data wrangling to import data, which functions can be used in calculated columns?
There are 3 correct answers to this question.
a) RESTRICT
b) LOOKUP
c) DATEDIFF
d) TRIM
e) CONTAIN: c) DATEDIFF
d) TRIM
e) CONTAIN
10.10. What validation rule types are supported by SAP Analytics Cloud? There are 2 correct answers to
this question.
a) Member
b) User exit
c) Hierarchy
, SAC Planning 2022
d) Attribute: a) Member
d) Attribute
11.Using a live connection in SAP Analytics Cloud, for which system can you change plan data?
A. SAP BPC Embedded
B. SAP S/4HANA
C. SAP BPC Estandar: A. SAP BPC Embedded
12.You are importing from SAP S/4HANA into a planning model with pre-con- verted actuals turned on. What
mappings are required to import both local and default currency?
A. Two currency types
B. Two measures
C. Two currencies: B. Two measures
13.You need a hierarchy that is based both on the region and the country column in the same dimension.
What hierarchy type can you use?
A. Level-based
B. Parent-child
C. Table-based: A. Level-based
14.Why do you use a table formula?
A. To disaggregate data
B. To define link dimensions
C. To create an on-the-fly calculation
D. To enable allocation of data: C. To create an on-the-fly calculation
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. 3
B. 4
C. 6
D. 1
E. 5: E. 5
16.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. 40
B. 10
C. 4
D. 14: A. 40
1. 01. For which of the following are value driver trees available? There are 2 correct answers
to this question.
a) Live models
b) Datasets
c) Planning models
d) Analytic models: c) Planning models
d) Analytic models
2. 02. Which components will you need before you can import group reporting transaction data from S/4HANA
into SAP Analytics Cloud?
There are 2 correct answers to this question.
a) S/4HANA connection
b) Freehand query
c) GRTransactionData query
d) OData connection: b) Freehand query
d) OData connection
3. 03. You have an SAP Analytics Cloud BI license. What can you do with a value driver tree (VDT)?
There are 2 correct answers to this question.
a) Create a VDT directly within a story.
b) Change data on a VDT.
c) Create a VDT from a planning process.
d) Publish data with a VDT.: a) Create a VDT directly within a story.
b) Change data on a VDT.
4. 04. How can you change plan data via the Planning Panel in a story? There are 2 correct answers to
this question.
a) Repost the values to a higher level of the hierarchy.
b) Realign values based on properties.
c) Distribute values based on recommendations.
d) Redistribute values among date members.: c) Distribute values based on recommendations.
d) Redistribute values among date members.
5. 05. In a story table cell, you want to change the value from 500 to 450. What can you enter to achieve this?
There are 2 correct answers to this question.
a) -50
b) -10%
c) 90%
d) +-50: b) -10%
d) +-50
, SAC Planning 2022
6. 06. What dimension types are required in a planning model? There are 3 correct answers
to this question.
a) Date
b) Version
c) Generic
d) Account
e) Organization: a) Date
b) Version
d) Account
7. 07. Where can you run data actions? There are 2 correct
answers to this question.
a) SAP Analytics Cloud calendar
b) Planning process
c) Planning sequence
d) Analytical application: a) SAP Analytics Cloud calendar
d) Analytical application
8. 08. What can you use to publish the result of a predictive forecast in a planning model?
There are 2 correct answers to this question.
a) Time series chart
b) Smart Predict model
c) Line chart
d) Table: b) Smart Predict model
d) Table
9. 09. When setting up data wrangling to import data, which functions can be used in calculated columns?
There are 3 correct answers to this question.
a) RESTRICT
b) LOOKUP
c) DATEDIFF
d) TRIM
e) CONTAIN: c) DATEDIFF
d) TRIM
e) CONTAIN
10.10. What validation rule types are supported by SAP Analytics Cloud? There are 2 correct answers to
this question.
a) Member
b) User exit
c) Hierarchy
, SAC Planning 2022
d) Attribute: a) Member
d) Attribute
11.Using a live connection in SAP Analytics Cloud, for which system can you change plan data?
A. SAP BPC Embedded
B. SAP S/4HANA
C. SAP BPC Estandar: A. SAP BPC Embedded
12.You are importing from SAP S/4HANA into a planning model with pre-con- verted actuals turned on. What
mappings are required to import both local and default currency?
A. Two currency types
B. Two measures
C. Two currencies: B. Two measures
13.You need a hierarchy that is based both on the region and the country column in the same dimension.
What hierarchy type can you use?
A. Level-based
B. Parent-child
C. Table-based: A. Level-based
14.Why do you use a table formula?
A. To disaggregate data
B. To define link dimensions
C. To create an on-the-fly calculation
D. To enable allocation of data: C. To create an on-the-fly calculation
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. 3
B. 4
C. 6
D. 1
E. 5: E. 5
16.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. 40
B. 10
C. 4
D. 14: A. 40