Oracle Cloud Platform Enterprise Analytics 2018 Associate (1Z1-936) Free Practice Test

Question 1

You want to create an Essbase cube using a MaxL script. This is the content of the Max! script:

You saved the script file locally as cubeBuild.mx1, uploaded it to the cloud service, and executed a "MaxL script" job type. The job failed. What is the problem?

A. It is an invalid script file. A script file must be saved with a .msh extension.

B. Only one MaxL statement per script is allowed.

C. It is an invalid MaxL statement. "Create or replace database" Is not supported.

D. MaxL scripts are not supported.

E. It is an invalid job type.

Correct Answer: C

Question 2

If your service uses the embedded LDAP server, you can add users and roles one-by-one through the Console.
What is the correct process to add a role?

A. Click Roles; Click Add; Enter a name for the role; Enter a more detailed display name and description (optional); Assign one or more users to this role by selecting Manage Members, select Users from the Type list and then click Search to list all the users; Move all the users you want for this role to the Selected Users pane; click OK.

B. Click Roles; Click Add; Enter a name for the role; Enter a more detailed display name and description (required); Assign one or more users to this role by selecting Manage Members, select Users from the Type list and then click Search to list all the users; Move all the users you want for this role to the Selected Users pane; click OK.

C. Click Roles; Click Add; Enter a name for the role; Enter a more detailed display name and description (optional); Assign one or more users to this role by selecting Manage Members; Import Users from a
.csv file; Move all the users you want for this role to the Selected Users pane; click OK.

D. Click Roles; Click Add; Enter a name for the role; Import Users from a .csv file; Assign one or more users to this role by selecting Manage Members; Select Users from the Type list and then click Search to list all the users you imported from your .csv file.

Correct Answer: A

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

Question 3

In which two ways can you use Oracle Analytics Cloud to determine which values of a given data set may provide the greatest opportunity due to their stand out qualities?

A. Use a combination of Max / Min value reference lines.

B. Add an outlier visualization to your canvas. This will highlight data points that stand out and may Justify further investigation.

C. Create a box plot visualization of your data set.

D. Modify the color palette to highlight unique values.

Correct Answer: A,C

Question 4

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 5

Which statement is false with respect to Dashboards?

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

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

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

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

Correct Answer: A

Question 6

Which statement is true about migrating BI Content and Users?

A. If you have Oracle Analytics Cloud services that use the WebLogic embedded LDAP server, you can only export data visualizations, reports and dashboards, and import them to another environment by using a WebLogic embedded LDAP server. User information must be exported separately.

B. You can only use the WebLogic embedded LDAP server which allows you to export everything including data visualizations, reports, dashboards, and user information and other relevant information and import them to another environment by using a WebLogic embedded LDAP server.

C. You can only use the WebLogic embedded LDAP server which allows you to export data visualizations, reports, dashboards, and user Information and import them to another environment by using a WebLogic embedded LDAP server.

D. If you have Oracle Analytics Cloud services that use the WebLogic embedded LDAP server, you can export data visualizations, reports, dashboards, and user information and import them to another environment by using a WebLogic embedded LDAP server.

Correct Answer: A

Question 7

Before you create an Oracle Analytics Cloud Standard Edition service, you must check to make sure you are subscribed to the required services. Which combination of services is required?

A. Oracle Cloud Infrastructure Compute Classic; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)

B. Oracle Cloud Infrastructure Compute Classic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)

C. Oracle Cloud Infrastructure Compute Classic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required); Oracle Big Data Cloud

D. Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Big Data Cloud

Correct Answer: C

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

Question 8

You are migrating 11.1.2.4.nnn On-Premises Essbase cubes to the cloud service. Which four steps should you perform?

A. Convert all application-level substitution variables to server-level variables before export.

B. Install and execute the Life Cycle Management utility to export the required Essbase source application.

C. Correct any partition settings in the Life Cycle Management exported .zip file.

D. Convert all applications and associated artifacts to non-Unicode mode before export.

E. Convert all application-level files and artifacts to database-level files and artifacts before export.

F. Import a .zip file using the Command Line Interface tool.

Correct Answer: A,B,C,F

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

Welcome to TestSimulate

Oracle Cloud Platform Enterprise Analytics 2018 Associate (1Z1-936) Free Practice Test