Introduction to Modeling

Question 1

Where should all formulas be created?

At the intersection of a level and account.

In a level tag, such as a dimension or attribute

At the highest rollup

Answer 1

At the intersection of a level and account.

Question 2

Fill in the blank: Actuals and Plan data should always be at the __________ level.

Answer 2

same

Question 3

Creating and using a consistent level structure year over year impacts which of the following? Check all that apply.

Maintenance
Security
Reporting

Answer 3

Maintenance
Security
Reporting

Question 4

Which of the following should be completed before loading a level structure? Check all that apply.

Enable the required currencies

Create and load in any level dimensions and/or level attributes for reporting

Select the parent currency for the Total Company or Top Level, if not USD

Answer 4

Enable the required currencies

Create and load in any level dimensions and/or level attributes for reporting

Select the parent currency for the Total Company or Top Level, if not USD

Question 5

Which of the following is a true statement?

Reloading the entire structure will only erase the data for the current level in the current version

Reloading the entire structure will only erase the data for all levels in the current version

Reloading the entire structure will erase the data for all levels in all versions

Answer 5

Reloading the entire structure will erase the data for all levels in all versions

Question 6

The top level should be tagged with the correct corporate currency before any child level is created.

True
False

Answer 6

True

Question 7

Which of the following are best practices for managing currencies. Check all that apply.

Only input the exchange rates for the direction in which you need currency translations

When importing data, verify that it will be loaded at the local level currency

Enable user defined currencies for entities with the same currency but different exchange rates

Answer 7

Only input the exchange rates for the direction in which you need currency translations

When importing data, verify that it will be loaded at the local level currency

Enable user defined currencies for entities with the same currency but different exchange rates

Question 8

Which of the following methods can be used to set up exchange rates?

Import the applicable rates
Manually enter the applicable rates
Copy and paste from Excel
All of the above

Answer 8

All of the above

Question 9

Accounts are the driving force of the model.

True
False

Answer 9

True

Question 10

Which accounts can be classified as debit or credit accounts?

Modeled accounts
General Ledger accounts
Metric accounts
Custom accounts

Answer 10

General Ledger accounts

Question 11

When working with root accounts, which of the following can a user change? Choose all that apply.

Account name
Account type
Account code
Balance type

Answer 11

Account name

Account code

Question 12

Which of the following are best practices for accounts? Check all that apply.

Use custom accounts for formula writing

Use multiple charts of accounts to provide more detailed reporting

Use rollup accounts for formula writing

Use master formulas for Net Income and YTD Earnings (Loss) root accounts

Always import data to Net Income or Year to Date Income (loss) accounts

Use naming conventions of Account Number and Name for Account Name field, e.g., 7010 Accounting Fees

Make the Account Code same as Account Code from the data source system

Use rollup accounts with child accounts; do not import a flat hierarchy

Answer 12

Use custom accounts for summarized reporting

Use rollup accounts for formula writing

Use master formulas for Net Income and YTD Earnings (Loss) root accounts

Use naming conventions of Account Number and Name for Account Name field, e.g., 7010 Accounting Fees

Make the Account Code same as Account Code from the data source system

Use rollup accounts with child accounts; do not import a flat hierarchy

Question 13

Which of the following statements are correct? Check all that apply.

Hierarchical dimensions can have dimension attributes

Attributes have a 1:1 relationship

Dimensions and attributes can be flat or hierarchical

Level dimensions cannot have dimension attributes

Answer 13

Attributes have a 1:1 relationship

Dimensions and attributes can be flat or hierarchical

Level dimensions cannot have dimension attributes

Question 14

A dimension must have a flat hierarchy to enable dimension attributes.

True
False

Answer 14

True

Question 15

Which of the following is a correct statement?

Data can be input into attributes

Data can be input into dimensions

Data can be input into either dimensions or attributes

Answer 15

Data can be input into dimensions

Question 16

Dimensions and attributes cannot be used in formulas.

True
False

Answer 16

False

Question 17

