KEMBAR78
SAC01 - Questions With Answers | PDF | Microsoft Excel | Oracle Corporation
0% found this document useful (0 votes)
135 views20 pages

SAC01 - Questions With Answers

The document contains a series of learning assessments and answers related to SAP Analytics Cloud, covering topics such as data connections, story creation, and model types. It includes true/false questions and multiple-choice questions with the correct answers provided. Additionally, it promotes a website and email for purchasing SAP-related materials.

Uploaded by

phoenixrv
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
135 views20 pages

SAC01 - Questions With Answers

The document contains a series of learning assessments and answers related to SAP Analytics Cloud, covering topics such as data connections, story creation, and model types. It includes true/false questions and multiple-choice questions with the correct answers provided. Additionally, it promotes a website and email for purchasing SAP-related materials.

Uploaded by

phoenixrv
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 20

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.

com

Unit 1

Learning Assessment - Answers

1. SAP's Business Technology Platform connects all elements of data processing into one
seamless experience.
Determine whether this statement is true or false.

X True

X False

SAP's Business Technology Platform connects all elements of data processing into one
seamless experience.

2. SAP Analytics Cloud is available in which two editions:


Choose the correct answers.

X A Embedded

X B Entrenched

X C Enterprise

X D Engagement

SAP Analytics Cloud is available in Embedded and Enterprise editions.

3. SAP Analytics Cloud includes Planning, Predictive, and Business Intelligence.


Determine whether this statement is true or false.

X True

X False

SAP Analytics Cloud includes Planning, Predictive, and Business Intelligence.

© Copyright. All rights reserved. 28

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 1: Learning Assessment - Answers

4. SAP Analytics Cloud offers live chat with experts as an embedded help function. This is
available via the Chat icon at the top of the screen.
Determine whether this statement is true or false.

X True

X False

The SAP Analytics cloud embedded help function includes guided help tutorials, videos,
and classical help documents. But no live chat.

5. When sharing a story externally, the file type is:


Choose the correct answer.

X A pdf

X B xlxs

X C html

X D csv

When sharing a story externally, the file type is pdf.

6. Bookmarks can be shared.


Determine whether this statement is true or false.

X True

X False

Bookmarks cannot be shared.

© Copyright. All rights reserved. 29

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 2

Learning Assessment - Answers

1. What are the two options for creating live data connections?
Choose the correct answers.

X A Channel

X B Direct

X C Tunnel

X D Linear

The two options for creating live data connections are Direct and Tunnel.

2. With an import connection, no data is stored in SAP Analytics Cloud.


Determine whether this statement is true or false.

X True

X False

With an import connection, data is duplicated from the on-premise datasource and stored
in SAP Analytics Cloud.

3. What kind of additional installation is needed to connect SAP Analytics Cloud with an on-
premise SAP BusinessObjects Universe?
Choose the correct answers.

X A BusinessObjects driver software

X B Business Intelligence Consumer Service (BICS)

X C SAP Cloud Platform Cloud Connector

X D SAP Analytics Cloud Agent

SAP Cloud Platform Cloud Connector and SAP Analytics Cloud Agent are needed to
connect SAP Analytics Cloud with an on-premise SAP BusinessObjects universe.

© Copyright. All rights reserved. 40

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 3

Learning Assessment - Answers

1. Stories have two main views. What are they?


Choose the correct answers.

X A Data view

X B Detailed view

X C Visual view

X D Story view

The two views available for a story are Data view and Story view.

2. Templates for stories are only predefined by SAP.


Determine whether this statement is true or false.

X True

X False

Templates can be created by your company or predefined by SAP.

3. What are the two possible foundations for a story?


Choose the correct answers.

X A Dataset

X B Model

X C Cube

X D InfoProvider

The two possible foundations for a story are a Model and a Dataset.

© Copyright. All rights reserved. 102

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 3: Learning Assessment - Answers

4. When using a model in a story, all table features are available, regardless of the model
type.
Determine whether this statement is true or false.

X True

X False

When using a model in a story, the set of table features depends on the type of model.

