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

Oracle 1Z0-1041-20 Online Questions & Answers

• Question 1:

  You have created a visualization of revenue data over time. It displays some seasonality (e.g. high revenue around typical holiday periods) but there is no obvious pattern to the data overall. In which two ways can you start to get insight from this data?

  A. Create a trend line.
  B. Create a column trellis over the prominent dimension value.
  C. Add a filter to remove the oldest data.
  D. Create a reference line which displays the average revenue.
  A. Create a trend line.
  D. Create a reference line which displays the average revenue.

• Question 2:

  You create a visualization of revenue data by date (at day level) for the past three years. You then add a forecast. How can you check the accuracy of the forecast?

  A. Add reference lines for the maximum and minimum.
  B. Combine a polynomial trend line with a suitable reference line.
  C. Change the model employed by the algorithm.
  D. Select the option to highlight the prediction interval for a given percentage.
  D. Select the option to highlight the prediction interval for a given percentage.

• Question 3:

  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. Application workbooks support the generation reference dimension build method.
  D. Multiple dimensions can be placed on a single worksheet.
  E. Application workbooks can have data load worksheets and calculation worksheets.
  A. Worksheets can be modified by using the Cube Designer wizard.
  C. Application workbooks support the generation reference dimension build method.
  E. Application workbooks can have data load worksheets and calculation worksheets.

• Question 4:

  Which step is required to create a new curated Data Set comprised of columns from several existing Data Sets?

  A. Merge Columns
  B. Add Data
  C. Aggregate
  D. Filter
  A. Merge Columns

• Question 5:

  Which two statements are true regarding the ways in which Oracle Analytics Cloud provides self- service data preparation capabilities?

  A. The Oracle Data Integrator tool used for extraction, load, and transformation of data is a foundational component of the Oracle Analytics Cloud and is essential for data preparation.
  B. Join rules for mashing up data from relational sources and delimited flat files can only be defined within the Oracle Analytics Cloud Data Modeler.
  C. Data flows within the data preparation feature of Data Visualization can be used to extract, wrangle, and format data content from all supported data sources to create data sets upon which visuals may be constructed.
  D. Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.
  C. Data flows within the data preparation feature of Data Visualization can be used to extract, wrangle, and format data content from all supported data sources to create data sets upon which visuals may be constructed.
  D. Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.

• Question 6:

  Describe what is the aim or the main functionality for the BI Ask?

  A. To search for specific Visualizations.
  B. You can search for a column names, select them and add a visualization to your project.
  C. You can search for column names, select them and quickly see a visualization containing those columns.
  D. To search for specific Projects.
  C. You can search for column names, select them and quickly see a visualization containing those columns.

• Question 7:

  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
  C. 2.2 million

• Question 8:

  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
  B. One to Many Relationship

• Question 9:

  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.
  B. Use the linear option.

• Question 10:

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