When loading data to a dimension, it is best practice to load data to:

A dimension attribute
The dimension value
The parent dimension

Answer 17

The dimension value

Question 18

What should be done before setting up the calendar and importing data? Check all that apply.

Identify the default time stratum needed for the general ledger accounts

Determine the fiscal year

Understand the customer’s reporting requirements, e.g, day, week, month

Answer 18

Identify the default time stratum needed for the general ledger accounts

Determine the fiscal year

Understand the customer’s reporting requirements, e.g, day, week, month

Question 19

Who is responsible for setting up the fiscal year in Adaptive?

The implementer
Adaptive Provisioning team
The Account Manager

Answer 19

The implementer

Question 20

The default time stratum determines the exchange rate time stratum.

True
False

Answer 20

True

Question 21

Which option should be used to add new years to the calendar?

Update
Append
Reload entire structure

Answer 21

Append

Question 22

A user can reference data across formulas in different versions?

True
False

Answer 22

False

Question 23

Which of the following are types of versions? Check all that apply.

Actuals
Plan
Historical
Reporting only
Virtual

Answer 23

Actuals
Plan
Virtual

Question 24

Which data crosses versions?

Plan
Actuals
Virtual
Reporting

Answer 24

Actuals

Question 25

Which version is read only?

Actuals
Plan
Virtual

Answer 25

Virtual

Question 26

Is it a best practice to enable the locked version option and the audit trail option?

Yes
No

Answer 26

Yes

Question 27

When setting the left scroll limit, how many years is typically sufficient for formula writing?

1
2
3
4

Answer 27

2

Question 28

Which of the following are true statements regarding Roles and Permissions? Check all that apply.

Permissions indicate whether a user can input, edit or view data

Permissions are globally set for each user

Settings affect all levels in a model

Answer 28

Permissions indicate whether a user can input, edit or view data

Permissions are globally set for each user

Settings affect all levels in a model

Question 29

Which of the following are unique to a super user role? Check all that apply.

Create custom reports

Create roles and users

View salary detail

Bypass any security control

Answer 29

Create roles and users

Bypass any security control

Question 30

Which of the following are best practices? Check all that apply.

Login as a new user to confirm the access and permissions

Enable the User Activity Log

Require users to change their password on first login

Answer 30

Login as a new user to confirm the access and permissions

Enable the User Activity Log

Require users to change their password on first login

Question 31

Adding rollups to the sheet automatically adds any future children to the sheet’s design.

True
False

Answer 31

True

Question 32

In View by level mode, which of the following is displayed?

Levels down the rows of the sheet, time as a drop-down selection, and accounts in the columns

Levels down the rows of the sheet, accounts as a drop-down selection, and time in the columns

Accounts down the rows of the sheet, levels as a drop-down selection, and time in the columns

Accounts down the rows of the sheet, time as a drop-down selection, and levels in the columns

Answer 32

Levels down the rows of the sheet, accounts as a drop-down selection, and time in the columns

Question 33

Splits can be added to cube and standard sheets.

True
False

Answer 33

False

Question 34

A report must contain at least one account or account attribute and an element on both the row and column axes before it can be saved.

True
False

Answer 34

True

Question 35

When not specifically assigned in the report’s design, the version defaults to the Current Version; whatever was selected last in sheets.

True
False

Answer 35

True

Question 36

Saving or clicking Modify Report from the viewer does not update the report’s design to the displayed expanded or Drill into… presentation.

True
False

Answer 36

False

Question 37

Import templates are sheet specific.

True
False

Answer 37

True

Question 38

Are dimensions required to be in the import template?

Yes
No

Answer 38

No

Question 39

The user must populate data for all columns when loading data to a which type of sheet?

Standard
Modeled
Cube

Answer 39

Cube

Question 40

What is required to tell the system where to put the data when it comes into Adaptive?

Unique name for all fields
A mapping table
A data source selector

Answer 40

A mapping table

Question 41

Existing data is automatically erased when a user manually imports data?

True
False

Answer 41

False