5. What programming language leverages machine learning and statistical capabilities for
data analysis?
Choose the correct answer.

X A HTML

X B R

X C C

X D Javascript

R is the programming language that leverages machine learning and statistical capabilities
for data analysis.

6. When using the explorer, you cannot change the visualization that is created
automatically.
Determine whether this statement is true or false.

X True

X False

When using the explorer, while visualizations are created automatically, you can change
them.

7. What are the supported calculation types?


Choose the correct answers.

X A Calculated Measures

X B Restricted Measures

X C Difference From

X D Currency Conversion

All of the above are supported calculation types.

© Copyright. All rights reserved. 103

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 3: Learning Assessment - Answers

8. SAP Analytics Cloud does not support IF conditional functions.


Determine whether this statement is true or false.

X True

X False

SAP Analytics Cloud supports IF conditional functions.

9. You create calculations only on measures.


Determine whether this statement is true or false.

X True

X False

You can create calculated dimensions.

10. To use cross calculations for currency conversion, the model must have currency
conversion enabled.
Determine whether this statement is true or false.

X True

X False

To use cross calculations for currency conversion, the model must have currency
conversion enabled.

11. If a datasource for a story includes variables/prompts, all tables and charts based on that
datasource are filtered to the variable response.
Determine whether this statement is true or false.

X True

X False

When a datasource for a story includes variables/prompts, all tables and charts based on
that datasource are filtered to the variable response.

© Copyright. All rights reserved. 104

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 3: Learning Assessment - Answers

12. What can you use to split a story page into smaller parts?
Choose the correct answer.

X A Section

X B Group

X C Container

X D Area

Use a Section to split a story page into smaller parts.

13. When using an input control for time, the time ranges must be fixed.
Determine whether this statement is true or false.

X True

X False

When using an input control for time, the time ranges can be either fixed or dynamic.

14. You can only have one filter per story or per page.
Determine whether this statement is true or false.

X True

X False

With advanced filtering, you can create story and page filters based on multiple
dimensions using AND or OR conditions.

15. Filtering on a single component on a story page is not possible.


Determine whether this statement is true or false.

X True

X False

Component filters filter the data in a specific component.

© Copyright. All rights reserved. 105

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 3: Learning Assessment - Answers

16. In what order can data be sorted?


Choose the correct answers.

X A Ascending

X B Descending

X C Specialized

X D Custom

Data can be sorted in Ascending, Descending, or Custom order.

17. How can you sort on a specific column or row as a primary sort?
Choose the correct answer.

X A Custom Sorting

X B Break Grouping

X C Canvas Sectioning

When Break Grouping is enabled, the sort is applied to the selected column/row first.

18. What do you use to enable one component to filter another component in a story?
Choose the correct answer.

X A Component Link

X B Grouped Analysis

X C Linked Analysis

X D Story Link

Linked Analysis allows you to enable one component to filter other components in a story.

19. Blending enables you to join a primary datasource with secondary datasources that
contain common linked dimensions.
Determine whether this statement is true or false.

X True

X False

Blending enables you to join a primary datasource with secondary datasources that
contain common linked dimensions.

© Copyright. All rights reserved. 106

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 3: Learning Assessment - Answers

20. What are two ways to geo-enrich your data?


Choose the correct answers.

X A By coordinates

X B By latitude

X C By longitude

X D By area name

The two ways to geo-enrich your data are by coordinates and by area name.

© Copyright. All rights reserved. 107

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 4

Learning Assessment - Answers

1. What are the possible foundations for an analytic application?


Choose the correct answers.

X A SAP Analytics Cloud model

X B Direct access to an OData Service

X C MS Excel spreadsheet

X D CVS file

The possible foundations for an analytic application are an SAP Analytics Cloud model and
direct access to an OData Service.

2. Which programming language can be used to enhance the Application Designer and its
functions?
Choose the correct answer.

X A C++

X B ABAP

X C VBA

X D JavaScript

JavaScript can be used to enhance the Application Designer and its functions.

© Copyright. All rights reserved. 117

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 5

