Font size
S
M
L
XL
WorksheetsC_SAC_2202 - SAP Certified Application Associate – SAP Analytics
Total questions: 80
Worksheet time: 40mins
Name
Class
Date
1.
Which story feature is NOT supported in the iOS app of SAP Analytics Cloud?
a)
R-Visualizations
b)
Sharing and Annotation
c)
Prompts
d)
Device Preview
2.
Which scenario types can you select when you create a new Predictive Scenario in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Regression
b)
Exponential Smoothing
c)
Classification
d)
Linear Regression
3.
Which connector must you configure to use a live connection to an SAP BusinessObjects universe?
a)
SAP COR Direct Connector
b)
Cloud connector
c)
SAP Analytics Connector
d)
SAP BOE Live Data Connect
4.
Which minimum technical client requirements does SAP recommend to display reports in SAP Analytics Cloud? Note: There are 3 correct answers to this question.
a)
JavaScript disabled
b)
At least 500 kbit/sec connection speed
c)
Cookies disabled
d)
HTTP 1.1 connection
e)
At least 250 MB browser cache
5.
Which of the following tools can you use to present your SAP Analytics Cloud stories? Note: There are 3 correct answers to this question.
a)
SAP Digital Boardroom
b)
SAP Analytics Catalog
c)
Content network
d)
Analytic applications
e)
SAP Analytics Hub
6.
In SAP Analytics Cloud, where can you create a data locking task?
a)
Calendar
b)
Story
c)
Model
d)
Folder
7.
In the SAP Analytics Cloud, which menu path must you use to access license information?
a)
System -> Monitor -> Overview
b)
Browse -> Processes -> Allocations
c)
Security -> Activities -> Status
8.
What can you do with Smart Discovery? Note: There are 2 correct answers to this question.
a)
Identify insightful data relationships
b)
Simulate numeric targets
c)
Display allocations
d)
Discover relationships between data models
9.
What can you do with the Geo map widget of SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Select the map provider.
b)
Adjust the basemap layer within the Builder panel.
c)
Select different data sources and connection types for each layer.
d)
Define custom regions with JSON files.
10.
Which formats are supported for scheduling a publication? Note: There are 3 correct answers to this question.
a)
Microsoft Word
b)
Microsoft Excel
c)
Link
d)
Adobe PDF
e)
Microsoft PowerPoint
11.
Which role type can you set as default?
a)
Custom
b)
Date
c)
Catalog
d)
User
12.
Which collaboration functions can you use in SAP Analytics Cloud? Note: There are 3 correct answers to this question.
a)
Calendar functions
b)
Discussions
c)
Comment
d)
Inbox message
e)
Chat
13.
From where can you import users with the import feature? Note: There are 2 correct answers to this question.
a)
From File
b)
From an SAP HANA system
c)
From Active Directory
d)
From an SAP BW system
14.
Which function does Smart Predict support?
a)
Data Discovery
b)
Smart transformations
c)
Business Intelligence
d)
Planning
15.
In basic story design, which mathematical predictions can you choose manually to create a forecast? Note: There are 2 correct answers to this question.
a)
Linear regression
b)
Exponential smoothing
c)
Moving average
d)
Extrapolation
16.
In a geo map, how does a choropleth layer present data?
a)
It shows data as points on the map.
b)
It shows connections between two locations.
c)
It applies blocks of shading to locations.
d)
It uses color to visualize data density.
17.
Which analytical processes does SAP Analytics Cloud offer? Note: There are 3 correct answers to this question.
a)
Data Integration
b)
Augmented Analytics
c)
Predictive Maintenance
d)
Business Intelligence
e)
Enterprise Planning
18.
What can you use to access content in SAP Analytics Cloud? Note: There are 3 correct answers to this question.
a)
SAP Data Intelligence
b)
SAP Data Hub
c)
SAP Digital Boardroom
d)
SAP Analytics Hub
e)
SAP Analytics Catalog
19.
What can be used as a data source for an SAP Analytics Cloud story? Note: There are 3 correct answers to this question.
a)
Version
b)
Table
c)
Data model
d)
File
e)
Dataset
20.
A user has created a model in My Files. How can the user make the model available to other users? Note: There are 3 correct answers to this question.
a)
Select the model in Browse → Files and then the Schedule Publication option.
b)
Save the model to a public folder that is accessible to these users.
c)
Select the model in Browse → Files and then the Share option.
d)
Save the model to the Team folder if the other users are team members.
e)
Select the model in Browse → Files and then the Publish to Catalog option.
21.
In Graphical Design of the SAP Analytics Cloud, analytics designer, what can you do with scripting? Note: There are 2 correct answers to this question.
a)
Move widgets from canvas to panel.
b)
Organize widgets on the canvas.
c)
Implement cascading filter behavior.
d)
Display popup dialogs.
22.
In SAP Analytics Cloud Analytics Designer, which of the following elements are technical widgets? Note: There are 2 correct answers to this question.
a)
Geo Maps
b)
Radio Button Group
c)
Script Objects
d)
Script Variables
23.
Which of the following license types has the license subtype Concurrent?
a)
Business Intelligence
b)
Analytics Hub
c)
Planning Professional
d)
Planning Standard
24.
Which Smart feature allows you to investigate the top contributors of specific data points?
a)
Smart Predict
b)
Smart Assist
c)
Smart Discovery
d)
Smart Insights
25.
Which systems can provide data security for SAP Analytic Cloud? Note: There are 2 correct answers to this question.
a)
SAP BusinessObjects
b)
SAP Lumira, server edition
c)
SAP Business Warehouse
d)
SAP Roambi
26.
Which of the following are characteristics of the SAP Analytics Cloud security concept? Note: There are 2 correct answers to this question.
a)
Application security is determined by the set of roles.
b)
Roles are defined by licenses.
c)
One user can be assigned to multiple roles.
d)
Many users can be assigned to the same role.
27.
Which feature uses artificial intelligence to create recommendations based on historical data?
a)
Smart Insights
b)
Smart Predict
c)
Search to Insight
d)
Smart Discovery
28.
How is SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud installed?
a)
As an Add-on to SAP Analytics Cloud
b)
As part of a service pack
c)
As independent installation
d)
As an Add-in to Microsoft Office
29.
Which transformations can you use in the data modeler? Note: There are 2 correct answers to this question.
a)
Switch
b)
Change
c)
Insert
d)
Extract
30.
Which of the following is a function of SAP Analytics Cloud Teams? Note: There are 2 correct answers to this question.
a)
Provide access to objects in the SAP Analytics Cloud file system
b)
Set up granular permissions for a specific model
c)
Group users
d)
Assign licenses to users
31.
Where can you change account information? Note: There are 2 correct answers to this question.
a)
SAP Analytics Hub
b)
User list
c)
User profile
d)
Allocations
32.
In which global performance indicators does Smart Predict divide predictive models? Note: There are 2 correct answers to this question.
a)
Prediction Classifications
b)
Prediction Confidence
c)
Predictive Statistics
d)
Predictive Power
33.
What page types are supported in the Digital Boardroom? Note: There are 2 correct answers to this question.
a)
Grid
b)
Layers
c)
Canvas
d)
Responsive
34.
Which dynamic calculation types can be used in SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud? Note: There are 3 correct answers to this question.
a)
Moving average
b)
Moving percentage
c)
Suppress zero value
d)
Rank number
e)
Cumulative sum
35.
Which filter type can you select when you enable Batch Exporting for PDF files?
a)
Page filter
b)
Measure filter
c)
Chart filter
d)
Story filter
36.
In which elements of SAP Analytics Cloud can you use exception aggregations? Note: There are 2 correct answers to this question.
a)
Model
b)
Story
c)
Application
d)
Dataset
37.
What are key factors of the SAC Analytics Cloud security concept? Note: There are 2 correct answers to this question.
a)
The Catalog HUB requires an extra license.
b)
During user creation both first name and last name must be entered.
c)
The email address of a user must be entered in lowercase.
d)
During user creation a default role is automatically assigned.
38.
In SAP Analytics Cloud, what determines the permissions of a user? Note: There are 3 correct answers to this question.
a)
Team
b)
SAML attribute
c)
Roles
d)
Version
e)
License
39.
Which of the following programming languages can you use to create custom widgets in SAP Analytics Cloud?
a)
ABAP
b)
R
c)
CSS
d)
Python
40.
In SAP Analytics Cloud Business Intelligence, what can be compared using chart scaling? Note: There are 2 correct answers to this question.
a)
Dimensions
b)
Measures
c)
Device screen sizes
d)
Data sources
41.
What are the standard layouts in SAP Analytics Cloud, analytics designer? Note: There are 2 correct answers to this question.
a)
Popup
b)
Canvas
c)
Panel
d)
TabStrip
42.
Where can you download SAP Analysis for Microsoft Office add-ins for SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Microsoft Office support
b)
SAP Store
c)
Microsoft Store
d)
SAP Support Portal
43.
Which of the following are exception aggregation types in SAP Analytics Cloud data models? Note: There are 3 correct answers<br />to this question.
a)
Running Sum
b)
Variance
c)
Last
d)
Average
e)
Sum
44.
Which feature does the Smart Assist suite support?
a)
Machine Learning
b)
Planning
c)
Enterprise Intelligence
d)
Natural Language Query
45.
In SAP Analytics Cloud Analytics Designer, what does the automatic syntax check do? Note: There are 3 correct answers to this question.
a)
Division by zero
b)
Find errors within the whole application
c)
Balance brackets
d)
Find errors within one script
e)
Correct capitalization automatically
46.
Which features does SAP Analytics Cloud offer? Note: There are 3 correct answers to this question.
a)
Integrated Planning
b)
Data Integration
c)
Business Intelligence
d)
Data Mining
e)
Data Exploration
47.
Which live data sources can you use to schedule a story? Note: There are 3 correct answers to this question.
a)
SAP Data Warehouse Cloud
b)
SAP BW
c)
SAP HANA
d)
SAP HANA Cloud
e)
SAP BPC
48.
What kind of data does the Data Foundation view display?
a)
Object-relational data
b)
Hierarchical data
c)
Relational data
d)
Transactional data
49.
What can you do in the Styling panel of SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Setting up Linked Analysis
b)
Aligning widgets
c)
Applying templates
d)
Formatting
50.
In SAP Analytics Cloud, when does SAP recommend you use a data model instead of a dataset?
a)
To use a Live connection
b)
To wrangle data
c)
To create ad-hoc analysis
d)
To define a dimension
51.
Which data-wrangling functions can you use in SAP Analytics Cloud data models? Note: There are 3 correct answers to this question.
a)
Substring
b)
Replace
c)
Upper
d)
Concatenate
e)
Split
52.
SAP Analytics Cloud is part of which platform?
a)
SAP Business Technology Platform
b)
SAP Business Intelligence Platform
c)
SAP Mobile platform, consumer edition
d)
SAP HANA Cloud platform
53.
What does Smart Insights feature allow you to do?
a)
Examine a particular data point.
b)
Query a model with natural language.
c)
Examine a particular measure.
d)
Create a predictive forecast.
54.
Which SAP Business Warehouse query feature can you use within an SAP Analytics Cloud Business Warehouse live connection?
a)
Multiple data dimensions
b)
Planning models
c)
Selection option – Contain Pattern
d)
Hierarchical characteristic structure
55.
What is the highest security level SAP Analytics Cloud administration?
a)
Role
b)
System owner
c)
Team
d)
Folder
56.
Which object can you use for permission assignments?
a)
Users
b)
Security Model
c)
Teams
d)
Roles
57.
What are restrictions of SAP Analytics Cloud data models for SAP Analysis for Microsoft Office, edition for SAP Analytics<br />Cloud? Note: There are 3 correct answers to this question.
a)
Usage of default currency
b)
Working with Private Versions
c)
Usage of prompts
d)
Consumption of thresholds
e)
Visualization of SAP Analytics data locking
58.
Which filter operations can be used in SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Filter by measure
b)
Filter by member
c)
Filter by dimension
d)
Filter by dataset
59.
Which platform provides processes to ensure data quality in SAP Analytics Cloud?
a)
SAP Data Integration Service
b)
SAP HANA Cloud
c)
SAP Data Warehouse Cloud
d)
SAP Analytics Cloud
60.
In SAP Analytics Cloud, which file type does the Translation function support?
a)
XLIFF
b)
CSV
c)
Microsoft Word
d)
Microsoft Excel
61.
What kind of tables are used in the Structure view? Note: There are 2 correct answers to this question.
a)
Flat tables
b)
Dimension tables
c)
Attribute tables
d)
Fact tables
62.
What can you do with an SAP Analytics Cloud dataset compared with an SAP Analytics Cloud model? Note: There are 3 correct answers to this question.
a)
Overwrite data during data preparation
b)
Switch between data preparation view and story view
c)
Use special planning functions
d)
Secure datasets as objects
e)
Change visualizations within stories
63.
In SAP Analytics Cloud, you have blended two models in a story. What is a consequence?
a)
The original models are modified.
b)
The links between the models can be used in that story only.
c)
The links between the models can be used in other stories.
d)
A new model is created.
64.
In a story, what can you scale across multiple charts?
a)
Attributes
b)
Dimensions
c)
Chart types
d)
Measures
65.
What is a predictive scenario?
a)
A technique that divides a dataset into a training and a validation subset
b)
A process that uses SAP machine learning algorithms to explore relationships in datasets
c)
A workspace that guides the user through the creation of predictive models
d)
A description of the observations (rows) stored in a dataset
66.
Which of the following products can provide data to SAP Analytics Cloud? Note: There are 3 correct answers to this question.
a)
SAP Infrastructure Cloud
b)
Oracle Cloud Platform
c)
Microsoft Azure
d)
SAP Data Warehouse Cloud
e)
SAP HANA Cloud
67.
Which APIs can you use to manipulate data in SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
SAP Java API
b)
SAP REST API
c)
SAP VBA API
d)
SAP Formula API
68.
In which of the following components do you enable users for the SAP Analytics Cloud planning function?
a)
Configuration management
b)
Security management
c)
Permission management
d)
License management
69.
Which feature generates story pages?
a)
Search to Insight
b)
Smart Insights
c)
Smart Predict
d)
Smart Discovery
70.
Which of the following SAP BW/4HANA query features are supported in a live connection? Note: There are 3 correct answers to this question.
a)
Exit variables
b)
Expressions
c)
Conditions
d)
Initial layout
e)
SAP BW/4HANA structures
71.
Per load, what are the limits of data acquisition? Note: There are 2 correct answers to this question.
a)
1 billion cells
b)
100 million cells
c)
100 columns
d)
1000 columns
72.
What are the main components of SAP Analytics Cloud Business Intelligence? Note: There are 3 correct answers to this question.
a)
Models
b)
Stories
c)
Planning
d)
Predictive Scenario
e)
Analytic Applications
73.
In SAP Analytics Cloud, which of the following are International Business Communication Standards (IBCS) rules? Note: There are 2 correct answers to this question.
a)
Use information density
b)
Use reduced charts
c)
Use tables without in-cell charts
d)
Use signs instead of deviations
74.
Which of the following are layout sets in SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Style
b)
Cell
c)
Sheet
d)
VBA
75.
On what levels can you use linked dimensions? Note: There are 2 correct answers to this question.
a)
Page level
b)
Component level
c)
Model level
d)
Story level
76.
In SAP Analytics Cloud, where can you modify data security settings?
a)
Model preferences
b)
Version management
c)
Single sign-on
d)
Hierarchies
77.
You want to create a task with assignees and reviewers. Which task type must you select?
a)
Review task
b)
Data Action task
c)
Composite task
d)
General task
78.
Which license types can be used in SAP Analytics Cloud? Note: There are 2 correct answers to this question.
a)
Premium platform
b)
Planning
c)
Data Intelligence
d)
Business Intelligence
79.
Another user has uploaded an Excel file to the public folder. To create a model from this file, what must you do first?
a)
Move it to your Private folder.
b)
Download the file from the Public folder to your computer.
c)
Create a new Data Action on this file.
80.
In addition to basic styling options within the Styling panel of SAP Analytics Cloud, which programming language can you use to adjust visualizations?
a)
Python
b)
R
c)
CSS
d)
ABAP
e)
None
Reset
