Oracle Platform as a Service (PaaS) 1Z0-1041-20 Questions & Answers

• Question 41:

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

  A. Many to ManyRelationship

  B. One to Many Relationship

  C. Zero Cardinality

  D. Multiple Relationship

  Correct Answer: B

• Question 42:

  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 applied manually?

  A. Previous changes applied manually in cloud service cannot be retained while using Cube Designer.

  B. A new dimension cannot be added to an existing cube using Cube Designer.

  C. 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, select Update Cube from the build options.

  D. In Cube Designer:

  1. Export the cube to the application workbook.

  E. 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 embers in the dimension worksheet.

  Finally, select the Load Data option.

  Correct Answer: C

• Question 43:

  The extensive palette of visualization options delivered with Oracle Analytics Cloud can be extended with

  custom plugins.

  What option is false about implementing custom visualization plugins?

  A. The bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a skeleton visualization to facilitate custom development.

  B. Oracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of custom plugins.

  C. To be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted.

  D. Plugins for rendering sophisticated visuals can be downloaded from the Oracle Data Visualization Library.

  Correct Answer: C

• Question 44:

  Which operating system does the administration tool require?

  A. Microsoft Windows x86-64-bit

  B. Linux x86-64-bit

  C. Oracle Solaris on SPARC 64-bit

  D. Oracle Solaris on x86 64-bit

  Correct Answer: A

• Question 45:

  If something goes wrong with your data model, you can easily restore your content to a previous working state from a_____.

  A. db_restore command

  B. Model Restore

  C. analytics_restore command D. snapshot

  Correct Answer: D

  Reference https://docs.oracle.com/en/cloud/paas/data-visualization-cloud/bidvc/taking-snapshots- andrestoring.html#GUID-52D4F7BA-DC1E-4BE9-B8C3-9CC7D204E698

• Question 46:

  Which two statements pertaining to Action Links are false?

  A. Navigation from one Analysis to another Analysis is not possible if they reside In different folders.

  B. The Navigation option on a column can be enabled conditionally.

  C. Navigation from one Analysis to another Analysis only works when both analyses are created from single subject area.

  D. Presentation variables can be used while navigating from one Analysis to another Analysis.

  Correct Answer: AC

• Question 47:

  You want the Oracle BI Baseline Validation Tool to use specific dashboard prompts when executing a specific dashboard page. In which default file should you specify the values?

  A. DashboardPrompts.txt

  B. DashboardPrompts.xml

  C. Prompts.txt

  D. Prompts.xml

  Correct Answer: A

• Question 48:

  Your customer is looking to get a better understanding of their data, in particular how Oracle Analytics

  Cloud can help them gain a competitive advantage.

  Which two tasks can help them achieve their goals?

  A. Import the data Into Oracle Analytics Cloud and use the Data Tile functionality in the Prepare section of the product. Use the resulting combination of visualization types to determine relationships and avenues for further exploration.

  B. Perform analysis on the data by using trend lines, clustering, and outlier detection to offer new perspectives.

  C. Create a data story by using the narrate functionality to present to their management.

  D. Create a data flow to highlight the interesting data.

  Correct Answer: BC

• Question 49:

  Which statement is false regarding arrangement of visuals on a canvas?

  A. Visuals can be stacked one on top of another.

  B. Visuals can be arranged vertically, one visual beside another.

  C. Visuals cannot be arranged automatically.

  D. Visuals can be arranged horizontally, one visual above another.

  Correct Answer: C

• Question 50:

  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 the confidence interval to 95%.

  B. Use the linear option.

  C. Use the polynomial option.

  D. Use the exponential option.

  Correct Answer: B