Learning Assessment - Answers

1. The SAP Analytics Cloud Add-In for Microsoft Office is integrated with Office 365.
Determine whether this statement is true or false.

X True

X False

The SAP Analytics Cloud Add-In for Microsoft Office is integrated with Office 365.

2. The SAP Analytics Cloud Add-In for Microsoft Office is available for business intelligence
data analysis only.
Determine whether this statement is true or false.

X True

X False

The SAP Analytics Cloud Add-In for Microsoft Office is available for business intelligence
data analysis and for planning activities.

3. What are the basic features of Analysis for Excel?


Choose the correct answers.

X A Restrict

X B Calculate

X C Filter

X D Sort

The basic features of Analysis for Excel are Filter and Sort.

© Copyright. All rights reserved. 132

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 6

Learning Assessment - Answers

1. A model is SAP Analytics Cloud's semantic layer.


Determine whether this statement is true or false.

X True

X False

A model is SAP Analytics Cloud's semantic layer.

2. What does a model represent?


Choose the correct answer.

X A A star schema

X B A table of data

X C A snowflake schema

X D A cube

A model represents a table of data.

3. What are the three types of models used in SAP Analytics Cloud?
Choose the correct answers.

X A Planning

X B Business Intelligence

X C Analytics

X D Analytics based on an SAP HANA view

The three types of models used in SAP Analytics Cloud are Planning, Analytics, and
Analytics based on an SAP HANA view.

© Copyright. All rights reserved. 212

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 6: Learning Assessment - Answers

4. Data wrangling involves manipulating the data to make it accurate and match your
business needs.
Determine whether this statement is true or false.

X True

X False

Data wrangling involves manipulating the data to make it accurate and match your
business needs.

5. What are the two possible states of dimensions in SAP Analytics Cloud?
Choose the correct answers.

X A Secure

X B Ad Hoc

X C Public

X D Private

The two possible states of dimensions in SAP Analytics Cloud are Public and Private.

6. A private dimension can be shared by several models.


Determine whether this statement is true or false.

X True

X False

A public dimension can be shared by several models.

7. What are three types of dimensions?


Choose the correct answers.

X A Account

X B Generic

X C Organization

X D Product

Three types of dimensions are Account, Generic, and Organization.

© Copyright. All rights reserved. 213

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 6: Learning Assessment - Answers

8. What are the two types of aggregation in SAP Analytics Cloud?


Choose the correct answers.

X A Standard

X B Default

X C Exception

X D Deviation

The two types of aggregation in SAP Analytics Cloud are Standard and Exception.

9. The Account dimension can have multiple hierarchies.


Determine whether this statement is true or false.

X True

X False

The Account dimension has only a single hierarchy.

10. The New Model requires an Account dimension.


Determine whether this statement is true or false.

X True

X False

The Account dimension is optional in the New Model.

11. What is required to create an import data connection to an SAP BusinessObjects


universe?
Choose the correct answer.

X A ODBC Connector

X B SAP Analytics Cloud Connector

X C Generic Connector

The SAP Analytics Cloud Connector is required to create an import data connection to an
SAP BusinessObjects universe.

© Copyright. All rights reserved. 214

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 6: Learning Assessment - Answers

12. When importing data from SAP S/4HANA, dimension properties from S/4HANA may
need to be imported separately from the dimension's ID and Description data.
Determine whether this statement is true or false.

X True

X False

When importing data from SAP S/4HANA, dimension properties from S/4HANA may
need to be imported separately from the dimension's ID and Description data.

13. With a live data connection to SAP BW, authorizations must be duplicated in SAP
Analytics Cloud.
Determine whether this statement is true or false.

X True

X False

With a live data connection to SAP BW, SAP Analytics Cloud re-uses existing SAP BW
authorizations.

14. Validation rules can help prevent data input for invalid member combination across
dimensions.
Determine whether this statement is true or false.

X True

X False

Validation rules can help prevent data input for invalid member combination across
dimensions.

15. What are two possible uses of a Value Driver Tree?


Choose the correct answers.

