1Z0-1041-22 Online Practice Questions and Answers

Oracle Analytics Cloud offers several visualization options for presenting query results. How do you explicitly invoke "best visualization" in Oracle Analytics Cloud?

A. Select the desired data elements from the Data Elements pane and drag them onto the Best Visualization zone in the Explore pane.

B. Drag an entire Data Set from the Data Elements pane onto the Data Visualization canvas and let the tool determine the best visualization.

C. Select the "Best Visualization" option from the project's Canvas Settings drop-down menu.

D. Select the desired data elements from the Data Elements pane, right-click and select "Create Best Visualization" from the drop-down menu.

Which two elements does a well modeled Fact Table consist of?

A. Dimension Keys

B. REST APIs

C. Nulls

D. Measures

Monitoring information is updated automatically. You can also run a health check to update the display of monitoring information at any time. What are the correct steps to explicitly run a health check?

A. Select an Analytics Cloud service on the OAC dashboard; click the Display monitoring information icon on the Overview pane; click the Export Healthcheck Details icon.

B. Select an Analytics Cloud service on the OAC dashboard; click the View Healthcheck Details Icon In the Resources section; click the Export Healthcheck Details icon.

C. Select an Analytics Cloud service on the OAC dashboard; click the Display monitoring information Icon on the Overview pane; click the View Healthcheck Details icon in the Resources section.

D. On the Overview pane, click the Display monitoring information icon and select an Analytics Cloud service; In the Resources section, click the View Healthcheck Details icon.

Which statement is false with respect to Dashboards?

A. All the Analyses placed on a dashboard must be sourced from the same subject area.

B. Prompts on the dashboards can be shared between different pages of a dashboard.

C. Multiple Analyses can be arranged into different columns and sections with different sizes on a dashboard.

D. Options for the Export and Refresh report links can be enabled globally at the dashboard level.

Which of the following cannot be done with Data Visualization to shape stories?

A. Visual canvases can be resized and the Auto Fit setting can be disabled.

B. Enhance narrative transition by rearranging and/or hiding Insight canvases.

C. Create filters to focus upon pertinent data points.

D. Multiple projects can be combined into one project by clicking on the Share icon in the Narrate menu bar.

A customer wants to build a Block Storage (BSO) cube which has 8 standard dimensions and 2 attribute dimensions. How many dimension worksheets will the application workbook have?

A. 10 dimension worksheets

B. 12 dimension worksheets

C. 8 dimension worksheets

D. 9 dimension worksheets

E. 1 dimension worksheet

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.

How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas?

A. Use a variety of colors for each data point.

B. Create a cluster with a suitable number of groups for the specific analysis.

C. Use a combination of a tree diagram and a trellis visualization.

D. Visualize the data by using a network chart.

Which option is false with respect to the Presentation Catalog?

A. Catalog Manager is a client administration tool that can be used to view and manage the Presentation Catalog.

B. Object permissions for Analyses and Prompts can be archived along with the object in the catalog.

C. Multiple objects can be archived into a single file.

D. To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.

What should you use to make sure that the model you created is correct?

A. Data Checker icon

B. Validate Icon

C. DB Sync Icon

D. Correct icon

Your customer has an Essbase cube with current year PandL 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 Update Cube option from the Build Option menu in Cube Designer.

B. Use the Transform Data option in Cube Designer.

C. Cube Designer cannot be used to load data in the cube.

D. Cube Designer cannot be used to load data incrementally in the cube.

E. Use the Load Data option in Cube Designer.

Which statement is false with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas?

A. Change the visual's location on a canvas by selecting and dragging it to the desired location.

B. Duplicate a visual that is on the canvas, changing the visual type in the duplicated visual.

C. Resize the canvas by changing the Canvas Layout option from Auto Fit to Freeform.

D. Hide a visual by right-clicking the canvas and selecting Hide from the drop-down menu.

Which tab should you use to restrict access to a specific item in a model?

A. Permissions

B. Security

C. App Responsibilities

D. App Roles

What are the two commonly used dimensional modeling schemas?

A. Star

B. Sun

C. Moon

D. Snowflake

Which is the maximum row count for unformatted files?

A. 500k

B. 1.2 million

C. 2.2 million

D. 800k

E. 3.2 million