Operations Modeling Basics

Question 1

Which of the following is considered a best practice with regards to levels? Check all that apply.

Avoid naming convention that requires frequent changes

Create a level structure where actuals and plan data exist at different levels

Organize levels with the same currency under a shared parent level

Use punctuation symbols in level names

Answer 1

Avoid naming convention that requires frequent changes

Organize levels with the same currency under a shared parent level

Question 2

Which of the following options would be used when multiple levels use the same currency, but need different exchange rates?

Exchange Rate Type

Standard Currency

User Defined Currency

User Defined Exchange Rate Type

Answer 2

User Defined Currency

Question 3

Fill in the blank: Similar to level attributes, level __________________ can be used to define alternate level hierarchies.

Answer 3

dimensions

Question 4

Fill in the blank: A level structure ______________ can either overwrite, update or append any existing definitions.

Answer 4

import

Question 5

Level access assigned to a rollup is automatically applied to all underlying levels.

True
False

Answer 5

True

Question 6

The account code must be the same as the account code in the source system.

True
False

Answer 6

False

Question 7

Net Income (Loss) and Year to Date Income (Loss) should never have data imported to them.

True
False

Answer 7

True

Question 8

Which of the following is true when a structure import template contains errors?

The structure is imported for only those values that do not contain an error(s)

Nothing is loaded

Answer 8

Nothing is loaded

Question 9

Data can be loaded to both attributes and dimensions.

True
False

Answer 9

False

Question 10

A week that crosses two different months must use two different time codes.

True
False

Answer 10

True

Question 11

The default time stratum can only be changed be deleting all standard account data.

True
False

Answer 11

True

Question 12

Fill in the blank: __________________ can be created to organize versions.

Answer 12

Folders

Question 13

Fill in the blank: Best practice is to enable _______________ when a version is complete to avoid potential inputs errors.

Answer 13

locked version

Question 14

Which of the following is impacting by the version length? Check all that apply.

Importing data process

Number of formulas evaluated

Report generation time

Sheet load time

Answer 14

Number of formulas evaluated

Sheet load time

Question 15

Fill in the blank: The Starting scroll location defines the first column of ______________ displayed in the sheet.

Answer 15

actuals

Question 16

When logging in, users initially see the current version.

True
False

Answer 16

False

Question 17

Fill in the blank: User security is based on the ________________ to which a user is assigned and the level(s) the user needs to access.

Answer 17

roles

Question 18

Two predefined role groups are available. Both can be modified but not deleted.

True
False

Answer 18

False

Question 19

When multiple administrators are required, best practice is to have only one “super” administrator with access to which of the following administrative permissions? Check all that apply.

Import to All Levels

Privileged Actuals Access

Roles

Users

Answer 19

Roles

Users

Question 20

The Import Access permission does not respect level access.

True
False

Answer 20

True

Question 21

Data can be erased for both Actuals and Plan data with the Erase Data functionality.

True
False

Answer 21

False

Question 22

Data must be imported in the currency assigned to the level.

True
False

Answer 22

True

Question 23

Users can view Actuals data based on the left scroll limit in a Plan version without the role permission Privileged Actuals Access.

True
False

Answer 23

True

Question 24

Fill in the blank: An _______________ column is included in the import template when importing balance sheet account opening balances. (The answer is two words.)

Answer 24

Initial Balance

Question 25

The standard template for Actuals import can be used for Plan imports to cube and modeled sheets. True False

Answer 25

False

Question 26

Do not rename the Actuals tab in the data import template; data will load to the version selected on the Import Data page. True False

Answer 26

True

Question 27

Which of the following is a driver of sheet performance? Check all that apply. Accounts Dimensions Formulas Levels

Answer 27

Accounts Dimensions Formulas Levels

Question 28

Which of the following is true of standard sheets? Check all that apply. Allow for account customization Data withstands sheet deletion Default time stratum independence Support version comparison

Answer 28

Allow for account customization Data withstands sheet deletion Support version comparison

Question 29

Fill in the blank: Adding rollup, or parent accounts, to the sheet automatically adds any current or future _______________ .

Answer 29

children

Question 30

Fill in the blank: In _____________________ mode, accounts display as a drop-down selection.

Answer 30

View By Level

Question 31

Setting an account to read-only within the account group affects all levels. True False

Answer 31

True

Question 32

Fill in the blank: Best practice dictates that __________________________ should be run on a version when completed to ensure that there are no formula errors.

Answer 32

formula validation

Question 33

Which of the following are true concerning formula best practices? Check all that apply. Avoid using dates Reference time rollups or a prior period with the modifier time.this syntax Avoid using hard-coded drivers in formulas Use the * symbol to annotate a formula

Answer 33

Avoid using dates Avoid using hard-coded drivers in formulas

Question 34

Fill in the blank: The __________________ for an account must be set to one of the public options for its data to evaluate in a formula that crosses organization levels.

Answer 34

data privacy

Question 35

Fill in the blank: this.account and version.name are examples of _____________________ syntax.

Answer 35

dot notation

Question 36

Shared formulas do not support dimensionality. True False

Answer 36

True

Question 37

Fill in the blank: _______________formulas delete all existing data from the account.

Answer 37

master

Question 38

Personnel can be planned by week in a modeled sheet even with the default time stratum set to month. True False

Answer 38

True

Question 39

Fill in the blank: Modeled sheets allow for only one ______________ column.

Answer 39

timespan

Question 40

Modeled sheets support version comparison. True False

Answer 40

False

Question 41

Fill in the blank: Modeled sheet design is performed within the __________________ which consists of three panes.

Answer 41

sheet editor

Question 42

Fill in the blank: ______________ is a required column type and included by default in a new modeled sheet.

Answer 42

level

Question 43

Which column type is not available for use in matrix reports or formulas. Text Selector Text Timespan Date

Answer 43

Text Selector

Question 44

Which account type only allows for data entry at the highest (only) level of the structure? Assumption Custom Metric Modeled

Answer 44

Assumption

Question 45

Modeled accounts include the sheet code as a prefix to all accounts. Once created, this code can be modified. True False

Answer 45

False

Question 46

Which of the following is true of user-assigned sheets? Check all that apply. Respect level access Do not respect Access salary detail permission Administrator selects the users who can view the user-assigned sheet Only a modeled sheet can be a user-assigned sheet

Answer 46

Do not respect Access salary detail permission Administrator selects the users who can view the user-assigned sheet

Question 47

Cube accounts can be created manually or imported with the Import Structure feature. True False

Answer 47

True as of 2021R1. New functionality.

Question 48

Which general ledger account supports the use of the Formulas sheet to create formulas? cube standard

Answer 48

standard

Question 49

Which of the following is true of cube general ledger accounts? Check all that apply. Must be added to a cube sheet. Data entry to the account is performed on a cube sheet Can be displayed on a standard or cube sheet Formulas can be entered on the Formulas sheet or in each cell

Answer 49

Must be added to a cube sheet. Data entry to the account is performed on a cube sheet Can be displayed on a standard or cube sheet

Question 50

Fill in the blank: Up to ten_______________ can be added to a cube sheet.

Answer 50

dimensions

Question 51

An account’s type cannot be modified. If an error is made, delete the account and begin again. True False

Answer 51

True

Question 52

Fill in the blank: _________________ are created at the intersection of any two elements in order to hide or make certain input cells read-only.

Answer 52

restrictions

Question 53

Linked accounts do not cross all versions and levels. True False

Answer 53

False