X A View a planning simulation graphically

X B Track planning tasks

X C Leverage driver-based planning

X D Lock data

Two possible uses of a Value Driver Tree are to view a planning simulation graphically and
to leverage driver-based planning.

© Copyright. All rights reserved. 215

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 6: Learning Assessment - Answers

16. Stories can only be shared internally.


Determine whether this statement is true or false.

X True

X False

Stories can be shared both internally and externally.

17. Comments in SAP Analytics Cloud are limited to how many characters?
Choose the correct answer.

X A 280

X B 1332

X C 1,000

Comments in SAP Analytics Cloud are limited to 1,000 characters.

18. Live models cannot support which forecasting options?


Choose the correct answers.

X A Smart Grouping

X B Time Series Forecasting

X C Smart Insights

X D Smart Discovery

Live models cannot support the Smart Insights and Smart Discovery forecasting options.

19. What two items comprise the context for a Smart Discovery?
Choose the correct answers.

X A Dimension

X B Entity

X C Target

X D Measure

Entity and Target comprise the context for a Smart Discovery.

© Copyright. All rights reserved. 216

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 6: Learning Assessment - Answers

20. What are the three predictive scenarios available with Smart Predict?
Choose the correct answers.

X A Future

X B Classification

X C Historic

X D Regression

X E Time Series

The three predictive scenarios available with Smart Predict are Classification, Regression,
and Time Series.

© Copyright. All rights reserved. 217

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 7

Learning Assessment - Answers

1. SAP Digital Boardroom is a fully automated tool that instantly creates relevant
visualizations during a meeting. No preparation is needed before the meeting.
Determine whether this statement is true or false.

X True

X False

The content that needs to be displayed must be created and prepared in advance.

2. Which kind of mobile devices are supported by SAP Analytics Cloud?


Choose the correct answers.

X A iPhone

X B iPad

X C Android phone

X D Windows phone

SAP Analytics Cloud supports the iPhone and iPad.

3. Once a Schedule is defined, it cannot be modified.


Determine whether this statement is true or false.

X True

X False

Schedules can be modified as needed.

© Copyright. All rights reserved. 240

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 8

Learning Assessment - Answers

1. SAP Analytics Cloud offers the possibility to import user data from a CSV file.
Determine whether this statement is true or false.

X True

X False

You can import user data from a CSV file.

2. SAP Analytics Cloud provides security management for which three options?
Choose the correct answers.

X A Users

X B Groups

X C Roles

X D Teams

SAP Analytics Cloud provides security management for Users, Roles, and Teams.

3. Where is data security defined?


Choose the correct answer.

X A On a Model

X B On a Dimension

X C On a User

X D On a Role

Data security is defined on a Model.

© Copyright. All rights reserved. 267

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com
For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

Unit 8: Learning Assessment - Answers

4. When importing content into the most recent version of an SAP Analytics Cloud tenant,
the content must come from a tenant no older than the previous version.
Determine whether this statement is true or false.

X True

X False

When importing content into the most recent version of an SAP Analytics Cloud tenant,
the content must come from a tenant no older than the previous version.

5. When exporting data from SAP Analytics Cloud into a .csv file, what is the maximum
number of cells that will export?
Choose the correct answer.

X A 10 million

X B 3 million

X C 60 million

When exporting data from SAP Analytics Cloud into a .csv file, the maximum number of
cells that will export is 3 million.

6. When translating a story, what is the source language based on?


Choose the correct answer.

X A The language settings of the SAP Analytics Cloud administrator.

X B The language settings of the user who is translating the story.

X C The language settings of the creator of the story.

When translating a story, the source language is based on the language settings of the
creator of the story.

7. The Content Network contains pre-delivered content to assist customers with faster
implementations.
Determine whether this statement is true or false.

X True

X False

The Content Network contains pre-delivered content to assist customers with faster
implementations.

© Copyright. All rights reserved. 268

For Any SAP / IBM / Oracle - Materials Purchase Visit : www.erpexams.com OR Contact Via Email Directly At : sapmaterials4u@gmail.com

You might also like