Online Access Free 1Z0-1041-21 Exam Questions

You've created a visualization of revenue data over time. The revenue data over time exhibits some curvature in the line visualization.
What trending algorithm should you use to refine the trendline?

• A.Set theconfidence interval to 95%.
• B.Use the polynomial option.
• C.Use the linear option.
• D.Use the exponential option.

Which two statements are true regarding the source of Oracle BI Enterprise Edition Analyses?

• A.Analyses can be created from multiple business models as long as they contain common, conformed dimensions.
• B.Analyses can be created from multiple subject areas as long as at least one metric Is Included from each, and the Dimensionality Flag is enabled.
• C.Analyses cannot be created from multiple subject areas even though they contain common, conformed dimensions.
• D.Analyses can be created with measures from multiple physical tables defined as sources in a single logical fact table.

A customer built an Essbase cube (Block Storage) with six dimensions. At a later stage, a few cube settings were updated and new members were added manually. Based on new requirements from users, the customer wants to add a new dimension to the existing cube.
The administrator will be using the Cube Designer extension in SmartVlew to make the updates. How can the customer update the cube incrementally while retaining any previous changes that were appliedmanually?

• A.Select "From Sheet" to populate the wizard with contents of the application workbook.
  3. Add a new dimension.
  4. Select "To Sheet to propagatethe changes to the application workbook.
  5 Add embers in the dimension worksheet.
  Finally, select the Load Data option.
• B.In Cube Designer:
  1. Export the cube to the application workbook.
  2. Select "From Sheet" to populate the wizard with contents of the application workbook.
  3. Add a new dimension.
  4. Select "To Sheet" to propagate the changes to the application workbook.
  5. Add members in the dimension worksheet.
  6. Finally, selectUpdate Cube from the build options.
• C.A new dimension cannot be added to an existing cube using Cube Designer.
• D.In Cube Designer:
  1. Export the cube to the application workbook.
• E.Previous changes applied manually in cloud service cannot be retained while using Cube Designer.

What is a typical relationship between levels in a dimension hierarchy going from top to bottom?

• A.Multiple Relationship
• B.Many to ManyRelationship
• C.Zero Cardinality
• D.One to Many Relationship

Your customer has an Essbase cube with current year P&L data. Once a month, the cube needs to be updated with the last closed month data.
How can the monthly data be loaded incrementally using Cube Designer?

• A.Use the Load Data option in Cube Designer.
• B.Cube Designercannot be used to load data in the cube.
• C.Use the Transform Data option in Cube Designer.
• D.Use the Update Cube option from the Build Option menu in Cube Designer.
• E.Cube Designer cannot be used to load data incrementally in the cube.