Oracle Cloud Platform Enterprise Analytics 2019 Associate (1Z1-1041) Free Practice Test

Question 1

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 exponential option.

C. Use the linear option.

D. Use the polynomial option.

Correct Answer: C

Question 2

Which three options are correct about application workbooks?

A. Worksheets can be modified by using the Cube Designer wizard.

B. Worksheets cannot be modified directly in Excel.

C. Multiple dimensions can be placed on a single worksheet.

D. Application workbooks support the generation reference dimension build method.

E. Application workbooks can have data load worksheets and calculation worksheets.

Correct Answer: A,D,E

Question 3

Your customer has a hybrid aggregate Essbase cube. They want to be able to model what-if scenarios with hypothetical data and are considering using the Sandbox dimension.
Which two statements represent correct functionality of the Sandbox dimension?

A. Using the sandbox dimension has storage overhead that would be required to replicate data from the base environment.

B. The sandbox dimension has one base member and multiple sandbox members.

C. Initially, the state of each sandbox member is #missing.

D. When you submit changes to a base member, changes are seen and stored in each sandbox member.

E. After working in the sandbox environment, you can commit changes to the base environment or even to another sandbox target.

Correct Answer: B,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Your customer is using Oracle Analytics Cloud - Essbase Command Line Interface (CL1) to perform administrative actions on Oracle Analytics Cloud - Essbase.
Which are three valid options for executing the DataLoad command?

A. a data file and an optional rules file

B. a rules file with a username and password

C. a stream option referencing a saved local connection

D. a saved local connection using a secure URL

E. a dimension file

Correct Answer: A,B,C

Question 5

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

A. Model Restore

B. analytics_restore command

C. db_restore command

D. snapshot

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

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. Visualize the data by using a network chart.

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

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

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

What are two incorrect steps when creating pixel perfect reports with Bl Publisher?

A. Generate and save to a folder in the Presentation Catalog a sample set of data that can be used for configuring and testing the report.

B. Create connections to sources, some of which include Oracle l0g/llg, Oracle BI Server, JDBC, and MS SQL Server 2005/2008.

C. Test connections between BI Publisher and configured sources using Oracle Fusion Middleware Control.

D. Define a data model to set the business view of the data, join data sets, and create custom measures.

Correct Answer: C,D

Question 8

You want to create a filter that restricts access to the Fact table so that Revenue Is only visible to users assigned to a particular role. In which tab should you set this up?

A. Table filter

B. Row Level Data

C. Permissions

D. Data Filters

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Cloud Platform Enterprise Analytics 2019 Associate (1Z1-1041) Free Practice Test