Pass 1Z0-1041-20 Exam in First Attempt Guaranteed 2021 Dumps!
1Z0-1041-20 Dumps Full Questions - Exam Study Guide
NEW QUESTION 32
What does the band inside a box plot visualization represent?
- A. The standard deviation of the data
- B. The median of the data
- C. The maximum of the data
- D. The average of the data
Answer: B
Explanation:
Explanation
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/visualizing-data-and-building-reports-oracle-analytic
NEW QUESTION 33
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. Exclude Quarters from the Time hierarchy.
- B. Ensure the dimension representing Time is tagged as the "Time" dimension.
- C. Ensure the Time Balance functionality is turned on for the cube.
- D. Enable Dynamic Time Series in the Time dimension and configure Y-T-D and Q-T-D.
Answer: C,D
NEW QUESTION 34
If we select the Oracle Analytics Cloud Enterprise Edition, which are the options available to select while creating the service?
- A. Business Intelligence - Enterprise Reports
Pixel Perfect Reports
Data Visualization - B. Essbase
Pixel Perfect Reports
Data Visualization - C. Business Intelligence - Enterprise Reports
Pixel Perfect Reports
Essbase - D. Business Intelligence - Enteprise Reports
Data Visualization
Essbase
Answer: D
NEW QUESTION 35
Which statement is false with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas?
- A. Duplicate a visual that is on the canvas, changing the visual type in the duplicated visual.
- B. Hide a visual by right-clicking the canvas and selecting Hide from the drop-down menu.
- C. Resize the canvas by changing the Canvas Layout option from Auto Fit to Freeform.
- D. Change the visual's location on a canvas by selecting and dragging it to the desired location.
Answer: B
NEW QUESTION 36
The data loads for your Essbase cube are taking many hours, due to which the cube is unavailable to the user for extended periods every day. You are assigned the task of optimizing the data load process.
Which are four optimization steps?
- A. making the data source as small as possible by eliminating redundancy
- B. loading from the Essbase server
- C. switching from multiple data fields to a single data field
- D. using Parallel load
- E. grouping the data source by sparse-dimension member combination
- F. positioning data in reverse order as the outline
Answer: A,B,D,E
NEW QUESTION 37
What is a typical relationship between levels in a dimension hierarchy going from top to bottom?
- A. Many to ManyRelationship
- B. Zero Cardinality
- C. One to Many Relationship
- D. Multiple Relationship
Answer: C
NEW QUESTION 38
What should you use to make sure that the model you created is correct?
- A. DB Sync Icon
- B. Correct icon
- C. Data Checker icon
- D. Validate Icon
Answer: D
NEW QUESTION 39
What does a confusion matrix illustrate?
- A. a table that reports the occurrences of upper positives, lower negatives, mid positives, and true negatives for a machine learning model
- B. a table that reports the occurrences of negative positives, false negatives, true positives, and positive negatives for a machine learning model
- C. a table that reports the occurrences of higher positives, false negatives, lower positives, and true negatives for a machine learning model
- D. a table that reports the occurrences of false positives, false negatives, true positives, and true negatives for a machine learning model
Answer: D
Explanation:
Explanation
Reference https://blogs.oracle.com/analyticscloud/machine-learning-and-data-visualization:-its-all-related
NEW QUESTION 40
Which statement is true when migrating content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud?
- A. You can only migrate an Oracle BI Enterprise Edition 12c Data Model to Oracle Analytics Cloud.
Catalog migration is not allowed. - 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. At this time there is no option to migrate Oracle BI Enterprise Edition llg content to Oracle Analytics Cloud.
- D. You can migrate a snapshot from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud.
Answer: D
NEW QUESTION 41
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. Change the model employed by the algorithm.
- B. Combine a polynomial trend line with a suitable reference line.
- C. Add reference lines for the maximum and minimum.
- D. Select the option to highlight the prediction interval for a given percentage.
Answer: D
NEW QUESTION 42
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. The sandbox dimension has one base member and multiple sandbox members.
- B. After working in the sandbox environment, you can commit changes to the base environment or even to another sandbox target.
- C. When you submit changes to a base member, changes are seen and stored in each sandbox member.
- D. Initially, the state of each sandbox member is #missing.
- E. Using the sandbox dimension has storage overhead that would be required to replicate data from the base environment.
Answer: A,B
Explanation:
Explanation
Reference
https://docs.oracle.com/en/cloud/paas/analytics-cloud/adess/testing-changes-sandbox-dimension.html
NEW QUESTION 43
Which is not a step that can be followed to create a Story?
- A. Capture a story insight from one or more Visualization canvases in a project by navigating from Visualize to Narrate and dragging the desired Visualization canvas(es) onto the Narration canvas.
- B. Create a new project for the Story by clicking the Save As button in the project toolbar.
- C. Create and position annotations on the canvas as desired.
- D. Share the Story in presentation mode by setting the reportMode parameter in the project properties to FullDisplay.
Answer: D
NEW QUESTION 44
Which statement Is false about log files generated by Oracle BI Analyses?
- A. Catalog Manager provides rapid access to the log file.
- B. The log file is not accessible via the repository Administration client.
- C. The log file can be accessed via the Fusion Middleware Control.
- D. An Analysis that references two fact tables will generate two database-specific SQL queries in the log file.
Answer: A
NEW QUESTION 45
Which step is required to create a new curated Data Set comprised of columns from several existing Data Sets?
- A. Aggregate
- B. Add Data
- C. Filter
- D. Merge Columns
Answer: D
Explanation:
Explanation
Reference
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/typical-workflow-creating-curated-data-sets-data-flo
NEW QUESTION 46
Which option is false with respect to the Presentation Catalog?
- A. To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.
- B. Catalog Manager is a client administration tool that can be used to view and manage the Presentation Catalog.
- C. Object permissions for Analyses and Prompts can be archived along with the object in the catalog.
- D. Multiple objects can be archived into a single file.
Answer: A
NEW QUESTION 47
Which three options are correct about application workbooks?
- A. Application workbooks support the generation reference dimension build method.
- B. Worksheets can be modified by using the Cube Designer wizard.
- C. Multiple dimensions can be placed on a single worksheet.
- D. Worksheets cannot be modified directly in Excel.
- E. Application workbooks can have data load worksheets and calculation worksheets.
Answer: A,B,E
NEW QUESTION 48
What are two incorrect steps when creating pixel perfect reports with Bl Publisher?
- A. Define a data model to set the business view of the data, join data sets, and create custom measures.
- B. Test connections between BI Publisher and configured sources using Oracle Fusion Middleware Control.
- C. Create connections to sources, some of which include Oracle l0g/llg, Oracle BI Server, JDBC, and MS SQL Server 2005/2008.
- D. 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.
Answer: A,B
NEW QUESTION 49
Which are the correct steps to download the Autonomous DW wallet?
- A. - Go to Oracle Cloud Infrastructure overview
- Select the compartment where you have the ADW
Click to DB Connection.
- Click Download
- Confirm Download - B. - Go to Oracle Cloud Baremetal overview
- Select the compartment where you have the ADW
- Click to DB wallet download
- Confirm Download - C. - Go to Oracle Cloud Infrastructure overview
- Select the compartment where you have the ADW
- Click to DB Connection.
- Click Download
- Enter appropriate Password.
- Confirm Download - D. - Go to Oracle Cloud Infrastructure overview
- Select the compartment where you have the ATP
- Click to DB Connection.
- Click Download
- Enter appropriate Password.
- Confirm Download - E. - Go to Oracle Cloud Storage overview
- Select the bucket where you have the ADW
- Click to DB Connection.
- Click Download
- Enter appropriate Password.
- Confirm Download
Answer: C
NEW QUESTION 50
You've created an instance with 1 OCPU and 15 GB of RAM. What is this combination of OCPU and RAM called?
- A. Compute shape
- B. Analytics shape
- C. Classic compute
- D. Architecture shape
Answer: A
NEW QUESTION 51
How should you determine the accuracy of a machine learning model created in Oracle Analytics Cloud?
- A. Open the Inspect dialog for a given machine learning model and review the F1 score.
- B. Use the debug option in the data flow where the model was created.
- C. Run the machine learning model with various filter values applied.
- D. Create a data flow that Includes a histogram.
Answer: A
NEW QUESTION 52
Which 2 Dynamic time series are feasible to set up in Essbase cube:
- A. Y-T-D
- B. D-T-Y
- C. PY-TD
- D. LM-TD
- E. Q-T-D
Answer: A,E
NEW QUESTION 53
Which two statements are true regarding the ways in which Oracle Analytics Cloud provides self-service data preparation capabilities?
- A. Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.
- B. 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.
- C. Join rules for mashing up data from relational sources and delimited flat files can only be defined within the Oracle Analytics Cloud Data Modeler.
- D. 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.
Answer: A,D
NEW QUESTION 54
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. Use the linear option.
- B. Set the confidence interval to 95%.
- C. Use the polynomial option.
- D. Use the exponential option.
Answer: A
NEW QUESTION 55
The extensive palette of visualization options delivered with Oracle Analytics Cloud can be extended with custom plugins.
What option is false about implementing custom visualization plugins?
- A. The bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a skeleton visualization to facilitate custom development.
- B. Plugins for rendering sophisticated visuals can be downloaded from the Oracle Data Visualization Library.
- C. Oracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of custom plugins.
- D. To be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted.
Answer: D
NEW QUESTION 56
Describe what is the aim or the main functionality for the BI Ask?
- A. To search for specific Visualizations.
- B. You can search for column names, select them and quickly see a visualization containing those columns.
- C. You can search for a column names, select them and add a visualization to your project.
- D. To search for specific Projects.
Answer: B
NEW QUESTION 57
......
Oracle Business Analytics Free Certification Exam Material from PracticeVCE with 83 Questions: https://www.practicevce.com/Oracle/1Z0-1041-20-practice-exam-dumps.html