Oracle 1Z0-1041-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-1041-22 Online Questions & Answers

• Question 41:

  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. Permissions
  B. Row Level Data
  C. Table filter
  D. Data Filters
  D. Data Filters

  ---

  Explanation/Reference:

  You can define data filters for fact tables, dimension tables, and columns that provide row-level security for data model objects. For example, you can create a filter that restricts access to the Products table so that only certain brands are visible to users assigned to a particular role. https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/securing-access-data.html

• Question 42:

  You have a data set that you wish to use to train a machine learning model in Oracle Analytics Cloud. The attribute you are interested in predicting has one of two text values (e.g. Yes/No or True/False).

  How should you perform this operation?

  A. Create a data flow that includes a step to train a fuzzy prediction model and save the model for later use.
  B. Create a data flow that includes a step to analyze sentiment and save the model for later use.
  C. Create a data flow that includes a step to train a clustering model and save the model for later use.
  D. Create a data flow that includes a step to train a binary classifier model and save the model for later use.
  D. Create a data flow that includes a step to train a binary classifier model and save the model for later use.

• Question 43:

  A virtual machine In Compute Classic, created resources defined by a shape is called_____.

  A. Orchestration
  B. Private Gateway
  C. Image
  D. Instance
  D. Instance

• Question 44:

  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.
  C. Create a scatter plot of the two numeric values and choose a value of interest as the category (points).

• Question 45:

  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 applications and associated artifacts to non-Unicode mode before export.
  B. Correct any partition settings in the Life Cycle Management exported .zip file.
  C. Install and execute the Life Cycle Management utility to export the required Essbase source application.
  D. Import a .zip file using the Command Line Interface tool.
  E. Convert all application-level substitution variables to server-level variables before export.
  F. Convert all application-level files and artifacts to database-level files and artifacts before export.
  B. Correct any partition settings in the Life Cycle Management exported .zip file.
  C. Install and execute the Life Cycle Management utility to export the required Essbase source application.
  D. Import a .zip file using the Command Line Interface tool.
  E. Convert all application-level substitution variables to server-level variables before export.

  ---

  Explanation/Reference:

  Reference https://blogs.perficient.com/2018/04/11/migrating-essbase-cubes-oracle-analytics-cloud/

• Question 46:

  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.
  A. All the Analyses placed on a dashboard must be sourced from the same subject area.

• Question 47:

  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.
  C. Visuals cannot be arranged automatically.

• Question 48:

  Which two statements are true about a segment as defined in the Oracle Analytics Cloud machine learning functionality?

  A. It Is a component of the output from the Explain functionality.
  B. It Is a component of a data flow sequence.
  C. It is the resulting data set after applying a filter in a data flow.
  D. It is a statistically determined group of data points that may contribute to predicting the value of an attribute of interest.
  C. It is the resulting data set after applying a filter in a data flow.
  D. It is a statistically determined group of data points that may contribute to predicting the value of an attribute of interest.

• Question 49:

  How should you use a machine learning model within a canvas of an Oracle Analytics Cloud project?

  A. Create a custom calculation.
  B. Create a scenario using the required model.
  C. Use the machine learning model visualization.
  D. Create a data sequence.
  B. Create a scenario using the required model.

• Question 50:

  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.
  A. Use the Update Cube option from the Build Option menu in Cube Designer.

  ---

  Explanation/Reference:

  Reference https://docs.oracle.com/en/cloud/paas/analytics-cloud/essug/using-oracle-analytics- cloud-essbase.pdf (123)