OneStream Certification Exam UPDATED ACTUAL
QUESTIONS AND CORRECT Answers
What two dimensions are included in the Level 1 data Entity and Time
unit? Select 2.
-Entity
-Parent
-Time
-View
What is a helpful metric for determining the possible size Potential data intersections
of a data unit?
-Populated data intersections
-Number of cubes
-Number of workflows
-Potential data intersections
What is the purpose of the Cube Properties tab in To organize properties based on their role in the cube
OneStream?
-To organize properties based on their role in the cube
-To assign dimensions to the cube
-To link cubes through entity dimension
-To review data statistics
,What should be evaluated if one report renders faster Number of data units
than another?
-Number of dimensions
-Number of data units
-Number of scenarios
-Number of entities
What does Root indicate for a given dimension used in a The dimension is not being used in the cube
cube?
-The cube is using the default scenario for that dimension
-The dimension is not being used in the cube
-The dimension does not have data
-The cube is using the MainScenario for that dimension
What is the role of a Data Unit within a cube? To make data retrieval more efficient
-To manage data integration
-To make data retrieval more efficient
-To store and lock data
-To load, clear, calculate, translate, and consolidate data
An administrator runs a report to query Actuals, for the a.12
last 6 time periods, for 2 entities and 1 consolidation
dimension member.
How many Data Units will be queried?
a.12
b.6
c.9
d.10
Which report might perform slower due to the number of b.Consolidation Report containing multiple entities on the rows.
Data Units?
a. Income Statement with a single entity in the POV.
b. Consolidation Report containing multiple entities on the
rows.
c. Cash Flow statement with a single entity in the POV.
d. Balance Sheet with a single entity in the POV.
An administrator has added a significant number of base a. Through the Grid View
members into the Account dimension, but is only one
part of the job. They also need to make edits to the
member properties.
What is the quickest way for the administrator to edit the
member properties of these members?
a.Through the Grid View
b.Manually
c.Through an XML load file
Which tool can be used to create XML load files? a. Metadata Builder
a. Metadata Builder
b. Workflow Channels
c. Cube Views
d. Grid View
, What are siblings in a hierarchy? c.Members that share the same parent member.
a.Members up the chain from the selected member.
b.Bottom-level members where data is loaded.
c.Members that share the same parent member.
d.Upper-level members with children below them.
Which two statements accurately describe how to add a. XML Files are used to load entire dimension hierarchies by dimension type.
dimensions through an XML file? (Select 2.)
a. XML Files are used to load entire dimension hierarchies c. XML files are used when a large dimension hierarchy is required.
by dimension type.
b. XML files are used when a small hierarchy or a branch
within a hierarchy is required.
c. XML files are used when a large dimension hierarchy is
required.
d. XML files are used to make few additions to an existing
dimension hierarchy.
Which dimension type is not included in the Dimension c.Time
Library?
a.Scenario
b.Account
c.Time
d.Entity
What are descendants in a hierarchy? a.All members below a parent member.
a. All members below a parent member.
b. Members that share the same parent member.
c.Bottom-level members where data is loaded.
d.Members up the chain from the selected member.
What do you call a bottom-level member where data is b.Base member
loaded?
a. Parent members
b. Base member
c. Alternate hierarchies
d.Siblings
QUESTIONS AND CORRECT Answers
What two dimensions are included in the Level 1 data Entity and Time
unit? Select 2.
-Entity
-Parent
-Time
-View
What is a helpful metric for determining the possible size Potential data intersections
of a data unit?
-Populated data intersections
-Number of cubes
-Number of workflows
-Potential data intersections
What is the purpose of the Cube Properties tab in To organize properties based on their role in the cube
OneStream?
-To organize properties based on their role in the cube
-To assign dimensions to the cube
-To link cubes through entity dimension
-To review data statistics
,What should be evaluated if one report renders faster Number of data units
than another?
-Number of dimensions
-Number of data units
-Number of scenarios
-Number of entities
What does Root indicate for a given dimension used in a The dimension is not being used in the cube
cube?
-The cube is using the default scenario for that dimension
-The dimension is not being used in the cube
-The dimension does not have data
-The cube is using the MainScenario for that dimension
What is the role of a Data Unit within a cube? To make data retrieval more efficient
-To manage data integration
-To make data retrieval more efficient
-To store and lock data
-To load, clear, calculate, translate, and consolidate data
An administrator runs a report to query Actuals, for the a.12
last 6 time periods, for 2 entities and 1 consolidation
dimension member.
How many Data Units will be queried?
a.12
b.6
c.9
d.10
Which report might perform slower due to the number of b.Consolidation Report containing multiple entities on the rows.
Data Units?
a. Income Statement with a single entity in the POV.
b. Consolidation Report containing multiple entities on the
rows.
c. Cash Flow statement with a single entity in the POV.
d. Balance Sheet with a single entity in the POV.
An administrator has added a significant number of base a. Through the Grid View
members into the Account dimension, but is only one
part of the job. They also need to make edits to the
member properties.
What is the quickest way for the administrator to edit the
member properties of these members?
a.Through the Grid View
b.Manually
c.Through an XML load file
Which tool can be used to create XML load files? a. Metadata Builder
a. Metadata Builder
b. Workflow Channels
c. Cube Views
d. Grid View
, What are siblings in a hierarchy? c.Members that share the same parent member.
a.Members up the chain from the selected member.
b.Bottom-level members where data is loaded.
c.Members that share the same parent member.
d.Upper-level members with children below them.
Which two statements accurately describe how to add a. XML Files are used to load entire dimension hierarchies by dimension type.
dimensions through an XML file? (Select 2.)
a. XML Files are used to load entire dimension hierarchies c. XML files are used when a large dimension hierarchy is required.
by dimension type.
b. XML files are used when a small hierarchy or a branch
within a hierarchy is required.
c. XML files are used when a large dimension hierarchy is
required.
d. XML files are used to make few additions to an existing
dimension hierarchy.
Which dimension type is not included in the Dimension c.Time
Library?
a.Scenario
b.Account
c.Time
d.Entity
What are descendants in a hierarchy? a.All members below a parent member.
a. All members below a parent member.
b. Members that share the same parent member.
c.Bottom-level members where data is loaded.
d.Members up the chain from the selected member.
What do you call a bottom-level member where data is b.Base member
loaded?
a. Parent members
b. Base member
c. Alternate hierarchies
d.Siblings
