Checkout your knowledge with Free 30 MCQ (Multiple Choice Questions) on Modeling in SAP Analytics Cloud (SAC): 1 / 30 What does the 'Currency Conversion' feature in SAC Modeling allow you to do? Convert measures into different currencies dynamically Change the language of data Filter out certain currency values Group dimensions by country 2 / 30 Data Actions in SAP Analytics Cloud are primarily used for: Predictive Modeling Data Blending Write back and Planning logic Data import 3 / 30 Which of the following cannot be done in the Modeler in SAC? Set up hierarchies Define a story page Create a calculated measure Schedule data imports 4 / 30 Which of the following is a benefit of using Hierarchies in SAC? Simplifies navigation and aggregation Increases data storage Remove dimensions Eliminates the need for data import 5 / 30 Which model type in SAC supports predictive features like Smart Predict? Predictive Model Analytical Model Planning Model Both B and C 6 / 30 In which scenario is Data Import Scheduling applicable? Live Connection Import Connection Both Live and Import Connection None of the above 7 / 30 Which of the following allows the extension of existing data models with additional data without changing the base model? Data Blending Data Wrangling Data Actions Data Enrichments 8 / 30 What is the main purpose of 'Linked Models' in SAC? To link stories to external applications To replicate data between models To link dimensions inside a model To create relationships between models for unified reporting 9 / 30 Which feature enables write-back capability in SAC? Data Actions Predictive Scenerios Smart Discovery Calendar Events 10 / 30 What are 'Input Tasks' used for in Planning Models? Collecting data from users for planning purposes Scheduling data loads Sending reports to users Creating predictive models 11 / 30 In a Planning Model, ‘Version’ dimension is used for: Connecting external data Storing historical data Comparing Actual, Plan, Forecast Validating data quality 12 / 30 What does the Smart Transformations feature allow during data import? Recommend joins between datasets Create time hierarchies automatically Suggest predictive forecasts Auto detect dimensions and measures 13 / 30 When creating a new model from a dataset, the default option is: Live Model Import Model Planning Model None of the above 14 / 30 Which of the following statements is TRUE about calculated dimensions? They replace hierarchies They are used to filter models They can be used only in stories They allow you to create new columns based on expressions 15 / 30 Which dimension is mandatory in all SAC Planning Models? Account Version Organization Time 16 / 30 Which of the following modeling options supports Hierarchies in SAC? Attributes Dimensions Measures Version Types 17 / 30 In SAP Analytics Cloud, the option to cleanse data during import is called: Data Harmonization Data Cleansing Wizard Data Wrangling Data Flow Transformation 18 / 30 The feature that enables time-based calculations in a model is called: Calendar Functions Date Type Time Dimension Time Based Hierarchy 19 / 30 Which of the following is NOT a valid dimension type in SAC models? Account Dimension Generic Dimension Organization Dimension Category Dimension 20 / 30 Which dimension in a Planning Model holds KPIs and Key Figures? Account Organization Version Category 21 / 30 Which of the following can be used to restrict measures based on conditions? Restricted Measures Calculated Measures Dimensions Hierarchies 22 / 30 Which feature in SAC allows you to group multiple members into a single member? Member Formula Member Aggregation Grouping Blending 23 / 30 Which of the following file formats are supported for data upload in SAC? CSV TXT XLSX All of the above 24 / 30 In SAC, Data Blending is mainly used to? Combine planning and actual data Join two datasets at the modeling level Merge different models in a story Blend different charts in one 25 / 30 Which connection type enables live access to backend systems without data replication? OData Connection Import Data Connection API Connection Live Data Connection 26 / 30 Which modeling option allows for on-the-fly calculations in SAC? Calculated Dimensions Restricted Measures Calculated Measures Both B and C 27 / 30 What is the primary purpose of a Model in SAP Analytics Cloud? To schedule data imports To design user access policies To create dashboards To define data structures and relationships 28 / 30 Which of the following is NOT a type of model in SAP Analytics Cloud? Predictive Model Business Process Model Planning Model Analytical Model 29 / 30 In a Planning Model, which feature allows for version comparisons like Actual vs Forecast? Data Wrangling Linked Dimensions Version Management Story Filters 30 / 30 4. Which of the following data types is supported in SAC models?A) IntegerB) StringC) DateD) All of the above✅ Answer: D String Date Integer All of the Above Your score is The average score is 71% 0% Restart quiz
Checkout your knowledge with Free 30 MCQ (Multiple Choice Questions) on Modeling in SAP Analytics Cloud (SAC):
1 / 30
What does the 'Currency Conversion' feature in SAC Modeling allow you to do?
2 / 30
Data Actions in SAP Analytics Cloud are primarily used for:
3 / 30
Which of the following cannot be done in the Modeler in SAC?
4 / 30
Which of the following is a benefit of using Hierarchies in SAC?
5 / 30
Which model type in SAC supports predictive features like Smart Predict?
6 / 30
In which scenario is Data Import Scheduling applicable?
7 / 30
Which of the following allows the extension of existing data models with additional data without changing the base model?
8 / 30
What is the main purpose of 'Linked Models' in SAC?
9 / 30
Which feature enables write-back capability in SAC?
10 / 30
What are 'Input Tasks' used for in Planning Models?
11 / 30
In a Planning Model, ‘Version’ dimension is used for:
12 / 30
What does the Smart Transformations feature allow during data import?
13 / 30
When creating a new model from a dataset, the default option is:
14 / 30
Which of the following statements is TRUE about calculated dimensions?
15 / 30
Which dimension is mandatory in all SAC Planning Models?
16 / 30
Which of the following modeling options supports Hierarchies in SAC?
17 / 30
In SAP Analytics Cloud, the option to cleanse data during import is called:
18 / 30
The feature that enables time-based calculations in a model is called:
19 / 30
Which of the following is NOT a valid dimension type in SAC models?
20 / 30
Which dimension in a Planning Model holds KPIs and Key Figures?
21 / 30
Which of the following can be used to restrict measures based on conditions?
22 / 30
Which feature in SAC allows you to group multiple members into a single member?
23 / 30
Which of the following file formats are supported for data upload in SAC?
24 / 30
In SAC, Data Blending is mainly used to?
25 / 30
Which connection type enables live access to backend systems without data replication?
26 / 30
Which modeling option allows for on-the-fly calculations in SAC?
27 / 30
What is the primary purpose of a Model in SAP Analytics Cloud?
28 / 30
Which of the following is NOT a type of model in SAP Analytics Cloud?
29 / 30
In a Planning Model, which feature allows for version comparisons like Actual vs Forecast?
30 / 30
4. Which of the following data types is supported in SAC models?A) IntegerB) StringC) DateD) All of the above✅ Answer: D
Your score is
The average score is 71%
Restart quiz
