Unit 1
Learning Assessment - Answers
1. From where can stories access data?
Choose the correct answers.
X A InfoCubes
X B Import models
X C Datasets
X D Universes
X E Calculation Views
Stories access data from datasets, import models, and live data models.
2. The account-based model only has one measure.
Determine whether this statement is true or false.
X True
X False
A typical account-based model only has one measure.
3. A planning model requires which dimensions?
Choose the correct answers.
X A Version
X B Organization
X C Generic
X D Date
A planning model requires Version and Date dimensions.
© Copyright. All rights reserved. 17
Unit 1: Learning Assessment - Answers
4. The account-based model does not support:
Choose the correct answers.
X A Calculated measures
X B Story calculations
X C Converted measures
X D Table formulas
You cannot create calculated measures or converted measures in an account-based
model.
5. How many measures can you have in a measure-based model?
Choose the correct answer.
X A One
X B Unlimited
X C No more than five
You can have as many measures as you need in a measure-based model.
6. Models always contain data.
Determine whether this statement is true or false.
X True
X False
Live models do not contain data.
7. In a live model, where is data access controlled?
Choose the correct answer.
X A The source system
X B The model
X C SAP Analytics Cloud
In a live model, data access is controlled in the source system for the model.
18 © Copyright. All rights reserved.
Unit 1: Learning Assessment - Answers
8. What supports scheduled data uploads?
Choose the correct answer.
X A Data set
X B Live model
X C Import model
Only import models support scheduled data uploads.
9. Embedded datasets are user-specific.
Determine whether this statement is true or false.
X True
X False
Embedded datasets are story specific.
© Copyright. All rights reserved. 19
Unit 2
Learning Assessment - Answers
1. Measure values are stored in models.
Determine whether this statement is true or false.
X True
X False
Measure values are stored in models.
2. Which is a valid dimension type?
Choose the correct answers.
X A Imported
X B Live
X C Public
X D Private
The dimension valid types are Public and Private.
3. Which dimension cannot be shared among models?
Choose the correct answer.
X A Imported
X B Live
X C Public
X D Private
A Private dimension cannot be shared among models because it exists only in the model
where it was created.
44 © Copyright. All rights reserved.
Unit 2: Learning Assessment - Answers
4. You can create public date dimensions.
Determine whether this statement is true or false.
X True
X False
The system creates date dimensions. They are model-specific.
5. What dimension types can you add when you create a model in SAP Analytics Cloud?
Choose the correct answers.
X A Account
X B Version
X C Generic
X D Organization
X E Date
When creating a model, you can add Account, Generic, and Organization dimension types.
Version and date dimensions are added by the system.
6. A model can contain multiples of which dimension type?
Choose the correct answers.
X A Account
X B Generic
X C Date
X D Version
X E Organization
A model can contain multiple Date and Generic dimension types.
7. A Person Responsible property can be created in a Generic dimension.
Determine whether this statement is true or false.
X True
X False
A Person Responsible property can be enabled in a Generic dimension.
© Copyright. All rights reserved. 45
Unit 2: Learning Assessment - Answers
8. What is a type of hierarchy?
Choose the correct answers.
X A Level-based
X B Branched tree
X C Parent-Child
X D Star schema
The types of hierarchies are level-based and parent-child.
9. Hierarchies are available in every dimension type.
Determine whether this statement is true or false.
X True
X False
Hierarchies are not available for the Version dimension type.
10. Data preparation involves manipulating the data to make it accurate and to match your
business needs.
Determine whether this statement is true or false.
X True
X False
Data preparation involves manipulating the data to make it accurate and to match your
business needs.
11. You can add calculated columns when importing into a dimension.
Determine whether this statement is true or false.
X True
X False
You can add calculated columns when importing into a dimension.
46 © Copyright. All rights reserved.
Unit 2: Learning Assessment - Answers
12. What can you use to prepare master data?
Choose the correct answers.
X A Calculation Editor
X B Custom Expression Editor
X C Smart Transformations
X D Formula Editor
To prepare master data, you can use the Calculation Editor and Smart Transformations.
© Copyright. All rights reserved. 47
Unit 3
Learning Assessment - Answers
1. What happens when you turn off the Planning option in Model Preferences?
Choose the correct answer.
X A Data can be written to the model
X B Currency conversion is possible
X C The Version dimension goes away
X D The Data dimension is added
The Version dimension goes away when the Planning option is turned off, thus creating an
Analytic model where Version is not required.
2. When importing data into a model, which dimension has no import option?
Choose the correct answers.
X A Version
X B Account
X C Date
X D Organization
The Version and Date dimensions are system-generated so have no import option.
3. If just one step in a scheduled import fails, all steps fail.
Determine whether this statement is true or false.
X True
X False
If just one step in a scheduled import fails, the subsequent steps can run if the import
allows it.
86 © Copyright. All rights reserved.
Unit 3: Learning Assessment - Answers
4. Dimension member formulas are only available for the account type dimension.
Determine whether this statement is true or false.
X True
X False
Dimension member formulas are only available for the account type dimension.
5. Where does SAP Analytics Cloud store exchange rates?
Choose the correct answer.
X A In a dataset
X B In a currency table
X C In a model
X D In a dimension
Exchange rates are stored in a separate currency table.
6. How can the currency table be updated?
Choose the correct answers.
X A BPC rate model
X B Flat File
X C FTP
X D BW query
X E Internet download
The currency table can be updated via flat file, BPC rate model, or BW query.
7. What time pattern is supported for the Date dimension?
Choose the correct answer.
X A 4-4-4
X B 4-5-5
X C 13x4
X D 12x4
The supported weekly time patterns are: 4-4-5, 4-5-4, 5-4-4, 13x4.
© Copyright. All rights reserved. 87
Unit 3: Learning Assessment - Answers
8. How is the model's time unit granularity defined?
Choose the correct answer.
X A By the model Preferences
X B By the imported data
X C By the Date dimension
X D By the import query
The model's time unit granularity is defined by the Date dimension.
9. What is a prerequisite for creating a custom time hierarchy?
Choose the correct answer.
X A Add the hierarchy to the source system
X B Add time-related properties to the Date dimension
X C Change the Date dimension to organize date by fiscal year
Because time hierarchies are parent-child, you must add time-related properties to the
Date dimension.
88 © Copyright. All rights reserved.
Unit 4
Learning Assessment - Answers
1. Data Analyzer can use import connections.
Determine whether this statement is true or false.
X True
X False
The data analyzer can use live connections.
2. When accessing data from SAP S/4HANA, what is a possible data source?
Choose the correct answers.
X A Query
X B Core Data Services View
X C Calculation View
X D InfoProvider
Data sources for SAP S/4HANA are CDS Views and Queries.
3. What is the source when acquiring data from SAP HANA Cloud into SAP Analytics Cloud?
Choose the correct answer.
X A Core Data Services View
X B Calculation View
X C Composite View
X D Responsive View
Calculation Views in SAP HANA Cloud are used to provide data to SAP Analytics Cloud.
© Copyright. All rights reserved. 99
Unit 4: Learning Assessment - Answers
4. What SAP BW element is supported in a SAP Analytics Cloud model?
Choose the correct answers.
X A Exception
X B Structure
X C Variable
X D Condition
Structures and Variables are supported BW elements, along with Time-dependent
hierarchies, Variants and Personalization, and parallel processing of queries.
5. When using a WebI document as a data source, Web Intelligence variables are not
accessible.
Determine whether this statement is true or false.
X True
X False
Your SAP Analytics Cloud live model has access to variables defined in the Web
Intelligence document.
100 © Copyright. All rights reserved.
Unit 5
Learning Assessment - Answers
1. When you geo-enrich data, the system concatenates the latitude and longitude columns.
Determine whether this statement is true or false.
X True
X False
When you geo-enrich data, the system concatenates the latitude and longitude columns.
2. Which dimension is automatically created when you geo-enrich the data?
Choose the correct answer.
X A Region
X B Area
X C Geo Reference
X D Location
The Location dimension is created when you geo-enrich the data.
3. Where can you get Point of Interest data?
Choose the correct answers.
X A .xlsx or .csv file
X B SAP HANA model
X C Internet download
X D Esri shapefile
X E Geo table
You can get Point of Interest data from .xlsx or .csv files, SAP HANA models, and Esri
shapefiles.
108 © Copyright. All rights reserved.
Unit 6
Learning Assessment - Answers
1. How is access to objects controlled?
Choose the correct answer.
X A via Roles
X B via Teams
X C In the object
Access to objects is controlled via Roles.
2. With data access control, what permission can you set for dimension members?
Choose the correct answers.
X A Update
X B Read
X C Write
X D Manage
Dimension members can have Read or Write access set for them with data access control.
116 © Copyright. All rights reserved.
