Exam Questions Answers Braindumps 1Z0-1041-20 Exam Dumps PDF Questions
Download Free Oracle 1Z0-1041-20 Real Exam Questions
Understanding functional and technical aspects of Oracle Cloud Platform Enterprise Analytics 2020 Certified Specialist Certification
The following will be asked from you in the 1Z0-1041-20 exam dumps:
- Oracle Analytics Cloud (OAC)
- Entering and Calculating Data
- Building and Configuring User-Defined Elements
- Building and Configuring Dimensions and Their Elements
- Building and Configuring an Application
- Configuring and Using the Approval Process
- Overview of Planning and Budgeting
- Importing and Exporting Metadata
- Loading and Calculating Data
- Securing Access
- Describing the Planning Application and Navigating the User Interface
NEW QUESTION 11
What is a typical relationship between levels in a dimension hierarchy going from top to bottom?
- A. Zero Cardinality
- B. Multiple Relationship
- C. One to Many Relationship
- D. Many to ManyRelationship
Answer: C
NEW QUESTION 12
What are two incorrect steps when creating pixel perfect reports with Bl Publisher?
- A. Create connections to sources, some of which include Oracle l0g/llg, Oracle BI Server, JDBC, and MS SQL Server 2005/2008.
- B. Define a data model to set the business view of the data, join data sets, and create custom measures.
- C. 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.
- D. Test connections between BI Publisher and configured sources using Oracle Fusion Middleware Control.
Answer: B,D
NEW QUESTION 13
You have added new columns to the source table. What should you do to include the new columns in your data model?
- A. Connect to Tables
- B. Update Data Model
- C. Synchronize with Database
- D. Add Columns from Database
Answer: C
NEW QUESTION 14
Which option is false with respect to the Presentation Catalog?
- A. Catalog Manager is a client administration tool that can be used to view and manage the Presentation Catalog.
- B. To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.
- C. Multiple objects can be archived into a single file.
- D. Object permissions for Analyses and Prompts can be archived along with the object in the catalog.
Answer: B
NEW QUESTION 15
Which feature does the Data Lake Edition uniquely offer?
- A. Live optimized connectivity to your on-premises database
- B. Execute data flows on Apache Spark
- C. Use the Day by Day mobile app
- D. Migrate content from your existing on-premises environment
Answer: B
Explanation:
Explanation
Reference https://www.us-analytics.com/hyperionblog/oracle-unveils-data-lake-edition-for-oac
NEW QUESTION 16
Which statement is false with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas?
- A. Change the visual's location on a canvas by selecting and dragging it to the desired location.
- B. Resize the canvas by changing the Canvas Layout option from Auto Fit to Freeform.
- C. Duplicate a visual that is on the canvas, changing the visual type in the duplicated visual.
- D. Hide a visual by right-clicking the canvas and selecting Hide from the drop-down menu.
Answer: D
NEW QUESTION 17
What should you do to visualize the relationship between two numeric values?
- A. Create a scatter plot of the two numeric values and choose a value of interest as the category (points).
- B. Create multiple pie charts.
- C. Use a box plot with trellising.
- D. Create a line chart with multiple reference lines.
Answer: A
NEW QUESTION 18
What should you use to make sure that the model you created is correct?
- A. DB Sync Icon
- B. Data Checker icon
- C. Validate Icon
- D. Correct icon
Answer: C
NEW QUESTION 19
You've created an instance with 1 OCPU and 15 GB of RAM. What is this combination of OCPU and RAM called?
- A. Classic compute
- B. Architecture shape
- C. Compute shape
- D. Analytics shape
Answer: C
NEW QUESTION 20
Which two elements does a well modeled Fact Table consist of?
- A. REST APIs
- B. Nulls
- C. Dimension Keys
- D. Measures
Answer: C,D
Explanation:
Explanation
https://docs.oracle.com/cd/E05553_01/books/admintool/admintool_DataModeling8.html
NEW QUESTION 21
Which two statements are true regarding configuring filters to control visual content?
- A. Expression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data Visualization data flows.
- B. When the Oracle Business Intelligence Enterprise Edition repository is used as a data source, filters defined in the initialization blocks with the client administration tool are automatically inherited in Data Visualization.
- C. Variables may be employed in all Data Visualization filter types (that is, Range, List, Date, Expression).
- D. Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler.
Answer: B,D
NEW QUESTION 22
How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas?
- A. Use a combination of a tree diagram and a trellis visualization.
- B. Create a cluster with a suitable number of groups for the specific analysis.
- C. Use a variety of colors for each data point.
- D. Visualize the data by using a network chart.
Answer: B
Explanation:
Explanation
Reference
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/visualizing-data-and-building-reports-oracle-analytic
NEW QUESTION 23
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. Multiple Analyses can be arranged into different columns and sections with different sizes on a dashboard.
- C. Options for the Export and Refresh report links can be enabled globally at the dashboard level.
- D. Prompts on the dashboards can be shared between different pages of a dashboard.
Answer: A
NEW QUESTION 24
What are the two commonly used dimensional modeling schemas?
- A. Snowflake
- B. Star
- C. Sun
- D. Moon
Answer: A,B
Explanation:
Explanation
https://docs.oracle.com/cd/A97630_01/server.920/a96520/schemas.htm
NEW QUESTION 25
You are migrating 11.1.2.4.nnn On-Premises Essbase cubes to the cloud service. Which four steps should you perform?
- A. Correct any partition settings in the Life Cycle Management exported .zip file.
- B. Install and execute the Life Cycle Management utility to export the required Essbase source application.
- C. Convert all applications and associated artifacts to non-Unicode mode before export.
- D. Convert all application-level files and artifacts to database-level files and artifacts before export.
- E. Import a .zip file using the Command Line Interface tool.
- F. Convert all application-level substitution variables to server-level variables before export.
Answer: A,B,E,F
Explanation:
Explanation
Reference https://blogs.perficient.com/2018/04/11/migrating-essbase-cubes-oracle-analytics-cloud/
NEW QUESTION 26
Which statement is false regarding arrangement of visuals on a canvas?
- A. Visuals can be arranged horizontally, one visual above another.
- B. Visuals can be stacked one on top of another.
- C. Visuals can be arranged vertically, one visual beside another.
- D. Visuals cannot be arranged automatically.
Answer: D
NEW QUESTION 27
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. positioning data in reverse order as the outline
- B. switching from multiple data fields to a single data field
- C. making the data source as small as possible by eliminating redundancy
- D. loading from the Essbase server
- E. using Parallel load
- F. grouping the data source by sparse-dimension member combination
Answer: C,D,E,F
NEW QUESTION 28
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 and position annotations on the canvas as desired.
- C. Create a new project for the Story by clicking the Save As button in the project toolbar.
- D. Share the Story in presentation mode by setting the reportMode parameter in the project properties to FullDisplay.
Answer: D
NEW QUESTION 29
Which two statements are true regarding the source of Oracle BI Enterprise Edition Analyses?
- A. Analyses can be created from multiple subject areas as long as at least one metric Is Included from each, and the Dimensionality Flag is enabled.
- B. Analyses can be created from multiple business models as long as they contain common, conformed dimensions.
- C. Analyses can be created with measures from multiple physical tables defined as sources in a single logical fact table.
- D. Analyses cannot be created from multiple subject areas even though they contain common, conformed dimensions.
Answer: C,D
NEW QUESTION 30
Your company is using an Essbase cube, which is enabled for Scenario Management. Planners model data in individual scenarios and submit them for approval.
While modeling data in the "SB1" sandbox, you changed a few values based on some assumption. Later, you realized that your assumptions were incorrect. You want to start again with the original values, the same as base.
Which step should you perform?
- A. Type #Discard in the changed scenario cells and Submit Data.
- B. Type #Base in the changed scenario cells and Submit Data.
- C. Type #Original in the changed scenario cells and Submit Data.
- D. Type #Revert in the changed scenario cells and Submit Data.
- E. Type #Missing in the changed scenario cells and Submit Data.
Answer: D
NEW QUESTION 31
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 stream option referencing a saved local connection
- B. a saved local connection using a secure URL
- C. a rules file with a username and password
- D. a data file and an optional rules file
- E. a dimension file
Answer: A,C,D
NEW QUESTION 32
Select two correct editions of Oracle Analytics Cloud.
- A. Big Data Edition
- B. BI Cloud Service Edition
- C. SaaS Edition
- D. Standard Edition
- E. Data Lake Edition
Answer: D,E
Explanation:
Explanation
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsgs/what-is-oracle-analytics-cloud.html#GUID-E68C8A
NEW QUESTION 33
......
Latest Oracle 1Z0-1041-20 Real Exam Dumps PDF: https://www.ipassleader.com/Oracle/1Z0-1041-20-practice-exam-dumps.html