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.

You have added new columns to the source table. What should you do to include the new columns in your data model?

A. Update Data Model

B. Add Columns from Database

C. Synchronize with Database

D. Connect to Tables

Your customer has a requirement to generate a Year-to-Date and Quarter-to-Date report from a Block Storage Essbase cube. The cube has a dimension that represents Time and includes calendar months as leaf-level members. What two steps should you perform to enable To-Date reporting?

A. Enable Dynamic Time Series in the Time dimension and configure Y-T-D and Q-T-D.

B. Ensure the Time Balance functionality is turned on for the cube.

C. Exclude Quarters from the Time hierarchy.

D. Ensure the dimension representing Time is tagged as the "Time" dimension.

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

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

What should you do to visualize the relationship between two numeric values?

A. Use a box plot with trellising.

B. Create a line chart with multiple reference lines.

C. Create a scatter plot of the two numeric values and choose a value of interest as the category (points).

D. Create multiple pie charts.

You've been given a spreadsheet of employee attrition data and have been asked to determine which are the most important factors that contribute to whether an employee is likely to leave their position. What is the quickest way to start this analysis after uploading the data to Oracle Analytics Cloud?

A. Calculate a forecast of the probability of attrition.

B. Use Outlier identification.

C. Use the Explain option on the attrition attribute.

D. Perform a cluster analysis of employees.

Which statement is true when migrating content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud?

A. At this time there is no option to migrate Oracle BI Enterprise Edition llg content to Oracle Analytics Cloud.

B. Both the Oracle BI Enterprise Edition 12c Data Model and the Catalog must be migrated to Oracle Analytics Cloud. They cannot be migrated independently.

C. You can migrate a snapshot from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud.

D. You can only migrate an Oracle BI Enterprise Edition 12c Data Model to Oracle Analytics Cloud. Catalog migration is not allowed.

Which 2 Dynamic time series are feasible to set up in Essbase cube:

A. LM-TD

B. PY-TD

C. Q-T-D

D. D-T-Y

E. Y-T-D

Which are the steps to upload the wallet to set up a connection with OAC?

A. -Go to the oracle website and sign in

-Download the wallet.zip

-Proceed without Virus scan.

-Use this zip file to upload it in DV console.

-Upload it.

B. - Go to the oracle website and sign in

-Click over the hamburger menu icon.

-Select Console.

-

Click connections

-

Click over the top-right hamburger icon.

-Proceed without Virus scan.

-Choose wallet.sso

-Upload it.

C. - Go to the url/dv/ui

-Click over the hamburger menu icon.

-Select connections

-Click over the top-right hamburger icon.

-Proceed without Virus scan.

-Choose wallet.zip

-Upload it.

D. - Go to the url/dv/ui

-Click over the hamburger menu icon.

-Select Console.

-

Click connections

-

Click over the top-right hamburger icon.

-Proceed without Virus scan.

-Choose wallet.sso

-Upload it.

E. -Go to the url/dv/ui

-Click over the hamburger menu icon.

-Select Console.

-

Click connections

-

Click over the top-right hamburger icon.

-Proceed without Virus scan.

-Choose wallet.zip

-Upload it.