Online Access Free C2090-719 Exam Questions

A customer adds transactional data daily and rolls off historical transactional data monthly to archive. Which partitioning strategy should they use to accomplish this time-cyclical data management for their warehouse data?

• A.Specify database partitioning on month and a table partitioning key for day.
• B.Specify a MDC for month and a table partitioning key for day.
• C.Specify a MDC on day and a table partitioning key for month.
• D.Specify database partitioning on day and a table partitioning key for month.

Which two statements are true about a hierarchies, levels, and dimensions? (Choose two.)

• A.Dimensions store information about how the hierarchies within a level are related to each other and how they are structured.
• B.A hierarchy object is an ordered list of dimension objects.
• C.A hierarchy object is an ordered list of level objects.
• D.Levels store information about how the hierarchies within a dimension are related to each other and how they are structured.
• E.Each dimension can have multiple hierarchies.

What is a benefit of using warehouse based analytics?

• A.It provides more functions in the available calculation set.
• B.It provides a common pool of analytic methods to produce consistent answers across all users.
• C.It ensures the user response time will always be fast.
• D.It provides end users the ability to add additional calculations at report time.

Which components are used to run a Cubing Services Server?

• A.Cubing Services Server, Design Studio, Admin Console, Cubing Services multidimensional database
• B.Cubing Services Server, Admin Console, Alphablox, DB2
• C.Cubing Services Server, Design Studio, Admin Console, Alphablox
• D.Cubing Services Server, Design Studio, Admin Console, DB2

When using the Design Studio to define hierarchies for a cube model, you specify the hierarchy type and deployment method. If you were to specify a hierarchy type of
"balanced" and a deployment of "standard", what would that imply?

• A.The levels in the hierarchy have associated meaning, branches have consistent depth and the parent of any member is found in the level above. The data used to define EACH level for a specific branch of the hierarchy is found in a single row in the dimension table.
• B.The levels in the hierarchy have a consistent parent-child relationship and levels are logically inconsistent. The data used to define the members of ALL of the levels for a specific branch of the hierarchy is found in a single row in the dimension table.
• C.The levels in the hierarchy have a consistent parent-child relationship and levels are logically inconsistent. The data used to define EACH level for a specific branch of the hierarchy is found in a single row in the dimension table.
• D.The levels in the hierarchy have associated meaning, branches have consistent depth andtheparent of any member is found in the level above. The data used to define the members of ALL of the levels for a specific branch of the hierarchy is found in a single row in the dimension table.